desktop

label	label_count
Tags #
#parent	1243
#hashtag	1034
#cookie	450
#image	299
#client	298
#received	298
#pubkey	144
#https	44
#changelog	36
#title	35

item_title	tagset_threads	cart	child_count	item_score	file_hash	add_timestamp
Threads #
IMG_	bump; flag	+cart	1	1	`56ef28fe`	Sun, 02 Nov 2025
Thank you for supplying this code monkey with bananas	bump; flag	+cart	2	1	`7b17570c`	Mon, 06 Oct 2025
FDW_1650889631479_3JF	bump; flag	+cart	2	2	`7a0758cb`	Sun, 05 Oct 2025
axolotl-invasion-finale-mit-v0-zde0eskznioc	bump; flag	+cart	2	2	`a582176f`	Tue, 23 Sep 2025
Screenshot_2024-07-18_at_13-00-26_Instagram	bump; flag	+cart	2	2	`cb65def6`	Tue, 23 Sep 2025
IMG_20230310_	bump; flag	+cart	1	1	`f4738144`	Tue, 23 Sep 2025
the_banana_gang	bump; flag	+cart	1	1	`fe9e1640`	Tue, 23 Sep 2025
IMG_20221112_	bump; flag	+cart	1	1	`8cd77753`	Tue, 23 Sep 2025
th	bump; flag	+cart	1	1	`38736a47`	Tue, 23 Sep 2025
IMG_20221110_	bump; flag	+cart	1	1	`f1c27135`	Tue, 23 Sep 2025

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 #
`3B9A7133BCE947C2`	Guest	+cart	Guest	Mon, 03 Nov 2025	3	1	approve; flag	`5b7855e5`
`7A234F65162037CB`	lana	+cart	lana	Mon, 03 Nov 2025	13	12	approve(1); flag	`54b1dbce`
`59635BFE4BB3967F`	Tigran	+cart	Tigran	Wed, 29 Oct 2025	1	11	approve(1); flag	`96fbb6e7`
`797D3897C144458A`	JLLeitschuh	+cart	JLLeitschuh	Wed, 29 Oct 2025	4	9011	approve(1); flag	`a94e203e`
`E5C4CFC5A2AEDCA1`	Jensen	+cart	Jensen	Sat, 25 Oct 2025	4	12	approve(1); flag	`e9ddf965`
`B72F655A3F49A248`	ilyag	+cart	ilyag	Tue, 07 Oct 2025	8	9003	approve; flag	`d68f6eeb`
`6C5F50F4838F8DFA`	ilyag	+cart	ilyag	Mon, 06 Oct 2025	1	1	approve; flag	`38c5127d`
`C42BECC41232837A`	Guest	-	-	Mon, 06 Oct 2025	5	-	-	-
`11651AA6925A6207`	Guest	+cart	Guest	Sun, 05 Oct 2025	1	1	approve; flag	`1ad8113c`
`126F0938A277CC33`	ilyag	+cart	ilyag	Thu, 02 Oct 2025	3	9011	approve(1); flag	`50458c2d`

tagset_url	url	author_id	item_title	labels_list	item_score	file_hash
Links #
promote; report	https://www.propublica.org/article/ocean-freight-shipping-co...	Guest	https://www.propublica.org/article/ocean-freight-shipping-costs	#like; #https	2	`815b1eac`
promote; report	https://github.com/gulkily/thankyou	Guest	Software Updated to Version aa818e11..	#changelog; #hasvote; #notext; #signed; #hashtag; #https	1	`53c9d82a`