Labels #
label label_count
#image 149
#hashtag 3
#changelog 3
Cart #
Paste
Clear
Add All
labels.sql #

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



Welcome ; New ; Threads ; Topics ; Write ; Settings ; Session ; People ; Labels(3) ; Help
Welcome
JavaScript #