|
|
Affichage de 1 à 3
(sur 3 produits) |
Page de résultats: |
1 - Can't create/write to file '/var/tmp/#sql_79cb_0.MAI' (Errcode: 28)
select p.products_image,p.products_image_lrg, pd.products_name, pd.products_description, p.products_quantity, p.products_id, p.manufacturers_id,p.products_prix_achat, p.products_price, p.products_tax_class_id, p.ecotax_rates_id, 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
from (products p
left join specials_retail_prices s using(products_id))
left join manufacturers m on p.manufacturers_id = m.manufacturers_id join
products_description pd join
products_to_categories p2c
where p.products_status = '1'
and p.goto_website = '1'
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '1'
and p2c.categories_id = '276' order by final_price , pd.products_name limit 0, 16
[TEP STOP]
| |
