Chang Hang Guang Rong
Submitted by Gatehouse on Wed, 23/10/2013 - 13:42Ship Type:
Tanker
DeadWt:
45720
GRT:
29588
NRT:
12469
Length OverAll:
185
SELECT `nid`,`field_sr_shname_nid`,(select `title` from `node` where `nid`= `field_sr_shname_nid`) AS shipname,`field_sr_darrival_value`,`field_sr_dtatanchor_value`,`field_sr_pobeta_value`, `field_sr_ddeparturedate_value`, TIMESTAMPDIFF(HOUR,`field_sr_darrival_value`,`field_sr_ddeparturedate_value`) AS TotHours,
`field_sr_dberth_value`, TIMESTAMPDIFF(HOUR,`field_sr_pobeta_value`,`field_sr_ddeparturedate_value`) AS berthOcc,
TIMESTAMPDIFF(HOUR,`field_sr_dtatanchor_value`,`field_sr_pobeta_value`) AS atAnchorHours,
Please download the following form.