2022-10-16

Count #

Items on page: 35

file_hash	item_title	cart
2022-10-16 #
`8b753eb7`	digging through the bags again	+cart
`4e1bcd2c`	something wrong with how this was submitted	+cart
`c46fc0d8`	a couple arrives,, walking quickly	+cart
`78e4f5ca`	they did not take any	+cart
`50d177a4`	two people arrive together and begin digging. they each take 1	+cart
`dd4a757b`	Imagine 15 is a prime number	+cart
`e6f2e839`	takes about 3-4 bananas, leaves	+cart
`44c9de14`	still digging through the boxes and bags	+cart
`cd0c06f0`	one more bunch for the road, carried in hands. and they're out.	+cart
`6e096f71`	reluctantly shoves a bag in a box out of place	+cart
`ad72db32`	person just arrived 30sec ago, looking through bananas	+cart
`2206e6d5`	2 people just arrived, onl 1 is looking through bananas	+cart
`74515a63`	Oct 15	+cart
`840e8234`	still looking. now begins to fill backpack.	+cart
`ec915c6a`	still looking. by now, i estimate they've touched at least 50 b	+cart
`fd00ea07`	still looking, in the back	+cart
`27a62ef9`	begins by observing banana state from a distance	+cart
`ff4c6e54`	a person arrives, arms folded	+cart
`a989131a`	<10 seconds, i would say	+cart
`ee40d968`	two people came and went, did not like how the bananas looked?	+cart
`16011410`	other person is holding a fall leaf	+cart
`39c6787f`	still looking	+cart
`94f132e0`	#offtopic	+cart
`e90077ce`	person arrived, took one bag and about 3-5 bananas	+cart
`c3f9072e`	i can't see back there, but i am hearing a lot of bag shuffling	+cart

#client; #cookie; #parent; #received
begin observing #
>>d7da19e2.. begin observing -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; ; 003611ee; like ; +cart

#client; #cookie; #parent; #received
one bunch has been chose #
>>af001494.. one bunch has been chosen, looking for the second place bunch -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; ; 0adfd2d6; like ; +cart

#client; #cookie; #parent; #received
other person is holding #
>>6f335952.. other person is holding a fall leaf -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; 16011410; like ; +cart

#client; #cookie; #parent; #received
within seconds, they too #
>>a0ecf5a2.. within seconds, they took about 6 bananas in a bunch and left -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; ; 182f0c26; like ; +cart

#client; #cookie; #parent; #received
2 people just arrived, o #
>>daaa5c63.. 2 people just arrived, onl 1 is looking through bananas -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; 2206e6d5; like ; +cart

#client; #cookie; #parent; #received
begins by observing bana #
>>acc2c67f.. begins by observing banana state from a distance -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; ; 27a62ef9; like ; +cart

#client; #cookie; #parent; #received
still looking #
>>920bd500.. still looking -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; ; 39c6787f; like ; +cart

#client; #cookie; #parent; #received
still digging through th #
>>f9b84fad.. still digging through the boxes and bags -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; ; 44c9de14; like ; +cart

#client; #cookie; #hashtag; #parent; #received
something wrong with how #
>>df3f62c6.. #flag something wrong with how this was submitted #meta -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; 4e1bcd2c; like ; +cart

#client; #cookie; #parent; #received
two people arrive togeth #
>>daaa5c63.. two people arrive together and begin digging. they each take 1 banana and leave. -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; 50d177a4; like ; +cart

#client; #cookie; #parent; #received
someone who has been wor #
>>daaa5c63.. someone who has been working at a table, got up and took a banana and went back to their table. -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; 59d85633; like ; +cart

#client; #cookie; #parent; #received
reluctantly shoves a bag #
>>b221e430.. reluctantly shoves a bag in a box out of place -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; 6e096f71; like ; +cart

#client; #cookie; #received
Oct 15 #
Oct 15 -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; ; 74515a63; like ; +cart

#client; #cookie; #parent; #received
they did not take any #
>>6b6a75cb.. they did not take any -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; 78e4f5ca; like ; +cart

#client; #cookie; #parent; #received
second bunch has been ch #
>>a713d14a.. second bunch has been chosen from the middle box in the front aisle. second bunch goes into backpack, backpack goes onto back. person is preparing to leave. -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; ; 80a39eab; like ; +cart

#client; #cookie; #parent; #received
still looking. now begin #
>>87cc9c37.. still looking. now begins to fill backpack. -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; ; 840e8234; like ; +cart

#client; #cookie; #parent; #received
digging through the bags #
>>f39f54b8.. digging through the bags again -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; ; 8b753eb7; like ; +cart

#client; #cookie; #hashtag; #parent; #received
#offtopic #
>>82e9b41b.. #offtopic -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; 94f132e0; like ; +cart

#client; #cookie; #parent; #received
finish observing #
>>daaa5c63.. finish observing -- [Client] [Cookie] [Received]
Thu, 22 Dec 2022; ; 976253e6; like ; +cart

#client; #cookie; #parent; #received
<10 seconds, i would #
>>4ca4c81c.. <10 seconds, i would say -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; a989131a; like ; +cart

#client; #cookie; #hashtag; #parent; #received
#like #
>>5a1e2c5f.. #like -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; aa07fd7f; like ; +cart

#client; #cookie; #parent; #received
two people arrive from o #
>>daaa5c63.. two people arrive from opposite directions, simultaneously. one takes 2 bananas, one takes about 8. -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; acc1a7d0; like ; +cart

#client; #cookie; #parent; #received
person just arrived 30se #
>>daaa5c63.. person just arrived 30sec ago, looking through bananas -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; ad72db32; like ; +cart

#client; #cookie; #parent; #received
i can't see back there, #
>>e9d501fa.. i can't see back there, but i am hearing a lot of bag shuffling -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; c3f9072e; like ; +cart

#client; #cookie; #parent; #received
a couple arrives,, walki #
>>daaa5c63.. a couple arrives,, walking quickly -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; c46fc0d8; like ; +cart

#client; #cookie; #parent; #received
one more bunch for the r #
>>ad973f0d.. one more bunch for the road, carried in hands. and they're out. -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; cd0c06f0; like ; +cart

#client; #cookie; #parent; #received
they leave simultaneousl #
>>8374d03e.. they leave simultaneously through the front door -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; cf1ae3fd; like ; +cart

#client; #cookie; #parent; #received
doing things on the phon #
>>4d8ff20d.. doing things on the phone while standing in between the banana aisles -- [Cookie] [Client] [Received]
Thu, 22 Dec 2022; ; d5213ff6; like ; +cart

#OutOfContext; #client; #cookie; #hashtag; #received
Imagine 15 is a prime nu #
#OutOfContext "Imagine 15 is a prime number" -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; dd4a757b; like ; +cart

#client; #cookie; #parent; #received
takes about 3-4 bananas, #
>>f10837db.. takes about 3-4 bananas, leaves -- [Client] [Received] [Cookie]
Thu, 22 Dec 2022; ; e6f2e839; like ; +cart

#client; #cookie; #parent; #received
person arrived, took one #
>>daaa5c63.. person arrived, took one bag and about 3-5 bananas -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; ; e90077ce; like ; +cart

#client; #cookie; #parent; #received
still looking. by now, i #
>>790ba269.. still looking. by now, i estimate they've touched at least 50 bananas in 10 different boxes -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; ec915c6a; like ; +cart

#client; #cookie; #parent; #received
two people came and went #
>>daaa5c63.. two people came and went, did not like how the bananas looked? -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; ee40d968; like ; +cart

#client; #cookie; #parent; #received
still looking, in the ba #
>>1d5b6402.. still looking, in the back -- [Received] [Client] [Cookie]
Thu, 22 Dec 2022; ; fd00ea07; like ; +cart

#client; #cookie; #parent; #received
a person arrives, arms f #
>>daaa5c63.. a person arrives, arms folded -- [Received] [Cookie] [Client]
Thu, 22 Dec 2022; ; ff4c6e54; 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-16'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2022-10-16'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2022-10-16'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2022-10-16'
					)
				);

Cart #

Paste

Clear
Add All

Read ; Write ; Upload ; Image(258) ; Threads(139) ; Settings ; Profile ; Boxes ; Help
Banana Lounge Unofficial Fan Forum