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 = 4 
WHERE 
  cscart_products_categories.product_id IN (
    69132, 69131, 69252, 69412, 69405, 69404, 
    68938, 68937, 68936, 68934, 68933, 
    68932, 68931, 68930, 68929, 68928, 
    68927, 68926, 68925, 68924, 68923, 
    68922, 68918, 68917, 68915, 68913, 
    68857, 68856, 68855, 68854, 68853, 
    68852, 68851, 68849, 68846, 68842, 
    68841, 68840, 68839, 69286
  ) 
GROUP BY 
  cscart_products_categories.product_id