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 `gdydcolordet` ORDER BY `gydid` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts gydid Descending Ascending 1 gdid ydcolor ydqty subref subrefdate iopmid reference devtype approval appdate ydwtg
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12367
12367 31717 White(YBR) 1161 COMO PLAID + WHITE MULTI 3100.00 IOM 2026-07-25 87839 NULL NEW 2nd Submitted Yardage 2026-07-25 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12366
12366 31717 Carbon Navy(DCC) 1162 COVINGTON PLAID + CARBON NAV 4600.00 IOM 2026-07-25 87839 NULL NEW 2nd Submitted Yardage 2026-07-25 NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12365
12365 31703 02 (700 BROWM ) 2290.00 SAMPLE 2026-07-23 NULL IOM-88892 NEW IOM-88892 2026-07-23 8.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12364
12364 31701 2 (700 BROWN) 10855.00 SAMPLE 2026-07-23 NULL IOM-88892 NEW IOM-88892 2026-07-23 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12363
12363 31697 TBA 25000.00 SAMPLE 2026-07-01 NULL As per Swatch Repeat As per Swatch 2026-07-04 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12362
12362 31242 GREY STRIPE SEERSUCKER 2500.00 SAMPLE 2025-09-26 NULL IOM-80556/2025 Repeat IOM-80556/2025 2026-03-01 8.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12361
12361 31694 ECRU F. BRICH 13 0905TCX 5825.00 SAMPLE 2026-07-21 NULL IOM 73854 New ECRU F. BRICH 13 0905TCX 2026-07-21 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12360
12360 31694 MARRON TAUPE 5435.00 SAMPLE 2026-07-21 NULL - New - 2026-07-21 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12359
12359 31691 3 (Neutral mirco check) 3610.00 SAMPLE 2026-07-19 NULL GD-31495 Repeat GD-31495 2026-07-19 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12358
12358 31689 INDIGO 1000.00 IOM 2026-06-26 82955 NULL NEW IOM 82955/2025 2026-07-15 10.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12357
12357 31688 Sassafras 4330.00 SAMPLE 2026-07-01 NULL GD-30593 Repeat GD-30593 2026-07-18 7.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12356
12356 31688 Brindle 3251.00 SAMPLE 2026-07-01 NULL GD-30593 Repeat GD-30593 2026-07-18 8.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12355
12355 31688 Urban Chic 9430.00 SAMPLE 2026-07-01 NULL GD-30593 Repeat GD-30593 2026-07-18 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12354
12354 31688 Vintage Indigo 9958.00 SAMPLE 2026-07-01 NULL GD-30593 Repeat GD-30593 2026-07-18 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12353
12353 31684 LP-S27-ALL-NFA2011A 10330.00 SAMPLE 2026-06-25 NULL IOM-86896 New 2nd Submission Approved 2026-06-26 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12352
12352 31682 CAR-S27-ALL-NFA1059A 12734.00 SAMPLE 2026-06-25 NULL IOM-87770 NEW 1st Submission Approved 2026-06-26 6.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12351
12351 31674 Col - 10-210 White Light Stripe 5388.00 HANDLOOM 2026-07-01 NULL TBA Repeat TBA 2026-07-07 5.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12350
12350 31674 Col - 74-211 Blue Light Stripe 7575.00 HANDLOOM 2026-07-01 NULL IOM-88617 D-43428 New IOM-88617 D-43428 2026-07-03 12.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12349
12349 31673 C127CJGYD111-4 15402.00 HANDLOOM 2026-06-24 NULL D-43233 NEW APPROVED 2026-07-16 5.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12348
12348 31673 C127CJGYD111-3 49621.00 HANDLOOM 2026-06-24 NULL D-43234 NEW APPROVED 2026-07-16 5.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12347
12347 28625 18-305 Brown Medium Dusty 1460.00 SAMPLE 2024-11-01 NULL IOM-84203 Repeat D-41985R1 2024-11-18 14.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12346
12346 31059 74-205 Blue Light C/W-005 450.00 SAMPLE 2026-03-03 NULL IOM-84954 Repeat IOM-84954 2026-03-05 30.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12345
12345 31656 OF27-012:SIGNATURE PLAID 3780.00 HANDLOOM 2026-07-12 NULL As per swatch NEW As per swatch 2026-07-13 5.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12344
12344 31655 Cornstalk 2493.00 SAMPLE 2026-07-13 NULL ref IOM 85450/2026 NEW Approved 2026-07-13 7.00
Edit Edit Copy Copy Delete Delete
DELETE FROM gdydcolordet WHERE `gdydcolordet`.`gydid` = 12343
12343 29922 76- 109 / 001 ( YD Check) 1322.00 SAMPLE 2025-08-01 NULL IOM-85144 NEW IOM-85144 2025-08-01 15.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