Сретенское сельское поселение
select `id`, `alias`, `template` , `url` from `cms_structure`
where
(
`parent_id`=11649 or
(11788>0 and `parent_id`=11788) or
`subversionOf`=11650 or
(`subversionOf` <> 0 and `subversionOf`=11649) or
(`subversionOf` <> 0 and `subversionOf`=11788
and `id`<>11649)
) and
`published`='y' and
`base_id`=0 and
(`source`<>'admin')
and `id` NOT IN (11650, 33039)
order by `alias` asc