Count # Items on page: 5 2025-02-05 # file_hash item_title author_id cart 8aaa106a #like ilyag +cart 322bc897 #like ilyag +cart f346261c [Public key for ilyag, 40E4DF118C2D943A] ilyag +cart ae234670 Hey ilyag +cart 5281de0d #like ilyag +cart #like # #hashtag; #parent >>885eee65..#like no timestamp; ilyag; b8f3e25f; like ; +cart #like # #hashtag; #parent >>IMG_#like 02/05; ilyag; 5281de0d; like ; +cart #like # #hashtag; #parent >>1732654326_image#like no timestamp; ilyag; f8cf2d87; like ; +cart Hey # Hey 02/05; ilyag; ae234670; like ; +cart [Public key for ilyag, 4 # #pubkey [This item is a public key.] no timestamp; ilyag; c52dcaf0; like ; +cart 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) = '2025-02-05' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2025-02-05' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2025-02-05' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2025-02-05' ) ); Cart # * Paste Clear Add All ^ JavaScript # * Some features may require JavaScript
>>885eee65..#like
>>IMG_#like
>>1732654326_image#like
Hey
[This item is a public key.]
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) = '2025-02-05' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2025-02-05' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2025-02-05' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2025-02-05' ) );