SQL
AخA
USE lvwiki_p;
SET @rank = 0;
SELECT @rank := @rank + 1 AS rank, CHAR_LENGTH( page_title ) AS length, page_title AS title FROM page
WHERE page_namespace = 0 and page_is_redirect=0 and page_title not like "%Olimpiskajās_spēlēs%"
ORDER BY length DESC
LIMIT 50
/*
oriģināls
USE lvwiki_p;
SET @rank = 0;
SELECT @rank := @rank + 1 AS rank, CHAR_LENGTH( page_title ) AS length, page_is_redirect AS redir, page_title AS title FROM page
WHERE page_namespace = 0
ORDER BY length DESC
LIMIT 100
*/
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.