Count # Items on page: 6 2022-09-05 # file_hash item_title author_id cart a676247d a) don't say baseball is boring or slow +cart 867bf101 f) do not agree to watch baseball game next time +cart cc03a29d boxes: 42.5 +cart ae115a1d boxes: 45 +cart d0d00836 boxes: 1 ilya +cart 6be51a53 c) expect to be there 3-5 hours +cart c) expect to be there 3- # #client; #cookie; #parent; #received >>55cb9119..c) expect to be there 3-5 hours -- [Client][Cookie][Received] Mon, 12 Sep 2022; ; 6be51a53; like ; +cart f) do not agree to watch # #baseball; #client; #cookie; #hashtag; #received #baseballf) do not agree to watch baseball game next time -- [Received][Cookie][Client] Mon, 12 Sep 2022; ; 867bf101; like ; +cart a) don't say baseball is # #client; #cookie; #parent; #received >>55cb9119..a) don't say baseball is boring or slow -- [Cookie][Client][Received] Mon, 12 Sep 2022; ; a676247d; like ; +cart boxes: 45 # #1662416095; #boxes; #client; #cookie; #received boxes: 45Box count at 1662400600 -- [Received][Client][Cookie] Fri, 09 Sep 2022; ; ae115a1d; like ; +cart boxes: 42.5 # #1662416095; #boxes; #client; #cookie; #received boxes: 42.5Box count at 1662413607 -- [Cookie][Received][Client] Mon, 05 Sep 2022; ; cc03a29d; like ; +cart boxes: 1 # #1662400600; #boxes; #client; #cookie; #received boxes: 1Box count at 1662350094 -- [Client][Cookie][Received] Mon, 05 Sep 2022; ilya; d0d00836; 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-09-05' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-09-05' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-09-05' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-09-05' ) ); 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: 12
>>55cb9119..c) expect to be there 3-5 hours -- [Client][Cookie][Received]
#baseballf) do not agree to watch baseball game next time -- [Received][Cookie][Client]
>>55cb9119..a) don't say baseball is boring or slow -- [Cookie][Client][Received]
boxes: 45Box count at 1662400600 -- [Received][Client][Cookie]
boxes: 42.5Box count at 1662413607 -- [Cookie][Received][Client]
boxes: 1Box count at 1662350094 -- [Client][Cookie][Received]
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-09-05' OR file_hash IN ( SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-09-05' ) ) ) AND ( file_hash NOT IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-09-05' ) OR file_hash IN ( SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-09-05' ) );