SELECT
  acw.id,
  acw.categoryCode,
  acw.packageID,
  acwp.endDate,
  ac.editPrint,
  wptpd.units,
  wptp.package_period,
  wptp.package_type
FROM adCart ac
  INNER JOIN adCartW2P acw
    ON (acw.adCartID = ac.adCartID)
  LEFT JOIN adCartW2P_Publications acwp
    ON (acwp.adCartID = ac.adCartID AND acwp.publicationID = 768)
  INNER JOIN webtoprint_pricing_to_publications wptp
    ON (acw.packageID = wptp.packageID)
  INNER JOIN webtoprint_pricing_to_publications_details wptpd
    ON (wptp.packageID = wptpd.packageID
        AND wptp.publicationID = wptpd.publicationID
        AND ac.pricingType = wptpd.pricingType)
WHERE ac.adCartID = 2568895
      AND wptp.publicationID = 768
      AND wptpd.chargeTypeID = 1
LIMIT 1;