| use frwiki_p;
SELECT count(*) as nb_pages_with_template
FROM revision
join... |
4 years ago |
| use frwiki_p;
SELECT count(*) as nb_pages_with_template
FROM revision
join... |
4 years ago |
| use frwiki_p;
SELECT
page_title,
content.*
FROM revision
join page on... |
4 years ago |
| use frwiki_p;
SELECT
page_title,
content.*
FROM revision
join page on... |
4 years ago |
| use frwiki_p;
SELECT
page_title,
rev_id
FROM revision
join page on... |
4 years ago |
| use frwiki_p;
SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from =... |
4 years ago |
| use frwiki_p;
SELECT
distinct tl_title
FROM templatelinks
where tl_title... |
4 years ago |
| use frwiki_p;
SELECT
distinct tl_title
FROM templatelinks
limit 200; |
4 years ago |
| use frwiki_p;
SELECT
*
FROM templatelinks; |
4 years ago |
| use frwiki_p;
SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from =... |
4 years ago |
| use frwiki_p;
SELECT
page_title
FROM page
JOIN templatelinks
ON tl_from =... |
4 years ago |
| SHOW TABLES FROM frwiki_p; |
4 years ago |
| SHOW TABLES FROM frwiki_p |
4 years ago |
