SQL issue when migrating from 1.6 to 1.7

[Cyril5959]

Hello,

I am migrating from 1.6 to 1.7.

When copy pasting my SQL request, I have a "Checked Form" error. I didn't have this error before.

Here is my SQL request :

SELECT DISTINCT o.id_order, o.id_shop as 'id_shop', o.payment as 'pdm', o.total_paid as 'prix total ttc', o.total_products_wt as 'prix produits ttc', o.total_discounts as 'promo', o.current_state, h.product_quantity as 'qté produits', p.wholesale_price, o.invoice_date, p.id_supplier, p.id_product
FROM ps_orders o
LEFT JOIN ps_order_carrier d ON o.id_order=d.id_order
LEFT JOIN ps_order_detail h ON o.id_order=h.id_order
LEFT JOIN ps_product p ON h.product_id=p.id_product
LEFT JOIN ps_carrier c ON d.id_carrier=c.id_carrier
WHERE invoice_date> '2019-07-01 00:00:00' AND  invoice_date< '2019-10-01 00:00:00' AND o.current_state='4'
ORDER BY id_order

Could you help me ?

Thanks

 

 

 

[selectshop.at]

Welcome to the Prestasho Forum. We kindly ask you, if you are adding your questions in English language, to exclusively use the English Forum section. French Forum section is only for questions in French. I'm moving your question to the correct forum section.