Wiktionary Checker

SQL

USE enwiktionary_p;
SET @word_like = "%elio%";
# SELECT * FROM langlinks WHERE ll_title = "hello";
# SELECT * FROM langlinks WHERE ll_lang = "fr" AND NOT ll_title = "" AND ASCII(SUBSTRING(ll_title, 1, 1)) BETWEEN ASCII('a') AND ASCII('z') LIMIT 10;

# SHOW TABLES;
# DESCRIBE content_models;
# SELECT * FROM content_models LIMIT 10;
# SELECT * FROM revision LIMIT 10;
# SELECT * FROM page WHERE NOT page_lang = NULL LIMIT 10;

SELECT p.page_title, c.content_address
FROM page p
JOIN revision r ON p.page_latest = r.rev_id
JOIN content c ON r.rev_id = c.content_id  -- Assuming content is linked by content_id
WHERE p.page_title LIKE @word_like
AND p.page_namespace = 0  -- Main namespace for articles
AND c.content_model = 1;  -- Content model for wikitext

/*
SELECT page_title FROM page
	WHERE page_namespace = 0
	AND page_title LIKE @word_like
	AND page_title NOT LIKE "-%"
    AND LENGTH(page_title) <= 8
    AND ASCII(SUBSTRING(page_title, 1, 1)) BETWEEN ASCII('a') AND ASCII('z');
*/
SQL

Checking query status...
