select max(catalog.cost) as max from catalog where catalog.cost>0 and catalog.cat=262
Мы ответим на Ваши вопросы
Смартфоны
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 catalog.cat=262 and catalog.subcat=263 and catalog.cost<=107990 and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=2110 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=2399 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=613 limit 1) ) 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 catalog.cat=262 and catalog.subcat=263 and catalog.cost<=107990 and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=2110 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=2399 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=613 limit 1) ) order by (select if(st1+st2+st3+st4+st5>0,1,0) as n from catalog_params where catalog_params.idt=catalog.id limit 1) desc, cost asc limit 0,30
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 catalog.cat=262 and catalog.subcat=263 and catalog.cost<=107990 and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=2110 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=2399 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=613 limit 1) ) order by (select if(st1+st2+st3+st4+st5>0,1,0) as n from catalog_params where catalog_params.idt=catalog.id limit 1) desc, cost asc limit 0,30
Ничего не найдено!
