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 text;
# SELECT * from page WHERE NOT page_lang = NULL LIMIT 10;

/*
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...
