select `id`, `alias`, `template` , `url` from `cms_structure` where ( `parent_id`=47815 or (0>0 and `parent_id`=0) or `subversionOf`=47816 or (`subversionOf` <> 0 and `subversionOf`=47815) or (`subversionOf` <> 0 and `subversionOf`=0 and `id`<>47815) ) and `published`='y' and `base_id`=0 and (`source`<>'admin') and `id` NOT IN (47816, 33039) order by `alias` asc