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

Count #
Items on page: 5
2024-12-05 #
file_hash item_title author_id cart
11dd55d5 #like ilyag +cart
12b43c68 https://news.ycombinator.com/item?id=42331270 ilyag +cart
94b6059f [Public key for ilyag, 4E301AC1CF9020C7] ilyag +cart
b9efd22a #like ilyag +cart
bfb21dc8 #like ilyag +cart
#like #
#hashtag; #parent

>>272149642_309790
#like

; ilyag; 11dd55d5; like ; +cart
https://news.ycombinator #
#https

[https]

; ilyag; 12b43c68; like ; +cart
[Public key for ilyag, 4 #
#pubkey

[This item is a public key.]

no timestamp; ilyag; 5aa7b05e; like ; +cart
#like #
#hashtag; #parent

>>272148517_460335
#like

; ilyag; b9efd22a; like ; +cart
#like #
#hashtag; #parent

>>272021601_439726
#like

; ilyag; bfb21dc8; like ; +cart
query.sql #


		SELECT
			item_flat.file_path file_path,
			item_flat.item_name item_name,
			item_flat.file_hash file_hash,
			item_flat.author_key author_key,
			item_flat.child_count child_count,
			item_flat.parent_count parent_count,
			item_flat.add_timestamp add_timestamp,
			item_flat.item_title item_title,
			item_flat.item_score item_score,
			item_flat.labels_list labels_list,
			item_flat.item_type item_type,
			item_flat.item_order item_order,
			item_flat.item_sequence item_sequence
		FROM
			item_flat
	 
		WHERE
			file_hash IN (
				SELECT file_hash
				FROM item_flat
				WHERE
					item_score >= 0 AND
					(
						SUBSTR(DATETIME(add_timestamp, 'unixepoch', 'localtime'), 0, 11) = '2024-12-05'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-12-05'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-12-05'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-12-05'
					)
				);
			

Cart #
Paste
Clear
Add All
PrintedInfo #

Q: When was this page printed?
Printed: April 03 2025 14:53:07.

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

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

^
JavaScript #