SQL ERROR:
SQLSTATE[HY000]: General error: 1021 Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device")

select p.products_image, p.products_image_med, p.products_image_lrg, p.products_model, pd.products_name, p.products_id, 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, p.products_price) as final_price, p.products_family_name from (products p left join specials_retail_prices s using(products_id) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd, products_to_categories p2c , products_filter_collection fclc where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and p.products_stock_type NOT IN (9) AND fclc.filter_collection LIKE "%|95_983|%" AND fclc.filter_collection LIKE "%|60_1277|%" AND fclc.filter_collection LIKE "%|36_977|%" AND fclc.filter_collection LIKE "%|95_1382|%" and fclc.products_id = p.products_id and pd.language_id = '1' and p2c.categories_id in (633,630,869,591,626,644,631,634,548) and (p.products_group_access like "%,G,%" or p.products_group_access like "G,%" or p.products_group_access like "%,G" or p.products_group_access="G") and p.products_parent_id = 0 group by p.products_family_name order by p.products_date_added DESC,p.products_family_name, p.products_model , pd.products_name