tags #
All tags are listed below.
Sort by clicking headers.
Click tag to see content.
Tags #
vote_value vote_count
#image 149
1 item(s)
tags.sql #
 
SELECT
	vote_value,
	vote_count
FROM (
	SELECT
		vote_value,
		COUNT(vote_value) AS vote_count
	FROM
		vote
	WHERE
		file_hash IN (
			SELECT file_hash
			FROM item_flat
			WHERE item_score >= 0
		)
	GROUP BY
		vote.vote_value
	)
ORDER BY
	vote_count DESC

Welcome ; Threads ; Write ; Settings ; Authors ; Tags(1) ; Help
Welcome Expand; Minimal; Reprint;