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

Ilya #

This page is about a person named Ilya.
RecentActivity #
file_hash item_title add_timestamp author_id author_key cart
2c9f6a64 [declined: #person] Ilya 517F197C5F2E0794 +cart
a39a9ebd [declined: #person] Ilya 517F197C5F2E0794 +cart
18e44e5b IlyaG has self-identified Ilya 517F197C5F2E0794 +cart
8e983db4 Ilya G has self-identified Ilya 517F197C5F2E0794 +cart
b71b2659 [Public key for Ilya, 517F197C5F2E0794] Ilya 517F197C5F2E0794 +cart
ApprovedKeys #
file_hash item_title add_timestamp tagset_pubkey
b71b2659 [Public key for Ilya, 517F197C5F2E0794] person; approve(1); vouch
ApprovedKeys.sql #
 


			SELECT
				file_hash,
				item_title,
				add_timestamp,
				'' AS tagset_pubkey
			FROM item_flat
			WHERE
				(labels_list LIKE '%,pubkey,%' OR labels_list LIKE '%,my_name_is,%') AND
				labels_list LIKE '%,approve,%' AND
				file_hash IN (
					SELECT file_hash
					FROM item_flat
					WHERE author_key IN(
						SELECT author_key
						FROM author_flat
						WHERE author_alias = 'Ilya'
					)
				)
PendingKeys #
file_hash add_timestamp author_id author_key tagset_pending cart
18e44e5b Ilya 517F197C5F2E0794 approve; flag +cart
8e983db4 Ilya 517F197C5F2E0794 approve; flag +cart
^
JavaScript #