Witam, mam mały problem, po wykonaniu tego zapytania SQL, niektóre wyniki mam po 4 razy to samo
a wpisy w bazie są poprawne, co robię nie tak w tym zapytaniu SQL? Proszę o pomoc
SELECT
shop_users.id,
shop_orders.id,
shop_orders.klient,
shop_orders.czas,
shop_orders.produkty,
shop_orders.cena,
shop_orders.wysylka,
shop_orders.platnosc,
shop_orders.drukowane,
shop_orders.STATUS,
shop_orders.paragon,
shop_users.imie,
shop_users.nazwisko,
shop_users.ulica,
shop_users.nr_domu,
shop_users.nr_mieszkania,
shop_users.kod_pocztowy,
shop_users.miasto,
shop_users.telefon,
shop_users.email,
shop_orders_useraddress.order_id,
shop_orders_useraddress.useraddress,
shop_orders_date.order_id,
shop_orders_date.prod,
shop_orders_date.reel,
shop_orders_comments.order_id,
shop_orders_comments.comments,
shop_orders_invoices.order_id,
shop_orders_invoices.invoice,
shop_orders_payment.order_id,
shop_orders_payment.pay_status
FROM shop_orders LEFT JOIN shop_users ON (shop_orders.klient=shop_users.id)
LEFT JOIN shop_orders_useraddress ON (shop_orders_useraddress.order_id=shop_orders.id)
LEFT JOIN shop_orders_date ON (shop_orders_date.order_id=shop_orders.id)
LEFT JOIN shop_orders_comments ON (shop_orders_comments.order_id=shop_orders.id)
LEFT JOIN shop_orders_invoices ON (shop_orders_invoices.order_id=shop_orders.id)
LEFT JOIN shop_orders_payment ON (shop_orders_payment.order_id=shop_orders.id)
WHERE shop_orders.STATUS = '3' ORDER BY shop_orders.czas