SELECT left_sides.`id` AS t0_r0, left_sides.`created_at` AS t0_r1, left_sides.`hit_count` AS t0_r2, right_sides.`id` AS t1_r0, right_sides.`name` AS t1_r1, right_sides.`type` AS t1_r2, right_sides.`facet_id` AS t1_r3 FROM left_sides LEFT OUTER JOIN right_sides_left_sides ON right_sides_left_sides.search_id = left_sides.id LEFT OUTER JOIN right_sides ON right_sides.id = right_sides_left_sides.facet_id WHERE (right_sides.id in (5)) GROUP BY left_sides.id HAVING count(right_sides.id) = 1