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

Active #
author_key author_id author_seen item_count author_score tagset_author file_hash
B72F655A3F49A248 ilyag 8 9003 approve; flag d68f6eeb
6C5F50F4838F8DFA ilyag 1 1 approve; flag 38c5127d
C42BECC41232837A Guest 5 - - -
E5C4CFC5A2AEDCA1 Jensen 3 12 approve(1); flag e9ddf965
11651AA6925A6207 Guest 1 1 approve; flag 1ad8113c
Cart #
Paste
Clear
Add All
active.sql #

SELECT
	author_key,
	author_key author_id,
	author_seen,
	item_count,
	author_score,
	'' AS tagset_author,
	file_hash
FROM
	author_flat
WHERE
	author_seen >= strftime('%s', 'now', '-3 day')
ORDER BY
	author_seen DESC


^
JavaScript #