SELECT xfrmact.deleted, template.hid, template.id, template.name, template.component_id
FROM template
INNER JOIN transformations xfrm ON xfrm.template_id = template.id
INNER JOIN transformation_steps xfrmstep ON xfrmstep.transformation_id = xfrm.id
INNER JOIN transformation_task_steps tts ON tts.transformation_step_id = xfrmstep.id
INNER JOIN transformation_activity xfrmact ON xfrmact.hid = tts.transformation_task_id
INNER JOIN template_group_template tgt ON tgt.template_id = xfrmact.hid
WHERE component_id IN ('c4b3ebdd32137419b820ba3ddbd7d141e', 'c25d1206fbd2543fd90f8ce76d363087b') and xfrmact.deleted = 'f';