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

Tags

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 = 'received' OR
					label IN (
						SELECT label
						FROM label_parent
						WHERE label_parent = 'received'
				)
			)
			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 17:19:59.

Q: How old was the page when downloaded?
Age: Fresh!
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