Select count(catalog.id) as n 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=101 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 ) ) limit 1

---

MySQL server has gone away
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=101 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 150,30

---

MySQL server has gone away