| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_to =... |
4 years ago |
| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_to =... |
4 years ago |
| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_to =... |
4 years ago |
| use ruwiki_p;
select *
from categorylinks cl
where cl.cl_to =... |
4 years ago |
| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_to =... |
4 years ago |
| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_to =... |
4 years ago |
| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_from =... |
4 years ago |
| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_from =... |
4 years ago |
| use ruwiki_p;
select count(1)
from categorylinks cl
where cl.cl_from =... |
4 years ago |
| use ruwiki_p;
select *
from categorylinks cl
where cl.cl_type = 'subcat'
limit 10 |
4 years ago |
| use ruwiki_p;
select *
from categorylinks cl
where 1=1 and cl.cl_type =... |
4 years ago |
| use ruwiki_p;
select *
from categorylinks cl
where 1=1 and cl.cl_type =... |
4 years ago |
| -- use s53200__fountain;
create temporary table Pages
select p.page_title,... |
4 years ago |
| use s53200__fountain;
create temporary table Pages
select p.page_title,... |
4 years ago |
| use ruwiki_p;
create temporary table Pages
select p.page_title,... |
4 years ago |
| use ruwiki_p;
-- create temporary table Pages
select p.page_title,... |
4 years ago |
| use ruwiki_p;
-- create temporary table Pages
select p.page_title,... |
4 years ago |
| use ruwiki_p;
-- create temporary table Pages
select p.page_title
from... |
4 years ago |
| use ruwiki_p;
select count(1) -- p.page_title
from categorylinks cl
join... |
4 years ago |
| use ruwiki_p;
select count(1),-- p.page_title
from categorylinks cl
join... |
4 years ago |
| use ruwiki_p;
select p.page_title
from categorylinks cl
join page p on... |
4 years ago |
| use ruwiki_p;
select p.page_title
from categorylinks cl
join page p on... |
4 years ago |
| use ruwiki_p;
select *
from categorylinks cl
join page p on p.page_id =... |
4 years ago |
| use ruwiki_p;
select cast(p.page_title as char) cat, cast(cl.cl_to as char)... |
4 years ago |
| user ruwiki_p;
select cast(p.page_title as char) cat, cast(cl.cl_to as... |
4 years ago |
| select cast(p.page_title as char) cat, cast(cl.cl_to as char) parent_cat,... |
4 years ago |
