Presta - cross selling - orders

gistfile1.sql

SELECT o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
    AND od.product_id = 991