selectcount(*) as aggregate from "parts" whereexists (select*from "cars" innerjoin "car_part" on "cars"."id" = "car_part"."car_id" where "parts"."id" = "car_part"."part_id" and "cars"."id" in (607, 633, 791, 851, 909, 1047)) andexists (select*from "nested_categories" innerjoin "part_sub_category" on "nested_categories"."id" = "part_sub_category"."nested_category_id" where "parts"."id" = "part_sub_category"."part_id" and "nested_categories"."id" =443)