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 :
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 `job_cards` ORDER BY `job_card_number` DESC
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
Sort by key:
Full texts id job_card_number Descending Ascending 1 quotation_id customer_id vehicle_id assigned_to status priority start_date completion_date actual_labor_hours notes subtotal tax total_amount created_at updated_at advance_amount vehicle_inspection_report_id branch_id sales_vat_exempt discount lpo_number vehicle_km
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'c41a133f-e0f1-40f1-a600-665006452748'
 		c41a133f-e0f1-40f1-a600-665006452748 JC-2026-0097 c695dd51-f5e8-4142-be47-074ef898b37a b32856df-759d-415a-89ff-8cb09a021585 28b26626-1553-49b1-99dd-7b60b1456825 3783e945-6e94-400d-8bc9-13faa4c621bb pending medium NULL NULL 0.00 NULL 600.06 0.00 600.06 2026-04-17 09:51:04 2026-04-18 12:40:41 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'aee0a0b0-a12e-4b62-a7e1-c506f8f72339'
 		aee0a0b0-a12e-4b62-a7e1-c506f8f72339 JC-2026-0096 d8c3ccaa-6af1-44da-a89a-2f2889bd7873 7506015e-37e8-4f79-951b-c5bfec974515 1fd1778a-1ddb-44e3-94d6-cad1285da923 3783e945-6e94-400d-8bc9-13faa4c621bb pending medium NULL NULL 0.00 NULL 15200.04 0.00 15200.04 2026-04-14 14:30:05 2026-04-17 14:40:40 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '901b6259-7d63-4561-9f68-e907696b14b3'
 		901b6259-7d63-4561-9f68-e907696b14b3 JC-2026-0095 73bc4080-c4a1-45c1-be63-d9a6d2180a9a 15a7f269-9457-427f-b840-2c00196f5968 9ce9329d-83b4-467e-b6c7-e99c889af923 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-04-13 05:54:57 NULL NULL 15000.00 0.00 15000.00 2026-04-13 09:54:41 2026-04-13 09:54:57 5000.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '36dc78a8-0f10-4bc8-93e0-c5bb1827c8a8'
 		36dc78a8-0f10-4bc8-93e0-c5bb1827c8a8 JC-2026-0094 95f41997-74a1-4b06-92ce-0fd600a73310 55a2e017-159f-4266-8c2d-057e19e72ae3 29015a0a-d95e-4d7d-8e7f-930f32ab8a51 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-04-10 09:37:56 NULL NULL 500.00 0.00 500.00 2026-04-10 11:32:49 2026-04-10 13:37:56 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'e2df3f69-692a-445a-9111-fce1a7338b67'
 		e2df3f69-692a-445a-9111-fce1a7338b67 JC-2026-0093 fd5868f6-88b9-4f94-8a95-91ac3db60412 304e221b-8139-41b7-8c42-c263a62675d8 14b268f7-d778-40b1-8c79-9894e8521686 2e4aa417-592c-4d48-9b6e-929341addbdf completed medium NULL 2026-04-13 13:24:21 0.00 NULL 7799.97 390.00 8189.97 2026-04-08 11:18:11 2026-04-13 17:24:21 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 0 100.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '6c9b9d05-67bf-4a08-bdbe-1e69f5acbb91'
 		6c9b9d05-67bf-4a08-bdbe-1e69f5acbb91 JC-2026-0092 5ba0a3eb-01e6-4637-a1ce-81d2c62316f9 882e8316-6237-49fd-8136-4458ec443d60 27999af0-a50f-4701-9030-e254e0eff736 2e4aa417-592c-4d48-9b6e-929341addbdf completed medium NULL 2026-04-02 01:59:43 0.00 NULL 40.00 2.00 42.00 2026-04-02 09:59:33 2026-04-02 10:00:35 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 0 10.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '3db35117-1329-4c87-b28c-0d92403b63fd'
 		3db35117-1329-4c87-b28c-0d92403b63fd JC-2026-0091 66ea71fd-c0dd-4f10-b078-cb80ba201d8c 50118a8b-9da5-42d4-af92-fa85f33a5a38 8af0ee10-b7f7-493d-b832-754c74c3d5a7 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-04-01 07:32:41 NULL NULL 10000.00 0.00 10000.00 2026-04-01 11:32:07 2026-04-01 11:32:41 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'c82f78a6-fa07-4360-8ba0-aefedb079d12'
 		c82f78a6-fa07-4360-8ba0-aefedb079d12 JC-2026-0090 e875bcba-8dc8-4c34-a41e-4a228e66a6c3 3692de10-f6b4-481b-9127-45ad8f51056f 6ec80c27-eb11-4633-9561-56e343d5eb07 2e4aa417-592c-4d48-9b6e-929341addbdf completed medium NULL 2026-04-01 07:31:01 NULL NULL 4470.00 223.50 4693.50 2026-04-01 11:30:32 2026-04-01 11:31:01 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 0 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '85a459d5-f67f-4ab7-9010-53a036313e2c'
 		85a459d5-f67f-4ab7-9010-53a036313e2c JC-2026-0089 NULL 55a2e017-159f-4266-8c2d-057e19e72ae3 0d2241e8-c65d-4535-93e6-22ec61273722 NULL pending medium 2026-03-30 20:00:00 NULL 0.00 NULL 0.02 0.00 0.02 2026-03-31 09:46:27 2026-03-31 10:14:08 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 0 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '27c82c29-131e-4541-be3d-bebce3cc853b'
 		27c82c29-131e-4541-be3d-bebce3cc853b JC-2026-0088 7ec5bcf0-274a-4ef6-aba6-e54db46bccfd 55a2e017-159f-4266-8c2d-057e19e72ae3 cdbcac97-624c-490a-a553-284d049d1b1c 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-30 07:18:24 NULL NULL 2500.00 0.00 2500.00 2026-03-30 11:17:59 2026-03-30 11:18:24 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '8d414ffe-f4f0-4896-943a-29bf61eec576'
 		8d414ffe-f4f0-4896-943a-29bf61eec576 JC-2026-0087 966eff73-537b-431e-98be-b6c788f5f2e5 55a2e017-159f-4266-8c2d-057e19e72ae3 771bdae9-fbef-447e-bffc-6d5517936e69 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-30 07:18:46 NULL NULL 500.00 0.00 500.00 2026-03-30 10:11:56 2026-03-30 11:18:46 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'cfb175f0-14ce-49d1-b3a0-f49a0890dda5'
 		cfb175f0-14ce-49d1-b3a0-f49a0890dda5 JC-2026-0086 b1161f44-cc82-431e-b385-95a5e0fdf412 22f9f981-a2e8-4572-8808-f119c4483305 691aea3b-a355-4583-bcbf-9ff245f21920 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:22:16 NULL NULL 1857.14 92.86 1950.00 2026-03-26 16:27:05 2026-03-26 17:22:16 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 0 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '150e997f-438c-4087-9868-3d4870bc15c8'
 		150e997f-438c-4087-9868-3d4870bc15c8 JC-2026-0085 39f73686-56a6-4dae-89c9-f8b1d1017073 608c2553-0edc-4f5b-98e9-b070fc9975d3 c6fe1922-08d8-4272-b2ba-3c676409cd2b 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 05:21:56 0.00 NULL 1500.00 75.00 1575.00 2026-03-26 16:27:01 2026-03-27 09:34:18 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 0 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '864c0fe9-31ba-43c2-b0f9-8b6cdfbff3a4'
 		864c0fe9-31ba-43c2-b0f9-8b6cdfbff3a4 JC-2026-0084 2ee30874-65c6-4687-8b33-99e255a8e1ef 995bf727-84aa-4666-8d20-e28759784491 18868345-27e8-424e-972e-56220d4182a4 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:21:37 NULL NULL 2600.00 0.00 2600.00 2026-03-26 16:26:57 2026-03-26 17:21:37 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '0696b953-5a5f-495e-9fbd-5b7b61772f2b'
 		0696b953-5a5f-495e-9fbd-5b7b61772f2b JC-2026-0083 d202db82-30f6-45c5-9087-0b0206ada095 3d01f02e-516f-43b4-b564-6a6ad0658eda 5f2f29f3-70dd-4f19-aa6b-59c9344e5f38 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:21:14 NULL NULL 3100.00 0.00 3100.00 2026-03-26 16:26:53 2026-03-26 17:21:14 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '29ab1d7e-f11f-4850-870e-33676b00d315'
 		29ab1d7e-f11f-4850-870e-33676b00d315 JC-2026-0082 edec6fa6-ef58-443d-8b45-893160b5fe5d fb88afdd-870a-4afc-bfc5-8dc0f84bd38b 59151f55-9c3c-4a1c-85ab-0029591c839d 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:20:54 NULL NULL 5000.00 0.00 5000.00 2026-03-26 16:26:49 2026-03-26 17:20:54 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'e5707ba8-419c-4a81-8130-2b14b65994bf'
 		e5707ba8-419c-4a81-8130-2b14b65994bf JC-2026-0081 7e266b12-553c-42d7-80fc-bc61ceacd2bd 58264d95-c3df-48b5-ae38-3577f7e9d877 c016d4fc-b0eb-4fa6-8ac1-86ea313c9c11 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:20:34 NULL NULL 2550.00 0.00 2550.00 2026-03-26 16:26:46 2026-03-26 17:20:34 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'cddaf34f-e187-4697-8d1e-9d67cba190d6'
 		cddaf34f-e187-4697-8d1e-9d67cba190d6 JC-2026-0080 86714954-24f2-42e2-95ae-00ebc62b6aaa 58264d95-c3df-48b5-ae38-3577f7e9d877 40a64816-4bc0-4686-8bd4-47d00576ca6d 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:20:11 NULL NULL 800.00 0.00 800.00 2026-03-26 16:26:38 2026-03-26 17:20:11 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'ba1a3901-30af-4720-809d-3952b65c5ef5'
 		ba1a3901-30af-4720-809d-3952b65c5ef5 JC-2026-0079 e4f588ce-2410-40a0-b0d9-81a621ed23c3 58264d95-c3df-48b5-ae38-3577f7e9d877 efa3753d-0db0-4b6a-bf5a-7f16e0ae6254 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:19:46 NULL NULL 800.00 0.00 800.00 2026-03-26 16:26:34 2026-03-26 17:19:46 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '657c43e2-f1d9-49dd-bb11-94905b8b3832'
 		657c43e2-f1d9-49dd-bb11-94905b8b3832 JC-2026-0078 d435e334-27eb-45af-a103-78d589253e87 55a2e017-159f-4266-8c2d-057e19e72ae3 0587f239-98c5-4d56-b2dc-44ccc323630d 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:19:26 NULL NULL 1000.00 0.00 1000.00 2026-03-26 16:26:30 2026-03-26 17:19:26 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'e4747648-589c-43b5-ad6d-a86833906f16'
 		e4747648-589c-43b5-ad6d-a86833906f16 JC-2026-0077 0b71d6f7-6bc2-4cd9-8d4b-4d26eef77f53 55a2e017-159f-4266-8c2d-057e19e72ae3 522ab0c3-5b7d-4b17-a39a-760cf4ce5681 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:19:04 NULL NULL 500.00 0.00 500.00 2026-03-26 16:26:21 2026-03-26 17:19:04 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '32d20c16-ef75-4e60-ad0e-d3e37fb881f9'
 		32d20c16-ef75-4e60-ad0e-d3e37fb881f9 JC-2026-0076 ad313d92-472f-4fbe-8870-29993c701d35 55a2e017-159f-4266-8c2d-057e19e72ae3 f963d316-92cf-463f-9a86-cff2132c2346 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:18:38 NULL NULL 700.00 0.00 700.00 2026-03-26 16:26:15 2026-03-26 17:18:38 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'f53f065a-d862-48b1-9958-c018eff157cc'
 		f53f065a-d862-48b1-9958-c018eff157cc JC-2026-0075 0df32f26-940b-42f2-9843-3dfbe3f7f6f3 55a2e017-159f-4266-8c2d-057e19e72ae3 d40984cc-32ab-4389-b8e5-36602533ab33 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:18:16 NULL NULL 250.00 0.00 250.00 2026-03-26 16:26:10 2026-03-26 17:18:16 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = '5e43a828-ab08-4d05-bed4-79f95e456fee'
 		5e43a828-ab08-4d05-bed4-79f95e456fee JC-2026-0074 5ae29584-3db1-472b-8075-39aa17e4d739 58264d95-c3df-48b5-ae38-3577f7e9d877 190333e9-afe5-466b-a1bb-e1d418f0c096 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:17:54 NULL NULL 1850.00 0.00 1850.00 2026-03-26 16:26:06 2026-03-26 17:17:54 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM job_cards WHERE `job_cards`.`id` = 'f4ad2c3e-e431-4364-a2eb-a9cd72657d07'
 		f4ad2c3e-e431-4364-a2eb-a9cd72657d07 JC-2026-0073 2c2c933d-03fa-479e-ab84-bba96d51c11c 58264d95-c3df-48b5-ae38-3577f7e9d877 075b63b2-e2b9-4818-a71a-be79e883febe 3783e945-6e94-400d-8bc9-13faa4c621bb completed medium NULL 2026-03-26 13:17:31 NULL NULL 1050.00 0.00 1050.00 2026-03-26 16:26:02 2026-03-26 17:17:31 0.00 NULL 40e34208-0e98-4c0d-be45-deff7dc0babc 1 0.00 NULL NULL
With selected: With selected:
|
|
|
|
Filter rows:
Sort by key:
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