read #
Newest items on the board with at least one #approve.
read.sql #
SELECT
item_title,
item_flat.author_key AS author_id,
add_timestamp,
tags_list,
file_hash
FROM
item_flat
LEFT JOIN author_score
ON (item_flat.author_key = author_score.author_key)
WHERE
item_score >= 0
ORDER BY
(add_timestamp * item_score) DESC
Welcome ; Threads ; Write ; Settings ; Authors ; Tags(1) ; Help | |
Welcome | Expand; Minimal; Reprint; |