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

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