desktop

label	label_count
Tags #
#client	295
#received	295
#cookie	282
#image	275
#parent	266
#hashtag	185
#like	74
#pubkey	71
#1661863245	63
#boxes	24

item_title	tagset_threads	cart	child_count	item_score	file_hash	add_timestamp
Threads #
hey this is a test, please ignore	bump; flag	+cart	3	2	`59443e6b`	Sun, 04 May 2025
hi from sipb office!	bump; flag	+cart	2	2	`9b710283`	Mon, 28 Apr 2025
iwatch has self-identified	bump; flag	+cart	1	1	`50f85cf7`	Wed, 19 Mar 2025
Hi from Apple watch	bump; flag	+cart	2	2	`529cbaf0`	Sun, 16 Mar 2025
pi day celebration!	bump; flag	+cart	1	-	`041c20e9`	Fri, 14 Mar 2025
hey	bump; flag	+cart	1	1	`58e95028`	Fri, 07 Mar 2025
IMG_	bump; flag	+cart	2	1	`4c3c96b9`	Thu, 26 Dec 2024
1732654326_image	bump; flag	+cart	2	-	`ba730dc3`	Tue, 26 Nov 2024
ChiquitaScandinavia	bump; flag	+cart	1	-	`f4876a77`	Sun, 28 Jul 2024
1717634910_image	bump; flag	+cart	1	-	`1ad2018f`	Wed, 05 Jun 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	cart	author_alias	author_seen	item_count	author_score	tagset_author	file_hash
Authors #
`16CDF62B2EC76539`	ilyag	+cart	ilyag	06/01	2	1	approve; flag	`20c1c1f2`
`363345268330364D`	ilyag	+cart	ilyag	06/01	1	1	approve; flag	`db00c73f`
`8E3C810099295332`	Guest	-	-	05/22	3	1	-	-
`A97D6E71F4D0FE5D`	thaomazein	+cart	thaomazein	05/20	1	11	approve(1); flag	`1b623a59`
`191182F0F8D59ABE`	ac	+cart	ac	Fri, 09 May 2025	2	11	approve(1); flag	`591891a9`
`3A299E89ABA55DE4`	Guest	-	-	Wed, 07 May 2025	1	-	-	-
`F1513F1C2979C34D`	ilyag	+cart	ilyag	Sun, 04 May 2025	5	3	approve; flag	`52a51ae2`
`041487CD1FE63F8B`	ilyag	+cart	ilyag	Sun, 04 May 2025	4	1	approve; flag	`3118c90a`
`60C5C79D4B85467A`	Guest	+cart	Guest	Wed, 30 Apr 2025	1	1	approve; flag	`980a45e0`
`4E32BF984550144A`	Guest	+cart	Guest	Wed, 30 Apr 2025	2	1	approve; flag	`97d39acf`

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`