Chain(599) ; Write ; Upload ; Image(245) ; Settings ; Session ; Help
Banana Lounge Unofficial Fan Forum

People #

No people found.

people.sql #

SELECT * FROM (
	SELECT
		author_alias AS person_name,
		COUNT(author_key) AS author_key_count,
		MAX(author_seen) AS author_seen,
		SUM(author_score) AS author_score,
		SUM(item_count) AS item_count
	FROM author_flat
	WHERE author_key IN (SELECT author_key FROM person_author)
	GROUP BY author_alias
)
WHERE
	person_name != ''
	AND author_key_count >= 1
	AND author_score >= 0


Awaiting Approval #
file_hash author_id author_score add_timestamp tagset_pending cart author_key
7fbe2869 Ilya Gulko 1 approve; flag +cart 903C98D8B2BAAB65
Guests #
file_hash author_id author_key author_seen tagset_guest cart item_count
1cabb5ed Guest C98348E0933ABA2C approve; vouch; flag +cart 1
fb00a0f5 Guest DD644B6EA244B3B5 approve; vouch; flag +cart 2
a8d2248a Guest 9385BF91E5D797C4 approve; vouch; flag +cart 1
63b53d70 Guest DD024D87224130D4 approve; vouch; flag +cart 1
0e1f609b Guest C3AD55675C0F3BB3 approve; vouch; flag +cart 7
9fbedc20 Guest 40F6C9A6A1B70ABC approve; vouch; flag +cart 12
d0054ff8 Guest C1D5685BA5FBF0B9 approve; vouch; flag +cart 1
fff9b951 Guest DE9D12F4D04BC9C9 approve; vouch; flag +cart 3
25a1a8be Guest 905AAFC00C4FF6EC approve; vouch; flag +cart 1
9d3151a3 Guest 8BB17D510C31BAE8 approve; vouch; flag +cart 2
73f550cf Guest 5B39E9E415188DCD approve; vouch; flag +cart 1
f9e7993e Guest 60800F831CD4B52F approve; vouch; flag +cart 1
1b308947 Guest 049856EDFDCD032D approve; vouch; flag +cart 1
PrintedInfo #

Q: When was this page printed?
Printed: July 24 2024 13:41:24.

Q: How old was the page when downloaded?
Age: Fresh!
pollyanna: 308151d

Q: How can I get a fresher copy?
A: Ask the server to

^
Notice #
This server is set to ASCII mode.
Some characters may not be printed.
Non-ASCII characters removed during page printing: 14