0Promo Kit600000039SELECT SUM(quantity * productprice) as Price, SUM(quantity * ourprice) as OurPrice, tpkii.promo_kit_precent_off as prod_precent_off, tpkii.promo_kit_precent_off_our as our_precent_off, tpkii.promo_kit_name_long as NameLong, SUM((IF(CAST(ProductWeight as decimal)>'.5',CAST(ProductWeight as decimal),.5) * quantity)) as wgt FROM tbl_promo_kit tpk INNER JOIN tbl_promo_kit_info tpkii on tpk.promo_kit_id = tpkii.promo_kit_id INNER JOIN tbl_promo_kit_items tpki ON tpk.promo_kit_id = tpki.promo_kit_id INNER JOIN tbl_prod tp ON tpki.productcode = tp.productcode WHERE tpk.promo_kit_id = 600000039