query 22072016 search not in warehouse products - prestashop

SELECT A.id_product AS IdProd, A.name AS Nome, B.id_warehouse AS IdMag, C.name AS Magazzino FROM ps_product_lang A
LEFT JOIN ps_warehouse_product_location B ON A.id_product = B.id_product
LEFT JOIN ps_warehouse C on B.id_warehouse = C.id_warehouse
LEFT JOIN ps_product D on A.id_product = D.id_product
WHERE C.id_warehouse IS NULL AND D.active = 1