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_kriteria_so`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts SHOP WIL DESC TGL_SO KONDISI_SO LAMA_SO JMLH_PERSONIL JARAK_SO TIPE_GUDANG JMLH_RAK STOK_TOKO P_TOK_SB P_TOK_RTE P_TOK_RTD P_TOK_BUAH P_TOK_POINT TOK_FRSH TOK_POINT TOK_HYBRD TOK_MTH_STR SPD_TOKO
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TX3U' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MARIYAI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 0 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TX3U SON MARIYAI 2023-09-01 20 0 10 10 0 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TIJE' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MALIBELA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TIJE SON MALIBELA 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T84M' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'AHMAD YANI 41' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T84M SON AHMAD YANI 41 2023-09-01 0 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TXYX' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KPR PAM' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TXYX SON KPR PAM 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TC0Z' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'NANGKA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TC0Z SON NANGKA 2023-09-01 20 0 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TBZF' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KLAMASEN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TBZF SON KLAMASEN 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'THOD' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'YOS SUDARSO' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
THOD SON YOS SUDARSO 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TP9O' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'SUNGAI KAMUNDAN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TP9O SON SUNGAI KAMUNDAN 2023-09-01 0 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 0.0 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'THM9' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'SAMRATULANGI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 0 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
THM9 SON SAMRATULANGI 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 0 0.0 0.0 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TYJO' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'JENDRAL SUDIRMAN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 0 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TYJO SON JENDRAL SUDIRMAN 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 0 0.0 0.0 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T1KT' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'JL PRAMUKA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 0 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T1KT SON JL PRAMUKA 2023-09-01 0 10 10 10 5 0 0 0 0 0 0 0 0.0 0.0 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TKWP' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'RAYA FRANS KAISEPO' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 0 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TKWP SON RAYA FRANS KAISEPO 2023-09-01 0 10 10 10 0 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TW87' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MALASOM' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 5 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TW87 SON MALASOM 2023-09-01 20 0 10 10 5 0 5 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T3PP' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'AHMAD YANI RUKO B-D' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T3PP SON AHMAD YANI RUKO B-D 2023-09-01 0 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T4ZW' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BASUKI RAHMAT' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 0 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 5 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T4ZW SON BASUKI RAHMAT 2023-09-01 20 10 0 10 5 0 5 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T6RD' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BASUKI RAHMAT KM 7 NO. 9' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T6RD SON BASUKI RAHMAT KM 7 NO. 9 2023-09-01 20 0 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T7TW' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BUNCIS MALAWELA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 5 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T7TW SON BUNCIS MALAWELA 2023-09-01 0 0 10 10 5 0 5 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TFIG' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KLAGETE' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TFIG SON KLAGETE 2023-09-01 0 0 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TW4T' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'PENDIDIKAN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TW4T SON PENDIDIKAN 2023-09-01 20 0 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T4VV' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'AM SANGAJI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T4VV SON AM SANGAJI 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TPX8' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KAMPUNG SALAK' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TPX8 SON KAMPUNG SALAK 2023-09-01 0 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TUQG' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'TRANS AIMAS' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TUQG SON TRANS AIMAS 2023-09-01 0 0 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TB0U' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BASUKI RAHMAT KM 11' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 0 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TB0U SON BASUKI RAHMAT KM 11 2023-09-01 20 10 0 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TCR7' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MALAWEI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
TCR7 SON MALAWEI 2023-09-01 20 10 10 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
Edit Edit Copy Copy Delete Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T1V9' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'FRANS KAISEIPO' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 0 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
T1V9 SON FRANS KAISEIPO 2023-09-01 20 0 0 10 5 0 0 0 0 0 0 2 0.0 2.5 0.0 2.5 0
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