# x Count Items on page: 3 # x 2024-12-23 file_hash item_title author_id cart 665eef29 -----BEGIN PGP SIGNED MESSAGE-----Hash: SHA256hike set python3/ Guest +cart 77139332 -----BEGIN PGP SIGNED MESSAGE-----Hash: SHA256YouretheMadest an Guest +cart 83c8b025 -----BEGIN PGP SIGNED MESSAGE-----Hash: SHA256https://en.m.wiki Guest +cart # x -----BEGIN PGP SIGNED ME #hastext; #hastitle; #client; #received 05:54; 665eef29; thanks ; +cart # x -----BEGIN PGP SIGNED ME #hastext; #hastitle; #client; #received 05:54; 77139332; thanks ; +cart # x -----BEGIN PGP SIGNED ME #hastext; #hastitle; #client; #https; #received 05:54; 83c8b025; thanks ; +cart # x 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-12-23' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-12-23' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-12-23' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-12-23' ) ); # x Cart * Paste Clear Add All RESET # x JavaScript * Some features may require JavaScript # x PageMap Welcome ; Threads ; Random ; Menu ; Help * * Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset
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-12-23' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-12-23' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-12-23' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-12-23' ) );