query
RESULTSET
query
  COUNTRY ID MYPORT PORT PORT_DESC STATE VIEWABLE
1 AA 134 AAA A AAA A [empty string] Yes
2 DM 108 AAR AARHUS AAR AARHUS [empty string] Yes
3 AA 132 ABD AA ABD AA [empty string] Yes
4 AF 131 ABF ABF PORT DESCRIPTION ABF ABF PORT DESCRIPTION [empty string] No
5 BE 135 AN7 ANTWERP 7 AN7 ANTWERP 7 [empty string] Yes
6 BE 136 AN8 ANTWERP 8 AN8 ANTWERP 8 [empty string] Yes
7 BE 1 ANT ANTWERP-A ANT ANTWERP-A [empty string] Yes
8 BE 125 ANT1 ANTWERP1 ANT1 ANTWERP1 [empty string] Yes
9 BE 126 ANT2 ANTWERP2 ANT2 ANTWERP2 [empty string] Yes
10 BE 127 ANT3 ANTWERP3 ANT3 ANTWERP3 [empty string] Yes
11 BE 128 ANT4 ANTWERP4 ANT4 ANTWERP4 [empty string] Yes
12 BE 129 ANT5 ANTWERP5 ANT5 ANTWERP5 [empty string] yes
13 BE 130 ANT6 ANTWERP6 ANT6 ANTWERP6 [empty string] Yes
14 BE 2 ANZ Antwerp ANZ Antwerp [empty string] Yes
15 AR 64 ARG BUENOS AIRES ARG BUENOS AIRES [empty string] Yes
16 US 3 BAL BALTIMORE PORT U.S.A. BAL BALTIMORE PORT U.S.A. MD Yes
17 SP 57 BAR BARCELONA BAR BARCELONA [empty string] Yes
18 IR 4 BEL Belfast BEL Belfast [empty string] No
19 SP 5 BIL Bilbao BIL Bilbao [empty string] No
20 SP 84 BIO BILBAO BIO BILBAO [empty string] Yes
21 DE 6 BRA Bremen BRA Bremen [empty string] No
22 DE 61 BRE BREMERHAVEN BRE BREMERHAVEN [empty string] Yes
23 US 7 BRI Baltimore BRI Baltimore MD No
24 GB 119 BRT BRISTOL BRT BRISTOL [empty string] Yes
25 KR 46 BUS BUSAN PORT BUS BUSAN PORT [empty string] Yes
26 SP 111 CAD CADIZ CAD CADIZ [empty string] Yes
27 DR 82 CCO CAUCEDO CCO CAUCEDO [empty string] Yes
28 US 8 CHE CHESTER CHE CHESTER PA Yes
29 IN 96 CHN CHENNAI CHN CHENNAI [empty string] Yes
30 IR 9 CRK Cork CRK Cork [empty string] No
31 CH 86 DAL DALIAN DAL DALIAN [empty string] Yes
32 SA 117 DAM DAMMAN DAM DAMMAN [empty string] Yes
33 GB 10 DAR Dartford DAR Dartford [empty string] No
34 UA 93 DBI DUBAI DBI DUBAI [empty string] Yes
35 IR 11 DUB Dublin DUB Dublin [empty string] No
36 SA 116 DUR DURBAN DUR DURBAN [empty string] Yes
37 SE 106 GAV GAVLE GAV GAVLE [empty string] Yes
38 PL 60 GDN GDANSK GDN GDANSK [empty string] Yes
39 PL 105 GDY GDYNIA GDY GDYNIA [empty string] Yes
40 TR 70 GEB YILPORT GEB YILPORT [empty string] Yes
41 TR 69 GEM GEMLIK GEM GEMLIK [empty string] Yes
42 IT 56 GEN GENOA GEN GENOA [empty string] Yes
43 DE 12 GER Germersheim GER Germersheim [empty string] No
44 SP 83 GIJ PUERTO DE GIJON GIJ PUERTO DE GIJON [empty string] Yes
45 GB 13 GOO Goole GOO Goole [empty string] No
46 SE 73 GOT GOTHENBURG GOT GOTHENBURG [empty string] Yes
47 GB 14 GRM Grangemouth GRM Grangemouth [empty string] No
48 CH 107 GZH GUANGZHOU GZH GUANGZHOU [empty string] Yes
49 DE 15 HAM Hamburg HAM Hamburg [empty string] No
50 GB 16 HAR Harwich HAR Harwich [empty string] No
51 FI 72 HEL HELSINKI HEL HELSINKI [empty string] Yes
52 CH 88 HKG HONG KONG HKG HONG KONG [empty string] Yes
53 US 123 HOU HOUSTON HOU HOUSTON TX Yes
54 CH 89 HPU HUANGPU HPU HUANGPU [empty string] Yes
55 GB 17 HUL Hull HUL Hull [empty string] No
56 GB 21 IMH IMMINGHAM IMH IMMINGHAM [empty string] No
57 GB 97 IMM IMMINGHAM IMM IMMINGHAM [empty string] Yes
58 KR 113 INC INCHON INC INCHON [empty string] Yes
59 GB 22 IPS IPSWICH IPS IPSWICH [empty string] No
60 TR 74 IST MARPORT IST MARPORT [empty string] Yes
61 TR 103 IZM IZMIR IZM IZMIR [empty string] Yes
62 TA 99 KAO KAOHSIUNG KAO KAOHSIUNG [empty string] Yes
63 LT 23 KLA KLAIPEDA KLA KLAIPEDA [empty string] No
64 IR 24 LBF BELFAST LBF BELFAST [empty string] No
65 GB 25 LCB COATBRIDGE LCB COATBRIDGE [empty string] No
66 IR 26 LDB DUBLIN LDB DUBLIN [empty string] No
67 GB 27 LGN GREENOCK LGN GREENOCK [empty string] No
68 GB 28 LIV LIVERPOOL LIV LIVERPOOL [empty string] Yes
69 TH 94 LMC LAEM CHABANG LMC LAEM CHABANG [empty string] Yes
70 GB 29 LPL LIVERPOOL LPL LIVERPOOL [empty string] No
71 IT 66 LSP LA SPEZIA LSP LA SPEZIA [empty string] Yes
72 AU 85 MEL MELBOURNE, AUSTRALIE MEL MELBOURNE, AUSTRALIE [empty string] Yes
73 TR 95 MER MERSIN MER MERSIN [empty string] Yes
74 IT 30 MIL MILAN MIL MILAN [empty string] No
75 CA 75 MNT MONTREAL MNT MONTREAL [empty string] Yes
76 UY 51 MON MONTEVIDEO. URUGUAY MON MONTEVIDEO. URUGUAY [empty string] Yes
77 UY 80 MOV MONTEVIDEO MOV MONTEVIDEO [empty string] No
78 JP 77 NAG NAGOYA NAG NAGOYA [empty string] Yes
79 BR 118 NAV NAVEGANTES NAV NAVEGANTES [empty string] Yes
80 IN 98 NHA NHAVA SHEVA NHA NHAVA SHEVA [empty string] Yes
81 CH 54 NIN NINGBO NIN NINGBO [empty string] Yes
82 US 53 NOR NORFOLK U.S.A. PORT NOR NORFOLK U.S.A. PORT VA Yes
83 US 31 NYC NEW YORK NYC NEW YORK NY No
84 RU 90 PET ST PETERSBURG PET ST PETERSBURG [empty string] Yes
85 US 50 PHI PHILADELPHIA PHI PHILADELPHIA PA Yes
86 GR 114 PIR PIRAEUS PIR PIRAEUS [empty string] Yes
87 US 32 PMT PORTSMOUTH PMT PORTSMOUTH VA No
88 TH 76 POD LAEM CHABANG POD LAEM CHABANG [empty string] No
89 GB 33 PUR PURFLEET PUR PURFLEET [empty string] No
90 PA 120 QAS PORT QASHIM QAS PORT QASHIM [empty string] Yes
91 CH 68 QIG QINGDAO QIG QINGDAO [empty string] Yes
92 IT 67 RAV RAVENNA RAV RAVENNA [empty string] Yes
93 NL 34 RDD ROTTERDAM RDD ROTTERDAM [empty string] No
94 NL 35 RDM ROTTERDAM RDM ROTTERDAM [empty string] No
95 NL 36 RDZ ROTTERDAM RDZ ROTTERDAM [empty string] No
96 DR 81 RHA RIO HAINA RHA RIO HAINA [empty string] Yes
97 US 37 RIC RICHMOND RIC RICHMOND VA Yes
98 LA 124 RIG RIGA RIG RIGA [empty string] Yes
99 NL 62 ROT ROTTERDAM ROT ROTTERDAM [empty string] Yes
100 NL 65 RTM ECT DELTATERMINAL RTM ECT DELTATERMINAL [empty string] Yes
101 LV 38 RXA RIGA RXA RIGA [empty string] No
102 BR 59 SAN SANTOS SAN SANTOS [empty string] Yes
103 SS 133 SAS TEST SAS TEST [empty string] No
104 CH 52 SHA SHANGHAI PORT, CHINA SHA SHANGHAI PORT, CHINA [empty string] Yes
105 CH 115 SHE SHEKOU SHE SHEKOU [empty string] Yes
106 SI 79 SIN SINGAPORE SIN SINGAPORE [empty string] Yes
107 GB 121 SOU SOUTHAMPTON SOU SOUTHAMPTON [empty string] Yes
108 NO 109 STA STAVANGER STA STAVANGER [empty string] Yes
109 GU 92 STC SANTO TOMAS DE CASTILLA STC SANTO TOMAS DE CASTILLA [empty string] Yes
110 CI 112 STG SANTIAGO STG SANTIAGO [empty string] Yes
111 RU 39 STP ST PETERSBURG STP ST PETERSBURG [empty string] No
112 ID 102 SUR SURABAYA SUR SURABAYA [empty string] Yes
113 AU 91 SYD SYDNEY SYD SYDNEY [empty string] Yes
114 ES 101 TAL TALLINN TAL TALLINN [empty string] Yes
115 GB 40 TEE TEESPORT TEE TEESPORT [empty string] No
116 GR 110 THE THESSALONIKI THE THESSALONIKI [empty string] Yes
117 GB 41 TIL TILBURY TIL TILBURY [empty string] No
118 FI 71 TOR TORNIO TOR TORNIO [empty string] Yes
119 SP 78 VAL VALENCIA VAL VALENCIA [empty string] Yes
120 ME 104 VCZ VERACRUZ VCZ VERACRUZ [empty string] Yes
121 SP 58 VIG VIGO VIG VIGO [empty string] Yes
122 IR 42 WAT WATERFORD WAT WATERFORD [empty string] No
123 US 100 WIL WILMINGTON WIL WILMINGTON NC Yes
124 CH 87 WUH WUHAN PORT WUH WUHAN PORT [empty string] Yes
125 CH 63 XIN XINGANG XIN XINGANG [empty string] No
126 CH 55 XNG XINGANG XNG XINGANG [empty string] Yes
CACHED false
EXECUTIONTIME 16
SQL SELECT [id] ,[port] ,[port_desc] , port + ' ' + port_desc as myport ,[state] ,[country] ,[viewable] FROM CT_LOV_ports ORDER BY port
Voyage Number:
POL:
POD:

Active Only: Show All:

Published: Unpublished: Show All:

Start Date:
Date Picker


End Date:
Date Picker