Read ; Write ; Upload ; Image(269) ; Threads(144) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum

MyDesktop #

This page is about a person named MyDesktop.
RecentActivity #
file_hash item_title add_timestamp author_id author_key cart
530f1acf [Public key for MyDesktop, 49135DFC8C7F0209] MyDesktop 49135DFC8C7F0209 +cart
702354ea Thanks for the upload, kind visitor! MyDesktop 49135DFC8C7F0209 +cart
788bab22 #like MyDesktop 49135DFC8C7F0209 +cart
b6912ec3 title: In the morning MyDesktop 49135DFC8C7F0209 +cart
ApprovedKeys #
file_hash item_title add_timestamp tagset_pubkey
530f1acf [Public key for MyDesktop, 49135DFC8C7F0209] 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 = 'MyDesktop'
					)
				)
PendingKeys #

This space reserved for future content...
Query took 0.00031415952 second(s):
SELECT DISTINCT file_hash, add_timestamp, author_key AS author_id, author_key, '' AS tagset_pending, '' AS cart FROM item_flat WHERE (labels_list LIKE '%,pubkey,%' OR labels_list LIKE '%,my_name_is,%') AND labels_list NOT 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 = 'MyDesktop' ) )
^
JavaScript #