Edit History

Hi.

It does not work for combinations !

ps_ => table prefix

id_lang = 1 => language id

SELECT a.id_product, a.name, b.quantity, b.location FROM `ps_product_lang` a 
LEFT JOIN `ps_stock_available` b ON (a.id_product = b.id_product)
WHERE a.id_lang = 1 AND b.id_product_attribute = 0;

Hi.

ps_ => table prefix

id_lang = 1 => language id

SELECT a.id_product, a.name, b.quantity, b.location FROM `ps_product_lang` a 
LEFT JOIN `ps_stock_available` b ON (a.id_product = b.id_product)
WHERE a.id_lang = 1 AND b.id_product_attribute = 0;