Count # Items on page: 4 2024-10-12 # file_hash item_title author_id cart b7310368 07012D5C-FB01-4668-BDB5-06E13696C2C Guest +cart 345ea6fb thank you, banana lounge team! Guest +cart a2d67f53 Public Key for Guest Guest +cart 9bac2e3b 1728712921_image Guest +cart thank you, banana lounge # thank you, banana lounge team! 10/12; Guest; 345ea6fb; like ; +cart 1728712921_image # #image 10/12; 9bac2e3b; like ; +cart Public Key for Guest # #pubkey [This item is a public key.] 10/12; Guest; a2d67f53; like ; +cart 07012D5C-FB01-4668-BDB5- # #image 10/12; b7310368; 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) = '2024-10-12' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-10-12' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-10-12' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-10-12' ) ); Cart # * Paste Clear Add All ^ JavaScript # * Some features may require JavaScript Notice # This server is set to ASCII mode.Some characters may not be printed. Non-ASCII characters removed during page printing: 4
thank you, banana lounge team!
[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) = '2024-10-12' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-10-12' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-10-12' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-10-12' ) );