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

Count #
Items on page: 4
media_DnUDOEiX4AUevxJ #
#2018; #like; #image

media_DnUDOEiX4AUevxJ

; 38adf416; like(1) ; +cart
media_DnUDOD_XoAUvX #
#2018; #like; #image

media_DnUDOD_XoAUvX15

; 3d1ff266; like(1) ; +cart
media_DnUDOEDXoAAVZkc #
#2018; #like; #image

media_DnUDOEDXoAAVZkc

; 21bd8965; like(1) ; +cart
media_DnUDOEeXoAINXt #
#2018; #like; #image

media_DnUDOEeXoAINXt4

; d3ca4a7f; like(1) ; +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 = '2018' OR
					label IN (
						SELECT label
						FROM label_parent
						WHERE label_parent = '2018'
				)
			)
			AND item_flat.item_score >= 0
			 ORDER BY item_flat.add_timestamp DESC LIMIT 100

Cart #
Paste
Clear
Add All
^
JavaScript #