Pastebin

Paste #240:

< previous paste - next paste>

Pasted by tdn

Download View as text

SELECT A.body, A.date_created, A.title, A.article_id, COUNT(AC.comment_id) AS comments
FROM article A, article_comment AC
WHERE A.article_id = AC.article_id
  AND A.visibility > 0
  AND AC.visibility > 0
GROUP BY A.body, A.date_created, A.title, A.article_id
ORDER BY A.date_created DESC
LIMIT '10'

New Paste

Go to most recent paste.

Backed by:

PostgreSQL Professional Services

Debian Linux Support