[SOLVED] Manager SQL - Select things (?)

[requ]

Hi

 

Please help, how to select in SQL Manager this things:

 

1 Product name

2 It is display in shop

3 It have defined out_of_stock=0 (disalow to display - first option in edit)

 

Presta 1.6.1.10

 

Thanks in advance

[rocky]

Try:

SELECT `name`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product`
WHERE pl.`id_lang` = 1 AND pl.`id_shop` = 1 AND p.`out_of_stock` = 0 

Change ps_ to your database prefix, the first 1 to the ID of the language you want the product name in and the second 1 to the ID of the shop you want the product name from.

[requ]

Its works! Thank you so much!!!

 

Idk how to change tiitle, can be marked as SOLVED

Edited February 28, 2017 by requ (see edit history)

[rocky]

I edited the title for you.