Read ; Write ; Upload ; Image(252) ; Threads(139) ; Settings ; Profile ; Boxes ; Help
Banana Lounge Unofficial Fan Forum

New #
file_hash item_title cart item_type child_count add_timestamp labels_list tagset_all
b0d76a5a Public Key for ilyag +cart txt - #pubkey like
0aa5f9a4 Public Key for Guest +cart txt - #pubkey like
baf42983 1729502540_image +cart image - #image like
b6dc5296 1729502510_image +cart image - #image like
1249bcb5 Public Key for ilyag +cart txt - #pubkey; #approve like
222e19b9 Public Key for Guest +cart txt - #pubkey like
70e36a82 Public Key for Guest +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 #