Disk full (/tmp/#sql_4a6_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") SQL=SELECT product_special, product_final_price, product_id, category_id, manufacturer_id FROM (SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`, `jos_vm_manufacturer`.`manufacturer_id`, `jos_vm_manufacturer`.`mf_name`, `jos_vm_product`.`product_final_price`, `jos_vm_product`.`product_special` FROM (`jos_vm_product`) LEFT JOIN `jos_vm_product_price` ON `jos_vm_product_price`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_shopper_group` ON `jos_vm_shopper_group`.`shopper_group_id` = `jos_vm_product_price`.`shopper_group_id` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_category`.`category_id` = `jos_vm_product_category_xref`.`category_id` LEFT JOIN `jos_vm_product_mf_xref` ON `jos_vm_product_mf_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_manufacturer` ON `jos_vm_manufacturer`.`manufacturer_id` = `jos_vm_product_mf_xref`.`manufacturer_id` WHERE #{product_idnotin} `jos_vm_product_category_xref`.`category_id` IN (35,42,36,54,84,44,52,95,97,98,80,33,75,82,100,20,65,110) AND `jos_vm_product_mf_xref`.`manufacturer_id`='101' AND `jos_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' AND `category_publish`='Y' AND product_in_stock > 0 AND `jos_vm_product`.`product_sku`<>'EMBALLAGECADEAU' GROUP BY `jos_vm_product`.`product_sku` ORDER BY `jos_vm_product`.`product_special` DESC, `jos_vm_product`.`cdate` DESC, `jos_vm_product`.`product_id` DESC) AS f;