desktop

label	label_count
Tags #
#client	295
#received	295
#cookie	282
#image	275
#parent	266
#hashtag	185
#like	74
#pubkey	72
#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`	1 month ago
hi from sipb office!	bump; flag	+cart	2	2	`9b710283`	2 months ago
iwatch has self-identified	bump; flag	+cart	1	1	`50f85cf7`	3 months ago
Hi from Apple watch	bump; flag	+cart	2	2	`529cbaf0`	3 months ago
pi day celebration!	bump; flag	+cart	1	-	`041c20e9`	3 months ago
hey	bump; flag	+cart	1	1	`58e95028`	3 months ago
IMG_	bump; flag	+cart	2	1	`4c3c96b9`	6 months ago
1732654326_image	bump; flag	+cart	2	-	`ba730dc3`	7 months ago
ChiquitaScandinavia	bump; flag	+cart	1	-	`f4876a77`	11 months ago
1717634910_image	bump; flag	+cart	1	-	`1ad2018f`	1 year ago

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 #
`35A4CCB9B99CDBFF`	Aj	+cart	Aj	4 days ago	1	11	approve(1); flag	`4fc98535`
`16CDF62B2EC76539`	ilyag	+cart	ilyag	1 month ago	2	1	approve; flag	`20c1c1f2`
`363345268330364D`	ilyag	+cart	ilyag	1 month ago	1	1	approve; flag	`db00c73f`
`8E3C810099295332`	Guest	-	-	1 month ago	3	1	-	-
`A97D6E71F4D0FE5D`	thaomazein	+cart	thaomazein	1 month ago	1	11	approve(1); flag	`1b623a59`
`191182F0F8D59ABE`	ac	+cart	ac	1 month ago	2	11	approve(1); flag	`591891a9`
`3A299E89ABA55DE4`	Guest	-	-	1 month ago	1	-	-	-
`F1513F1C2979C34D`	ilyag	+cart	ilyag	1 month ago	5	3	approve; flag	`52a51ae2`
`041487CD1FE63F8B`	ilyag	+cart	ilyag	1 month ago	4	1	approve; flag	`3118c90a`
`60C5C79D4B85467A`	Guest	+cart	Guest	2 months ago	1	1	approve; flag	`980a45e0`

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`

Status #

Updated: just now!

Built: 4 months ago

Version: 4078

9 people
verified and approved people

148 threads
items with replies

275 images

0 items
new public items on site

1 links
links to pages and sites

Read ; Write ; Upload ; Image(275) ; Threads(148) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum