Nos pneus LEAO Nova-Force 4X4 HP en vente à prix discount
Warning: mysqli_query(): (08S01/1053): Server shutdown in progress in
/home/pneustorvn/www/includes/functions/database.php on line
51
1053 - Server shutdown in progress
select p.products_image, UPPER(m.manufacturers_name) as manufacturers_name, pd.products_name, CONCAT(param_largeur_valeur,"/",param_hauteur_valeur," R",param_diametre_valeur) as products_largeur, p.products_charge, p.products_vitesse,
p.products_id, p.manufacturers_id, p.products_price, p.products_image, p.products_marge, p.products_recyclage_unitaire_4,
p.products_recyclage, p.products_tax_class_id, s.starting_date as date_debut, s.expires_date as date_fin,
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price,
IF(s.status, s.specials_new_products_price, p.products_price) as final_price,
((p.products_price / (1-(pma.param_marge_valeur/100)))+pr.param_recyclage_valeur) as 'prix_public'
from products_description pd, products p
left join manufacturers m on p.manufacturers_id = m.manufacturers_id
left join param_marge pma on p.products_marge=pma.param_marge_id
left join specials s on p.products_id = s.products_id
left join products_to_categories p2c on p.products_id=p2c.products_id
left join param_recyclage pr on p.products_recyclage=pr.param_recyclage_id
left join param_largeur on p.products_largeur = param_largeur_id
left join param_hauteur on p.products_hauteur=param_hauteur_id
left join param_diametre on p.products_diametre=param_diametre_id
where p.products_status = '1'
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '1' and p2c.categories_id = '26' and p.manufacturers_id = m.manufacturers_id and p.manufacturers_id = '1252' and (pd.products_name like 'Nova-Force%4X4%HP' or pd.products_name like 'Nova-Force%4X4%HPpromo' or pd.products_name like 'Nova-Force%4X4%HP promo' or pd.products_name like 'Nova-Force%4X4%HPPromo' or pd.products_name like 'Nova-Force%4X4%HP Promo' or pd.products_name like 'Nova-Force%4X4%HP¤' or pd.products_name like 'Nova-Force%4X4%HP ¤' or pd.products_name like 'Nova-Force%4X4%HP§' or pd.products_name like 'Nova-Force%4X4%HP §' or pd.products_name like 'Nova-Force%4X4%HP*' or pd.products_name like 'Nova-Force%4X4%HP *' or pd.products_name like 'Nova-Force%4X4%HP(DOT 08)' or pd.products_name like 'Nova-Force%4X4%HP (DOT 08)' or pd.products_name like 'Nova-Force%4X4%HP(DOT 09)' or pd.products_name like 'Nova-Force%4X4%HP (DOT 09)' or pd.products_name like 'Nova-Force%4X4%HP(Run-Flat)' or pd.products_name like 'Nova-Force%4X4%HP (Run-Flat)' ) order by prix_public asc limit 0, 30
[TEP STOP]
