Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `tbv_regis_nrb_tol`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts KdToko NamaToko No_NRB PLU Jenis_Tolakan Det_Alasan_Tolakan PLU2 QTY2 Tgl_Exp RegDate REF
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'T224' AND `tbv_regis_nrb_tol`.`NamaToko` = 'FUNDAR SAKELA' AND `tbv_regis_nrb_tol`.`No_NRB` = 17 AND `tbv_regis_nrb_tol`.`PLU` = '20034583' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Hilang' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Fisik Tidak Datang - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-12 10:15:18' AND `tbv_regis_nrb_tol`.`REF` = 'T2241720034583' LIMIT 1
T224 FUNDAR SAKELA 17 20034583 Hilang Fisik Tidak Datang - NULL NULL NULL 2023-07-12 10:15:18 T2241720034583
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'T224' AND `tbv_regis_nrb_tol`.`NamaToko` = 'FUNDAR SAKELA' AND `tbv_regis_nrb_tol`.`No_NRB` = 17 AND `tbv_regis_nrb_tol`.`PLU` = '20122576' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Hilang' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Fisik Tidak Datang - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-12 10:15:18' AND `tbv_regis_nrb_tol`.`REF` = 'T2241720122576' LIMIT 1
T224 FUNDAR SAKELA 17 20122576 Hilang Fisik Tidak Datang - NULL NULL NULL 2023-07-12 10:15:18 T2241720122576
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'T224' AND `tbv_regis_nrb_tol`.`NamaToko` = 'FUNDAR SAKELA' AND `tbv_regis_nrb_tol`.`No_NRB` = 25 AND `tbv_regis_nrb_tol`.`PLU` = '20024303' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Hilang' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Fisik Tidak Datang - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-12 10:19:03' AND `tbv_regis_nrb_tol`.`REF` = 'T2242520024303' LIMIT 1
T224 FUNDAR SAKELA 25 20024303 Hilang Fisik Tidak Datang - NULL NULL NULL 2023-07-12 10:19:03 T2242520024303
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFIG' AND `tbv_regis_nrb_tol`.`NamaToko` = 'KLAGETE' AND `tbv_regis_nrb_tol`.`No_NRB` = 1214 AND `tbv_regis_nrb_tol`.`PLU` = '20016246' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Expired - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` = '2023-07-24' AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 03:37:57' AND `tbv_regis_nrb_tol`.`REF` = 'TFIG121420016246' LIMIT 1
TFIG KLAGETE 1214 20016246 Rusak Expired - NULL NULL 2023-07-24 2023-07-17 03:37:57 TFIG121420016246
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFIG' AND `tbv_regis_nrb_tol`.`NamaToko` = 'KLAGETE' AND `tbv_regis_nrb_tol`.`No_NRB` = 1214 AND `tbv_regis_nrb_tol`.`PLU` = '20104155' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Expired - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` = '2023-07-06' AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 03:37:57' AND `tbv_regis_nrb_tol`.`REF` = 'TFIG121420104155' LIMIT 1
TFIG KLAGETE 1214 20104155 Rusak Expired - NULL NULL 2023-07-06 2023-07-17 03:37:57 TFIG121420104155
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TW4T' AND `tbv_regis_nrb_tol`.`NamaToko` = 'PENDIDIKAN' AND `tbv_regis_nrb_tol`.`No_NRB` = 1412 AND `tbv_regis_nrb_tol`.`PLU` = '20096794' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 03:41:31' AND `tbv_regis_nrb_tol`.`REF` = 'TW4T141220096794' LIMIT 1
TW4T PENDIDIKAN 1412 20096794 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-17 03:41:31 TW4T141220096794
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TYJO' AND `tbv_regis_nrb_tol`.`NamaToko` = 'JENDRAL SUDIRMAN' AND `tbv_regis_nrb_tol`.`No_NRB` = 1193 AND `tbv_regis_nrb_tol`.`PLU` = '20103341' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Expired - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` = '2023-06-01' AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 03:44:34' AND `tbv_regis_nrb_tol`.`REF` = 'TYJO119320103341' LIMIT 1
TYJO JENDRAL SUDIRMAN 1193 20103341 Rusak Expired - NULL NULL 2023-06-01 2023-07-17 03:44:34 TYJO119320103341
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1001 AND `tbv_regis_nrb_tol`.`PLU` = '10000143' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 03:52:36' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100110000143' LIMIT 1
THOD YOS SUDARSO 1001 10000143 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-17 03:52:36 THOD100110000143
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1000 AND `tbv_regis_nrb_tol`.`PLU` = '20054847' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 04:03:35' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100020054847' LIMIT 1
THOD YOS SUDARSO 1000 20054847 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-17 04:03:35 THOD100020054847
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1000 AND `tbv_regis_nrb_tol`.`PLU` = '20067964' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Segel terlepas - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 04:03:35' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100020067964' LIMIT 1
THOD YOS SUDARSO 1000 20067964 Rusak Segel terlepas - NULL NULL NULL 2023-07-17 04:03:35 THOD100020067964
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1000 AND `tbv_regis_nrb_tol`.`PLU` = '20069546' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 04:03:35' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100020069546' LIMIT 1
THOD YOS SUDARSO 1000 20069546 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-17 04:03:35 THOD100020069546
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1000 AND `tbv_regis_nrb_tol`.`PLU` = '20096977' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Segel terlepas - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 04:03:35' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100020096977' LIMIT 1
THOD YOS SUDARSO 1000 20096977 Rusak Segel terlepas - NULL NULL NULL 2023-07-17 04:03:35 THOD100020096977
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1000 AND `tbv_regis_nrb_tol`.`PLU` = '20122476' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Segel terlepas - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 04:03:35' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100020122476' LIMIT 1
THOD YOS SUDARSO 1000 20122476 Rusak Segel terlepas - NULL NULL NULL 2023-07-17 04:03:35 THOD100020122476
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1003 AND `tbv_regis_nrb_tol`.`PLU` = '10003941' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Expired - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` = '2023-07-01' AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 04:08:12' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100310003941' LIMIT 1
THOD YOS SUDARSO 1003 10003941 Rusak Expired - NULL NULL 2023-07-01 2023-07-17 04:08:12 THOD100310003941
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'THOD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'YOS SUDARSO' AND `tbv_regis_nrb_tol`.`No_NRB` = 1003 AND `tbv_regis_nrb_tol`.`PLU` = '20096794' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Pecah - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-17 04:08:12' AND `tbv_regis_nrb_tol`.`REF` = 'THOD100320096794' LIMIT 1
THOD YOS SUDARSO 1003 20096794 Rusak Pecah - NULL NULL NULL 2023-07-17 04:08:12 THOD100320096794
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'T84M' AND `tbv_regis_nrb_tol`.`NamaToko` = 'AHMAD YANI 41' AND `tbv_regis_nrb_tol`.`No_NRB` = 1000 AND `tbv_regis_nrb_tol`.`PLU` = '20122147' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Barang putus - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` = '2023-07-18' AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:36:08' AND `tbv_regis_nrb_tol`.`REF` = 'T84M100020122147' LIMIT 1
T84M AHMAD YANI 41 1000 20122147 Rusak Barang putus - NULL NULL 2023-07-18 2023-07-18 02:36:08 T84M100020122147
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TP9O' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI KEMUNDAN' AND `tbv_regis_nrb_tol`.`No_NRB` = 1084 AND `tbv_regis_nrb_tol`.`PLU` = '20122147' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Barang putus - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` = '2023-07-18' AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:47:54' AND `tbv_regis_nrb_tol`.`REF` = 'TP9O108420122147' LIMIT 1
TP9O SUNGAI KEMUNDAN 1084 20122147 Rusak Barang putus - NULL NULL 2023-07-18 2023-07-18 02:47:54 TP9O108420122147
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '10000184' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42410000184' LIMIT 1
TFZD SUNGAI MARUNI 424 10000184 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-18 02:49:32 TFZD42410000184
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '10000431' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42410000431' LIMIT 1
TFZD SUNGAI MARUNI 424 10000431 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-18 02:49:32 TFZD42410000431
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '10000713' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42410000713' LIMIT 1
TFZD SUNGAI MARUNI 424 10000713 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-18 02:49:32 TFZD42410000713
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '10005601' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42410005601' LIMIT 1
TFZD SUNGAI MARUNI 424 10005601 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-18 02:49:32 TFZD42410005601
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '10012338' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Bocor - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42410012338' LIMIT 1
TFZD SUNGAI MARUNI 424 10012338 Rusak Bocor - NULL NULL NULL 2023-07-18 02:49:32 TFZD42410012338
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '10035900' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42410035900' LIMIT 1
TFZD SUNGAI MARUNI 424 10035900 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-18 02:49:32 TFZD42410035900
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '20007834' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42420007834' LIMIT 1
TFZD SUNGAI MARUNI 424 20007834 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-18 02:49:32 TFZD42420007834
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_regis_nrb_tol WHERE `tbv_regis_nrb_tol`.`KdToko` = 'TFZD' AND `tbv_regis_nrb_tol`.`NamaToko` = 'SUNGAI MARUNI' AND `tbv_regis_nrb_tol`.`No_NRB` = 424 AND `tbv_regis_nrb_tol`.`PLU` = '20019930' AND `tbv_regis_nrb_tol`.`Jenis_Tolakan` = 'Rusak' AND `tbv_regis_nrb_tol`.`Det_Alasan_Tolakan` = 'Kemasan Sobek - ' AND `tbv_regis_nrb_tol`.`PLU2` IS NULL AND `tbv_regis_nrb_tol`.`QTY2` IS NULL AND `tbv_regis_nrb_tol`.`Tgl_Exp` IS NULL AND `tbv_regis_nrb_tol`.`RegDate` = '2023-07-18 02:49:32' AND `tbv_regis_nrb_tol`.`REF` = 'TFZD42420019930' LIMIT 1
TFZD SUNGAI MARUNI 424 20019930 Rusak Kemasan Sobek - NULL NULL NULL 2023-07-18 02:49:32 TFZD42420019930
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query