Count # Items on page: 4 2022-02-01 # file_hash item_title author_id cart 0679963e [declined: #admin] Ilya Gulko +cart 16ecdd32 [declined: #remove] Ilya Gulko +cart 46585a38 Do you like this place? Guest +cart b2af7999 [declined: #admin] Ilya Gulko +cart [declined: #admin] # #hashtag; #parent >>9250efb0..#admin Tue, 01 Feb 2022; Ilya Gulko; 0679963e; like ; +cart [declined: #remove] # #hashtag; #parent >>6549db9c..#remove Tue, 01 Feb 2022; Ilya Gulko; 16ecdd32; like ; +cart Do you like this place? # Do you like this place?Please tell us to help the volunteers feel appreciated!26-110.com-- 09/22; 46585a38; like ; +cart [declined: #admin] # #hashtag; #parent >>8f451946..#admin Tue, 01 Feb 2022; Ilya Gulko; b2af7999; 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) = '2022-02-01' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-02-01' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-02-01' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-02-01' ) ); Cart # * Paste Clear Add All ^ JavaScript # * Some features may require JavaScript
>>9250efb0..#admin
>>6549db9c..#remove
Do you like this place?Please tell us to help the volunteers feel appreciated!26-110.com--
>>8f451946..#admin
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) = '2022-02-01' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-02-01' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-02-01' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-02-01' ) );