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

Tags

#22Oct16 #HACKBOSTON #HI #OutOfContext #PersonalOpinion #scunthorpe

Tag Information #
Items which may contain cusswords get the #scunthorpe tag. If you are wondering why, look it up.
Count #
Items on page: 1
[Public key for poop, F7 #
#scunthorpe; #pubkey; #approve

[This item is a public key.]

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

Cart #
Paste
Clear
Add All
^
JavaScript #