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