2022-10-21

Count #

Items on page: 13

file_hash	item_title	author_id	cart
2022-10-21 #
`04d01774`	testing	Guest	+cart
`156b5b65`	test	Guest	+cart
`1fe3bcfd`	MIT NEET	Guest	+cart
`3c66be58`	MIT AV	Guest	+cart
`64943c20`	website	Guest	+cart
`65c7ca15`	Online form on MIT AV website	Guest	+cart
`6b34fed7`	Canvas	Guest	+cart
`76de3941`	Slack	Guest	+cart
`77bf1ded`	External:	Guest	+cart
`88eb198a`	title: nesquick	Guest	+cart
`8df02790`	Software Updated to Version 2ceae406..	Guest	+cart
`f84a1532`	Servicenow	Guest	+cart
`fd325920`	in-person	Guest	+cart

#client; #cookie; #received
testing #
testing -- [Client] [Received] [Cookie]
Thu, 22 Dec 2022; Guest; 04d01774; like ; +cart

#client; #cookie; #parent; #received
test #
>>e830da45.. test -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; Guest; 156b5b65; like ; +cart

#client; #cookie; #received
MIT NEET #
MIT NEET -- [Cookie] [Received] [Client]
Thu, 22 Dec 2022; Guest; 1fe3bcfd; like ; +cart

#client; #cookie; #received
MIT AV #
MIT AV Slack Email -- [Cookie] [Received] [Client]
Thu, 22 Dec 2022; Guest; 3c66be58; like ; +cart

#client; #cookie; #parent; #received
website #
>>fcf61000.. website -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; Guest; 64943c20; like ; +cart

#client; #cookie; #parent; #received
Online form on MIT AV we #
>>4c510424.. Online form on MIT AV website Creates a ticket -- [Cookie] [Received] [Client]
Thu, 22 Dec 2022; Guest; 65c7ca15; like ; +cart

#client; #cookie; #parent; #received
Canvas #
>>bbdb4b22.. Canvas -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; Guest; 6b34fed7; like ; +cart

#client; #cookie; #parent; #received
Slack #
>>ee7806b3.. Slack -- [Cookie] [Received] [Client]
Thu, 22 Dec 2022; Guest; 76de3941; like ; +cart

#client; #cookie; #parent; #received
External: #
>>3a31135a.. External: Email Phone -- [Cookie] [Received] [Client]
Thu, 22 Dec 2022; Guest; 77bf1ded; like ; +cart

#client; #cookie; #parent; #received; #title
title: nesquick #
>>nesquick title: nesquick -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; Guest; 88eb198a; like ; +cart

#changelog; #hashtag
Software Updated to Vers #
Software Updated to Version 2ceae406.. Installed software version has changed from 9225ec3f.. to 2ceae406.. 2ceae40 change tag pages from being at /top/foo.html to /tag/foo.html 80d2a65 print line feed after cluster_by_time.pl is done 84e34bd add to scratch.js a51a9a6 add "hide" tag to all and hastext tagsets 1331b1d do not show items with "hide" tag on threads page 5d911bc update todo.txt d65315c add search keyword in make_simple_page.pl 7b0b6c4 remove no longer used code for help page in GetSimplePage() make_simple_page.pl 1086b65 add search keywords to index_text_file.pl 59b31a1 add option for textarea-tag-based timestamp widget in widget.pl (using existing template timestamp_textarea.template) 41dc24f improve help page; create separate module for help page (page.pl); add views dialog on help page; files: help.pl help_views.template widget.pl index_text_file.pl help.template 2cd7aaf update scratch.js dc680e3 update todo #changelog
Thu, 22 Dec 2022; 8df02790; like ; +cart

#client; #cookie; #parent; #received
Servicenow #
>>5b4b8f07.. Servicenow -- [Cookie] [Received] [Client]
Thu, 22 Dec 2022; Guest; f84a1532; like ; +cart

#client; #cookie; #parent; #received
in-person #
>>af8c5b60.. in-person -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; Guest; fd325920; 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-10-21'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-10-21'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-10-21'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-10-21'
					)
				);

Cart #

Paste

Clear
Add All

Read ; Write ; Upload ; Image(299) ; People(21) ; Threads(48) ; Settings ; Profile ; Help
Banana Lounge Unofficial Fan Forum