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 `servis` ORDER BY `status` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id no_nota cabang_id pelanggan_id user_id teknisi_id vendor_id vendor_stage vendor_tanggal_dikirim vendor_tanggal_dikerjakan biaya_approved_by teknisi_2_id vendor_nama vendor_status vendor_biaya nama_pelanggan no_hp_pelanggan pickup_address pickup_maps_url perangkat sn_perangkat keluhan kondisi_fisik kelengkapan foto_perangkat foto_kelengkapan estimasi_biaya biaya_jemput dp biaya_jasa biaya_part biaya_vendor total_biaya margin_profit status Ascending Descending 1 status_pembayaran is_locked tanggal_masuk tanggal_ambil keterangan_teknisi penawaran_syarat
Syarat & ketentuan penawaran servis
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 67
67 SRV-260504-062D 1 62 25 NULL NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 ARYA 6281273940141 CPU RAKITAN Stuck logo & tidak masuk windows UNIT NULL NULL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BARU PENDING 0 2026-05-04 16:20:32 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 68
68 SRV-260504-12EA 1 63 25 NULL NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 KHOIRUL 6282270488811 CPU RAKITAN Mati total UNIT NULL NULL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BARU PENDING 0 2026-05-04 16:21:14 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 72
72 SRV-260505-7325 1 66 25 NULL NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 RIO 628999350260 LAPTOP TOSHIBA INSTALL WINDOWS (windows 10 ke windows yg lebih ri... UNIT, CHARGER NULL NULL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BARU PENDING 0 2026-05-05 11:33:35 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 73
73 SRV-260505-CEC5 1 69 25 NULL NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 ROMI 6285267743091 LAPTOP ZYEREX INSTALL APLIKASI OFFICE STANDAR UNIT, CHARGER, TAS NULL NULL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BARU PENDING 0 2026-05-05 13:39:27 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 74
74 SRV-260505-5FE8 1 70 25 NULL NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 EKA 6281332195590 PRINTER CANON MX328 Tinta tidak keluar UNIT NULL NULL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BARU PENDING 0 2026-05-05 14:07:15 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 76
76 SRV-260505-9E8A 1 62 24 NULL NULL TIDAK NULL NULL NULL NULL NULL DITEMPAT 0.00 Golden star 6281273940141 Laptop Asus A507 - Ketika di senggol laptop tiba tiba mati Unit aja dev_SRV-260505-9E8A.jpg NULL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 BARU PENDING 0 2026-05-05 16:14:41 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 61
61 SRV-260504-C81C 1 56 26 26 NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 Feri 6281369719121 Laptop Lenovo Keyboard mencet sendiri, instal ulang windows Charger, unit, tas dev_SRV-260504-C81C.jpg NULL 0.00 0.00 0.00 0.00 200000.00 0.00 200000.00 0.00 PENAWARAN_DISETUJUI PENDING 0 2026-05-04 12:01:37 NULL [04/05/2026 12:42 - FIR]: Tidak dapat install wind...
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 2
2 SRV-260502-E7C7 1 2 24 23 NULL TIDAK NULL NULL 28 NULL NULL TIDAK 0.00 Andi 6281373559466 Printer epson L3110 Blinking(tidak bisa narik kertas dev_SRV-260502-E7C7.jpg NULL 0.00 0.00 NULL 100000.00 50000.00 0.00 150000.00 0.00 SELESAI PENDING 0 2026-05-02 12:38:21 NULL [02/05/2026 12:39 - FANDI]: Tuas roller bermasalah
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 14
14 SRV-260504-A5D2 1 14 26 26 NULL TIDAK NULL NULL 22 NULL NULL TIDAK 0.00 Desi 6281293140847 Asus a09F Upgrade ram 8 gb Unit dev_SRV-260504-A5D2.jpg NULL 0.00 0.00 NULL 50000.00 500000.00 0.00 550000.00 0.00 SELESAI PENDING 0 2026-05-04 10:35:08 NULL [04/05/2026 10:40 - FIR]: Upgrade ram 4 gb ddr4 so...
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 34
34 SRV-260504-5FDF 1 32 23 23 NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 Pt.sembada/farid 6281216993330 Ups - Drop Unit dev_SRV-260504-5FDF.jpg NULL 0.00 0.00 NULL 0.00 600000.00 0.00 600000.00 0.00 SELESAI PENDING 0 2026-05-04 11:20:41 NULL [04/05/2026 11:24 - Jumbo]: Batre
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 37
37 SRV-260504-6D7F 1 35 23 26 NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 Pt.sembada/farid 62812163330 Ica - Drop Unit dev_SRV-260504-6D7F.jpg NULL 0.00 0.00 NULL 0.00 280000.00 0.00 280000.00 0.00 SELESAI PENDING 0 2026-05-04 11:22:13 NULL [04/05/2026 14:16 - FIR]: kondisi normal sdh di te...
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 66
66 SRV-260504-7A36 1 61 25 23 NULL TIDAK 2026-05-04 13:38:00 2026-05-04 13:38:00 28 NULL NULL TIDAK 0.00 NYIMAS 6285379032005 LAPTOP AXIOO CEK BATERAI KEMBUNG (KONDISI MATI) UNIT, CHARGER NULL NULL 0.00 0.00 200000.00 0.00 550000.00 0.00 550000.00 0.00 SELESAI PENDING 0 2026-05-04 12:16:36 NULL [05/05/2026 13:28 - AYU PUTRI HANDAYANI]: Terima D...
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 69
69 SRV-260504-4DF3 1 64 25 24 NULL TIDAK NULL NULL 22 NULL NULL TIDAK 0.00 SINTA 6281361259011 LAPTOP Acer aspire 3 Wifi tidak connect UNIT, CHARGER, TAS NULL NULL 0.00 0.00 0.00 20000.00 0.00 0.00 20000.00 0.00 SELESAI PENDING 0 2026-05-04 16:22:10 NULL [05/05/2026 09:31 - FANDI]: Update driver internet
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 70
70 SRV-260504-B377 1 64 25 24 NULL TIDAK NULL NULL 22 NULL NULL TIDAK 0.00 SINTA 6281361259011 LAPTOP Asus X441M Wifi tidak bisa connect ke hp UNIT, CHARGER, TAS NULL NULL 0.00 0.00 0.00 20000.00 0.00 0.00 20000.00 0.00 SELESAI PENDING 0 2026-05-04 16:22:57 NULL [05/05/2026 10:07 - FANDI]: Update driver wifi
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 75
75 SRV-260505-3615 1 32 22 2 NULL TIDAK NULL NULL 28 NULL NULL TIDAK 0.00 Pt.sembada/farid 6281216993330 CPU RAKITAN SERING HANK NULL NULL 0.00 0.00 0.00 0.00 650000.00 0.00 650000.00 0.00 SELESAI PENDING 0 2026-05-05 14:39:11 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 1
1 SRV-260502-F36F 1 1 2 24 NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 TIARA 6289531527873 PRINTER L3110 TINTA TIDAK LANCAR Unit NULL NULL 0.00 0.00 NULL 200000.00 0.00 0.00 200000.00 0.00 DIAMBIL PENDING 0 2026-05-02 10:02:19 2026-05-02 19:14:07 [02/05/2026 12:32 - FANDI]: Printhead lemah
[02/05...
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 3
3 SRV-260502-3BCC 1 3 22 2 NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 Mei 6285809579134 laptop hp 14 em881 TIDAK MASUK WINDOWS NULL NULL 0.00 0.00 NULL 30000.00 0.00 0.00 30000.00 0.00 DIAMBIL PENDING 0 2026-05-02 20:06:13 2026-04-03 20:27:25 [02/05/2026 20:25 - AYU PUTRI HANDAYANI]: Analisa:...
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 4
4 SRV-260502-BD06 1 4 22 2 NULL TIDAK NULL NULL NULL NULL NULL TIDAK 0.00 SEla 6282176650672 ASUS VIVOBOOK 14 TIDAK MASUK WINDOWS NULL NULL 0.00 0.00 NULL 75000.00 0.00 0.00 75000.00 0.00 DIAMBIL PENDING 0 2026-05-02 20:32:24 2026-04-04 20:34:28 [02/05/2026 20:33 - AYU PUTRI HANDAYANI]: analisa ...
Edit Edit Copy Copy Delete Delete
DELETE FROM servis WHERE `servis`.`id` = 13
13 SRV-260503-BB8B 1 13 24 28 NULL TIDAK NULL NULL NULL NULL NULL DITEMPAT 0.00 Fandi 6283809742129 Laptop asus - Engsel patah Unit dev_SRV-260503-BB8B.jpg NULL 0.00 0.00 0.00 0.00 250000.00 0.00 0.00 0.00 CANCEL PENDING 0 2026-05-03 18:56:46 NULL [03/05/2026 19:04 - FANDI]: Wawawawawawawa
[03/05/...
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