| use fawiki_p;
select * from abuse_filter
where af_pattern like '%ك%'; |
6 years ago |
| use fawiki_p;
select * from abuse_filter
limit 1; |
6 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 493253;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 493253;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 493253;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 493253;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 493253;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553;
explain... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553;
explain... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553;
select * from... |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553 |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 261553 |
8 years ago |
| use fawiki_p;
select * from langlinks where ll_from = 1092716 |
8 years ago |
| use fawiki_p;
select page_id from page where page_title = 'Lixer' and... |
8 years ago |
| use fawiki_p;
select page_id from page where page_title = 'Lixer' and... |
8 years ago |
| use fawiki_p;
select page_id from page where page_title = 'Lixer' |
8 years ago |
| use fawiki_p;
select user_name, count(rev_first) tot, sum(if(page_namespace... |
8 years ago |
| use fawiki_p;
select user_name, count(rev_first) tot, sum(if(page_namespace... |
8 years ago |
| use fawiki_p;
select user_name, count(rev_first) tot, sum(if(page_namespace... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) tot, sum(if(page_namespace =... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) tot, sum(if(page_namespace =... |
8 years ago |
| use fawiki_p;
select rev_user, min(rev_timestamp) ff, count(rev_first) tot,... |
8 years ago |
| use fawiki_p;
select rev_user, min(rev_first) ff, count(rev_first) tot,... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) tot, sum(if(page_namespace =... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) tot, sum(if(page_namespace =... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) from revision r... |
8 years ago |
| use fawiki_p;
select rev_user, sum(if(rev_ from revision r join
(
select... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) from revision r... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) from revision r... |
8 years ago |
| use fawiki_p;
select rev_user, count(rev_first) from revision r... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select concat(date_format(now(), '%Y%m%d'), '000000') today,... |
8 years ago |
| use fawiki_p;
select concat(date_format(now(), '%Y%m%d'), '000000') today,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker, ipb_reason,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker, ipb_reason,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker, ipb_reason,... |
8 years ago |
| use fawiki_p;
select u1.user_name blockee, u2.user_name blocker, ipb_reason,... |
8 years ago |
| use fawiki_p;
select ipb_user, ipb_by, ipb_reason, ipb_timestamp, ipb_expiry... |
8 years ago |
| use fawiki_p;
select ipb_user, ipb_by, ipb_reason, ipb_timestamp, ipb_expiry... |
8 years ago |
| use fawiki_p;
select ipb_user, ipb_by, ipb_reason, ipb_timestamp,... |
8 years ago |
| use fawiki_p;
explain ipblocks |
8 years ago |
| use fawiki_p;
show tables; |
8 years ago |
| use fawiki_p;
explain ipblock; |
8 years ago |
| use fawiki_p;
select user_name, sum(img_size) as tot from image join user... |
8 years ago |
| use fawiki_p;
explain image;
explain filearchive; |
8 years ago |
| use fawiki_p;
show tables; |
8 years ago |
| use fawiki_p;
select user_name, count(rev_id) cnt from revision join user on... |
8 years ago |
| use fawiki_p;
select user_name, count(rev_id) cnt from revision join user on... |
8 years ago |
| use fawiki_p;
show tables;
-- select user_name, count(rev_id) cnt from... |
8 years ago |
| use fawiki_p;
show tables;
--select user_name, count(rev_id) cnt from... |
8 years ago |
| use fawiki_p;
show tables;
select user_name, count(rev_id) cnt from revision... |
8 years ago |
| use fawiki_p;
select user_name, count(rev_id) cnt from revision join user on... |
8 years ago |
| use fawiki_p;
select user_name, count(rev_id) cnt from revision join user on... |
8 years ago |
| use fawiki_p;
explain user |
8 years ago |
| use fawiki_p;
explain users |
8 years ago |
| use fawiki_p;
SELECT DISTINCT user_name, rev_timestamp,... |
8 years ago |
| use fawiki_p;
select page_id from page where page_title =... |
8 years ago |
| use fawiki_p;
select page_id from page where page_title = 'آرمهای_اسپانیا' |
8 years ago |
| use fawiki_p;
select page_id from page where page_title = 'رده:آرمهای_اسپانیا' |
8 years ago |
| use fawiki_p;
select max(page_id) from page; |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select user_id from user where user_name = 'AliReza';
select... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select page_namespace, page_title, rev_comment, rev_timestamp... |
8 years ago |
| use fawiki_p;
select * from revision join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select * from revision join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select * from revision join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select * from revision join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select * from revision join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select * from revision join page
on rev_page = page_id
where... |
8 years ago |
| use fawiki_p;
select * from revision
where rev_user = 57277 limit 10; |
8 years ago |
| use fawiki_p;
select * from revision
where rev_user = 57277 limit 10; |
8 years ago |
| use fawiki_p;
select * from revision
where ver_user = 57277 limit 10; |
8 years ago |
| use fawiki_p;
select * from revision
where ver_user = 57277 limit 10; |
8 years ago |
| use fawiki_p;
select * from revision
where ver_user = 57277 limit 10; |
8 years ago |
| use fawiki_p;
select * from revision
where ver_user = 57277 limit 10; |
8 years ago |
| use fawiki_p;
select * from revision where ver_user = 57277 limit 10; |
8 years ago |
| use fawiki_p;
select user_id from user where user_name = 'Omid.koli'; |
8 years ago |
| use fawiki_p;
select user_id from users where user_name = 'Omid.koli'; |
8 years ago |
| use fawiki_p;
select user_id from users where user_name = 'Omid.koli'; |
8 years ago |
| use fawiki_p;
select user_id from users where user_name = 'Omid.koli'; |
8 years ago |
| use fawiki_p;
select user_id from user where user_name = 'Omid.koli'; |
8 years ago |
| use fawiki_p;
select user_id from user where user_name = 'Omid.koli'; |
8 years ago |
| use fawiki_p;
select user_id from user where user_name = 'Omid.koli'; |
8 years ago |
