Files F12297781

operations-grimoire-older-pages.sql
No OneTemporary
Actions

Size

612 B

Referenced Files

None

Subscribers

None

operations-grimoire-older-pages.sql
View Options

	-- Agora
	-- What Operations Grimoire pages are older than 6 months?

	USE nasqueron_wiki;

	SELECT
	-- page_link example: [Operations grimoire/Kubernetes\|Kubernetes]]
	REPLACE(CONCAT("[[", page_title, "\|", SUBSTRING(page_title, 21), "]]"), "_", " ") as page_link,

	-- age in days (1 day = 86400 seconds)
	FLOOR((UNIX_TIMESTAMP() - UNIX_TIMESTAMP(page_touched)) / 86400) as age
	FROM
	page
	WHERE
	LEFT(page_title, 20) = "Operations_grimoire/"
	AND LEFT(page_title, 29) != "Operations_grimoire/Incidents"
	AND page_is_redirect = 0
	HAVING age > 180
	ORDER BY page_touched DESC, page_title ASC;

File Metadata

Mime Type: text/plain
Expires: Wed, Oct 22, 13:15 (1 d, 20 h)
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 3075043
Default Alt Text: operations-grimoire-older-pages.sql (612 B)

Event Timeline