(slug = 'zooroyal' or id = 'zooroyal') or id in ( select target_id from aliases where source_id = 'zooroyal' and type in ('slug','domain') ) and 1=1