2023-03-09

Count

Items on page: 3

file_hash	item_title	author_id	cart
2023-03-09
`907dd877`	Maddie Lam	Guest+[;'']	+cart
`82ac23db`	Maddie Lam	Guest+[;'']	+cart
`e009c6a3`	Maddie Lam	Guest+[;'']	+cart

#hastext; #hastitle; #signed
Maddie Lam
Maddie Lam hi friends. maddie here. update: my next single release violet sky will be released on april 1st, not march 20th. i am learning how to take my time and not rush my artistic process. i needed more time to sit with this song, to offer it to the sky and mother earth first, to share it with my safe loved ones, to take time with my cover art, and not buy into the capitalistic hustle we artists feel. i want to honor my timeline, to honor the seasons changing with this song. i want to invite you to listen when my heart feels soft and open, and she is opening. my songs are the most intimate thing you can know, because they come from the deepest part of me. you get to feel my center, and that is everything. thank you for your tenderness with me. this song is special to me. thank you for your patience. thank you for your kindness. i love you, maddie
Thu, 09 Mar 2023; Guest+[;'']; 82ac23db; thanks ; +cart

#hastext; #hastitle; #signed
Maddie Lam
Maddie Lam hi friends. maddie here. update: my next single release violet sky will be released on april 1st, not march 20th. i am learning how to take my time and not rush my artistic process. i needed more time to sit with this song, to offer it to the sky and mother earth first, to share it with my safe loved ones, to take time with my cover art, and not buy into the capitalistic hustle we artists feel. i want to honor my timeline, to honor the seasons changing with this song. i want to invite you to listen when my heart feels soft and open, and she is opening. my songs are the most intimate thing you can know, because they come from the deepest part of me. you get to feel my center, and that is everything. thank you for your tenderness with me. this song is special to me. thank you for your patience. thank you for your kindness. i love you, maddie
Thu, 09 Mar 2023; Guest+[;'']; 907dd877; thanks ; +cart

#hastext; #hastitle; #signed
Maddie Lam
Maddie Lam hi friends. maddie here. update: my next single release violet sky will be released on april 1st, not march 20th. i am learning how to take my time and not rush my artistic process. i needed more time to sit with this song, to offer it to the sky and mother earth first, to share it with my safe loved ones, to take time with my cover art, and not buy into the capitalistic hustle we artists feel. i want to honor my timeline, to honor the seasons changing with this song. i want to invite you to listen when my heart feels soft and open, and she is opening. my songs are the most intimate thing you can know, because they come from the deepest part of me. you get to feel my center, and that is everything. thank you for your tenderness with me. this song is special to me. thank you for your patience. thank you for your kindness. i love you, maddie
Thu, 09 Mar 2023; Guest+[;'']; e009c6a3; 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-03-09'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2023-03-09'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2023-03-09'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2023-03-09'
					)
				);

Cart

Paste

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