Promo pneu : Nos pneus GISLAVED en vente à prix discount
1053 - Server shutdown in progress
select pd.products_name, count(products.products_id) as nb_pneu
from products
inner join products_description as pd on (products.products_id = pd.products_id)
inner join products_to_categories on (products.products_id = products_to_categories.products_id)
where products.products_status = '1'
and products.manufacturers_id='1284'
and products_to_categories.categories_id ='26'
and pd.language_id = '1'
group by pd.products_name order by nb_pneu DESC
[TEP STOP]