2023-06-19

Count

Items on page: 53

file_hash	item_title	author_id	cart
2023-06-19
`8f4c3f4d`	title: on the train to brooklyn	Guest[*!,]	+cart
`7b7fd7c1`	title: on the train to brooklyn	Guest[*!,]	+cart
`6ba800f5`	title: on the train to brooklyn	Guest[*!,]	+cart
`0656449a`	title: on the train to brooklyn	Guest[*!,]	+cart
`ee7f13b2`	title: on the train to brooklyn	Guest[*!,]	+cart
`4cc78249`	title: on the train to brooklyn	Guest[*!,]	+cart
`199e55e4`	title: on the train to brooklyn	Guest[*!,]	+cart
`f9734206`	title: on the train to brooklyn	Guest[*!,]	+cart
`08d1f822`	title: on the train to brooklyn	Guest[*!,]	+cart
`086aca12`	title: on the train to brooklyn	Guest[*!,]	+cart
`bd561a92`	title: on the train to brooklyn	Guest[*!,]	+cart
`953d5255`	title: on the train to brooklyn	Guest[*!,]	+cart
`bde2175e`	title: on the train to brooklyn	Guest[*!,]	+cart
`1336f4f5`	title: on the train to brooklyn	Guest[*!,]	+cart
`50531f9b`	title: on the train to brooklyn	Guest[*!,]	+cart
`df6c4723`	title: on the train to brooklyn	Guest[*!,]	+cart
`844a089d`	title: on the train to brooklyn	Guest[*!,]	+cart
`55a2008a`	title: on the train to brooklyn	Guest[*!,]	+cart
`621f46c4`	title: on the train to brooklyn	Guest[*!,]	+cart
`b1426f6f`	title: on the train to brooklyn	Guest[*!,]	+cart
`86458d5e`	title: on the train to brooklyn	Guest[*!,]	+cart
`237b498f`	title: on the train to brooklyn	Guest[*!,]	+cart
`0b38bbbc`	title: on the train to brooklyn	Guest[*!,]	+cart
`7804c44a`	title: on the train to brooklyn	Guest[*!,]	+cart
`673a2e86`	title: on the train to brooklyn	Guest[*!,]	+cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 0173c592; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 05367c12; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 0656449a; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 086aca12; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 08d1f822; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 09c6b439; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 0b38bbbc; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 0c20fefc; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 0ee736f4; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 1336f4f5; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 15ea7a2d; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 199e55e4; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 1cbe807d; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 1ef93b3a; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 237b498f; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 27010017; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 41c98f05; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 46e5db61; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 4cc78249; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 50531f9b; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 55a2008a; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 621f46c4; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 673a2e86; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 69d125f6; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 6ba800f5; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 6fc36a5c; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 76b9dc37; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 7804c44a; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 7b7fd7c1; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 7e6a5e22; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 81fd938f; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 844a089d; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 86458d5e; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 8742cbec; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 8f4c3f4d; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 8f8c9cfe; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 8ffc5535; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 90a0adaf; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 953d5255; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; 95d35d1e; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; a68a2393; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; ab99571d; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; b1426f6f; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; ba5106fd; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; ba9c7992; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; bd561a92; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; bde2175e; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; c38c0979; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; ca728773; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; df6c4723; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; ee7f13b2; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; f9734206; thanks ; +cart

#hastext; #hastitle; #signed; #parent; #title
title: on the train to b
>>on the train to title: on the train to brooklyn
Mon, 19 Jun 2023; Guest[*!,]; fae65e0d; 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-06-19'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2023-06-19'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2023-06-19'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2023-06-19'
					)
				);

Cart

Paste

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