Portály mimo kategorie portálů

SQL

use mediawikiwiki_p;
select * from page where page_title rlike "[Pp]ywiki(bot|pedia)" and page_title rlike '\.py' and not page_title rlike '\/[a-z]{2}$' and not page_id in (select cl_from from categorylinks where cl_to like 'Pywikibot_scripts');
select * from page where page_title rlike "[Pp]ywiki(bot|pedia)" and not page_title rlike '\/[a-z]{2}$' and page_namespace in (4, 10, 14, 100) and not page_is_redirect;
select * from page join redirect on page_id=rd_from where rd_title rlike "[Pp]ywiki(bot|pedia)";

SQL

Checking query status...