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

Tags

Tag Information
Items without text get the #notext tag. Examples are items which only contain votes, hashtags, or other tokens.
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 = 'notext' OR
					label IN (
						SELECT label
						FROM label_parent
						WHERE label_parent = 'notext'
				)
			)
			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 24 2024 19:24:45.

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