SELECT 
  p.product_id, 
  ifnull(
    count(dp.post_id), 
    0
  ) as discussion_amount_posts 
FROM 
  cscart_discussion 
  INNER JOIN cscart_products as p ON (
    cscart_discussion.object_id = p.product_id
  ) 
  INNER JOIN cscart_discussion_posts as dp ON (
    cscart_discussion.thread_id = dp.thread_id 
    AND cscart_discussion.object_type = 'P' 
    AND cscart_discussion.company_id = 1
  ) 
WHERE 
  dp.status = 'A' 
  and p.product_id in (
    51297, 51296, 139, 51300, 51299, 51298, 
    51304, 51303, 51302, 51301, 138, 51443, 
    51309, 51308, 51307, 51306, 51305, 
    129, 51318, 51317, 51316, 51, 51319, 
    51323, 51322, 51321, 51320, 50, 51324, 
    51497, 51498, 51564, 51568, 51569, 
    51570, 51571, 51572, 51573, 51565, 
    51574, 51575, 51576, 51577, 51566, 
    51578, 51579, 51580, 51581, 51567, 
    51582, 51583, 51584, 51585, 51586
  ) 
GROUP BY 
  p.product_id