desktop

label	label_count
Tags #
#client	285
#received	285
#cookie	272
#image	260
#parent	242
#hashtag	161
#like	68
#1661863245	63
#pubkey	28
#boxes	24

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 #
`0BBA1D304234D6EF`	Lighthouse prompt respon	Lighthouse prompt response	01/19	1	1	approve; flag	`6fcad4cf`
`E423F71B5077083D`	Lighthouse prompt respon	Lighthouse prompt response	01/19	1	11	approve(1); flag	`f4177bac`
`2F2861BC9AB887DC`	ilyag	ilyag	01/13	1	1	approve; flag	`b4451da0`
`7D5EB94D7242D701`	Guest	Guest	Sat, 21 Dec 2024	1	1	approve; flag	`5c67984a`
`4E301AC1CF9020C7`	ilyag	ilyag	Fri, 06 Dec 2024	5	1	approve; flag	`94b6059f`
`6E0EA864782E7D5C`	Guest	Guest	Tue, 19 Nov 2024	4	1	approve; flag	`0aa5f9a4`
`5FBB8DAE3AA786AE`	ilyag	ilyag	Mon, 21 Oct 2024	1	1	approve; flag	`b0d76a5a`
`8E3C810099295332`	ilyag	ilyag	Mon, 21 Oct 2024	1	11	approve(1); flag	`1249bcb5`
`D49F40AE716496FC`	Guest	Guest	Mon, 21 Oct 2024	1	1	approve; flag	`222e19b9`
`F8DA7DA3F2B77A42`	Guest	Guest	Mon, 21 Oct 2024	1	1	approve; flag	`70e36a82`

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`