1 - Can't create/write to file '/tmp/#sql-temptable-281-12824ed-eb.MAI' (Errcode: 28 "No space left on device")
select
p.products_image, p.products_model, pd.products_name, p.products_weight,
p.products_id,
substring_index(pd.products_description, ' ', 20) as products_description,
p.manufacturers_id,
p.products_price,
p.products_tax_class_id,
if(
s.status,
s.specials_new_products_price,
NULL
) as specials_new_products_price,
if(
s.status,
s.specials_new_products_price,
greatest(
p.products_price,
p.products_price1,
p.products_price2,
p.products_price3,
p.products_price4,
p.products_price5,
p.products_price6,
p.products_price7,
p.products_price8
)
) as final_price
from
products_description pd,
products p
left join manufacturers m on p.manufacturers_id = m.manufacturers_id
left join specials s on p.products_id = s.products_id,
products_to_categories p2c
where p.products_status = '1'
and p.products_id = p2c.products_id
and pd.products_id = p2c.products_id
and pd.language_id = '4'
and p2c.categories_id = '8003'
order by pd.products_name
[TEP STOP]