| USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?curid=",page_id) as... |
7 years ago |
| USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?curid=",page_id) as... |
7 years ago |
| USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?curid=",page_id) as... |
7 years ago |
| USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?curid=",page_id) as... |
7 years ago |
| USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?curid=",page_id) as... |
7 years ago |
| USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?curid=",tl.tl_from) as... |
7 years ago |
| USE trwiki_p;
SELECT concat("tr.wikipedia.org/wiki?curid=",tl.tl_from),... |
7 years ago |
| USE trwiki_p;
SELECT tl.tl_title, count(*)
, IF(page_id in (
SELECT... |
7 years ago |
| USE trwiki_p;
SELECT tl.tl_title, count(*)
from templatelinks tl where... |
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title like "•w"
-- and... |
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title like "•w"
and... |
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title like "%w"
and... |
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title rlike "w"
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title like "?w"
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title rlike "?w"
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title rlike '?w'
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title in ('?w')
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title in ('*w')
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title in ("\*w")
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title in ("*w")
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title like "*w"
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title like "\*w"
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title rlike "'\*w"
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title rlike "\*w"
;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title rlike "`\*w"
limit 5;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title rlike "*w"
limit 5;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title = "*w"
limit 5;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_title = "*w"
limit 5;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM templatelinks where tl_to = "*w"
limit 5;
|
7 years ago |
| USE trwiki_p;
SELECT *
FROM template_links where tl_to = "*w"
limit 5;
|
7 years ago |
