Welcome ; New ; Threads(2) ; Topics ; Upload ; Write ; Settings ; Session ; People ; Labels(16) ; Help | |
Welcome | Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset |
Q: When was this page printed?
🔍 compost.sql
SELECT
item_title,
item_flat.author_key AS author_id,
author_score,
item_score,
item_type,
add_timestamp,
'' AS tagset_compost,
file_hash
FROM
item_flat
LEFT JOIN author_score ON (item_flat.author_key = author_score.author_key)
WHERE
labels_list NOT LIKE '%notext%'
AND add_timestamp <= strftime('%s', 'now', '-7 day')
ORDER BY
child_count ASC,
add_timestamp ASC
^
PrintedInfo #
Printed:
Q: How old was the page when downloaded?
Age: 577 seconds
pollyanna: 2512d82
Q: How can I get a fresher copy?
A: Ask the server to
🗺️ PageMap