Archive for March 16th, 2009
From Stack Overflow:
I have tables called
The latter three tables contain a
page_idforeign key in order to keep a record of each individual view, item and vote that belongs to a page.
When I query a page, I also want to retrieve
I have pasted a query below. It retrieves the total number of views.SELECT Page.*, COUNT(*) AS views FROM pages AS Page INNER JOIN page_views AS PageView ON Page.id = PageView.page_id GROUP BY Page.id ORDER BY views DESC LIMIT 10 OFFSET 0
I’ve made various attempts to add items and votes to it, but the result is either a syntax error or views/items/votes returned as an identical andwrongnumber, probably due to the way I am joining.
How can I add items and votes to this query?
On a first thought, it’s simple:
Read the rest of this entry »