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

Url #
tagset_url url author_id item_title labels_list item_score file_hash
promote; report https://github.com/gulkily/thankyou Guest Software Updated to Version aa818e11.. #changelog; #hasvote; #notext; #signed; #hashtag; #https 1 53c9d82a
Cart #
Paste
Clear
Add All
url.sql #
 

SELECT
	'' AS tagset_url,
	value AS url,
	author_key AS author_id,
	item_title,
	labels_list,
	item_flat.item_score AS item_score,
	item_flat.file_hash AS file_hash
FROM
	item_attribute
	LEFT JOIN item_flat ON (item_attribute.file_hash = item_flat.file_hash)
WHERE
	attribute IN('http', 'https') AND
	item_flat.item_score > 0
ORDER BY
	item_score DESC
^
JavaScript #