Wikipédia vita:Legkeresettebb csonkok
A Wikipédiából, a szabad lexikonból.
Az SQL lekérdezés:
- 1.4:
SELECT concat('* [[', cur_title, ']] ([[Speciális:Whatlinkshere/', cur_title,
'|', count(l_from), ']])'), count(l_from) AS req
FROM cur JOIN links ON cur_id=l_to
WHERE cur_namespace = 0
AND cur_text LIKE '%{{csonk%'
GROUP BY cur_title
ORDER BY req DESC
LIMIT 100;
- 1.5:
SELECT concat('* [[', page_title, ']] ([[Speciális:Whatlinkshere/', page_title,
'|', count(pl_from), ']])'), count(pl_from) AS req
FROM page JOIN revision ON page_latest = rev_id
JOIN text ON rev_text_id = old_id
JOIN pagelinks ON page_namespace=pl_namespace AND page_title=pl_title
WHERE page_namespace = 0
AND old_text LIKE '%{{csonk%'
GROUP BY page_title
ORDER BY req DESC
LIMIT 100;
