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

Guest #
Alias: Guest
 Seen: 
 Keys: 1
Score: 11
Items: 1
Ilya Gulko #
Alias: Guest
 Seen: 
 Keys: 1
Score: 11
Items: 49
ilyag #
Alias: ilyag
 Seen: 
 Keys: 1
Score: 11
Items: 1
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
b0d76a5a ilyag 1 approve; flag +cart 5FBB8DAE3AA786AE
Guests #
file_hash author_id author_key author_seen tagset_guest cart item_count
0aa5f9a4 Guest 6E0EA864782E7D5C approve; vouch; flag +cart 4
222e19b9 Guest D49F40AE716496FC approve; vouch; flag +cart 1
70e36a82 Guest F8DA7DA3F2B77A42 approve; vouch; flag +cart 1
a2d67f53 Guest F65605370AFD7AF3 approve; vouch; flag +cart 1
8bb5d7fb Guest 1F32D46389C9DDAA approve; vouch; flag +cart 2
5fbcfca4 Guest FD45C586E8EF7F0C approve; vouch; flag +cart 1
32fc7e6e Guest C98348E0933ABA2C approve; vouch; flag +cart 1
8e9a2c6c Guest C1D5685BA5FBF0B9 approve; vouch; flag +cart 1
09f1e8c4 Guest C3AD55675C0F3BB3 approve; vouch; flag +cart 7
10c5ea70 Guest 8BB17D510C31BAE8 approve; vouch; flag +cart 2
e61a46da Guest 60800F831CD4B52F approve; vouch; flag +cart 1
e8005ca3 Guest 1D8B038C25503E6F approve; vouch; flag +cart 7
cd0a169e Guest 049856EDFDCD032D approve; vouch; flag +cart 1
e188abd3 Guest 5B39E9E415188DCD approve; vouch; flag +cart 1
068218b8 Guest 40F6C9A6A1B70ABC approve; vouch; flag +cart 12
f0177e8f Guest 9385BF91E5D797C4 approve(1); vouch; flag +cart 1
fb00a0f5 Guest DD644B6EA244B3B5 approve; vouch; flag +cart 2
63b53d70 Guest DD024D87224130D4 approve; vouch; flag +cart 1
fff9b951 Guest DE9D12F4D04BC9C9 approve; vouch; flag +cart 3
25a1a8be Guest 905AAFC00C4FF6EC approve; vouch; flag +cart 1
PrintedInfo #

Q: When was this page printed?
Printed: November 21 2024 16:36:40.

Q: How old was the page when downloaded?
Age: Fresh!
pollyanna: 9e1f2d6

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

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