2023-04-29

Count #

Items on page: 48

file_hash	item_title	author_id	cart
2023-04-29 #
`017282d0`	--	Ilya Gulko	+cart
`04cc0b12`	--	Ilya Gulko	+cart
`1279cb8a`	--	Ilya Gulko	+cart
`13ccaeb4`	--	Ilya Gulko	+cart
`18e5bd82`	--	Ilya Gulko	+cart
`18f7b4a8`	--	Ilya Gulko	+cart
`1dd25de2`	--	Ilya Gulko	+cart
`2a4ce459`	--	Ilya Gulko	+cart
`2be56829`	--	Ilya Gulko	+cart
`30abfc6c`	--	Ilya Gulko	+cart
`36ac4188`	--	Ilya Gulko	+cart
`3b4700a2`	--	Ilya Gulko	+cart
`4cd9daf7`	--	Ilya Gulko	+cart
`58ead5a5`	--	Ilya Gulko	+cart
`59f8fbfe`	--	Ilya Gulko	+cart
`5c0705b1`	--	Ilya Gulko	+cart
`6f32dc11`	--	Ilya Gulko	+cart
`6fac4594`	--	Ilya Gulko	+cart
`70e64e43`	--	Ilya Gulko	+cart
`73a1add6`	--	Ilya Gulko	+cart
`750416d2`	--	Ilya Gulko	+cart
`791eef75`	--	Ilya Gulko	+cart
`83ffa47e`	--	Ilya Gulko	+cart
`84577b4a`	--	Ilya Gulko	+cart
`860c92af`	--	Ilya Gulko	+cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>d492f1b8.. #like -- [Client] [Cookie] -- [Received]
Sat, 27 Apr 2024; Ilya Gulko; 017282d0; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>88ca290e.. #like -- [Client] [Cookie] -- [Received]
Sat, 27 Apr 2024; Ilya Gulko; 04cc0b12; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1096210d.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; 1279cb8a; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>5ba17475.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 13ccaeb4; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>86cc7a83.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 18e5bd82; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1d3c7be3.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; 18f7b4a8; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>ae1e51a5.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; 1dd25de2; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>21bd8965.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; 2a4ce459; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>d3ca4a7f.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; 2be56829; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>65d3e515.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; 30abfc6c; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>e4425ed5.. #like -- -- [Received] [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 36ac4188; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>ca878ffa.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; 3b4700a2; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>6235b1e2.. #like -- [Client] [Cookie] -- [Received]
Sat, 27 Apr 2024; Ilya Gulko; 4cd9daf7; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>f1b05621.. #like -- [Client] [Cookie] [Received] --
Sat, 27 Apr 2024; Ilya Gulko; 58ead5a5; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>Picture Perfect #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 59f8fbfe; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>4132aa1a.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 5c0705b1; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>9ff5b1c9.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 6f32dc11; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>77cb6ecc.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; 6fac4594; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>63ac8862.. #like -- [Client] [Cookie] [Received] --
Sat, 27 Apr 2024; Ilya Gulko; 70e64e43; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>3d1ff266.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 73a1add6; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>f0864959.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; 750416d2; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>06903871.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 791eef75; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>0506338e.. #like -- [Client] [Received] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; 83ffa47e; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>5bd2b222.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; 84577b4a; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>c12e69fc.. #like -- [Client] [Cookie] -- [Received]
Sat, 27 Apr 2024; Ilya Gulko; 860c92af; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>6109f3d2.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; 88440535; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>2813ccd6.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; 8d39b456; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>b20b14be.. #like -- -- [Cookie] [Received] [Client]
Sat, 29 Apr 2023; Ilya Gulko; 918a3549; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>13ede5f8.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; 97030460; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1af212b7.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; a4789787; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>2f2dd384.. #flag #remove -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; a9ff90f8; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1756b2d2.. #like -- [Client] [Received] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; acda77cb; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>6d6fbd55.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; b1eb740b; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>14067593.. #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; b2d3776e; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>871809d0.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; b59ea786; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>raccoon eating a #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; be02fa79; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>92796dc7.. #like -- -- [Received] [Client] [Cookie]
Sat, 27 Apr 2024; Ilya Gulko; cddea61e; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>2db9bfb8.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; d0fed79b; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>9e6afa5f.. #like -- [Client] [Cookie] [Received] --
Sat, 27 Apr 2024; Ilya Gulko; d13fc388; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>CGI Bananas #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; d2643566; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>81adf6f4.. #like -- [Received] -- [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; d574f081; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>032a4982.. #like -- [Client] [Cookie] -- [Received]
Sat, 27 Apr 2024; Ilya Gulko; d68c1d94; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>38adf416.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; d9941d6d; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>5e0009b7.. #like -- [Client] [Cookie] -- [Received]
Sat, 27 Apr 2024; Ilya Gulko; e197348a; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>a mouse riding o #like -- -- [Cookie] [Client] [Received]
Sat, 27 Apr 2024; Ilya Gulko; e8306fd4; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>e2b43634.. #like -- -- [Received] [Cookie] [Client]
Sat, 27 Apr 2024; Ilya Gulko; ed7b0f56; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>0be2bdc3.. #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; f0b60b22; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>new shirts! #like -- [Received] [Client] [Cookie] --
Sat, 27 Apr 2024; Ilya Gulko; fe4978b1; 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) = '2023-04-29'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2023-04-29'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2023-04-29'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2023-04-29'
					)
				);

Cart #

Paste

Clear
Add All

Read ; Write ; Upload ; Image(299) ; People(21) ; Threads(48) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum