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

Tags

Tag Information
Public keys shared with the server.
Archive
This tag has no items yet,
so no archive is available.
No items found.
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 = 'pubkey' OR
					label IN (
						SELECT label
						FROM label_parent
						WHERE label_parent = 'pubkey'
				)
			)
			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: November 23 2024 20:34:28.

Q: How old was the page when downloaded?
Age: 1211 seconds
pollyanna: 3d5171f

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