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,
CASE WHEN `field_sr_ddeparturedate_value`> '2013-08-01T00:00:00' and `field_sr_ddeparturedate_value` WHEN `field_sr_pobeta_value`> '2013-08-01T00:00:00' and `field_sr_pobeta_value` '2013-08-31T23:59:00' THEN TIMESTAMPDIFF(HOUR,`field_sr_pobeta_value`,'2013-08-31T23:59:00')
ELSE TIMESTAMPDIFF(HOUR,`field_sr_pobeta_value`,`field_sr_ddeparturedate_value`) END AS dtrangehrs, CASE WHEN `field_sr_pobeta_value`> '".$range_starttime."' and `field_sr_pobeta_value` WHEN `field_sr_dtatanchor_value`> '".$range_starttime."' and `field_sr_dtatanchor_value` '".$range_endtime."' THEN TIMESTAMPDIFF(HOUR,`field_sr_dtatanchor_value`,'".$range_endtime."')
ELSE TIMESTAMPDIFF(HOUR,`field_sr_dtatanchor_value`,`field_sr_pobeta_value`) END AS dtrangeanchoradjhrs,
`field_sr_fumigationstdt_value`,`field_sr_fumigationeddt_value`,
TIMESTAMPDIFF(HOUR,`field_sr_fumigationstdt_value`,`field_sr_fumigationeddt_value`) AS fumeHours,`field_sr_vessel_group_value`,`field_whichstage1_value`
FROM `content_type_dtaipdv`
WHERE `field_sr_vessel_group_value` = 'Northport' AND (DATE_FORMAT(STR_TO_DATE(`field_sr_darrival_value`, '%%Y-%%m-%%dT%%T'), '%%Y-%%m-%%d') >= '2013-08-01' AND (DATE_FORMAT(STR_TO_DATE(`field_sr_darrival_value`, '%%Y-%%m-%%dT%%T'), '%%Y-%%m-%%d') = '2013-08-01' AND DATE_FORMAT(STR_TO_DATE(`field_sr_ddeparturedate_value`, '%%Y-%%m-%%dT%%T'), '%%Y-%%m-%%d') ORDER BY `content_type_dtaipdv`.`field_sr_darrival_value` ASC