Tags #
label label_count
#image 149
#changelog 3
#hashtag 3
Cart #
Paste
Clear
Add All
tags.sql #
 

SELECT
	label,
	label_count
FROM (
	SELECT
		label,
		COUNT(label) AS label_count
	FROM
		item_label
	WHERE
		file_hash IN (
			SELECT file_hash
			FROM item_flat
			WHERE item_score >= 0
		)
	GROUP BY
		item_label.label
	)
WHERE
	label = LOWER(label)
ORDER BY
	label_count DESC

Image(149) ; Settings
Welcome
JavaScript #