Out of resources when opening file './www_sunshine_gr/categories.MYD' (Errcode: 24)
query=SELECT t1.category AS lev1, t1.cat_id AS clev1, t2.category as lev2, t2.cat_id AS clev2, t3.category as lev3, t3.cat_id AS clev3, t4.category as lev4, t4.cat_id AS clev4, t5.category as lev5, t5.cat_id AS clev5, t6.category as lev6, t6.cat_id AS clev6, t7.category as lev7, t7.cat_id AS clev7, t8.category as lev8, t8.cat_id AS clev8, t9.category as lev9, t9.cat_id AS clev9, t10.category as lev10, t10.cat_id AS clev10, t1.cat_discount AS cdscnt1, t2.cat_discount AS cdscnt2, t3.cat_discount AS cdscnt3, t4.cat_discount AS cdscnt4, t5.cat_discount AS cdscnt5, t6.cat_discount AS cdscnt6, t7.cat_discount AS cdscnt7, t8.cat_discount AS cdscnt8, t9.cat_discount AS cdscnt9, t10.cat_discount AS cdscnt10 FROM categories AS t1 LEFT JOIN categories AS t2 ON t2.cat_father_id = t1.cat_id LEFT JOIN categories AS t3 ON t3.cat_father_id = t2.cat_id LEFT JOIN categories AS t4 ON t4.cat_father_id = t3.cat_id LEFT JOIN categories AS t5 ON t5.cat_father_id = t4.cat_id LEFT JOIN categories AS t6 ON t6.cat_father_id = t5.cat_id LEFT JOIN categories AS t7 ON t7.cat_father_id = t6.cat_id LEFT JOIN categories AS t8 ON t8.cat_father_id = t7.cat_id LEFT JOIN categories AS t9 ON t9.cat_father_id = t8.cat_id LEFT JOIN categories AS t10 ON t10.cat_father_id = t9.cat_id where t1.cat_father_id='0' order by t1.category, t2.category, t3.category, t4.category, t5.category, t6.category, t7.category, t8.category, t9.category, t10.category