SQL Queries

To list the number of versions from one Article

SELECT count(article_id) as sum, title, article_id FROM version Group BY title ORDER BY sum desc

SELECT id, article_id from version where article_id = 3409

SELECT count( title ) AS sum, title, id FROM version GROUP BY title ORDER BY sum desc

SELECT count(article_id) as sum, title, id, article_id FROM version Group BY id ORDER BY sum desc