SELECT
  FROM_UNIXTIME(a.article_publishdate) AS pub_dato,
  a.article_title AS overskrift,
  a.article_hits AS antal_visninger,
  COALESCE((SUM(c.thread_replies) + COUNT(c.thread_id)), 0) AS antal_debatindlaeg
FROM 
  comworld_simpson_article a
LEFT JOIN 
  comworld_agora_thread c
ON
  c.articleid = a.article_id AND 
  a.article_status > 0 AND 
  a.article_publishdate < UNIX_TIMESTAMP()
GROUP BY
  c.articleid
ORDER BY
  a.article_publishdate DESC
LIMIT
  0,1000