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 (
    41546, 41545, 41544, 41543, 41429, 41268, 
    41267, 41361, 41572, 41571, 41246, 
    41245, 41244, 41243, 41242, 41220, 
    41218, 41173, 41167, 41644, 41643, 
    41642, 41641, 41640, 41639, 41159, 
    41154, 41128, 41117, 41116, 41113, 
    41146, 41145, 41211, 41213, 41192, 
    41058, 41054, 41053, 41103, 41017, 
    40942, 40941, 40940, 40934, 40933, 
    40932, 40931, 40930, 40929, 40928, 
    40927, 40926, 40925, 40923, 40922, 
    40921, 40920, 40919, 40918, 40917, 
    40916, 40915, 40914, 40913, 40912, 
    40911, 40910, 40909, 40908, 40907, 
    40906, 40905, 40904, 40903, 40902, 
    40901, 40900, 40899, 41623
  ) 
GROUP BY 
  cscart_products_categories.product_id