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

Labels #
label label_count
#received 285
#client 285
#cookie 272
#image 258
#parent 242
#hashtag 161
#1661863245 63
#like 54
#pubkey 25
#boxes 24
#1662056941 22
#https 18
#changelog 14
#title 9
#22Oct16 5
#1661998972 5
#2018 4
#1662178680 4
#1662152809 4
#rotate 3
#my_name_is 3
#bug 3
#approve 3
#1661839138 3
#todo 2
#offtopic 2
#http 2
#1662416095 2
#1662400600 2
#1662328395 2
#1662262637 2
#1662211128 2
#water 1
#signed 1
#overheard 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
#31 1
#30 1
#29 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: December 22 2024 15:31:30.

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

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

^
JavaScript #