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

Count #
Items on page: 4
2023-03-03 #
file_hash item_title author_id cart
3984e037 title: CGI Bananas +cart
b12c0df1 Software Updated to Version e9c33aeb.. Guest +cart
7ce18279 1677811897_image Guest +cart
fcf089c3 1677819328_image Guest +cart
title: CGI Bananas #
#client; #cookie; #parent; #received; #title

>>1677819328_image

title: CGI Bananas
--
--
[Received]
[Client]
[Cookie]

; ; 3984e037; like ; +cart
1677811897_image #
#image

1677811897_image

; 7ce18279; like ; +cart
Software Updated to Vers #
#changelog; #hashtag

Software Updated to Version e9c33aeb..

Installed software version has changed from aa818e11.. to e9c33aeb..

e9c33ae comment out problematic debug output

#changelog

; b12c0df1; like ; +cart
1677819328_image #
#like; #image

1677819328_image

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

Cart #
Paste
Clear
Add All
^
JavaScript #
Notice #
This server is set to ASCII mode.
Some characters may not be printed.
Non-ASCII characters removed during page printing: 2