SELECT sc.rg_ship, rg_voyageid, dpi, voyagetype, es.noontime, etd, customerreference, v.voyagestatus, v.rg_shipcustomer FROM rg_voyage v
INNER JOIN informix.rg_entitysettings es ON v.rg_entitysettings = es.rg_entitysettingsid
INNER JOIN rg_shipcustomer sc ON sc.rg_shipcustomerid = v.rg_shipcustomer
WHERE 1 = 1
AND voyagestatus IN (16)
--AND v.rg_customer IN (4600)
--AND routecalculationtype in (5)
--AND voyagetype IN (4, 5, 11)
--AND etd < '2020-06-08 00:00'
--AND etd > '2020-05-01 00:00'
--AND rg_voyageid  IN (147611)
AND es.noontime = 7
--AND dpi = 't'
ORDER BY sc.rg_ship;