Help with Mysql query

This query working SELECT DATE_FORMAT(oo.date_added, '%m/%d/%Y') as Date, ot.order_id, round([login to view URL],2) as total, round(SUM([login to view URL]*[login to view URL]),2) AS weight, round(SUM([login to view URL]*p.cost_sk),2) AS product_cost, (Select round(SUM([login to view URL]),2) from oc_order_total ot1 where [login to view URL] like 'tax' and ot1.order_id = oo.order_id) as tax, (Select round(SUM([login to view URL])*-1,2) from oc_order_total ot2 where [login to view URL] like 'ultimate_coupons' and ot2.order_id = oo.order_id) as sconto, (Select round(SUM([login to view URL]),2) from oc_order_total ot3 where [login to view URL] like 'low_order_fee' and ot3.order_id = oo.order_id) as low_order_fee, (Select round(SUM([login to view URL]),2) from oc_order_total ot4 where [login to view URL] like 'category_product_based_fee' and ot4.order_id = oo.order_id) as isotermico, (Select round(SUM([login to view URL])*-1,2) from oc_order_total ot5 where [login to view URL] like 'redeem_point' and ot5.order_id = oo.order_id) as points, (Select round(SUM([login to view URL]),2) from oc_order_total ot6 where [login to view URL] like 'suppcontr' and ot6.order_id = oo.order_id) as contrassegno, (Select [login to view URL] from oc_order_total ot7 where [login to view URL] like 'ultimate_coupons' and ot7.order_id = oo.order_id group by ot7.order_id) as sconto_title, (Select round(SUM([login to view URL]),2) from oc_order_total ot8 where [login to view URL] like 'sub_total' and ot8.order_id = oo.order_id group by ot8.order_id) as subtotal, (Select [login to view URL] from oc_order_total ot9 where [login to view URL] like 'shipping' and ot9.order_id = oo.order_id group by ot9.order_id) as shipping_name, [login to view URL] as affiliateFee, (Select round(SUM([login to view URL]),2) from oc_order_total ot10 where [login to view URL] like 'shipping' and ot10.order_id = oo.order_id) as shipping_cost FROM oc_order_total ot INNER JOIN oc_order oo on ot.order_id = oo.order_id INNER JOIN oc_order_product op on op.order_id = ot.order_id INNER JOIN oc_product p on op.product_id = p.product_id LEFT JOIN oc_affiliate_transaction oat on oat.order_id = ot.order_id WHERE oo.store_name = 'test' AND oo.order_status_id != 0 AND oo.date_added BETWEEN '2018-08-10' AND '2018-08-25' GROUP BY ot.order_id ORDER BY ot.order_total_id DESC but i'm getting a wrong data for these due fields 'product_cost' and 'weight' Could you help me to fix? i can not send u the db due of privacy issues, but i can send u structure table