[Solved] Generate query product all specials

[giralatina]

Hi guys,

I want to generate a view with product all specials.
I have try so

mysql> select pr.name,pr.id_lang, ps.on_sale from ps_product_lang as pr, ps_product as ps where pr.id_lang=9 and ps.id_product=pr.id_product and ps.on_sale=1; 

but, the query is not correct.

help me?

[Matthieu Biart]

Hi giralatina!

Have a look on Product::getRandomSpecial() and remove the random part ;-P

[iondarie]

hello i tryed the above solution but it doesnt work am i doing something wrong please help. thank you