SELECT 
  f.feature_id, 
  f.purpose, 
  p.product_id, 
  p.parent_product_id, 
  g.id, 
  g.code 
FROM 
  cscart_product_variation_group_features AS f 
  INNER JOIN cscart_product_variation_groups AS g ON f.group_id = g.id 
  INNER JOIN cscart_product_variation_group_products AS p ON f.group_id = p.group_id 
WHERE 
  p.product_id IN (
    54608, 54607, 54606, 54605, 54604, 54603, 
    54602, 54601, 54600, 54599, 54598, 
    54597, 54596, 54595, 54594, 54593, 
    54592, 54591, 54590, 54589, 54588, 
    54587, 54586, 54441, 54366, 54365, 
    54263, 54262, 54261, 54204, 54140, 
    54135, 54132, 54208, 54371, 54370, 
    54368, 54110, 54082, 54081, 54080, 
    54079, 54056, 54053, 54052, 54647, 
    54646, 54645, 54644, 54643, 54642, 
    54641, 54640, 54639, 54638, 54324, 
    54278, 54277, 54276, 53951, 53945, 
    53932, 53915, 53914, 53913, 53912, 
    53911, 53910, 53909, 53908, 53901, 
    53897, 53896, 53895, 53887, 54447, 
    54446, 54445, 54444, 53790
  )