select * from categorylinks, page pageA
join templatelinks on tl_from =... |
11 months ago |
select 1 from categorylinks, page pageA
join templatelinks on tl_from =... |
11 months ago |
select 1 from categorylinks, page pageA
join templatelinks on tl_from =... |
11 months ago |
select *
from linktarget
join templatelinks on tl_target_id = lt_id
where... |
11 months ago |
select *
from linktarget
where linktarget.lt_title = "List_of_lists"
limit 10; |
11 months ago |
select *
from linktarget
where linktarget.lt_title like "%Disambiguation"
limit 10; |
11 months ago |
select *
from linktarget
where linktarget.lt_title like "%articles"
limit 10; |
11 months ago |
select *
from linktarget
limit 10; |
11 months ago |
select * from page
right join templatelinks on tl_from = page.page_id
limit 40; |
11 months ago |
select * from page
left join templatelinks on tl_from = page.page_id
limit 40; |
11 months ago |
select page.page_title, templatelinks.* from page
left join templatelinks on... |
11 months ago |
select pageA.page_title, templatelinks.* from page pageA
left join... |
11 months ago |
select page.page_title, templatelinks.* from page
left join templatelinks... |
11 months ago |
select page_title from page
left join templatelinks on tl_from =... |
11 months ago |
select * from page
left join templatelinks on tl_from = page.page_id
limit 40; |
11 months ago |
select * from page
left join templatelinks on tl_from = page.page_id
limit 10; |
11 months ago |
select * from templatelinks
limit 10; |
11 months ago |
blank query |
11 months ago |