2023-05-20

Count

Items on page: 44

file_hash	item_title	author_id	cart
2023-05-20
`73407a2c`	#like	Guest+[(##]	+cart
`7f7c7f99`	i write something.	Guest+[%*&]	+cart
`4c850920`	#like	Guest+[([^]	+cart
`544895b7`	#like	Guest+[%*&]	+cart
`295f1696`	i write something else...	Guest+[%*&]	+cart
`f9fda23d`	#like	Guest+[(##]	+cart
`3d495076`	i reply	Guest+[([^]	+cart
`195c16f2`	#like	Guest+[:*!]	+cart
`9e782d61`	i reply to my post please	Guest+[(##]	+cart
`ce1eedb1`	chrome has self-identified	chrome+[*!,]	+cart
`ac827dc6`	#like	Guest+[([^]	+cart
`b5c9a3b2`	i write something.	chrome+[*!,]	+cart
`f7d864b3`	#like	Guest+[%*&]	+cart
`f2e2e4cf`	i write something.	Guest+[:*!]	+cart
`e5fec538`	i write something else...	Guest+[%*&]	+cart
`b740360c`	i reply?	chrome+[*!,]	+cart
`21adabaf`	#like	chrome+[*!,]	+cart
`ebecf0cb`	this is my profile on hypercode	Guest+[(##]	+cart
`b5e12a60`	i just made a profile,	Guest+[([^]	+cart
`7e14354c`	i reply	Guest+[:*!]	+cart
`b0a15064`	#like	Guest+[%*&]	+cart
`9fb5ec91`	#like	Guest+[:*!]	+cart
`37e8ecde`	i reply to my post please	Guest+[(##]	+cart
`ca8f5cbc`	i reply?	chrome+[*!,]	+cart
`8757ce7f`	#like	Guest+[(##]	+cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>146b3dd9.. #like
Sat, 20 May 2023; Guest+[:*!]; 195c16f2; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>d1a0b675.. #like
Sat, 20 May 2023; chrome+[*!,]; 21adabaf; thanks ; +cart

#hastext; #hastitle; #signed
i write something else..
i write something else... i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; Guest+[%*&]; 295f1696; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; chrome+[*!,]; 30e47eff; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>683a25ab.. #like
Sat, 20 May 2023; Guest+[%*&]; 33b069ca; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply to my post pleas
>>30969c7f.. i reply to my post please
Sat, 20 May 2023; Guest+[(##]; 37e8ecde; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; Guest+[:*!]; 38d43d46; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply
>>ccd95477.. i reply
Sat, 20 May 2023; Guest+[([^]; 3d495076; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>46bd5b68.. #like
Sat, 20 May 2023; Guest+[(##]; 3ee37d00; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply
>>ccd95477.. i reply
Sat, 20 May 2023; Guest+[([^]; 3fd4eb53; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply?
>>d1a0b675.. i reply?
Sat, 20 May 2023; chrome+[*!,]; 42a26bbe; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply
>>163f0a20.. i reply
Sat, 20 May 2023; Guest+[:*!]; 44084473; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply?
>>d1a0b675.. i reply?
Sat, 20 May 2023; chrome+[*!,]; 47c3684d; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>ccd95477.. #like
Sat, 20 May 2023; Guest+[([^]; 4c850920; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>12b8df43.. #like
Sat, 20 May 2023; Guest+[%*&]; 51ef3318; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>683a25ab.. #like
Sat, 20 May 2023; Guest+[%*&]; 544895b7; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply?
>>d1a0b675.. i reply?
Sat, 20 May 2023; chrome+[*!,]; 597bb884; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>46bd5b68.. #like
Sat, 20 May 2023; Guest+[(##]; 73407a2c; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>ccd95477.. #like
Sat, 20 May 2023; Guest+[([^]; 76778bb9; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply
>>163f0a20.. i reply
Sat, 20 May 2023; Guest+[:*!]; 7e14354c; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; Guest+[%*&]; 7f7c7f99; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; chrome+[*!,]; 81b06106; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>46bd5b68.. #like
Sat, 20 May 2023; Guest+[(##]; 8757ce7f; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; Guest+[%*&]; 9d25af94; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply to my post pleas
>>30969c7f.. i reply to my post please
Sat, 20 May 2023; Guest+[(##]; 9e782d61; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>163f0a20.. #like
Sat, 20 May 2023; Guest+[:*!]; 9fb5ec91; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>5e58c325.. #like
Sat, 20 May 2023; Guest+[([^]; ac827dc6; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>12b8df43.. #like
Sat, 20 May 2023; Guest+[%*&]; b0a15064; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>46bd5b68.. #like
Sat, 20 May 2023; Guest+[(##]; b37e6824; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; chrome+[*!,]; b5c9a3b2; thanks ; +cart

#hastext; #hastitle; #signed
i just made a profile,
i just made a profile, now i write something
Sat, 20 May 2023; Guest+[([^]; b5e12a60; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply?
>>d1a0b675.. i reply?
Sat, 20 May 2023; chrome+[*!,]; b740360c; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply?
>>d1a0b675.. i reply?
Sat, 20 May 2023; chrome+[*!,]; ca8f5cbc; thanks ; +cart

#notext; #signed; #my_name_is
chrome has self-identifi
[MyNameIs]
Sat, 20 May 2023; chrome+[*!,]; ce1eedb1; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; Guest+[:*!]; cfbb5204; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>146b3dd9.. #like
Sat, 20 May 2023; Guest+[:*!]; dd22f57e; thanks ; +cart

#hastext; #hastitle; #signed
i write something else..
i write something else... i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; Guest+[%*&]; e5fec538; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply?
>>d1a0b675.. i reply?
Sat, 20 May 2023; chrome+[*!,]; e69a1484; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i reply to my post pleas
>>30969c7f.. i reply to my post please
Sat, 20 May 2023; Guest+[(##]; eb58ce95; thanks ; +cart

#hastext; #hastitle; #signed
this is my profile on hy
this is my profile on hypercode
Sat, 20 May 2023; Guest+[(##]; ebecf0cb; thanks ; +cart

#hastext; #hastitle; #signed
i write something.
i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something. i write something.
Sat, 20 May 2023; Guest+[:*!]; f2e2e4cf; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>683a25ab.. #like
Sat, 20 May 2023; Guest+[%*&]; f7d864b3; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>30969c7f.. #like
Sat, 20 May 2023; Guest+[(##]; f9fda23d; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>30969c7f.. #like
Sat, 20 May 2023; Guest+[(##]; fe6d0fe4; thanks ; +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-05-20'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2023-05-20'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2023-05-20'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2023-05-20'
					)
				);

Cart

Paste

Welcome ; Threads(18) ; Random ; Menu ; Help
let us not grow weary of doing good	Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset