List of Equipment Responsibles in Room

SELECT firstName, lastName, email, admin_user.`status`, equipment_equipment.name, equipment_role.title FROM equipment_equipment_role INNER JOIN admin_user ON admin_user.id = equipment_equipment_role.user_id INNER JOIN equipment_role ON equipment_equipment_role.role_id = equipment_role.id INNER JOIN equipment_equipment ON equipment_equipment.id = equipment_equipment_role.equipment_id WHERE equipment_id IN (SELECT id FROM equipment_equipment WHERE room_id = 29) AND equipment_equipment_role.status = 1;