| Revision as of 06:44, 16 January 2011 editVegaswikian (talk | contribs)270,510 edits Lower limit to 15,000 to display more pages to facilitate cleanup← Previous edit |
Revision as of 16:42, 6 February 2011 edit undoMZMcBride (talk | contribs)Extended confirmed users190,642 edits →longstubs.py: updated sectionNext edit → |
| Line 27: |
Line 27: |
|
|
|
|
|
report_template = u''' |
|
report_template = u''' |
|
Pages in categories that end in "stubs" and whose page length is greater than \ |
|
Long pages in categories that end in "stubs" (limited to the first 1000 entries); \ |
|
15,000 bytes; data as of <onlyinclude>%s</onlyinclude>. |
|
data as of <onlyinclude>%s</onlyinclude>. |
|
|
|
|
|
{| class="wikitable sortable plainlinks" style="width:100%%; margin:auto;" |
|
{| class="wikitable sortable plainlinks" style="width:100%%; margin:auto;" |
| Line 47: |
Line 47: |
|
cursor.execute(''' |
|
cursor.execute(''' |
|
/* longstubs.py SLOW_OK */ |
|
/* longstubs.py SLOW_OK */ |
|
SELECT DISTINCT |
|
SELECT |
|
page_title, |
|
page_title, |
|
page_len |
|
page_len |
| Line 53: |
Line 53: |
|
JOIN categorylinks |
|
JOIN categorylinks |
|
ON cl_from = page_id |
|
ON cl_from = page_id |
|
WHERE cl_to LIKE "%stubs" |
|
WHERE cl_to LIKE '%stubs' |
|
AND page_len > 15000 |
|
AND page_namespace = 0 |
|
AND page_namespace = 0; |
|
AND page_len > 2000 |
|
|
GROUP BY page_title |
|
|
ORDER BY page_len DESC |
|
|
LIMIT 1000; |
|
''') |
|
''') |
|
|
|
|