Chain(599) ; Write ; Upload ; Image(245) ; Settings ; Session ; Help
Banana Lounge Unofficial Fan Forum

Labels #
label label_count
#received 285
#client 285
#cookie 272
#image 245
#parent 233
#hashtag 149
#1661863245 63
#like 52
#boxes 24
#1662056941 22
#https 16
#pubkey 14
#changelog 11
#title 9
#22Oct16 5
#1661998972 5
#2018 4
#1662178680 4
#1662152809 4
#rotate 3
#my_name_is 3
#bug 3
#1661839138 3
#todo 2
#offtopic 2
#http 2
#1662416095 2
#1662400600 2
#1662328395 2
#1662262637 2
#1662211128 2
#water 1
#signed 1
#opinion 1
#notext 1
#meta 1
#javascript 1
#hasvote 1
#fountain 1
#cheatsheet 1
#baseball 1
#PersonalOpinion 1
#OutOfContext 1
#HI 1
#HACKBOSTON 1
#1662671950 1
Cart #
Paste
Clear
Add All
labels.sql #

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


PrintedInfo #

Q: When was this page printed?
Printed: July 24 2024 14:56:04.

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

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

^