Notice: Error: Out of resources when opening file '/tmp/#sql_562_0.MAD' (Errcode: 24 "Too many open files")
Error No: 23
SELECT DISTINCT pa.text, a.`attribute_id`, ad.`name`, ag.attribute_group_id, agd.name as attribute_group_name FROM `product_attribute` pa LEFT JOIN attribute a ON(pa.attribute_id=a.`attribute_id`) LEFT JOIN attribute_description ad ON(a.attribute_id=ad.`attribute_id`) LEFT JOIN attribute_group ag ON(ag.attribute_group_id=a.`attribute_group_id`) LEFT JOIN attribute_group_description agd ON(agd.attribute_group_id=ag.`attribute_group_id`) LEFT JOIN product p ON(p.product_id=pa.`product_id`) LEFT JOIN product_to_category p2c ON(p.product_id=p2c.product_id) LEFT JOIN product_to_store p2s ON(p.product_id=p2s.product_id) WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.store_id =0 AND p2c.category_id = '72' AND pa.language_id = '2' AND ad.language_id = '2' AND agd.language_id = '2' ORDER BY ag.sort_order, agd.name, a.sort_order, ad.name, pa.text in /home/site_229/public/system/database/mysql.php on line 49