Fishbowl QUERY

SELECT postsoitem.datecreated AS postsoitemDatecreated,
    product.num AS productNum, product.description AS productdescription
FROM postsoitem
    JOIN soitem ON postsoitem.soitemid = soitem.id
    JOIN product ON soitem.productid = product.id
    JOIN uom ON product.uomid = uom.id
    LEFT JOIN uomconversion ON (uomconversion.touomid = product.uomid AND uomconversion.fromuomid = soitem.uomid)
    JOIN company ON company.id = 1

WHERE postsoitem.datecreated BETWEEN '2015-05-09 00:00:00.0' AND '2016-05-09 00:00:00.0'