Most wanted articles: ns0→ns0 redlinks only

SQL

SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'your_table_name';
/*
SELECT pl_title AS Target, COUNT(IF(page_title IS NULL, 1, NULL)) AS LinkCount
FROM pagelinks
LEFT JOIN page ON page_namespace = 0 AND page_title = pl_title
WHERE pl_from_namespace = 0 AND pl_namespace = 0 AND pl_title >= 'L' AND pl_title < 'M'
GROUP BY Target
HAVING LinkCount > 500
ORDER BY LinkCount DESC;
*/

AخA
 
SELECT COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTHFROM INFORMATION_SCHEMA.COLUMNSWHERE TABLE_NAME = 'your_table_name';/*SELECT pl_title AS Target, COUNT(IF(page_title IS NULL, 1, NULL)) AS LinkCountFROM pagelinksLEFT JOIN page ON page_namespace = 0 AND page_title = pl_titleWHERE pl_from_namespace = 0 AND pl_namespace = 0 AND pl_title >= 'L' AND pl_title < 'M'GROUP BY TargetHAVING LinkCount > 500ORDER BY LinkCount DESC;*/

SQL

Checking query status...