Multistore database Pricing Structure

[AshbridgeWS]

Hi,

 

I am trying to select the price of all products from the store with ID of 1 but for some reason; not all products are showing and the price is very, very different from what is being shown on my website.

 

Here is my SQL query so far...

SELECT * FROM ps_product p LEFT JOIN ps_product_lang l ON l.id_product = p.id_product LEFT JOIN ps_product_attribute_shop s ON s.id_product = p.id_product LEFT JOIN ps_product_attribute a ON a.id_product_attribute = s.id_product_attribute WHERE l.id_shop = 1 AND s.id_shop = 1

Can anyone help?

[NemoPS]

The price can't be gotten directly like that, you must use Product::getPriceStatic($id_product)