| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title... |
1 year ago |
| select
# to show title only
SUBSTRING_INDEX(comment.comment_text, '*/', -1)... |
1 year ago |
| select
SUBSTRING_INDEX(comment.comment_text, '*/', -1) as... |
1 year ago |
|
select
SUBSTRING_INDEX(comment.comment_text, '*/', -1) as... |
1 year ago |
|
select
SUBSTRING_INDEX(comment.comment_text, '*/', -1)) as... |
1 year ago |
| CREATE FUNCTION extract_substring (input_string TEXT)
RETURNS TEXT
BEGIN
... |
1 year ago |
| select
comment.comment_text as "comment_of_delete",
revision.rev_timestamp... |
1 year ago |
| select... |
1 year ago |
| select... |
1 year ago |
| select
comment.comment_text,
wb_items_per_site.ips_site_page
from... |
1 year ago |
| select
comment.comment.text,
wb_items_per_site.ips_site_page
from... |
1 year ago |
| select
comment.*,
page.page_title,
wb_items_per_site.ips_site_page
from... |
1 year ago |
| select
comment.*,
page.page_title,
wb_items_per_site.ips_site_id
from... |
1 year ago |
| select
comment.*,
page.page_title,
GROUP_CONCAT(DISTINCT... |
1 year ago |
| select
comment.*,
page.page_title
GROUP_CONCAT(DISTINCT... |
1 year ago |
| select comment.*,page.page_title,page.page_namespace from revision
join page... |
1 year ago |
| select comment.*,page.page_title,page.page_namespace from revision
join page... |
1 year ago |
| select comment.* from revision
join comment on comment_id =... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
/*
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
select distinct log_title from logging
where... |
1 year ago |
| # todo: make it by day
select log_title from logging
where log_type like... |
1 year ago |
| select log_title from logging
where log_type like "delete" and log_action... |
1 year ago |
| select log_title from logging
where log_type like "delete" and log_action... |
1 year ago |
| select page_title from logging
where log_type like "delete" and log_action... |
1 year ago |
| select substr(log_title,1,1) as alpha, count(log_id) as count_pages from... |
1 year ago |
| select substr(log_title,1,1) as alpha, count(log_id) as count_pages from... |
1 year ago |
| select substr(log_title,1,1) as alpha, count(log_id) as count_pages from... |
1 year ago |
|
select substr(log_title,1,1), count(log_id) as alpha from logging
where... |
1 year ago |
| use enwiki_p;
select substr(log_title,1,1), count(logging_id) as alpha from... |
1 year ago |
| use enwiki_p;
select log_title from logging
where log_type like "delete"... |
1 year ago |
| use enwiki_p;
select log_title from logging
where log_type like "delete"... |
1 year ago |
| use enwiki_p;
select log_title from logging
where log_type like "delete"... |
1 year ago |
| use enwiki_p;
select log_title from logging
where log_type like "delete"... |
1 year ago |
| use enwiki_p;
select * from logging
where log_type like "delete" and... |
1 year ago |
| use enwiki_p;
select * from logging
where log_type like "delete" and... |
1 year ago |
| use enwiki_p;
select * from logging
where log_type like "delete" and... |
1 year ago |
| select * from logging
where log_type like "delete" and log_action like... |
1 year ago |
