| SELECT page_id, page_title
FROM categorylinks
JOIN page ON page_id =... |
2 years ago |
| SELECT *
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE cl_to =... |
2 years ago |
| SELECT IF(page_namespace = 0, 'category', 'article') page_id
FROM... |
2 years ago |
| SELECT *
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE cl_to =... |
2 years ago |
| select cl_to from categorylinks; |
2 years ago |
| SELECT *
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE cl_to =... |
2 years ago |
| SELECT IF(page_namespace = 6, 'category', 'article') as type, page_title... |
2 years ago |
