Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql-temptable-330d77-d3a019-a25a14.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /home/elrois/public_html/includes/functions/database.php on line 58
1021 - Disk full (/tmp/#sql-temptable-330d77-d3a019-a25a14.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")

select p.products_model, pd.products_name, p.products_image, p.products_image_orientation, p.products_price_cash, pd.products_short_description, p.products_stock_status_id, p.products_quantity, m.manufacturers_name, p.products_id, p.manufacturers_id, p.products_recent_sales, IF(s.status and s.specials_price_catalog>'0.00', s.specials_price_catalog, p.products_price) AS 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, IF(p.products_price_cash>'0.00', p.products_price_cash, p.products_price)) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials_retail_prices s on p2c.products_id = s.products_id 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 in (16,17,482,483,23,24,25,342,485,26,27,148,317,481,99,100,101,102,103,216,287,288,307,515,566,576,594,291,327,584,585,516,558,560,580,538,581,615,334) and p.parent_id='0' and p.products_id in (31845,22232,31851,31839,7045,6228,36273,7331,31873,17741,17754,17663,7321,5613,31904,31857,8748,36255,5132,11972,40091,34400,8739,40603,15462,32428,5130,20222,7089,30304,31701,15486,6253,11189,5386,35377,36749,31920,34205,7435,38452,5384,7680,10332,7602,8925,19951,40098,16140,39899,21921,34748,5388,28749,38206,13596,7670,35472,32935,30234,38154,30365,18439,35392,31921,30341,34111,18424,34197,35387,15192,35382) group by p.products_id order by final_price, pd.products_name desc

[TEP STOP]