Read ; Write ; Upload ; Image(296) ; People(18) ; Threads(40) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum

New #
file_hash item_title cart item_type child_count add_timestamp labels_list tagset_all
24e5a096 Rebuild Frontend finished at 1759895277 +cart txt - #textart; #client; #cookie; #hashtag; #received; #title like
6ec449d2 _dev_clean_html.sh +cart txt - #client; #cookie; #received like
9f35bb22 [Puzzle Solved] +cart txt - #puzzle; #hashtag; #parent like
6cf3cb06 #like +cart txt - #hashtag; #parent like
662ce595 #like +cart txt - #hashtag; #parent like
3d55f41b #like +cart txt - #hashtag; #parent like
eb48f127 #like +cart txt - #hashtag; #parent like
d68f6eeb [Public key for ilyag, B72F655A3F49A248] +cart txt - #pubkey like
38c5127d [Public key for ilyag, 6C5F50F4838F8DFA] +cart txt - #pubkey like
e49c7ebd #like +cart txt - #hashtag; #parent like
c0224e55 #like +cart txt - #hashtag; #parent like
41fab88b #like +cart txt - #hashtag; #parent like
2c40cc7a #like +cart txt - #hashtag; #parent like
376aa720 #like +cart txt - #hashtag; #parent like
7b17570c Thank you for supplying this code monkey with bananas +cart txt 1 #like like(1)
e9ddf965 [Public key for Jensen, E5C4CFC5A2AEDCA1] +cart txt - #pubkey; #approve like
7a0758cb FDW_1650889631479_3JF +cart image 2 #like; #image like(2)
1ad8113c [Public key for Guest, 11651AA6925A6207] +cart txt - #pubkey like
Cart #
Paste
Clear
Add All
new.sql #

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


^
JavaScript #