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

Tags

#notable

Archive
notable.zip
Count
Items on page: 3
-----BEGIN PGP SIGNED ME
#hastext; #hastitle; #hasvote; #notable; #client; #hashtag; #received


; 2d950b8e; thanks ; +cart
-----BEGIN PGP SIGNED ME
#hastext; #hastitle; #hasvote; #notable; #client; #hashtag; #received


; 77b1e416; thanks ; +cart
-----BEGIN PGP SIGNED ME
#hastext; #hastitle; #hasvote; #notable; #client; #hashtag; #received


; fa273fd5; thanks ; +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
			item_flat.file_hash IN (
				SELECT
					file_hash
				FROM
					item_label
				WHERE
					label = 'notable' OR
					label IN (
						SELECT label
						FROM label_parent
						WHERE label_parent = 'notable'
				)
			)
			AND item_flat.item_score >= 0
			 ORDER BY item_flat.add_timestamp DESC LIMIT 100

Cart
Paste
Clear
Add All
PrintedInfo

Q: When was this page printed?
Printed: December 23 2024 11:28:11.

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