SELECT S.*, C.C_name FROM tg_ship S
LEFT OUTER JOIN tg_cate C ON S.S_cate = C.C_no
WHERE S_gubun = 'P'
ORDER BY S_no DESC
-
P2400099 |
TYPE |
TOWING TUG |
L/B/D(M) |
|
BUILT |
|
UPDATE |
0000-00-00 |
-
P2300094 |
TYPE |
DIVING SUPPORT VESSEL |
L/B/D(M) |
|
BUILT |
2000 ONWARD |
UPDATE |
2023-05-11 |
-
P2200084 |
TYPE |
GENERAL CARGO |
L/B/D(M) |
|
BUILT |
1995-2002 |
UPDATE |
2022-11-25 |
-
P2200081 |
TYPE |
HARBOUR TUG |
L/B/D(M) |
|
BUILT |
1990s ONWARD |
UPDATE |
2022-10-14 |
-
P2200070 |
TYPE |
TUG BOAT |
L/B/D(M) |
|
BUILT |
2012 |
UPDATE |
2022-07-14 |
-
P2200064 |
TYPE |
FLOATING DOCK |
L/B/D(M) |
LOA: 250M |
BUILT |
|
UPDATE |
2022-07-27 |