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 `job_card_items` ORDER BY `is_done` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id job_card_id description quantity unit_price total cost_price vendor_name vat_for_expense type supplier_id product_id created_at is_done Ascending Descending 1 discount
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '00bb1a02-7cd7-4dd7-9895-d381669c08be'
00bb1a02-7cd7-4dd7-9895-d381669c08be 57fb3e4f-d77d-470a-8459-ff2b06e46d54 DETAILING 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:22:34 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '01599eaa-8d32-4959-b0a3-5ad72e7c6959'
01599eaa-8d32-4959-b0a3-5ad72e7c6959 473b9d58-362c-4f7c-ad5d-487470e1b74b FIXING BUMPER AND BONET, PDR, POLISHING BONET 1 4000.00 4000.00 NULL NULL 0 service NULL NULL 2026-03-26 16:22:11 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '017616e9-ffef-4443-a4cd-9627f4845576'
017616e9-ffef-4443-a4cd-9627f4845576 9020c26e-fb2c-444a-a046-9eb5e1f091d4 DETAILLING 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:21:51 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '04b263f8-165a-4bf3-b52d-33270df7f97f'
04b263f8-165a-4bf3-b52d-33270df7f97f 6c64969c-9d35-453c-a799-7e5dfdda152b DETAILING 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:25:45 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '060c2671-7ba1-4e5a-99f0-c1033c1ce282'
060c2671-7ba1-4e5a-99f0-c1033c1ce282 f7c7b2a5-7ff4-481d-9aeb-515f395a3641 REMOVE DENT ON LEFT FRONT FENDER AND REAR LEFT DOO... 1 625.00 625.00 NULL NULL 0 service NULL NULL 2026-03-26 16:25:10 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '06665acb-231d-4e50-833e-eb9834295c2a'
06665acb-231d-4e50-833e-eb9834295c2a 0696b953-5a5f-495e-9fbd-5b7b61772f2b FIXING BODY KIT 1 1250.00 1250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:26:53 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '06a2e90c-8a0f-4e0c-8e5e-c75c3eae6b72'
06a2e90c-8a0f-4e0c-8e5e-c75c3eae6b72 65d3d071-5385-417e-a136-75030c4eec20 DETAILING 1 700.00 700.00 NULL NULL 0 service NULL NULL 2026-03-26 16:24:19 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '06ecdd6f-91e1-4205-9169-4a3123e5910c'
06ecdd6f-91e1-4205-9169-4a3123e5910c 6776d989-4e95-459e-b28e-54432054a1f9 POLISHING 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:21:25 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '086a8f46-d518-47a8-8eb1-68ed66b7792e'
086a8f46-d518-47a8-8eb1-68ed66b7792e c82f78a6-fa07-4360-8ba0-aefedb079d12 Fixing Front bumper 1 1500.00 1500.00 NULL NULL 0 service NULL NULL 2026-04-01 11:30:32 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '08905ade-5f8a-4471-90a3-f467f8bf095c'
08905ade-5f8a-4471-90a3-f467f8bf095c ba1a3901-30af-4720-809d-3952b65c5ef5 DETAILING 1 400.00 400.00 NULL NULL 0 service NULL NULL 2026-03-26 16:26:34 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '089b7532-ff58-456c-b5a1-b008d93fcc51'
089b7532-ff58-456c-b5a1-b008d93fcc51 0f28a077-5c81-4baa-9596-81958c36afe5 POLISHING AND DETAILLING 1 1500.00 1000.00 NULL NULL 0 service NULL NULL 2026-03-26 14:40:51 0 500.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '09c556ed-3542-4c2a-87e1-2dafc84675c7'
09c556ed-3542-4c2a-87e1-2dafc84675c7 769432fe-4a26-40a7-834a-1ec4c6bbfe9e CLEAR COAT CARBON TRUNK 1 100.00 100.00 NULL NULL 0 service NULL NULL 2026-03-26 16:23:25 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '0c024341-7919-4ec5-8778-fa8373304fe9'
0c024341-7919-4ec5-8778-fa8373304fe9 32d20c16-ef75-4e60-ad0e-d3e37fb881f9 FULL FRONT BUMBER SMART PAINT 1 200.00 200.00 NULL NULL 0 service NULL NULL 2026-03-26 16:26:16 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '0e4fcc79-717a-4f0d-9732-6e0761e4841c'
0e4fcc79-717a-4f0d-9732-6e0761e4841c e2df3f69-692a-445a-9111-fce1a7338b67 Front right headlight 1 2500.00 2500.00 2150.00 ZPARTS 0 outsourced NULL NULL 2026-04-13 11:59:08 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '0e9b6fbe-4dc5-4ee6-b345-ed7220babe9e'
0e9b6fbe-4dc5-4ee6-b345-ed7220babe9e 92de01a4-8619-438a-81b9-310cf4b0e3f2 DOOR HANDLE COVERING (BLACK GLOSSY) 1 2000.00 2000.00 NULL NULL 0 service NULL NULL 2026-03-26 16:22:42 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '112dfb5c-031a-40ee-9a1e-451ba7b3dfd3'
112dfb5c-031a-40ee-9a1e-451ba7b3dfd3 a7f05b3d-653c-4ef1-a5a7-6079cb5fd7f5 DETAILING 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:23:18 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '121cb3a9-4d4a-4453-9fe8-4c62e2e0bf81'
121cb3a9-4d4a-4453-9fe8-4c62e2e0bf81 5e43a828-ab08-4d05-bed4-79f95e456fee POLISHING 1 400.00 400.00 NULL NULL 0 service NULL NULL 2026-03-26 16:26:06 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '135b8d41-2731-4228-abe5-af43beb52746'
135b8d41-2731-4228-abe5-af43beb52746 23ab3e45-d304-409b-b97b-e41f97876b8e POLISHING 1 400.00 400.00 NULL NULL 0 service NULL NULL 2026-03-26 16:23:57 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '16fa1789-caf6-491a-9536-f51a25321fd6'
16fa1789-caf6-491a-9536-f51a25321fd6 fbefe3c3-63ae-45ee-8085-5e8ad1f4ffcb TOUCH UP 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:23:03 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '1a083636-bc9b-43d2-b0cb-766b30b0ac28'
1a083636-bc9b-43d2-b0cb-766b30b0ac28 657c43e2-f1d9-49dd-bb11-94905b8b3832 DETAILING 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-26 16:26:30 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '1e203c2b-9a58-4ea2-8556-1ac7ba287c17'
1e203c2b-9a58-4ea2-8556-1ac7ba287c17 8d414ffe-f4f0-4896-943a-29bf61eec576 POLISHING 1 250.00 250.00 NULL NULL 0 service NULL NULL 2026-03-30 10:11:57 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '1e3f16ec-81f0-41ab-8bb8-d49265724491'
1e3f16ec-81f0-41ab-8bb8-d49265724491 769432fe-4a26-40a7-834a-1ec4c6bbfe9e PAINTING DRIVER SEAT 1 300.00 300.00 NULL NULL 0 service NULL NULL 2026-03-26 16:23:23 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '1f883e2e-c11e-46b4-8ee0-2c48cd85fdf0'
1f883e2e-c11e-46b4-8ee0-2c48cd85fdf0 f4c0cfd7-824f-444d-98d0-b95e95a5fef8 POLISHING 1 400.00 400.00 NULL NULL 0 service NULL NULL 2026-03-25 17:47:21 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '216e9a48-d363-408e-8844-10dfec12ab81'
216e9a48-d363-408e-8844-10dfec12ab81 f4ad2c3e-e431-4364-a2eb-a9cd72657d07 POLISHING 1 400.00 400.00 NULL NULL 0 service NULL NULL 2026-03-26 16:26:02 0 0.00
Edit Edit Copy Copy Delete Delete
DELETE FROM job_card_items WHERE `job_card_items`.`id` = '2198ee58-c80b-4583-aa74-ddc1a3ce4b68'
2198ee58-c80b-4583-aa74-ddc1a3ce4b68 a3126781-2213-47e2-b855-f33969e99f81 PAINT FRONT BUMPER 1 500.00 500.00 NULL NULL 0 service NULL NULL 2026-03-26 16:25:40 0 0.00
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