| use mediawikiwiki_p;
select * from page where page_namespace=2 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| select "10.10.10.10" regexp "\\d*\\.\\d*\\.\\d*\\.\\d*"
/*use... |
3 years ago |
| select "zebra" regexp "\\d*\\.\\d*\\.\\d*\\.\\d*"
/*use... |
3 years ago |
| select "zebra" regexp "\d*\.\d*\.\d*\.\d*"
/*use mediawikiwiki_p;
select *... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| select "107.167.105.140" regexp "\d*\.\d*\.\d*\.\d*"
/*
use... |
3 years ago |
| select "107.167.105.140" regexp "/d*./d*./d*./d*"
/*
use... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select * from user where user_name like '"k%' limit 10; |
3 years ago |
| use mediawikiwiki_p;
select * from user order by user_name limit 10; |
3 years ago |
| use mediawikiwiki_p;
select * from user limit 10; |
3 years ago |
| use mediawikiwiki_p;
select * from page where page_namespace=3 and not... |
3 years ago |
| use mediawikiwiki_p;
select page_namespace, page_title, tl_namespace,... |
3 years ago |
| use mediawikiwiki_p;
select page_namespace, page_title, tl_namespace,... |
3 years ago |
| use mediawikiwiki_p;
select page_namespace, page_title, tl_namespace,... |
3 years ago |
| use mediawikiwiki_p;
select page_namespace, page_title, tl_namespace,... |
3 years ago |
| use mediawikiwiki_p;
select page_namespace, page_title, tl_namespace,... |
3 years ago |
| use mediawikiwiki_p;
select * from templatelinks where tl_namespace != 10... |
3 years ago |
| use mediawikiwiki_p;
select * from templatelinks limit 1; |
3 years ago |
| use mediawikiwiki_p;
select afl_id, afl_title from abuse_filter_log where... |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log where afl_filter=12 and... |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log where afl_filter=12 and... |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log where afl_filter=12 and... |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log where afl_filter=12 and... |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log where afl_filter=12 and... |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log where afl_filter=12 limit 1; |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log where afl_filtet=12 limit 1; |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log limit 1; |
3 years ago |
| use mediawikiwiki_p;
select * from abuse_filter_log; |
3 years ago |
| use mediawikiwiki_p;
select... |
3 years ago |
| use mediawikiwiki_p;
select * from revision_compat join page on... |
3 years ago |
| use mediawikiwiki_p;
select * from revision_compat join page on... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and exists... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 /*and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| -- use mediawikiwiki_p;
-- select * from archive where ar_namespace=10 and... |
3 years ago |
| -- use mediawikiwiki_p;
-- select * from archive where ar_namespace=10 and... |
3 years ago |
| -- use mediawikiwiki_p;
-- select * from archive where ar_namespace=10 and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| select "ABC" like "A_C";
select "A_C" like "A_C" escape "_";
select "A_C"... |
3 years ago |
| select "ABC" like "A_C";
select "A_C" like "A_C" escape "_";
select "A_C"... |
3 years ago |
| select "ABC" like "A_C";
select "A_C" like "A_C" escape "_";
select "AZ_C"... |
3 years ago |
| select * from page where page_title like "Gather_FAQ/%" and page_namespace=102; |
3 years ago |
| select * from page where page_title like "OggHandler/Client_download\/%" and... |
3 years ago |
| use mediawikiwiki_p;
select distinct ar_title from archive where... |
3 years ago |
| use mediawikiwiki_p;
select distinct ar_title from archive where... |
3 years ago |
| use mediawikiwiki_p;
select * from archive where ar_namespace=10 and... |
3 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
3 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
3 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
3 years ago |
| select * from archive_compat where ar_user=(select user_id from user where... |
3 years ago |
