|
|
|
|
SELECT s.*, t.*, COUNT(r.counter_story_id) AS reads FROM stories s
LEFT OUTER JOIN readcounter r
ON r.counter_story_id = s.story_id
LEFT OUTER JOIN story_titles t
ON t.title_story_id = s.story_id
WHERE s.story_id <> 31
AND s.story_published = '1'
GROUP BY t.title_id
ORDER BY reads DESC
LIMIT 0, 20sql error | | |
