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 (357, 407, 422, 563, 806, 956)) 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" =196)