|
Count
Items on page: 1 |
|
2024-02-28
|||
file_hash | item_title | author_id | cart |
---|---|---|---|
117377a6 | 117377a6.. | Guest |
|
Untitled
#notext |
---|
|
;
117377a6;
thanks
; |
|
query.sql
|
|
Cart
Welcome ; Threads(18) ; Random ; Menu ; Help | |
let us not grow weary of doing good | Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset |
Q: When was this page printed?
Count
Items on page: 1
2024-02-28
file_hash
item_title
author_id
cart
117377a6
117377a6..
Guest
Untitled
#notext
;
117377a6;
thanks
;
query.sql
SELECT
item_flat.file_path file_path,
item_flat.item_name item_name,
item_flat.file_hash file_hash,
item_flat.author_key author_key,
item_flat.child_count child_count,
item_flat.parent_count parent_count,
item_flat.add_timestamp add_timestamp,
item_flat.item_title item_title,
item_flat.item_score item_score,
item_flat.labels_list labels_list,
item_flat.item_type item_type,
item_flat.item_order item_order,
item_flat.item_sequence item_sequence
FROM
item_flat
WHERE
file_hash IN (
SELECT file_hash
FROM item_flat
WHERE
item_score >= 0 AND
(
SUBSTR(DATETIME(add_timestamp, 'unixepoch', 'localtime'), 0, 11) = '2024-02-28'
OR
file_hash IN (
SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-02-28'
)
)
)
AND (
file_hash NOT IN (
SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-02-28'
)
OR
file_hash IN (
SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-02-28'
)
);
Cart
PrintedInfo
Printed:
Q: How old was the page when downloaded?
Age: Fresh!
pollyanna: fc2d252
Q: How can I get a fresher copy?
A: Ask the server to
PageMap