SELECT *
FROM category
LEFT JOIN categorylinks ON cl_to = cat_title
WHERE... |
5 years ago |
SELECT *
FROM category
LEFT JOIN categorylinks ON cl_to = cat_title
WHERE... |
5 years ago |
SELECT *
FROM category
LEFT JOIN categorylinks ON cl_to = cat_title
WHERE... |
5 years ago |
SELECT *
FROM category
WHERE cat_subcats = 0
AND cat_title NOT LIKE... |
5 years ago |
SELECT *
FROM category
WHERE cat_subcats = 0
AND cat_title NOT LIKE... |
5 years ago |
SELECT *
FROM category
WHERE cat_subcats = 0
ORDER BY cat_pages DESC
LIMIT 500 |
5 years ago |
SELECT *
FROM category
WHERE cat_subcats = 0
LIMIT 500 |
5 years ago |
SELECT *
FROM category
LIMIT 500 |
5 years ago |
use enwiki_p;
SELECT *
FROM category
LIMIT 500 |
5 years ago |
use enwiki_p;
SELECT categorylinks.*
FROM `categorylinks`
LEFT JOIN `page`... |
5 years ago |
use enwiki_p;
SELECT categorylinks.*
FROM `categorylinks`
LEFT JOIN `page`... |
5 years ago |
use enwiki_p;
SELECT 14 AS `namespace`,cl_to AS `title`,COUNT(*) AS... |
5 years ago |