sales query

select 
	CAST(SUM(`o_p`.`cost` * `o_p`.`count`) as UNSIGNED) as `cost`,
	CAST(SUM(`o_t`.`subtotal`)             as UNSIGNED) as `subtotal`,
	CAST(SUM(`o_t`.`shipping_fee`)         as UNSIGNED) as `shipping_fee`,
	CAST(SUM(`o_t`.`payment_fee`)          as UNSIGNED) as `payment_fee`,
	CAST(SUM(`o_t`.`wrapping_total`)       as UNSIGNED) as `wrapping_total`,
	CAST(SUM(`o_t`.`points_discount`)      as UNSIGNED) as `points_discount`,
	CAST(SUM(`o_t`.`total`)                as UNSIGNED) as `total`
from
	order_products as o_p,
	order_totals   as o_t
where
	o_p.order_id AND o_t.order_id
	IN (186840,186841,186842,186843,186844)