SELECT
  o0_.serialized_data AS serialized_data_0,
  o0_.id AS id_1,
  o0_.materialized_path AS materialized_path_2,
  o0_.title AS title_3,
  o0_.created_at AS created_at_4,
  o0_.updated_at AS updated_at_5,
  o0_.tree_left AS tree_left_6,
  o0_.tree_level AS tree_level_7,
  o0_.tree_right AS tree_right_8,
  o0_.tree_root AS tree_root_9,
  o1_.id AS id_10,
  o0_.id AS id_11
FROM
  oro_catalog_category o0_
  INNER JOIN oro_product o1_
    ON (
      EXISTS
      (SELECT
        1
      FROM
        oro_category_to_product o2_
        INNER JOIN oro_product o3_
          ON o2_.product_id = o3_.id
      WHERE o2_.category_id = o0_.id
        AND o3_.id IN (o1_.id))
    )
WHERE o1_.id IN (
    557001,
    557002,
    557003,
    557004,
    557005,
    557006,
    557007,
    557008,
    557009,
    557010,
    557011,
    557012,
    557013,
    557014,
    557015,
    557016,
    557017,
    557018,
    557019,
    557020,
    557021,
    557022,
    557023,
    557024,
    557025,
    557026,
    557027,
    557028,
    557029,
    557030,
    557031,
    557032,
    557033,
    557034,
    557035,
    557036,
    557037,
    557038,
    557039,
    557040,
    557041,
    557042,
    557043,
    557044,
    557045,
    557046,
    557047,
    557048,
    557049,
    557050,
    557051,
    557052,
    557053,
    557054,
    557055,
    557056,
    557057,
    557058,
    557059,
    557060,
    557061,
    557062,
    557063,
    557064,
    557065,
    557066,
    557067,
    557068,
    557069,
    557070,
    557071,
    557072,
    557073,
    557074,
    557075,
    557076,
    557077,
    557078,
    557079,
    557080,
    557081,
    557082,
    557083,
    557084,
    557085,
    557086,
    557087,
    557088,
    557089,
    557090,
    557091,
    557092,
    557093,
    557094,
    557095,
    557096,
    557097,
    557098,
    557099,
    557100
  )