Get reward

gistfile1.sql

SELECT op.product_id, op.name, op.quantity, op.reward
	FROM oc_order_product op, oc_product_reward pr, `oc_order` o
	WHERE op.product_id = pr.product_id
		AND o.customer_group_id = pr.customer_group_id
		AND o.order_id = op.order_id
		AND o.order_id = '1415'
		AND points > 0
		AND o.customer_id > 0