SELECT 
  cscart_products_categories.product_id, 
  GROUP_CONCAT(
    IF(
      cscart_products_categories.link_type = "M", 
      CONCAT(
        cscart_products_categories.category_id, 
        "M"
      ), 
      cscart_products_categories.category_id
    )
  ) AS category_ids, 
  product_position_source.position AS position 
FROM 
  cscart_products_categories 
  INNER JOIN cscart_categories ON cscart_categories.category_id = cscart_products_categories.category_id 
  AND cscart_categories.storefront_id IN (0, 1) 
  AND (
    cscart_categories.usergroup_ids = '' 
    OR FIND_IN_SET(
      0, cscart_categories.usergroup_ids
    ) 
    OR FIND_IN_SET(
      1, cscart_categories.usergroup_ids
    )
  ) 
  AND cscart_categories.status IN ('A', 'H') 
  LEFT JOIN cscart_products_categories AS product_position_source ON cscart_products_categories.product_id = product_position_source.product_id 
  AND product_position_source.category_id = 22 
WHERE 
  cscart_products_categories.product_id IN (
    43553, 43552, 43548, 43547, 43546, 43530, 
    43535, 43534, 43528, 43527, 43526, 
    43525, 43523, 43520, 43781, 43780, 
    43779, 43778, 43777, 43776, 43775, 
    43774, 43773, 43772, 43771, 43770, 
    43769, 43768, 43423, 43420, 43416, 
    43411, 43410, 43409, 43378, 43377, 
    43333, 43332, 43331, 43349, 43348, 
    43347, 43342, 43341, 43340, 43339, 
    43338, 43337, 43336, 43335, 43334, 
    43328, 43326, 43325, 43292, 43555, 
    43529, 43288, 43287, 43286, 43281, 
    43280, 43279, 43619, 43513, 43508, 
    43290, 43289, 63106, 63105, 63104, 
    63103, 63102, 63101, 63100, 63099, 
    63098, 63097, 63096, 63095
  ) 
GROUP BY 
  cscart_products_categories.product_id