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