Read ; Write ; Upload ; Image(296) ; People(18) ; Threads(40) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum

Count #
Items on page: 5
2022-01-30 #
file_hash item_title author_id cart
3428456a #like Guest +cart
a6f091a2 #like Guest +cart
adb89279 #flag Guest +cart
dddf56d6 #jan26 #jan26 #jan26 #jan applied to 7 items Ilya G +cart
e2006cf4 #like Guest +cart
#like #
#cookie; #hashtag; #parent

>>d9968209..

#like
--
[Cookie]

; Guest; 3428456a; like ; +cart
#like #
#cookie; #hashtag; #parent

>>414e05f7..

#like
--
[Cookie]

; Guest; a6f091a2; like ; +cart
#flag #
#cookie; #hashtag; #parent

>>d9968209..

#flag
--
[Cookie]

; Guest; adb89279; like ; +cart
#jan26 #jan26 #jan26 #ja #
#hashtag; #parent

>>8ae9a895..
>>1096210d..
>>92796dc7..
>>ae1e51a5..
>>740980f0..
>>2db9bfb8..
>>9e6afa5f..

#jan26 #dorms

; Ilya G; dddf56d6; like ; +cart
#like #
#cookie; #hashtag; #parent

>>Exemplary Banana

#like
--
[Cookie]

; Guest; e2006cf4; 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
			file_hash IN (
				SELECT file_hash
				FROM item_flat
				WHERE
					item_score >= 0 AND
					(
						SUBSTR(DATETIME(add_timestamp, 'unixepoch', 'localtime'), 0, 11) = '2022-01-30'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-01-30'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-01-30'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-01-30'
					)
				);
			

Cart #
Paste
Clear
Add All
^
JavaScript #