Links

Url #
tagset_url	url	author_id	item_title	labels_list	item_score	file_hash
promote; report	https://www.propublica.org/article/ocean-freight-shipping-co...	Guest	https://www.propublica.org/article/ocean-freight-shipping-costs	#like; #https	2	`815b1eac`
promote; report	https://github.com/gulkily/thankyou	Guest	Software Updated to Version aa818e11..	#changelog; #hasvote; #notext; #signed; #hashtag; #https	1	`53c9d82a`

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

Read ; Write ; Upload ; Image(299) ; People(21) ; Threads(48) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum