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 `porivdetail` ORDER BY `piid` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts pprivid pprivdate ppid ppdate piid Descending Ascending 1 buyid emarid gwid lsid testsid enduseid finsid ppdelvdate wrapshrinkage weftshrinkage packing ppsample stid mmid mmdate srmmid srmmdate gmid gmdate poqty poruid seclsid poinst porivdate pprevno srkwid dyedlvdate dyecomment dyeuserid dyeappdate graydlvdate graycomment grayuserid grayappdate
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8447
8447 2026-07-22 50348 2026-07-22 48368 24 12 18 10 1 6 2 2026-08-26 3.00 3.00 Local Export 0 3 316 2026-07-22 356 2026-07-22 229 2026-07-22 6638.00 86 2 <p><strong>O/N-709442-7617<br />
<br />
- TEAR,T...
NULL NULL 4 2026-08-26 Auto Approve 85 2026-07-22 2026-08-26 Auto Approve 48 2026-07-22
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8449
8449 2026-07-23 50330 2026-07-20 48359 1143 12 9 1 1 10 2 2026-08-21 3.00 5.00 Local Export 0 3 207 2026-07-20 68 2026-07-20 68 2026-07-20 7230.00 86 2 <p><strong style="color: rgb(51, 51, 51); font-fam... NULL NULL 3 2026-08-21 Auto Approve 85 2026-07-20 2026-08-21 Auto Approve 48 2026-07-20
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8446
8446 2026-07-22 50298 2026-07-18 48331 13 4 18 2 1 6 2 2026-08-18 -6.00 -4.00 Local Export 0 3 472 2026-07-18 296 2026-07-18 296 2026-07-18 10000.00 86 2 <p>&nbsp;<span style="font-size: medium; color: rg... NULL NULL 1 2026-08-18 Auto Approve 85 2026-07-18 2026-08-18 Auto Approve 48 2026-07-18
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8437
8437 2026-07-19 50293 2026-07-18 48326 1181 12 9 2 1 10 2 2026-08-20 -2.00 -3.00 Local Export 0 3 453 2026-07-18 158 2026-07-18 97 2026-07-18 23596.00 86 2 NULL NULL NULL 1 2026-08-20 Auto Approve 85 2026-07-18 2026-08-20 Auto Approve 48 2026-07-18
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8436
8436 2026-07-18 50290 2026-07-16 48320 45 12 5 2 1 10 2 2026-08-17 3.00 7.00 Local Export 10 3 362 2026-07-16 267 2026-07-18 89 2026-07-18 10152.00 86 5 <p>&nbsp;<strong style="color: rgb(51, 51, 51); fo... NULL NULL 1 2026-08-17 Auto Approve 85 2026-07-16 2026-08-17 Auto Approve 48 2026-07-16
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8445
8445 2026-07-22 50285 2026-07-16 48252 2142 12 18 2 1 21 2 2026-08-20 -4.00 -4.00 Local Export 0 3 443 2026-07-16 241 2026-07-16 97 2026-07-16 4090.00 86 5 <p>&nbsp;THIS IS 1st Order for PEAK APPAREL LTD.&n... NULL NULL 3 2026-08-20 Auto Approve 85 2026-07-16 2026-08-20 Auto Approve 48 2026-07-16
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8435
8435 2026-07-18 50261 2026-07-14 48222 1454 4 9 1 1 32 2 2026-08-15 -4.00 -4.00 Local Export 50 3 446 2026-07-14 68 2026-07-14 68 2026-07-14 8030.00 86 2 <h2><span style="background-color: rgb(255, 255, 0... NULL NULL 3 2026-08-15 Auto Approve 85 2026-07-14 2026-08-15 Auto Approve 48 2026-07-14
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8421
8421 2026-07-11 50187 2026-07-09 48186 1388 12 9 7 1 27 2 2026-08-10 3.00 3.00 Local Export 20 3 422 2026-07-09 344 2026-07-09 229 2026-07-09 22556.00 86 2 <p><strong style="color: rgb(51, 51, 51); font-fam... NULL NULL 1 2026-08-10 Auto Approve 85 2026-07-09 2026-08-10 Auto Approve 48 2026-07-09
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8422
8422 2026-07-11 50167 2026-07-07 48185 1388 12 9 2 1 14 2 2026-08-10 3.00 3.00 Local Export 20 3 422 2026-07-07 344 2026-07-07 229 2026-07-07 37571.00 86 2 <p style="color: rgb(51, 51, 51); font-family: Ver... NULL NULL 1 2026-08-10 Auto Approve 85 2026-07-07 2026-08-10 Auto Approve 48 2026-07-07
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8444
8444 2026-07-22 50152 2026-07-07 48181 455 4 3 2 1 20 2 2026-08-08 -3.00 -3.00 Local Export 35 3 254 2026-07-07 248 2026-07-08 248 2026-07-08 650.00 86 5 <h4 style="color: rgb(51, 51, 51); font-family: Ve... NULL NULL 1 2026-08-08 Auto Approve 85 2026-07-07 2026-08-08 Auto Approve 48 2026-07-07
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8413
8413 2026-07-07 50122 2026-07-06 48174 24 12 9 10 1 9 2 2026-08-08 3.00 3.00 Local Export 50 3 316 2026-07-06 356 2026-07-06 229 2026-07-06 16957.00 86 2 <p><strong>O/N-698825-5787,698824-5787,698823-5787... NULL NULL 4 2026-08-08 Auto Approve 85 2026-07-06 2026-08-08 Auto Approve 48 2026-07-06
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8441
8441 2026-07-20 50195 2026-07-11 48153 1454 4 9 1 1 6 2 2026-08-11 -4.00 -4.00 Local Export 0 3 446 2026-07-11 68 2026-07-11 68 2026-07-11 8030.00 86 2 <h1><span style="font-family: Tahoma;"><strong>THI... NULL NULL 3 2026-08-11 Auto Approve 85 2026-07-11 2026-08-11 Auto Approve 48 2026-07-11
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8439
8439 2026-07-20 50054 2026-07-02 48128 1690 4 29 2 1 1 2 2026-08-04 -2.00 -2.00 Local Export 0 3 453 2026-07-02 158 2026-07-02 97 2026-07-02 10650.00 86 2 <p><label class="formColumnData" name="gdid" id="g... NULL NULL 1 2026-08-04 Auto Approve 85 2026-07-02 2026-08-04 Auto Approve 48 2026-07-02
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8414
8414 2026-07-07 50074 2026-07-04 48121 13 12 18 2 1 10 2 2026-08-05 -4.00 -4.00 Local Export 0 3 472 2026-07-04 296 2026-07-04 296 2026-07-04 16404.00 86 2 <p>&nbsp;<span style="font-family: VERDANA; font-s... NULL NULL 1 2026-08-05 Auto Approve 85 2026-07-04 2026-08-05 Auto Approve 48 2026-07-04
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8429
8429 2026-07-12 50053 2026-07-02 48107 24 4 9 10 1 9 2 2026-08-04 3.00 3.00 Local Export 50 3 316 2026-07-02 356 2026-07-02 229 2026-07-02 19440.00 86 2 <p><strong>O/N-695831-5777,696580-5777,696577-5777... NULL NULL 4 2026-08-04 Auto Approve 85 2026-07-02 2026-08-04 Auto Approve 48 2026-07-02
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8406
8406 2026-07-04 50024 2026-07-01 48096 24 12 9 10 1 6 2 2026-08-05 3.00 3.00 Local Export 0 3 316 2026-07-01 356 2026-07-01 229 2026-07-01 3250.00 86 2 <p><strong>O/N-695084 -6555<br />
<br />
- TEAR,...
NULL NULL 4 2026-08-05 Auto Approve 85 2026-07-01 2026-08-05 Auto Approve 48 2026-07-01
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8440
8440 2026-07-20 50188 2026-07-09 48087 1143 12 9 1 1 10 2 2026-08-09 3.00 6.00 Local Export 0 3 207 2026-07-09 68 2026-07-09 68 2026-07-09 20765.00 86 2 <h1>&nbsp;<strong>Please follow the IOM-86936 for ... NULL NULL 3 2026-08-09 Auto Approve 85 2026-07-09 2026-08-09 Auto Approve 48 2026-07-09
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8419
8419 2026-07-08 50014 2026-06-30 48083 24 12 18 10 1 6 2 2026-07-31 3.00 3.00 Local Export 0 3 316 2026-06-30 356 2026-06-30 229 2026-06-30 43000.00 86 2 <p><strong>O/N-<br />
<br />
- TEAR,TENSILE, Pil...
NULL NULL 4 2026-07-31 Auto Approve 85 2026-06-30 2026-07-31 Auto Approve 48 2026-06-30
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8403
8403 2026-07-01 49995 2026-06-28 48068 13 12 9 2 1 10 2 2026-07-29 -4.00 -4.00 Local Export 0 3 472 2026-06-28 296 2026-06-28 296 2026-06-28 7702.00 86 2 <p style="color: rgb(51, 51, 51); font-family: Ver... NULL NULL 1 2026-07-29 Auto Approve 85 2026-06-28 2026-07-29 Auto Approve 48 2026-06-28
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8443
8443 2026-07-22 50117 2026-07-05 48054 835 4 9 9 1 7 2 2026-08-06 -3.00 -3.00 Local Export 30 3 425 2026-07-05 68 2026-07-05 68 2026-07-05 3850.00 86 2 <h2>THIS IS TCP SPR'27 REPEAT ORDER</h2>
<h2>PLEA...
NULL NULL 4 2026-08-06 Auto Approve 85 2026-07-05 2026-08-06 Auto Approve 48 2026-07-05
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8442
8442 2026-07-22 50116 2026-07-05 48053 835 4 9 9 1 20 2 2026-08-05 -3.00 -3.00 Local Export 120 3 425 2026-07-05 68 2026-07-05 68 2026-07-05 23717.00 86 2 <h2>THIS IS TCP SPR'27 REPEAT ORDER</h2>
<h2>PLEA...
NULL NULL 4 2026-08-05 Auto Approve 85 2026-07-05 2026-08-05 Auto Approve 48 2026-07-05
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8402
8402 2026-07-01 49991 2026-06-27 48044 13 4 9 2 1 9 2 2026-07-28 -4.00 -4.00 Local Export 0 3 472 2026-06-27 296 2026-06-27 296 2026-06-27 5466.00 86 2 <p>&nbsp;<span style="font-family: VERDANA; font-s... NULL NULL 1 2026-07-28 Auto Approve 85 2026-06-27 2026-07-28 Auto Approve 48 2026-06-27
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8448
8448 2026-07-22 49992 2026-06-27 48039 1290 12 9 5 1 10 2 2026-07-28 3.00 5.00 Local Export 0 3 422 2026-06-27 344 2026-06-27 229 2026-06-28 11280.00 86 2 <p><span style="color: rgb(51, 51, 51); font-famil... NULL NULL 1 2026-07-28 Auto Approve 85 2026-06-27 2026-07-28 Auto Approve 48 2026-06-27
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8407
8407 2026-07-04 50034 2026-07-01 48024 1454 4 9 1 1 32 2 2026-08-01 -4.00 -4.00 Local Export 50 3 446 2026-07-01 68 2026-07-01 68 2026-07-01 6420.00 86 2 <h1><span style="background-color: rgb(255, 255, 0... NULL NULL 3 2026-08-01 Auto Approve 85 2026-07-01 2026-08-01 Auto Approve 48 2026-07-01
Edit Edit Copy Copy Delete Delete
DELETE FROM porivdetail WHERE `porivdetail`.`pprivid` = 8408
8408 2026-07-04 50033 2026-07-01 48023 1454 4 7 1 1 32 2 2026-08-01 -4.00 -4.00 Local Export 50 3 446 2026-07-01 68 2026-07-01 68 2026-07-01 5880.00 86 2 <h1><span style="background-color: rgb(255, 255, 0... NULL NULL 3 2026-08-01 Auto Approve 85 2026-07-01 2026-08-01 Auto Approve 48 2026-07-01
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