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