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