| #select concat("*[[",langlinks.ll_title,"]]")
select... |
2 years ago |
| select concat("*[[",langlinks.ll_title,"]]")
from categorylinks
inner join... |
2 years ago |
| select concat("*[[",langlinks.ll_title,"]]")
from categorylinks
inner join... |
2 years ago |
| select concat("[[",langlinks.ll_title,"]]")
from categorylinks
inner join... |
2 years ago |
| select conct("[[",langlinks.ll_title,"]]")
from categorylinks
inner join... |
2 years ago |
| select langlinks.ll_title,langlinks.ll_from
from categorylinks
inner join... |
2 years ago |
| select langlinks.ll_title
from categorylinks
inner join langlinks
on... |
2 years ago |
| select langlinks.ll_title
from categorylinks
inner join langlinks
on... |
2 years ago |
| select langlinks.ll_title
from categorylinks
inner join langlinks
on... |
2 years ago |
| select langlinks.ll_title
from categorylinks
inner join langlinks
on... |
2 years ago |
| select langlinks.ll_title
from categorylinks
inner join langlinks
on... |
2 years ago |
| select langlinks.ll_title
from categorylinks
inner join langlinks
on... |
2 years ago |
| select * from categorylinks where cl_to = "مقالات_نهاية_مسدودة_منذ_2020" limit 10;
|
2 years ago |
| #select * from categorylinks where cl_to = "مقالات_نهاية_مسدودة_منذ_2020"... |
2 years ago |
| select * from categorylinks where cl_to = "مقالات_نهاية_مسدودة_منذ_2020" limit 10; |
2 years ago |
| select * from categorylinks where cl_to = "مقالات نهاية مسدودة منذ 2020" limit 10; |
2 years ago |
| select * from categorylinks where cat_to = "مقالات نهاية مسدودة منذ 2020" limit 10; |
2 years ago |
| #select * from content limit 10;
show tables;
#desc... |
2 years ago |
| #select * from content limit 10;
show tables;
#desc... |
2 years ago |
| #select * from content limit 10;
#show tables;
select * from... |
2 years ago |
| #select * from content limit 10;
#show tables;
select * from abuse_filter... |
2 years ago |
| #select * from content limit 10;
show tables;
#desc abuse_filter;
/*
select... |
2 years ago |
| select * from content limit 10;
#show tables;
#desc abuse_filter;
/*
select... |
2 years ago |
|
show tables;
#desc abuse_filter;
/*
select... |
2 years ago |
|
#show tables;
desc abuse_filter;
/*
select... |
2 years ago |
|
show tables;
/*
select re.rev_id,co.comment_text,re.rev_user,us.user_name... |
2 years ago |
|
DESCRIBE page;
/*
select... |
2 years ago |
|
DESCRIBE page;
/*
select... |
2 years ago |
|
DESCRIBE text;
/*
select... |
2 years ago |
|
select * from text limit 10;
/*
select... |
2 years ago |
|
select * from text limit 10;
/*
select... |
2 years ago |
| /*
select re.rev_id,co.comment_text,re.rev_user,us.user_name from revision... |
2 years ago |
| /*
select re.rev_id,co.comment_text,re.rev_user,us.user_name from revision... |
2 years ago |
|
select re.rev_id,co.comment_text,re.rev_user/*,us.user_name*/ from revision... |
2 years ago |
|
select re.rev_id,co.comment_text/*,us.user_name*/ from revision as re
inner... |
2 years ago |
|
select re.rev_id,co.comment_text,us.user_name from revision as re
inner... |
2 years ago |
|
select re.rev_id,co.comment_text,us.user_name from revision as re
inner... |
2 years ago |
|
select re.rev_id,co.comment_text,us.user_name from revision as re
(inner... |
2 years ago |
|
select re.rev_id,co.comment_text,us.user_name from (revision as re
(inner... |
2 years ago |
|
select re.rev_id,co.comment_text,us.user_name from revision as re
inner... |
2 years ago |
|
select re.rev_id,co.comment_text from revision as re
inner join comment as... |
2 years ago |
|
select re.*,co.comment_text from revision as re
inner join comment as co
on... |
2 years ago |
|
select re.*,co.comment_text from revision as re
inner join comment as co
on... |
2 years ago |
|
select re.*,co.comment_text from revision re
inner join comment co
on... |
2 years ago |
|
select re.*,co.comment_text from revision re
inner join comment co
on... |
2 years ago |
| /*
select * from revision
inner join comment
on .rev_comment_id =
where... |
2 years ago |
| select * from revision where rev_page = 1149712 limit 10;
select * from... |
2 years ago |
| select * from revision where rev_page = 1149712 limit 10;
select * from... |
2 years ago |
| select * from revision where rev_page = 1149712 limit 10;
select * from text... |
2 years ago |
| select * from revision where rev_page = 1149712 limit 10
#select * from... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
#select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
select * from page_props where... |
2 years ago |
| #select * from page where page_id = 1149712
select * from pp_page limit... |
2 years ago |
| #select * from page where page_id = 1149712
select * from pp_page where... |
2 years ago |
| select * from page where page_id = 1149712 |
2 years ago |
| blank query |
2 years ago |
| select *,count(langlinks.ll_title) as c from category
where cat_title like... |
2 years ago |
| select * from category
where cat_title like "%stub%" and cat_subcats = 0... |
2 years ago |
| select * from category
where cat_title like "%stub%" and cat_subcats = 0... |
2 years ago |
| select * from category
where cat_title like "%stub%" and cat_subcats =... |
2 years ago |
| select * from category
where cat_title like "%stub%" and cat_subcats =... |
2 years ago |
| select * from category
#where cat_subcats = 0 and cat_title like "stub_%"... |
2 years ago |
| select * from category
#where cat_subcats = 0 and cat_title like "stub_%"... |
2 years ago |
| select * from category
#where cat_subcats = 0 and cat_title like "stub_%"... |
2 years ago |
| select * from category
where cat_title like "stub_%"
order by cat_pages... |
2 years ago |
| select * from category
where cat_subcats = 0 and cat_title like "stub_%"... |
2 years ago |
| select * from
where cat_subcats = 0 and cat_title like "stub_%"
order by... |
2 years ago |
| blank query |
2 years ago |
| select * from categorylinks
where cl_to like "مواليد_القرن_2"
and cl_type =... |
2 years ago |
| select * from categorylinks
where cl_to like "مواليد_1976"
and cl_type =... |
2 years ago |
| select * from categorylinks
where cl_to like "مواليد_1976"
limit 10; |
2 years ago |
| select * from categorylinks
where cl_from = 7878559;
#limit 10; |
2 years ago |
| select * from categorylinks
where cl_from = 7878559
limit 10; |
2 years ago |
| select * from categorylinks
where cl_from = 7878559
limit 10; |
2 years ago |
| select * from categorylinks
limit 10; |
2 years ago |
| select * from categorylinks where cl_from = 7878559 limit 10; |
2 years ago |
| select * from categorylinks where cl_from = 7878559; |
2 years ago |
| select * from categorylinks where cl_to = "مواليد 1976"; |
2 years ago |
| select * from categorylinks where cl_to = "مواليد_1976"; |
2 years ago |
| select * from categorylinks where cl_to = "مواليد_1976"; |
2 years ago |
| select * from categorylinks where cl_to like "مواليد_1976"; |
2 years ago |
| select * from categorylinks where cl_to like "مواليد_1976" limit 10; |
2 years ago |
| select * from categorylinks where cl_type like "subcat" and cl_to like... |
2 years ago |
| select * from categorylinks where cl_type like "subcat"limit 10; |
2 years ago |
| select * from categorylinks limit 10; |
2 years ago |
| select * from categorylinks where cl_from = 232640 limit 10; |
2 years ago |
| select * from categorylinks where cf_from = 232640 limit 10; |
2 years ago |
| select * from categorylinks cf_from = 232640 limit 10; |
2 years ago |
| select * from categorylinks limit 10; |
2 years ago |
| select * from wb_property_info limit 10; |
2 years ago |
| select * from wb_entity_per_page limit 10; |
2 years ago |
| select * from wb_entity_per_page limit 10; |
2 years ago |
| select * from wb_items_per_site where ips_site_id like "arwiki" limit 10; |
2 years ago |
| select * from wb_items_per_site where ips_site_id = arwiki limit 10; |
2 years ago |
| select * from wb_items_per_site limit 10; |
2 years ago |
| select * from wb_id_counters; |
2 years ago |
| SELECT COUNT(*) AS "عدد المقالات"
FROM revision r
join page p on... |
3 years ago |
| SELECT COUNT(*) AS "عدد المقالات"
FROM revision r
join page p on... |
3 years ago |
| SELECT COUNT(*) AS "عدد المقالات"
FROM revision r
join page p on... |
3 years ago |
| USE arwiki_p;
SELECT concat(actor_name) AS "المستخدم", COUNT(*) AS "عدد... |
3 years ago |
| USE arwiki_p;
SELECT concat(actor_name) AS "المستخدم", COUNT(*) AS "عدد... |
3 years ago |
| USE arwiki_p;
SELECT concat(actor_name) AS "المستخدم", COUNT(*) AS "عدد... |
3 years ago |
