| select cl_to, count(cl_to) as count from categorylinks
join page on page_id... |
3 years ago |
| select cl_to, count(cl_to) as count from categorylinks
join page on page_id... |
3 years ago |
| select cl_to, count(cl_to) from categorylinks
join page on page_id =... |
3 years ago |
| select cl_to, count(cl_to) from categorylinks
join page on page_id =... |
3 years ago |
| select cl_to, count(cl_to) from categorylinks
join page on page_id =... |
3 years ago |
| select concat('Module:', page_title) as title from categorylinks
join page... |
3 years ago |
| select page_title, if(sum(cl_to = 'Japanese_modules'), true, false) from... |
3 years ago |
| select page_title, if(sum(cl_to = 'Japanese_modules'), true, false) from... |
3 years ago |
| select cl_from, if(sum(cl_to = 'Japanese_modules'), true, false) from... |
3 years ago |
| select if(sum(cl_to = 'Japanese_modules'), true, false) from... |
3 years ago |
| select sum(cl_to = 'Japanese_modules') from categorylinks
where cl_to =... |
3 years ago |
| select * from categorylinks
where cl_to = 'Japanese_modules'
limit 10; |
3 years ago |
| select * from categorylinks
where cl_to = 'Japanese modules'
limit 10; |
3 years ago |
| select cl_to, count(cl_to) from page
join categorylinks on cl_from =... |
3 years ago |
| select * from page
join categorylinks on cl_from = page_id
where page_title... |
3 years ago |
| select * from page
where page_title like "ja/data/kanji%"
limit 10; |
3 years ago |
| select * from categorylinks
join page on page_id = cl_to
where page_title... |
3 years ago |
| select * from categorylinks
where cl_to like "ja/data/kanji%"
limit 10; |
3 years ago |
| select * from page limit 10; |
3 years ago |
