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 (
    50847, 50829, 50828, 50824, 50638, 50629, 
    50627, 50783, 79929, 50734, 50674, 
    50648, 50647, 50644, 50643, 50679, 
    50678, 50677, 50448, 50979, 50978, 
    50977, 50976, 50474, 79925, 50791, 
    50478, 92373, 92372, 92371, 92370, 
    92369, 92368, 92367, 92366, 92365, 
    92364, 92363, 50821, 51308, 50919, 
    50632, 50619, 50618, 50594, 50607, 
    50606, 50605, 50604, 50603, 50602, 
    50601, 50599, 50598, 50597, 50590, 
    50449, 50397, 50578, 50577, 50576, 
    50575, 50384, 50574, 50553, 50552, 
    50551, 50550, 50327, 50278, 50240, 
    50239, 50238, 50559, 50171, 50527, 
    50526, 50525, 50524, 50523
  )