Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: ksuiso »Table: pso_req_bk
Page-related settingsClick 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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (3665 total, Query took 0.0016 seconds.)
SELECT * FROM `pso_req_bk`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsreq_idjob_idcustomer_codecustomer_namecustomer_addr1customer_addr2customer_citycustomer_statecustomer_zipcustomer_countrycustomer_phoneattnemailbrokerspec_shttracking_nopurposerd_descother_descshipviashipdatedue_dateuseruser_levelbranchapprovedbyapprovedatecreate_datecomp_datestatus 1=OPN, 2=SHP active
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 1
1 160919001 019301 7 STAR FOODS 530 N PUENTE ST BREA CA 92821 USA Y 123456789 DONATION,OFFICE USE NEXT DAY AM 2016-09-27 10:34:54 2016-09-28 curtis 3 SF NULL 2016-09-19 12:54:21 NULL COMP 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 2
2 160919002 NEW Tokyo Design Center 1508 Fillmore St Suite 300 San Francisco CA 94115 USA 415-543-4886 Curtis Tsukano curtis@tokyodesign.com 123789 TEST KITCHEN,DONATION,SALES USE Free Sample NEXT DAY AM 2017-01-19 15:12:27 2016-09-22 curtis 3 HQ NULL 2016-09-19 13:00:49 NULL 2 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 3
3 160919003 019966 A & C DISTRIBUTORS 4048 W CHICAGO AVE CHICAGO IL 60639 USA Y TRADE SHOW NEXT DAY AM NULL 2016-09-20 curtis 3 SF NULL 2016-09-19 13:20:57 NULL OPEN 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 7
7 160923004 015136 FIRST SPICE MIXING CO INC 33-33 GREENPOINT AVE LONG ISLAND NY 11101 USA 2211105 Marcy Epstein Y dry seasoning blend 2ND DAY 2016-09-23 16:38:28 2016-09-27 curtis 3 SF NULL 2016-09-23 11:30:20 NULL COMP 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 8
8 160926001 014309 ADVANCE FOOD SYSTEM 21 ROOSEVELT AVENUE SOMERSET NJ 08873 USA Y NEXT DAY EXPRESS 2017-01-25 23:58:10 0000-00-00 curtis 3 HQ NULL 2016-09-26 15:35:01 NULL 2 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 9
9 160926002 014309 ADVANCE FOOD SYSTEM 21 ROOSEVELT AVENUE SOMERSET NJ 08873 USA Y NEXT DAY EXPRESS NULL 0000-00-00 curtis 3 NY NULL 2016-09-26 15:35:07 NULL OPEN 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 10
10 160927001 017168 A & L SALES, INC. P.O. BOX 74 BELLE CHASSE LA 70037 USA 3943840 Y NEXT DAY AM NULL 2016-09-14 curtis 3 HQ NULL 2016-09-27 10:32:01 NULL OPEN 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 11
11 160927002 017168 A & L SALES, INC. P.O. BOX 74 BELLE CHASSE LA 70037 USA 3943840 Y 123456789 NEXT DAY AM 2016-12-06 11:58:13 2016-09-14 curtis 3 NY NULL 2016-09-27 10:32:08 NULL 2 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 12
12 161116001 014468 NESTLE REFRIGERATED FOODS 1534 EL PINAL STOCKTON CA 95205 USA Y 123456, 456789,8888 NEXT DAY AM 2017-01-24 17:18:53 2016-11-17 curtis 0 SF NULL 2016-11-16 10:22:27 2017-01-27 15:04:39 3 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 13
13 161116002 015027 KAGOME FOODS INC R & D FACILITY/ATN:GWEN YOUNG BELMONT CA 94002 USA 3492271 Y 0000000000000 NEXT DAY AM 2017-01-27 13:50:07 2016-11-17 aisobe 0 SF NULL 2016-11-16 10:32:09 NULL 2 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 14
14 161216002 018486 TAYLOR FARMS NORTHWEST, LLC. 8030 S. 228TH STREET KENT WA 98032 USA 6251412 AP-DIRECT@TAYLORFARMS.COM NORTHWEST INGREDIENTS - SEATTLE Y iz00000 2ND DAY 2016-12-16 09:47:42 2016-12-20 aisobe 0 SF NULL 2016-12-16 09:44:42 NULL 2 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 15
15 170106001 011265 NESTLE FOOD CO P O BOX 198 MORTON IL 61550-0198 USA 88888888888 2ND DAY 2017-01-06 11:11:59 0000-00-00 aisobe 0 HQ NULL 2017-01-06 11:09:28 NULL 2 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 16
16 170110001 Kikkoman Marketing & Planning, Inc. 2500 West Higgins Road, Wuite 1180 Hoffman Estates IL 60169 USA 847-882-8901 Shuji Sugano ssugano@kikkoman.com 1Z9510011257464844 GROUND TRACK (7 DAYS) NULL 2017-01-17 aisobe 0 HQ NULL 2017-01-10 15:16:47 2017-01-12 16:16:14 3 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 17
17 170110003 Kikkoman Marketing & Planning, Inc. 2500 West Higgins Road, Wuite 1180 Hoffman Estates IL 60169 USA 847-882-8901 Shuji Sugano 1z9510011257944763 3RD DAY 2017-01-11 16:30:50 2017-01-16 aisobe 0 HQ NULL 2017-01-10 19:06:50 NULL 2 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 18
18 170112001 KMP c/o Siliver Spring Foods 2424 Alpine Rd Eau Claire WI 54703 USA 224-238-0855 Hidehito Kai 1Z9510010358059459 GROUND TRACK (7 DAYS) NULL 2017-01-20 0 NULL 2017-01-12 11:09:51 2017-01-12 16:21:19 3 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 19
19 170113001 Kikkoman Marketing & Planning 2500 West Higgins Road, Suite 1180 Hoffman Estate IL 60169 USA 847-882-2901 Shuji Sugano Y 1Z9510010357227993/ 1Z9510010357232469 GROUND TRACK (7 DAYS) NULL 2017-01-20 aisobe 0 HQ NULL 2017-01-13 15:29:45 2017-01-31 11:27:29 3 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 20
20 170119001 016618 KIKKOMAN MARKETING & PLANNING INC 2500 West Higgins Rd. Suite1180 Hoffman Estates IL 60169 USA Shuji Sugano Y GROUND TRACK (7 DAYS) 2017-01-20 09:17:06 2017-01-26 aisobe 3 HQ NULL 2017-01-19 15:43:16 2017-01-26 16:16:44 3 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 21
21 170120001 ComeIn de México Federalismo #122 Fracc. Industrial la Silla. Guadalupe N.L. CP. 61799 Mexico 52(81)8361 7440 Carolina Herrera carolina.herrera@comein.com.mx Y 1Z9510010457991094 MSG replacer, injection and tumber INTL SAVER 2017-01-23 16:28:50 0000-00-00 aisobe 0 HQ NULL 2017-01-20 15:03:30 2017-01-23 16:29:42 3 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 22
22 170131002 ComeIn de Mexico c/o MS Worldwide Logistics Inc. 822 Union Pacific Blvd. East Point Industrial Park Laredo TX 78045 USA (956) 791-5402 Carolina Herrera 1z9510010258526106 2ND DAY NULL 2017-02-02 aisobe 0 HQ NULL 2017-01-31 15:37:46 2017-02-02 17:15:39 3 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 23
23 170206001 KMP c/o Siliver Spring Foods 2424 Alpine Rd Eau Claire WI 54703 USA 224-238-0855 Hidehito Kai 3RD DAY SERVICE, Tracking # 1Z9510011256951355 GROUND TRACK (7 DAYS) NULL 2017-02-10 aisobe 0 HQ NULL 2017-02-06 14:39:39 2017-02-06 15:57:36 3 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 24
24 170214001 test test USA 2222222 NEXT DAY PM 2017-02-16 19:40:48 2017-02-15 admin 0 HQ NULL 2017-02-14 17:14:28 NULL 2 0
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 25
25 170214002 Kikkoman Marketing & Planning 2500 West Higgins Road, Suite 1180 Hoffman Estate IL 60169 USA 847-882-2901 undefined undefined UPS 3rd day service, Tracking# 1Z9510011258932783 GROUND TRACK (7 DAYS) 2017-02-16 16:33:30 2017-02-21 aisobe 0 HQ NULL 2017-02-14 17:21:51 NULL 2 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 26
26 170221001 Kewpie Corporation Dept of Overseas, Institute of Product Development... Sengawa Kewport, 2-5-7, Sengawa-cho Chofu-shi Tokyo 182-0002 Japan =81-3-5384-7762 Mr. Mimura Akihiro 1Z9510010457785745 INTL SAVER 2017-02-21 16:39:35 2017-02-28 aisobe 0 HQ NULL 2017-02-21 15:52:00 NULL 2 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 27
27 170227002 KMP c/o Siliver Spring Foods 2424 Alpine Rd Eau Claire WI 54703 USA 224-238-0855 Hidehito Kai undefined undefined GROUND TRACK (7 DAYS) 2017-02-28 09:30:14 2017-03-06 aisobe 0 HQ NULL 2017-02-27 14:16:20 NULL 2 1
Edit EditCopy CopyDelete Delete
DELETE FROM `pso_req_bk` WHERE `pso_req_bk`.`req_id` = 28
28 170227004 test USA test 2017-02-27 18:51:06 0000-00-00 HQ 0 Head Quarter NULL 2017-02-27 18:50:08 2017-02-27 18:52:01 3 0
With selected: With selected:

|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query