SELECT distinct od.product_id, c.firstname,c.lastname,c.email,c.birthday, a.phone, a.phone_mobile
FROM pre2466_customer c
INNER JOIN pre2466_orders o ON(o.id_customer = c.id_customer)
INNER JOIN pre2466_order_detail od ON(od.id_order = o.id_order)
INNER JOIN pre2466_address a ON(a.id_address = o.id_address_delivery)
WHERE o.id_customer=c.id_customer
AND od.product_id in (162,163,164,166,167,169,17.....
SELECT distinct od.product_id, c.firstname,c.lastname,c.email,c.birthday, a.phone, a.phone_mobile
FROM pre2466_customer c
INNER JOIN pre2466_orders o ON(o.id_customer = c.id_customer)
INNER JOIN pre2466_order_detail od ON(od.id_order = o.id_order)
INNER JOIN pre2466_address a ON(a.id_address = o.id_address)
WHERE o.id_customer=c.id_customer
AND od.product_id in (162,163,164,166,167,169,17.....
SELECT distinct c.firstname,c.lastname,c.email,c.birthday, a.phone, a.phone_mobile
FROM pre2466_customer c
INNER JOIN pre2466_orders o ON(o.id_customer = c.id_customer)
INNER JOIN pre2466_order_detail od ON(od.id_order = o.id_order)
INNER JOIN pre2466_address a ON(a.id_address = o.id_address)
WHERE o.id_customer=c.id_customer
AND od.product_id in (162,163,164,166,167,169,17.....