Welcome ; Threads ; Random ; Menu ; Help
let us not grow weary of doing good

Labels
label label_count
#hastitle 201
#hastext 201
#received 159
#client 159
#signed 50
#hasvote 48
#hashtag 48
#parent 22
#https 19
#gratitude 18
#notext 13
#like 13
#todo 6
#puzzle 5
#notable 3
#pubkey 2
#title 1
#approve 1
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


PrintedInfo

Q: When was this page printed?
Printed: December 22 2024 12:46:49.

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

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

JavaScript
PageMap
Welcome ; Threads ; Random ; Menu ; Help
Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset