2024-01-25

2024-01-25

This space reserved for future content...

Query took 0.00031415952 second(s):




			SELECT
				file_hash,
				item_title,
				author_key AS author_id,
				'' AS cart
			FROM item_flat
			WHERE
				item_score >= 0 AND (
					SUBSTR(DATETIME(add_timestamp, 'unixepoch', 'localtime'), 0, 11) = '2024-01-25'
					OR file_hash IN (
						SELECT file_hash
						FROM item_attribute
						WHERE
							attribute = 'date'
							AND value = '2024-01-25'
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-01-25'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-01-25'
					)
				)
			LIMIT 25

No items found.

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) = '2024-01-25'
						OR
						file_hash IN (
							SELECT file_hash FROM item_attribute where attribute = 'date' AND value = '2024-01-25'
						)
					)
				)
				AND (
					file_hash NOT IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value <> '2024-01-25'
					)
					OR
					file_hash IN (
						SELECT file_hash FROM item_attribute WHERE attribute = 'date' AND value = '2024-01-25'
					)
				);

Cart

Paste

Clear
Add All

Welcome ; Threads(2) ; Random ; Menu ; Help
let us not grow weary of doing good