select bcatalog.id,bcatalog.idpage,bcatalog.idblock,bcatalog.name,bcatalog.parent,bcatalog.sortir, menus.sortir as menusort, text_ext.sortir as blocksort from bcatalog, menus, text_ext where bcatalog.idpage = menus.id and text_ext.id = bcatalog.idblock and bcatalog.visible='1' and bcatalog.type='0' and bcatalog.parent='0' AND bcatalog.range_flag = '0'
AND bcatalog.design = '0'
AND bcatalog.pantograph = '0'
AND bcatalog.massiv = '0'
order by menusort, blocksort, bcatalog.sortir
ДИЗАЙН
select bcatalog.id,bcatalog.idpage,bcatalog.idblock,bcatalog.name,bcatalog.parent,bcatalog.sortir, menus.sortir as menusort, text_ext.sortir as blocksort from bcatalog, menus, text_ext where bcatalog.idpage = menus.id and text_ext.id = bcatalog.idblock and bcatalog.visible='1' and bcatalog.type='0' and bcatalog.parent='0' AND bcatalog.range_flag = '0'
AND bcatalog.design = '1'
AND bcatalog.pantograph = '0'
AND bcatalog.massiv = '0'
order by menusort, blocksort, bcatalog.sortir
МОДЕРН
select bcatalog.id,bcatalog.idpage,bcatalog.idblock,bcatalog.name,bcatalog.parent,bcatalog.sortir, menus.sortir as menusort, text_ext.sortir as blocksort from bcatalog, menus, text_ext where bcatalog.idpage = menus.id and text_ext.id = bcatalog.idblock and bcatalog.visible='1' and bcatalog.type='0' and bcatalog.parent='0' AND bcatalog.range_flag = '0'
AND bcatalog.design = '0'
AND bcatalog.pantograph = '1'
AND bcatalog.massiv = '0'
order by menusort, blocksort, bcatalog.sortir
МАССИВ
select bcatalog.id,bcatalog.idpage,bcatalog.idblock,bcatalog.name,bcatalog.parent,bcatalog.sortir, menus.sortir as menusort, text_ext.sortir as blocksort from bcatalog, menus, text_ext where bcatalog.idpage = menus.id and text_ext.id = bcatalog.idblock and bcatalog.visible='1' and bcatalog.type='0' and bcatalog.parent='0' AND bcatalog.range_flag = '0'
AND bcatalog.design = '0'
AND bcatalog.pantograph = '0'
AND bcatalog.massiv = '1'
order by menusort, blocksort, bcatalog.sortir
Каталог PLUS
select bcatalog.id,bcatalog.idpage,bcatalog.idblock,bcatalog.name,bcatalog.parent,bcatalog.sortir, menus.sortir as menusort, text_ext.sortir as blocksort from bcatalog, menus, text_ext where bcatalog.idpage = menus.id and text_ext.id = bcatalog.idblock and bcatalog.visible='1' and bcatalog.type='0' and bcatalog.parent='0' AND bcatalog.range_flag = '1'
AND bcatalog.design = '0'
AND bcatalog.pantograph = '0'
AND bcatalog.massiv = '0'
order by menusort, blocksort, bcatalog.sortir
Данный сайт носит информационно-справочный характер и ни при каких условиях не является публичной офертой. Пожалуйста, для уточнения информации, цен и условий акций обращайтесь к продавцам-консультантам по телефону: +7 495 77-22-088 и при посещении салона-магазина.
