Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT post_id, COUNT(CASE WHEN vote > 0 THEN vote ELSE NULL END) AS voters,
- AVG(CASE WHEN vote > 0 THEN vote ELSE NULL END) AS average FROM wp_imdb_rating
- GROUP BY post_id
- ORDER BY voters * average DESC
- LIMIT 0, 100
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement