1053 - Server shutdown in progress
select p.products_image, UPPER(m.manufacturers_name) as manufacturers_name, pd.products_name,products_normes, 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',
((p.products_price / (1-(pma.param_marge_valeur/100)))+pr4.param_recyclage_valeur) as 'prix_public_4'
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_recyclage pr4 on p.products_recyclage_unitaire_4=pr4.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 p.manufacturers_id!='36'
and pd.products_name LIKE '% promo'
and p.products_categorie ='1'
order by rand() limit 0, 10
[TEP STOP]
|
