2023-04-29

Count #

Items on page: 48

file_hash	item_title	author_id	cart
2023-04-29 #
`2a4ce459`	--	Ilya Gulko	+cart
`791eef75`	--	Ilya Gulko	+cart
`b2d3776e`	--	Ilya Gulko	+cart
`f0b60b22`	--	Ilya Gulko	+cart
`04cc0b12`	--	Ilya Gulko	+cart
`3b4700a2`	--	Ilya Gulko	+cart
`017282d0`	--	Ilya Gulko	+cart
`d13fc388`	--	Ilya Gulko	+cart
`860c92af`	--	Ilya Gulko	+cart
`cddea61e`	--	Ilya Gulko	+cart
`918a3549`	--	Ilya Gulko	+cart
`750416d2`	--	Ilya Gulko	+cart
`1279cb8a`	--	Ilya Gulko	+cart
`73a1add6`	--	Ilya Gulko	+cart
`b59ea786`	--	Ilya Gulko	+cart
`83ffa47e`	--	Ilya Gulko	+cart
`d68c1d94`	--	Ilya Gulko	+cart
`fe4978b1`	--	Ilya Gulko	+cart
`e197348a`	--	Ilya Gulko	+cart
`e8306fd4`	--	Ilya Gulko	+cart
`84577b4a`	--	Ilya Gulko	+cart
`4cd9daf7`	--	Ilya Gulko	+cart
`a9ff90f8`	--	Ilya Gulko	+cart
`be02fa79`	--	Ilya Gulko	+cart
`d0fed79b`	--	Ilya Gulko	+cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1681437697_image #like -- [Client] [Cookie] -- [Received]
Sun, 28 Apr 2024; Ilya Gulko; 017282d0; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>BLoOpening #like -- [Client] [Cookie] -- [Received]
Sun, 28 Apr 2024; Ilya Gulko; 04cc0b12; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>272021601_439726 #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; 1279cb8a; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221028_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 13ccaeb4; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>2022-11-23_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 18e5bd82; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1680389092_image #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; 18f7b4a8; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_ #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; 1dd25de2; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>media_DnUDOEDXoA #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; 2a4ce459; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>media_DnUDOEeXoA #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; 2be56829; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>20211223_ #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; 30abfc6c; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20230323_ #like -- -- [Received] [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 36ac4188; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20230310_ #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; 3b4700a2; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1678376751_image #like -- [Client] [Cookie] -- [Received]
Sun, 28 Apr 2024; Ilya Gulko; 4cd9daf7; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221016_ #like -- [Client] [Cookie] [Received] --
Sun, 28 Apr 2024; Ilya Gulko; 58ead5a5; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>CC15AD14-80BC-41 #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 59f8fbfe; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221016_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 5c0705b1; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>20211227_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 6f32dc11; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>20211223_ #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; 6fac4594; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1680389075_image #like -- [Client] [Cookie] [Received] --
Sun, 28 Apr 2024; Ilya Gulko; 70e64e43; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>media_DnUDOD_XoA #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 73a1add6; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221023_ #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; 750416d2; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221016_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 791eef75; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1680049097_image #like -- [Client] [Received] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; 83ffa47e; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1679373881_image #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; 84577b4a; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221016_ #like -- [Client] [Cookie] -- [Received]
Sun, 28 Apr 2024; Ilya Gulko; 860c92af; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>20211223_ #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; 88440535; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221028_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; 8d39b456; like ; +cart

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

#client; #cookie; #hashtag; #parent; #received
-- #
>>1665570398_image #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; 97030460; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20230310_150 #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; a4789787; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>photo_2022-11-13 #flag #remove -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; a9ff90f8; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1680389083_image #like -- [Client] [Received] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; acda77cb; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221028_ #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; b1eb740b; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>2022-07-14_ #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; b2d3776e; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221020_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; b59ea786; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>th #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; be02fa79; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>272148517_460335 #like -- -- [Received] [Client] [Cookie]
Sun, 28 Apr 2024; Ilya Gulko; cddea61e; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_ #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; d0fed79b; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_ #like -- [Client] [Cookie] [Received] --
Sun, 28 Apr 2024; Ilya Gulko; d13fc388; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1677819328_image #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; d2643566; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20230310_ #like -- [Received] -- [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; d574f081; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221016_ #like -- [Client] [Cookie] -- [Received]
Sun, 28 Apr 2024; Ilya Gulko; d68c1d94; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>media_DnUDOEiX4A #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; d9941d6d; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_20221021_ #like -- [Client] [Cookie] -- [Received]
Sun, 28 Apr 2024; Ilya Gulko; e197348a; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1666272635_image #like -- -- [Cookie] [Client] [Received]
Sun, 28 Apr 2024; Ilya Gulko; e8306fd4; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>IMG_ #like -- -- [Received] [Cookie] [Client]
Sun, 28 Apr 2024; Ilya Gulko; ed7b0f56; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>1679616938_image #like -- [Received] [Client] [Cookie] --
Sun, 28 Apr 2024; Ilya Gulko; f0b60b22; like ; +cart

#client; #cookie; #hashtag; #parent; #received
-- #
>>the_banana_gang #like -- [Received] [Client] [Cookie] --
Sun, 28 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(258) ; Threads(139) ; Settings ; Profile ; Boxes ; Help
Banana Lounge Unofficial Fan Forum