| blank query |
2 years ago |
| select templatelinks.tl_title, page.page_title, page.page_namespace
from... |
2 years ago |
| select templatelinks.tl_title, page.page_title
from templatelinks,... |
2 years ago |
| select *
from templatelinks
where tl_title='Notif'
limit 100 |
2 years ago |
| select distinct tl_namespace, tl_from_namespace
from templatelinks
where... |
2 years ago |
| select distinct tl_namespace, tl_from_namespace
from templatelinks |
2 years ago |
| select distinct(tl_namespace)
from templatelinks |
2 years ago |
| select distinct(tl_namespace), count()
from templatelinks
group by tl_namespace |
2 years ago |
| select distinct(tl_namespace), count()
from templatelinks
group by tl_namespace |
2 years ago |
| select distinct(tl_namespace), count()
from templatelinks
group by tl_namespace |
2 years ago |
| select *
from templatelinks
where tl_namespace <> 10
limit 100 |
2 years ago |
| select *
from templatelinks
where tl_namespace is not 10
limit 100 |
2 years ago |
|
select *
from templatelinks
limit 100 |
2 years ago |
|
select concat("[[Template:", tl_title, ']]')
from templatelinks
|
2 years ago |
| select concat("[[Template:", page_title, ']]')
from page
where... |
2 years ago |
| select concat("* [[Template:", page_title, ']]')
from page
where... |
2 years ago |
| select page_title
from page
where page_namespace = 10 -- count... |
2 years ago |
| select page_title
from page
where page_namespace = 10 -- count... |
2 years ago |
| select DISTINCT page_title
from page
where page_namespace = 10 --... |
2 years ago |
| select DISTINCT page_title
from page
where page_namespace = 10 --... |
2 years ago |
| select DISTINCT page_title
from page
where page_namespace = 10 --... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page.page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("[[Template:", page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("* [[Template:", page_title, ']]') as pagename,... |
2 years ago |
| select DISTINCT concat("* [[Template:", page_title, ']]') as pagename,... |
2 years ago |
