desktop

label	label_count
Tags #
#client	285
#received	285
#cookie	272
#image	254
#parent	239
#hashtag	157
#like	65
#1661863245	63
#boxes	24
#pubkey	23

item_title	tagset_threads	cart	child_count	item_score	file_hash	add_timestamp
Threads #
1717634910_image	bump; flag	+cart	1	-	`1ad2018f`	Thu, 06 Jun 2024
8D71BEB0-A606-4578-BF01-524BAECDE2AA	bump; flag	+cart	1	-	`bdf69b8c`	Tue, 28 May 2024
IMG_	bump; flag	+cart	1	-	`ae69b08e`	Tue, 21 May 2024
20645F66-1622-4ACF-91F7-E306F0A9914E	bump; flag	+cart	1	-	`feae88d0`	Mon, 13 May 2024
27812C8E-EF86-483B-B411-C8834284325D	bump; flag	+cart	2	-	`42b7876f`	Fri, 10 May 2024
88ABB0DE-B3F2-48BB-B2AC-8533852074D	bump; flag	+cart	1	-	`a35975eb`	Wed, 08 May 2024
E9FC77CA-2FFC-4997-922E-82AC86E50F	bump; flag	+cart	1	-	`4e34c1b4`	Wed, 08 May 2024
D710C1E3-71D3-435D-AE10-4D907998791E	bump; flag	+cart	1	-	`3415d59b`	Tue, 07 May 2024
hyy8tmhdwl5z	bump; flag	+cart	1	1	`b538f23e`	Sat, 02 Mar 2024
424965831_7085100014891870_6023132334185737794_n	bump; flag	+cart	1	-	`13ea8098`	Sat, 24 Feb 2024

New #

This space reserved for future content...

Query took 0.00031415952 second(s):



SELECT
	file_hash,
	item_title,
	'' AS cart,
	item_type,
	child_count,
	add_timestamp,
	labels_list,
	'' AS tagset_all
FROM
	item_flat
WHERE
	item_score >= 0 AND
	add_timestamp >= strftime('%s', 'now', '-3 day') AND
	labels_list NOT LIKE '%,notext,%'
ORDER BY
	add_timestamp DESC
 LIMIT 10

author_key	author_id	author_alias	author_seen	item_count	author_score	tagset_author	file_hash
Authors #
`5FBB8DAE3AA786AE`	ilyag	ilyag	10/21	1	1	approve; flag	`b0d76a5a`
`6E0EA864782E7D5C`	Guest	Guest	10/21	1	1	approve; flag	`0aa5f9a4`
`8E3C810099295332`	ilyag	ilyag	10/21	1	11	approve(1); flag	`1249bcb5`
`D49F40AE716496FC`	Guest	Guest	10/21	1	1	approve; flag	`222e19b9`
`F8DA7DA3F2B77A42`	Guest	Guest	10/21	1	1	approve; flag	`70e36a82`
`F65605370AFD7AF3`	Guest	Guest	10/12	1	1	approve; flag	`a2d67f53`
`1F32D46389C9DDAA`	Guest	Guest	10/12	2	1	approve; flag	`8bb5d7fb`
`FD45C586E8EF7F0C`	Guest	Guest	10/09	1	1	approve; flag	`5fbcfca4`
`C98348E0933ABA2C`	Guest	Guest	10/09	1	1	approve; flag	`32fc7e6e`
`C1D5685BA5FBF0B9`	Guest	Guest	10/09	1	1	approve; flag	`8e9a2c6c`

tagset_url	url	author_id	item_title	labels_list	item_score	file_hash
Links #
promote; report	https://github.com/gulkily/thankyou	Guest	Software Updated to Version aa818e11..	#changelog; #hasvote; #notext; #signed; #hashtag; #https	1	`53c9d82a`