Welcome ; Write ; Threads ; New ; Image(1) ; Links ; Upload ; Calendar ; #HumanTalk ; #ToiletTalk ; Search ; Settings ; Stats ; Session ; Authors(45) ; People(1) ; Scores ; Labels(17) ; Data ; Chain(125) ; Help
Welcome

Tags
label label_count
#signed 95
#hastext 85
#hastitle 85
#notext 38
#parent 28
#hashtag 21
#hasvote 20
#https 20
#pubkey 14
#puzzle 5
#changelog 3
#gratitude 3
#my_name_is 3
#approve 1
#declined 1
#image 1
#title 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


PrintedInfo #

Q: When was this page printed?
Printed: November 13 2024 15:17:56.

Q: How old was the page when downloaded?
Age: Fresh!
pollyanna:

Q: How can I get a fresher copy?
A: Ask the server to

JavaScript
Concept
Concept for this page is not defined yet.
PageMap
Welcome ; Write ; Threads ; New ; Image(1) ; Links ; Upload ; Calendar ; #HumanTalk ; #ToiletTalk ; Search ; Settings ; Stats ; Session ; Authors(45) ; People(1) ; Scores ; Labels(17) ; Data ; Chain(125) ; Help
Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset
CookieInfo #

You are signed in as Guest
Cookie: none
Alias: Guest
Score: 0
Avatar: