desktop

Tags

This space reserved for future content...

Query took 0.00031415952 second(s):



SELECT
	label,
	label_count
FROM (
	SELECT
		label,
		COUNT(label) AS label_count
	FROM
		item_label
	WHERE
		file_hash IN (
			SELECT file_hash
			FROM item_flat
			WHERE item_score >= 0
		)
	GROUP BY
		item_label.label
	)
WHERE
	label = LOWER(label)
ORDER BY
	label_count DESC
 LIMIT 10

Threads

This space reserved for future content...

Query took 0.00031415952 second(s):



SELECT
	item_flat.item_title AS item_title,
	'' AS tagset_threads,
	'' AS cart,
	item_flat.child_count AS child_count,
	item_flat.item_score AS item_score,
	item_flat.file_hash AS file_hash,
	item_flat.add_timestamp AS add_timestamp
FROM
	item_flat
WHERE
	item_flat.parent_count = 0 AND
	item_flat.child_count > 0 AND
	item_flat.item_score >= 0 AND
	item_flat.labels_list NOT LIKE '%,hide,%' AND
	item_flat.labels_list NOT LIKE '%,pubkey,%'
ORDER BY
	add_timestamp DESC
 LIMIT 10

New

This space reserved for future content...

Query took 0.00031415952 second(s):



SELECT
	file_hash,
	item_title,
	'' AS cart,
	item_type,
	child_count,
	add_timestamp,
	labels_list,
	'' AS tagset_all
FROM
	item_flat
WHERE
	item_score >= 0 AND
	add_timestamp >= strftime('%s', 'now', '-3 day') AND
	labels_list NOT LIKE '%,notext,%'
ORDER BY
	add_timestamp DESC
 LIMIT 10

Authors

This space reserved for future content...

Query took 0.00031415952 second(s):



SELECT
	author_key,
	author_key author_id,
	author_alias,
	author_seen,
	item_count,
	author_score,
	'' AS tagset_author,
	file_hash
FROM
	author_flat
ORDER BY
	author_seen DESC,
	item_count DESC
LIMIT 10