Count # Items on page: 7 2022-11-07 # file_hash item_title author_id cart 50793126 1667816387_image Guest +cart 1935de2f 1667816214_image Guest +cart 0fe2d2f3 1667816226_image Guest +cart e7b0af40 1667816329_image Guest +cart e13f3550 1667816091_image Guest +cart 37f16513 1667816129_image Guest +cart a935871b 1667816273_image Guest +cart 1667816226_image # #image Mon, 07 Nov 2022; 0fe2d2f3; like ; +cart 1667816214_image # #image Mon, 07 Nov 2022; 1935de2f; like ; +cart 1667816129_image # #image Mon, 07 Nov 2022; 37f16513; like ; +cart 1667816387_image # #image Mon, 07 Nov 2022; 50793126; like ; +cart 1667816273_image # #image Mon, 07 Nov 2022; a935871b; like ; +cart 1667816091_image # #image Mon, 07 Nov 2022; e13f3550; like ; +cart 1667816329_image # #image Mon, 07 Nov 2022; e7b0af40; 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-11-07' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-11-07' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-11-07' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-11-07' ) ); Cart # * Paste Clear Add All ^ JavaScript # * Some features may require JavaScript
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-11-07' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-11-07' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-11-07' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-11-07' ) );