2023-08-12

Count

Items on page: 56

file_hash	item_title	author_id	cart
2023-08-12
`4be0bee4`	when an item is added to the sqlite db, it should be added back	ilyag+[^%;]	+cart
`b0678f2c`	how do i message?	Guest+[#[$]	+cart
`9a457e25`	when an item is added to the sqlite db, it should be added back	ilyag+[^%;]	+cart
`48f30a83`	[declined: #admin]	ilyag+[^%;]	+cart
`b25b2e2c`	i test message	Guest+[,#(]	+cart
`c8c599e2`	testing localhost to website	ilyag+[$#:]	+cart
`78b7d71a`	i test message	Guest+[,#(]	+cart
`783c6155`	#flag	Guest+[.!']	+cart
`a946405a`	[Puzzle Solved]	ilyag+[^%;]	+cart
`008d846a`	#like	Guest+[#[$]	+cart
`93e8dfb4`	[declined: #admin]	ilyag+[^%;]	+cart
`b9d48972`	#like	Guest+[#[$]	+cart
`307d1e46`	test message	Guest+[#[$]	+cart
`21fdfa0d`	#flag	Guest+[#[$]	+cart
`e6e8a8bc`	testing localhost to website	ilyag+[$#:]	+cart
`c77cd164`	testing localhost to website	ilyag+[$#:]	+cart
`e0fdcd15`	[declined: #admin]	ilyag+[^%;]	+cart
`133beaf6`	[declined: #admin]	ilyag+[^%;]	+cart
`8340a4e4`	testing localhost to website	ilyag+[$#:]	+cart
`8da7f262`	[declined: #admin]	ilyag+[^%;]	+cart
`9f55c7f2`	[Puzzle Solved]	ilyag+[^%;]	+cart
`83301ab2`	testing	ilyag+[^%;]	+cart
`da7df3b5`	#like	Guest+[#[$]	+cart
`07fe07e2`	when an item is added to the sqlite db, it should be added back	ilyag+[^%;]	+cart
`ea2f1ed7`	test message	Guest+[#[$]	+cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>561f7cd1.. #like
Sat, 12 Aug 2023; Guest+[#[$]; 008d846a; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; 07fe07e2; thanks ; +cart

#declined; #notext; #signed; #hashtag; #parent
[declined: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; 133beaf6; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>60ed3e52.. #flag
Sat, 12 Aug 2023; Guest+[.!']; 143a8b28; thanks ; +cart

#hastext; #hastitle; #signed; #parent
test message
>>755980e8.. test message
Sat, 12 Aug 2023; Guest+[#[$]; 156b1041; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>7346544d.. #flag
Sat, 12 Aug 2023; Guest+[#[$]; 21fdfa0d; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; 279db0c7; thanks ; +cart

#hastext; #hastitle; #signed
how do i message?
how do i message?
Sat, 12 Aug 2023; Guest+[#[$]; 2efd336a; thanks ; +cart

#hastext; #hastitle; #signed; #parent
test message
>>755980e8.. test message
Sat, 12 Aug 2023; Guest+[#[$]; 307d1e46; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>60ed3e52.. #flag
Sat, 12 Aug 2023; Guest+[.!']; 341657fa; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i test message
>>755980e8.. i test message
Sat, 12 Aug 2023; Guest+[,#(]; 348cd3b2; thanks ; +cart

#declined; #notext; #signed; #hashtag; #parent
[declined: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; 48f30a83; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; 4be0bee4; thanks ; +cart

#hastag; #notext; #signed; #hashtag; #parent
[applied: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; 560275cd; thanks ; +cart

#notext; #signed; #puzzle
[Puzzle Solved]
[Puzzle Solved]
Sat, 12 Aug 2023; ilyag+[^%;]; 59829756; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; 6b6b98de; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>60ed3e52.. #flag
Sat, 12 Aug 2023; Guest+[.!']; 73410c9f; thanks ; +cart

#hastext; #hastitle; #signed
how do i message?
how do i message?
Sat, 12 Aug 2023; Guest+[#[$]; 737ee48e; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>60ed3e52.. #flag
Sat, 12 Aug 2023; Guest+[.!']; 783c6155; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i test message
>>755980e8.. i test message
Sat, 12 Aug 2023; Guest+[,#(]; 78b7d71a; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>561f7cd1.. #like
Sat, 12 Aug 2023; Guest+[#[$]; 82678326; thanks ; +cart

#hastext; #hastitle; #signed
testing
testing
Sat, 12 Aug 2023; ilyag+[^%;]; 83301ab2; thanks ; +cart

#hastext; #hastitle; #signed; #parent
testing localhost to web
>>Public Key for i testing localhost to website
Sat, 12 Aug 2023; ilyag+[$#:]; 8340a4e4; thanks ; +cart

#declined; #notext; #signed; #hashtag; #parent
[declined: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; 8da7f262; thanks ; +cart

#declined; #notext; #signed; #hashtag; #parent
[declined: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; 93e8dfb4; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; 9a457e25; thanks ; +cart

#notext; #signed; #puzzle
[Puzzle Solved]
[Puzzle Solved]
Sat, 12 Aug 2023; ilyag+[^%;]; 9f55c7f2; thanks ; +cart

#hastag; #notext; #signed; #hashtag; #parent
[applied: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; a386011d; thanks ; +cart

#hastext; #hastitle; #signed; #parent
testing localhost to web
>>Public Key for i testing localhost to website
Sat, 12 Aug 2023; ilyag+[$#:]; a52541f4; thanks ; +cart

#hastext; #hastitle; #signed; #parent
testing localhost to web
>>Public Key for i testing localhost to website
Sat, 12 Aug 2023; ilyag+[$#:]; a5c36fde; thanks ; +cart

#notext; #signed; #puzzle
[Puzzle Solved]
[Puzzle Solved]
Sat, 12 Aug 2023; ilyag+[^%;]; a946405a; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>60ed3e52.. #flag
Sat, 12 Aug 2023; Guest+[.!']; a9a25b51; thanks ; +cart

#hastext; #hastitle; #signed; #parent
test message
>>755980e8.. test message
Sat, 12 Aug 2023; Guest+[#[$]; abba4a47; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>561f7cd1.. #like
Sat, 12 Aug 2023; Guest+[#[$]; ac72ef9d; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>7346544d.. #flag
Sat, 12 Aug 2023; Guest+[#[$]; ae4638c0; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i test message
>>755980e8.. i test message
Sat, 12 Aug 2023; Guest+[,#(]; aed18c9c; thanks ; +cart

#hastext; #hastitle; #signed
how do i message?
how do i message?
Sat, 12 Aug 2023; Guest+[#[$]; b0678f2c; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i test message
>>755980e8.. i test message
Sat, 12 Aug 2023; Guest+[,#(]; b25b2e2c; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i test message
>>755980e8.. i test message
Sat, 12 Aug 2023; Guest+[,#(]; b30cef05; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>561f7cd1.. #like
Sat, 12 Aug 2023; Guest+[#[$]; b9d48972; thanks ; +cart

#hastag; #notext; #signed; #hashtag; #parent
[applied: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; c385fbfa; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; c57a25d6; thanks ; +cart

#hastext; #hastitle; #signed; #parent
testing localhost to web
>>Public Key for i testing localhost to website
Sat, 12 Aug 2023; ilyag+[$#:]; c77cd164; thanks ; +cart

#hastext; #hastitle; #signed; #parent
testing localhost to web
>>Public Key for i testing localhost to website
Sat, 12 Aug 2023; ilyag+[$#:]; c8c599e2; thanks ; +cart

#hastext; #hastitle; #signed; #parent
test message
>>755980e8.. test message
Sat, 12 Aug 2023; Guest+[#[$]; ccb9d7d1; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>Public Key for G #like
Sat, 12 Aug 2023; Guest+[.!']; d8716741; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>561f7cd1.. #like
Sat, 12 Aug 2023; Guest+[#[$]; da7df3b5; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>60ed3e52.. #flag
Sat, 12 Aug 2023; Guest+[.!']; dc439275; thanks ; +cart

#hastag; #notext; #signed; #hashtag; #parent
[applied: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; dc7ade3a; thanks ; +cart

#declined; #notext; #signed; #hashtag; #parent
[declined: #admin]
>>Public Key for i #admin
Sat, 12 Aug 2023; ilyag+[^%;]; e0fdcd15; thanks ; +cart

#hastext; #hastitle; #signed; #parent
testing localhost to web
>>Public Key for i testing localhost to website
Sat, 12 Aug 2023; ilyag+[$#:]; e2317414; thanks ; +cart

#hastext; #hastitle; #signed; #parent
testing localhost to web
>>Public Key for i testing localhost to website
Sat, 12 Aug 2023; ilyag+[$#:]; e6e8a8bc; thanks ; +cart

#hastext; #hastitle; #signed; #parent
test message
>>755980e8.. test message
Sat, 12 Aug 2023; Guest+[#[$]; ea2f1ed7; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#flag
>>d553dd45.. #flag
Sat, 12 Aug 2023; Guest+[.!']; ee90c827; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; efe42994; thanks ; +cart

#hastext; #hastitle; #hasvote; #signed; #todo; #hashtag
when an item is added to
#todo when an item is added to the sqlite db, it should be added back to the "chain"
Sat, 12 Aug 2023; ilyag+[^%;]; fd8debc7; 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-08-12'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2023-08-12'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2023-08-12'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2023-08-12'
					)
				);

Cart

Paste

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