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 `iostckupd` ORDER BY `iopdidupd` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
IOMNo iopmid RackNo Colorway iopdidupd Descending Ascending 1 Composition Weave Construction Fabricprocess Buyer Fabricfinish Emarizing GSM Rollqty CURRENT STOCK QTY
68686/2023 68686 NONE RFD 115305 98% COTTON 2% SPANDEX DOBBY 0X30+30+40D/216X116 RFD BERSHKA PEACH FINISH PEACH FINISH 280 1 27
68667/2023 68667 NONE PRINT 115278 80% BCI COTTON & 20% RECYCLED COTTON(PRE) 3/1 S TWILL 10X10/72X42 AOP H&M SOFT PEACH FINISH 270 1 14
68592/2023 68592 NONE RFD 115173 100% BCI COTTON TWILL 2/1 S TWILL 30X20/140X70 RFD NEXT SOFT PEACH FINISH 200 10 525
68558/2023 68558 NONE STONE 115104 100% BCI COTTON TWILL 3/1 S TWILL 20X16/128X60 Solid Dyed C&A REGULAR SOFT PEACH FINISH 225 1 20
68557/2023 68557 NONE 16-5101 115103 100% COTTON RIBSTOP RIBSTOP 20X16/110X55 Solid Dyed C&A REGULAR SOFT Non Peach 210 1 16
68546/2023 68546 NONE PRINT 115088 100% BCI COTTON OXFORD (6+6)X10/2/72X28 AOP VF ASIA LTD/ REGULAR Non Peach 420 1 3
68546/2023 68546 NONE PRINT 115088 100% BCI COTTON OXFORD (6+6)X10/2/72X28 AOP VF ASIA LTD/ REGULAR Non Peach 420 1 5
68528/2023 68528 NONE RFD 115059 79% BCI COTTON, 19% POLYESTER & 2% SPANDEX DOBBY 20X16+150D/144F+40D/144X88 RFD DREUSS WORLDWIDE LTD/ SOFT PEACH FINISH 302 4 145
68519/2023 68519 NONE PELICAN 14-6305 TCX 115043 100% BCI COTTON POPLIN 1/1 PLAIN 40X40/133X100 Solid Dyed NEXT SOFT Non Peach 134 1 22
68519/2023 68519 NONE 13-4303 115040 100% BCI COTTON POPLIN 1/1 PLAIN 40X40/133X100 Solid Dyed NEXT SOFT Non Peach 134 1 38
68502/2023 68502 130 RFD 115018 100% TENCEL 3/1 S TWILL 20X20/116X65 RFD TESCO REGULAR Non Peach 205 1 60
68501/2023 68501 128 RFD 115017 50% BCI COTTON & 50% TENCEL 2/2 Z TWILL 30X30/114X96 RFD TESCO SOFT Non Peach 170 1 25
68495/2023 68495 NONE Olive 115005 100% BCI COTTON 3/1 S TWILL 16X12/110X54 Solid Dyed BEST SELLER LTD/ REGULAR Lt/ Peach 263 1 24
68485/2023 68485 NONE VAPOROUS GREY 114976 98% BCI COTTON 2% SPANDEX 3/1 S TWILL 30X20+70D/168X66 Solid Dyed NEXT SOFT PEACH FINISH 205 1 14
68485/2023 68485 NONE STORMY SEA 114974 98% BCI COTTON 2% SPANDEX 3/1 S TWILL 30X20+70D/168X66 Solid Dyed NEXT SOFT PEACH FINISH 207 1 8
68485/2023 68485 NONE 17-1137 114974 98% BCI COTTON 2% SPANDEX 3/1 S TWILL 30X20+70D/168X66 Solid Dyed NEXT SOFT PEACH FINISH 205 1 13
68464/2023 68464 NONE RFD 114950 67% BCI COTTON, 31% RAYON & 2% SPANDEX 3/1 Z TWILL 12SX20+70D/96X62 RFD KOHLS REGULAR PEACH FINISH 282 1 47
68462/2023 68462 81 RFD 114949 98% BCI COTTON & 2% SPANDEX PANAMA (20+20)X(16+70D+16+70D)/120X60 RFD TIFFOSI PEACH FINISH PEACH FINISH 235 1 27
68447/2023 68447 NONE RFD 114925 100% BCI COTTON 2/2 Z TWILL 60/2X60/2/160X80 RFD RALPH LAUREN SOFT PEACH FINISH 189 1 21
68435/2023 68435 NONE RFD 114901 98% BCI COTTON & 2% SPANDEX 3/1 Z TWILL 10X10+70D/82X56 RFD AMERICAN EAGLE REGULAR SOFT PEACH FINISH 323 2 81
68430/2023 68430 NONE RFD 114896 98% TENCEL & 2% SPANDEX 2/1 S TWILL 20X20+70D/102X48 RFD AMERICAN EAGLE REGULAR SOFT Non Peach 190 1 27
68421/2023 68421 NONE PRINT 114886 100% COTTON(CMIA) 2/2 Z TWILL 20X20/64X54 Print On Reactive Dy DISTRA SOFT FACE SIDE BRUSH 180 1 8
68421/2023 68421 NONE PRINT 114886 100% COTTON(CMIA) 2/2 Z TWILL 20X20/64X54 Print On Reactive Dy DISTRA SOFT FACE SIDE BRUSH 140 2 81
68420/2023 68420 106 As per swatch 114885 98% BCI COTTON & 2% SPANDEX 3/1 S TWILL 20X20+70D/140X57 Solid Dyed TALISMAN LTD/ SOFT Non Peach 234 1 25
68409/2023 68409 NONE STONE 114869 100% COTTON PANAMA CANVAS PANAMA CANVAS (16+16)X(12+12)/108X56 PIGMENT TOPPING ON REACTIVE BASE VF ASIA LTD/ REGULAR Non Peach 265 1 6
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