Count # Items on page: 7 2024-10-21 # file_hash item_title author_id cart 70e36a82 Public Key for Guest Guest +cart 222e19b9 Public Key for Guest Guest +cart 1249bcb5 Public Key for ilyag ilyag +cart b6dc5296 1729502510_image Guest +cart baf42983 1729502540_image Guest +cart 0aa5f9a4 Public Key for Guest Guest +cart b0d76a5a Public Key for ilyag ilyag +cart Public Key for Guest # #pubkey [This item is a public key.] 22:36; Guest; 0aa5f9a4; like ; +cart Public Key for ilyag # #pubkey; #approve [This item is a public key.] 10/21; ilyag; 1249bcb5; like ; +cart Public Key for Guest # #pubkey [This item is a public key.] 10/21; Guest; 222e19b9; like ; +cart Public Key for Guest # #pubkey [This item is a public key.] 10/21; Guest; 70e36a82; like ; +cart Public Key for ilyag # #pubkey [This item is a public key.] 22:36; ilyag; b0d76a5a; like ; +cart 1729502510_image # #image 10/21; b6dc5296; like ; +cart 1729502540_image # #image 10/21; baf42983; 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-21' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-10-21' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-10-21' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-10-21' ) ); 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: 10
[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-21' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-10-21' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-10-21' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-10-21' ) );