Deprecated: Function ereg() is deprecated in
/home/pneustorvn/www/recherche_pneus.php on line
571
Nos pneus YOKOHAMA 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='95'
and products_to_categories.categories_id ='26'
and pd.language_id = '1'
group by pd.products_name order by nb_pneu DESC
[TEP STOP]
