2024-01-15

Count

Items on page: 12

file_hash	item_title	author_id	cart
2024-01-15
`f8f33cfe`	title: Relationship affirmations by Ashley Vaughn	ilyag[$,)]	+cart
`80769462`	Software Updated to Version 427695e8..	Guest	+cart
`9a84646f`	title: Relationship affirmations by Ashley Vaughn	ilyag[$,)]	+cart
`03b24260`	title: Relationship affirmations by Ashley Vaughn	ilyag[$,)]	+cart
`7e31cc07`	so i'm going to ensure they're in my calendar and set alarms.	ilyag+[;)[]	+cart
`6987c281`	title: Relationship affirmations by Ashley Vaughn	ilyag[$,)]	+cart
`39b22e63`	#like	ilyag+[;)[]	+cart
`d79fb72b`	#like	ilyag+[;)[]	+cart
`bd7d0b4e`	so i'm going to ensure they're in my calendar and set alarms.	ilyag+[;)[]	+cart
`4a719c58`	#like	ilyag+[;)[]	+cart
`f39860c9`	i went to bed around midnight and slept in until 11, feeling gr	ilyag+[;)[]	+cart
`771e57a2`	title: Relationship affirmations by Ashley Vaughn	ilyag[$,)]	+cart

#hastext; #hastitle; #signed; #parent; #title
title: Relationship affi
>>Relationship aff title: Relationship affirmations by Ashley Vaughn
Mon, 15 Jan 2024; ilyag[$,)]; 03b24260; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>521065c0.. #like
Mon, 15 Jan 2024; ilyag+[;)[]; 39b22e63; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>13a8debd.. #like
Mon, 15 Jan 2024; ilyag+[;)[]; 4a719c58; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: Relationship affi
>>Relationship aff title: Relationship affirmations by Ashley Vaughn
Mon, 15 Jan 2024; ilyag[$,)]; 6987c281; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: Relationship affi
>>Relationship aff title: Relationship affirmations by Ashley Vaughn
Mon, 15 Jan 2024; ilyag[$,)]; 771e57a2; thanks ; +cart

#hastext; #hastitle; #signed; #parent
so i'm going to ensure t
>>f60e3af4.. so i'm going to ensure they're in my calendar and set alarms.
Mon, 15 Jan 2024; ilyag+[;)[]; 7e31cc07; thanks ; +cart

#changelog; #hastext; #hastitle; #hasvote; #hashtag
Software Updated to Vers
Software Updated to Version 427695e8.. Installed software version has changed from 49927507.. to 427695e8.. 427695e8 add comment in hike.sh 9248c51c rebuild.sh: remake new.html page after rebuild. 5da2544d use IsFileAlreadyIndexed() instead of using GetCache() directly ; index.pl, index_file.pl, index_image_file.pl, index_text_file.pl, index_video_file.pl, utils.pl ff81230c improve sanity of IsFileAlreadyIndexed() ; index_file.pl d49a4221 improve comments for GpgParse() ; gpgpg.pl fa1ef045 update todo.txt 112b0226 improve debug output of IsFileAlreadyIndexed() ; index_file.pl 8afef372 update todo.txt d1e87662 add IsFileAlreadyIndexed() ; index_file.pl b9b18296 update todo.txt e1858063 update todo 39ba7dfc add searchable comment in pages.pl 889cccc7 try not doing a full reindex after a changelog, now that we have fixed one bug ; utils.pl 0c80516e improve debug output in utils.pl #changelog
Mon, 15 Jan 2024; 80769462; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: Relationship affi
>>Relationship aff title: Relationship affirmations by Ashley Vaughn
Mon, 15 Jan 2024; ilyag[$,)]; 9a84646f; thanks ; +cart

#hastext; #hastitle; #signed; #parent
so i'm going to ensure t
>>f60e3af4.. so i'm going to ensure they're in my calendar and set alarms.
Mon, 15 Jan 2024; ilyag+[;)[]; bd7d0b4e; thanks ; +cart

#hasvote; #notext; #signed; #hashtag; #parent
#like
>>9b064308.. #like
Mon, 15 Jan 2024; ilyag+[;)[]; d79fb72b; thanks ; +cart

#hastext; #hastitle; #signed; #parent
i went to bed around mid
>>13a8debd.. i went to bed around midnight and slept in until 11, feeling great
Mon, 15 Jan 2024; ilyag+[;)[]; f39860c9; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: Relationship affi
>>Relationship aff title: Relationship affirmations by Ashley Vaughn
Mon, 15 Jan 2024; ilyag[$,)]; 9a84646f; 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) = '2024-01-15'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-01-15'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-01-15'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-01-15'
					)
				);

Cart

Paste

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