| #select tl_from from templatelinks where tl_title='Reflist' and tl_from... |
7 years ago |
| #select tl_from from templatelinks where tl_title='Reflist' and tl_from... |
7 years ago |
| select tl_from from templatelinks where tl_title='Reflist' and tl_from... |
7 years ago |
| select tl_from from templatelinks where tl_title='Reflist' and tl_to... |
7 years ago |
| select tl_to from templatelinks where tl_title='Reflist' and tl_to in(select... |
7 years ago |
| select cl_from from categorylinks where cl_to='All_WikiProject_Medicine_articles'; |
7 years ago |
| select cl_from from categorylinks where cl_to='All WikiProject Medicine articles'; |
7 years ago |
| USE tewiki_p;
select * from templatelinks where tl_title='Reflist';
#SELECT... |
7 years ago |
| USE tewiki_p;
select * from templatelinks where tl_title='Reflist' limit... |
7 years ago |
| USE tewiki_p;
select * from templatelinks where 1 limit 10;
#SELECT DISTINCT... |
7 years ago |
| USE tewiki_p;
desc templates;
select * from templatelinks where 1 limit... |
7 years ago |
| USE tewiki_p;
desc template;
select * from templatelinks where 1 limit... |
7 years ago |
| USE tewiki_p;
desc templatelinks;
select * from templatelinks where 1 limit... |
7 years ago |
| USE tewiki_p;
desc templatelinks;
select * from templatelinks where... |
7 years ago |
| USE tewiki_p;
desc templatelinks;
sselect * from templatelinks where... |
7 years ago |
| USE tewiki_p;
desc templatelinks;
sselect * from templatelinks where... |
7 years ago |
| USE tewiki_p;
desc templatelinks;
#SELECT DISTINCT CONCAT('#... |
7 years ago |
| USE tewiki_p;
SELECT DISTINCT CONCAT('# [[',page_title,']]')
FROM page
WHERE... |
7 years ago |
| USE fawiki_p;
SELECT DISTINCT CONCAT('# [[',page_title,']]')
FROM page
WHERE... |
7 years ago |
