Select catalog.id, catalog.title, catalog.alias, catalog.total_count, catalog.short, catalog.photo, catalog.cropped, catalog.total_cost, catalog.total_sale, catalog.flag_sale, tree.alias as catalias, tree.title as cattitle FROM catalog, catalog_category as tree where tree.id=catalog.category and tree.hide=0 and catalog.total_cost>0 and exists(Select * from news_item where news_item.idn=117 and ( catalog.cat=news_item.category or news_item.category="" ) and ( catalog.factory=news_item.factory or news_item.factory="" ) and ( news_item.cost_start<=catalog.total_cost and news_item.cost_stop>=catalog.total_cost ) ) order by catalog.countshow desc limit 30000,10000

---

Disk full (/tmp/#sql_76e4_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")