select max(catalog.cost) as max from catalog where catalog.cost>0 and catalog.cat=36
Мы ответим на Ваши вопросы
Гигиена и здоровье
- Весы напольные
- Зеркала косметические
- Маникюрные наборы
- Педикюрные наборы
- Массажеры
- Массажные ванночки для ног
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=36 and catalog.subcat=47 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=36 and catalog.subcat=47 order by viewed asc, tomain asc, (select count(catalog_photo.id) from catalog_photo where catalog_photo.idt=catalog.id ) asc, id asc limit 230,10
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=36 and catalog.subcat=47 order by viewed asc, tomain asc, (select count(catalog_photo.id) from catalog_photo where catalog_photo.idt=catalog.id ) asc, id asc limit 230,10
Ничего не найдено!