Мы ответим на Ваши вопросы
Смартфоны
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=606 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=1839 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=613 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=1840 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=606 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=1839 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=613 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=1840 limit 1) ) order by viewed asc, tomain asc, (select count(catalog_photo.id) from catalog_photo where catalog_photo.idt=catalog.id ) asc, id asc limit 0,20
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=606 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=1839 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=613 limit 1) ) and ( exists(Select * from catalog_value where catalog_value.cid=catalog.id and catalog_value.def=1840 limit 1) ) order by viewed asc, tomain asc, (select count(catalog_photo.id) from catalog_photo where catalog_photo.idt=catalog.id ) asc, id asc limit 0,20
Ничего не найдено!
