3 Error writing file '/tmp/MYOiOfXL' (Errcode: 28 - No space left on device)
in:
[select p.products_id, p.products_type,p.products_status,p.products_price,p.products_price_retail,p.products_price_sample,p.product_is_wholesale,p.product_wholesale_min,p.products_quantity, p.products_quantity_order_min, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials 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 = '1' and ( p2c.categories_id =1 or p2c.categories_id =16 or p2c.categories_id =17 or p2c.categories_id =18 or p2c.categories_id =19 or p2c.categories_id =20 or p2c.categories_id =21 or p2c.categories_id =22 or p2c.categories_id =23 or p2c.categories_id =24 or p2c.categories_id =25 or p2c.categories_id =27 or p2c.categories_id =28 or p2c.categories_id =84 or p2c.categories_id =89 or p2c.categories_id =138 or p2c.categories_id =2 or p2c.categories_id =29 or p2c.categories_id =30 or p2c.categories_id =31 or p2c.categories_id =32 or p2c.categories_id =33 or p2c.categories_id =104 or p2c.categories_id =123 or p2c.categories_id =125 or p2c.categories_id =3 or p2c.categories_id =34 or p2c.categories_id =37 or p2c.categories_id =39 or p2c.categories_id =133 or p2c.categories_id =4 or p2c.categories_id =40 or p2c.categories_id =41 or p2c.categories_id =42 or p2c.categories_id =124 or p2c.categories_id =5 or p2c.categories_id =43 or p2c.categories_id =44 or p2c.categories_id =6 or p2c.categories_id =46 or p2c.categories_id =47 or p2c.categories_id =48 or p2c.categories_id =144 or p2c.categories_id =7 or p2c.categories_id =50 or p2c.categories_id =51 or p2c.categories_id =52 or p2c.categories_id =53 or p2c.categories_id =54 or p2c.categories_id =130 or p2c.categories_id =8 or p2c.categories_id =55 or p2c.categories_id =56 or p2c.categories_id =9 or p2c.categories_id =57 or p2c.categories_id =10 or p2c.categories_id =78 or p2c.categories_id =96 or p2c.categories_id =98 or p2c.categories_id =115 or p2c.categories_id =116 or p2c.categories_id =117 or p2c.categories_id =118 or p2c.categories_id =119 or p2c.categories_id =121 or p2c.categories_id =127 or p2c.categories_id =135 or p2c.categories_id =142 or p2c.categories_id =147 or p2c.categories_id =11 or p2c.categories_id =58 or p2c.categories_id =59 or p2c.categories_id =60 or p2c.categories_id =61 or p2c.categories_id =13 or p2c.categories_id =62 or p2c.categories_id =63 or p2c.categories_id =64 or p2c.categories_id =65 or p2c.categories_id =101 or p2c.categories_id =128 or p2c.categories_id =132 or p2c.categories_id =134 or p2c.categories_id =143 or p2c.categories_id =14 or p2c.categories_id =67 or p2c.categories_id =69 or p2c.categories_id =70 or p2c.categories_id =141 or p2c.categories_id =15 or p2c.categories_id =71 or p2c.categories_id =72 or p2c.categories_id =85 or p2c.categories_id =86 or p2c.categories_id =146 or p2c.categories_id =90 or p2c.categories_id =12 or p2c.categories_id =35 or p2c.categories_id =36 or p2c.categories_id =38 or p2c.categories_id =49 or p2c.categories_id =73 or p2c.categories_id =74 or p2c.categories_id =75 or p2c.categories_id =76 or p2c.categories_id =77 or p2c.categories_id =79 or p2c.categories_id =80 or p2c.categories_id =81 or p2c.categories_id =82 or p2c.categories_id =83 or p2c.categories_id =91 or p2c.categories_id =97 or p2c.categories_id =105 or p2c.categories_id =106 or p2c.categories_id =111 or p2c.categories_id =112 or p2c.categories_id =113 or p2c.categories_id =131 or p2c.categories_id =99 or p2c.categories_id =102 or p2c.categories_id =110 or p2c.categories_id =114 or p2c.categories_id =122 or p2c.categories_id =126 or p2c.categories_id =136 or p2c.categories_id =137 or p2c.categories_id =108 or p2c.categories_id =107 or p2c.categories_id =109 or p2c.categories_id =120 or p2c.categories_id =139 or p2c.categories_id =26 or p2c.categories_id =140 or p2c.categories_id =148 or p2c.categories_id =149 or p2c.categories_id =150 or p2c.categories_id =151 or p2c.categories_id =152) order by p.products_date_added DESC ]