Witam, uczę sie pilnie php i mysql jednak czasami coś mnie przystawi, próbuje z bazy pobrać pewne dane moje zapytanie wygląda tak:

[SQL] pobierz, plaintext 
SELECT ps_order_detail.id_order, ps_orders.id_customer, ps_customer.firstname, ps_customer.lastname,  ps_customer.email, ps_address.address1, ps_address.address2, ps_address.postcode, ps_address.city, ps_address.phone_mobile 
FROM ps_order_detail 
WHERE product_id = '18' OR product_id = '19' OR product_id = '20' OR product_id = '21' OR product_id = '45' 
LEFT JOIN ps_orders
ON ps_orders.id_order = ps_order_detail.id_order 
LEFT JOIN ps_customer
ON ps_customer.id_customer = ps_orders.id_customer
LEFT JOIN ps_address
ON ps_customer.id_customer = ps_address.id_customer
GROUP BY ps_address.id_customer
[SQL] pobierz, plaintext 

Otrzymuję komunikat:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN ps_orders
ON ps_orders.id_order = ps_order_detail.id_order
LEFT JOIN ' at line 4

Ktoś mnie może nakierować co robię źle?

WHERE daj PRZED GROUP BY

Ślicznie dziękuję, zapamiętam na przyszłość

Tak ściślej biorąc to WHERE powinno być PO JOIN-ach