(slug = 'chefdealsde' or id = 'chefdealsde') or (host like '%chefdealsde%') or id in ( select target_id from aliases where source_id = 'chefdealsde' and type in ('slug','domain') ) and 1=1