Select count(id) as n from catalog where catalog.cost>=0 and catalog.cat>0 and ( exists(select * from catalog_tree where catalog_tree.id=catalog.cat and catalog_tree.sh=0 limit 1 ) ) and ( catalog.subcat=0 or exists(select * from catalog_tree where catalog_tree.id=catalog.subcat and catalog_tree.sh=0 limit 1 ) ) and ( catalog.subsubcat=0 or exists(select * from catalog_tree where catalog_tree.id=catalog.subsubcat and catalog_tree.sh=0 limit 1 ) ) and ( brand=31 ) limit 1

---

select * from catalog where catalog.cost>=0 and catalog.cat>0 and ( exists(select * from catalog_tree where catalog_tree.id=catalog.cat and catalog_tree.sh=0 limit 1 ) ) and ( catalog.subcat=0 or exists(select * from catalog_tree where catalog_tree.id=catalog.subcat and catalog_tree.sh=0 limit 1 ) ) and ( catalog.subsubcat=0 or exists(select * from catalog_tree where catalog_tree.id=catalog.subsubcat and catalog_tree.sh=0 limit 1 ) ) and ( brand=31 ) order by 0+(Select catalog_orderby.pos from catalog_orderby where type=1 and catalog_orderby.tid=1 and (catalog_orderby.idt=catalog.cat or catalog_orderby.idt=catalog.subcat or catalog_orderby.idt=catalog.subsubcat) limit 1) desc , (select if(st1+st2+st3+st4+st5>0,1,0) as n from catalog_params where catalog_params.idt=catalog.id limit 1) desc, if(sale>0,1,0) desc, tomain desc, (select count(catalog_photo.id) from catalog_photo where catalog_photo.idt=catalog.id ) desc, id desc limit 160,20

---