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

Url #
tagset_url url author_id item_title labels_list item_score file_hash
promote; report https://news.ycombinator.com/item?id=42331270 Guest #like #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest Greetings from Hayden #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest Hey #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest Is there a printer in here? #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest Is today peak banana day? #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest Thanks for running the lounge and feeding us bananas! #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest This is my favorite place on campus #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Aditya Saxena, F7BBF9D67FAF80AF] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for E40-4thFloor, 30FB7BC9A1F0B129] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, 1A2B076CBCFC931C] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, 1F32D46389C9DDAA] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, 50241B5CDCAD0902] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, 6E0EA864782E7D5C] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, 7D5EB94D7242D701] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, 81356A997EC9D4C1] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, A702ABD6AD9A385F] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, D49F40AE716496FC] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, F65605370AFD7AF3] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, F8DA7DA3F2B77A42] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Guest, FD45C586E8EF7F0C] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Lighthouse prompt response, 0BBA1D304234D6EF] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for Lighthouse prompt response, E423F71B5077083D] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 09AED0E253200A17] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 0DE17A1AB5ED3335] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 1D622C1B8292954B] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 2F2861BC9AB887DC] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 40E4DF118C2D943A] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 4E301AC1CF9020C7] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 5FBB8DAE3AA786AE] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 7A3F8F553BDB9E0E] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 81A5E89BEDBC89CC] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, 8E3C810099295332] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Public key for ilyag, CCC52A7467A88A7F] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [Puzzle Solved] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [declined: #admin] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest [declined: #approve] #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest hi from E40 #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest https://news.ycombinator.com/item?id=42331270 #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://news.ycombinator.com/item?id=42331270 Guest thank you, banana lounge team! #overheard; #puzzle; #hashtag; #https; #parent; #pubkey; #approve 9038 1a3ec163
promote; report https://github.com/gulkily/thankyou Guest Software Updated to Version aa818e11.. #changelog; #hasvote; #notext; #signed; #hashtag; #https 1 53c9d82a
Cart #
Paste
Clear
Add All
url.sql #
 

SELECT
	'' AS tagset_url,
	value AS url,
	author_key AS author_id,
	item_title,
	labels_list,
	item_flat.item_score AS item_score,
	item_flat.file_hash AS file_hash
FROM
	item_attribute
	LEFT JOIN item_flat ON (item_attribute.file_hash = item_flat.file_hash)
WHERE
	attribute IN('http', 'https') AND
	item_flat.item_score > 0
ORDER BY
	item_score DESC
^
JavaScript #