| use ukwiki_p;
select count(*)
from (select p.*
from page p
... |
7 years ago |
| use ukwiki_p;
select count(*)
from page p
left join pagelinks pl on... |
7 years ago |
| use ukwiki_p;
select count(*)
from page p
left join pagelinks pl on... |
7 years ago |
| use ukwiki_p;
select count(*)
from page p
left join pagelinks pl on... |
7 years ago |
| use ukwikiquote_p;
select p.page_id, r.rd_from, 0 + case... |
7 years ago |
| use ukwikiquote_p;
select p.page_id, r.rd_from, 0 + case r.rd_from when... |
7 years ago |
| use ukwikiquote_p;
select p.page_id, 0 + case r.rd_from when null then 0... |
7 years ago |
| use ukwikiquote_p;
select p.page_id, ifnull(r.rd_from,0) as redir,... |
7 years ago |
| use ukwikiquote_p
select p.page_id, ifnull(r.rd_from,0) as redir,... |
7 years ago |
