Read ; Write ; Upload ; Image(265) ; Threads(145) ; Settings ; Profile ; Boxes ; Help
Banana Lounge Unofficial Fan Forum

Tags #
label label_count
#client 295
#received 295
#cookie 282
#image 265
#parent 258
#hashtag 177
#pubkey 88
#like 69
#1661863245 63
#boxes 24
#1662056941 22
#https 20
#changelog 18
#approve 9
#title 9
#1661998972 5
#my_name_is 5
#1662152809 4
#1662178680 4
#2018 4
#rotate 4
#1661839138 3
#bug 3
#1662211128 2
#1662262637 2
#1662328395 2
#1662400600 2
#1662416095 2
#http 2
#offtopic 2
#overheard 2
#puzzle 2
#todo 2
#1662671950 1
#29 1
#30 1
#31 1
#baseball 1
#cheatsheet 1
#fountain 1
#hasvote 1
#javascript 1
#meta 1
#notext 1
#opinion 1
#scunthorpe 1
#signed 1
#water 1
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
^
JavaScript #