Мы ответим на Ваши вопросы
Техника для кухни
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=368 and ( brand=42 ) 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
Ничего не найдено!