Önskelista/nyhetsbrev

Exempel: Du har gjort X redigeringar senaste veckan (+X jämfört med veckan innan). Du har redigerat i X olika artiklar. Artiklarna du har redigerat i har visats X gånger senaste veckan. Artikeln som visades mest (x gånger) var X. Du har totalt gjort X redigeringar i X artiklar.

Queries

Edits last week

SELECT COUNT(*) AS 'Edits last week' FROM svwiki_p.revision
JOIN svwiki_p.page ON rev_page = page_id
JOIN svwiki_p.user ON rev_user = user_id
WHERE page_namespace = 0
AND user_name = '@username'
AND rev_timestamp  >  DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 8 DAY),'%Y%m%d%H%i%s')

Different articles edited last week

SELECT COUNT(DISTINCT rev_page) AS 'Articles last week' FROM svwiki_p.revision
JOIN svwiki_p.page ON rev_page = page_id
JOIN svwiki_p.user ON rev_user = user_id
WHERE page_namespace = 0
AND user_name = '@username'
AND rev_timestamp  >  DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 8 DAY),'%Y%m%d%H%i%s')

Edits in total

SELECT COUNT(*) AS 'Edits in total' FROM svwiki_p.revision
JOIN svwiki_p.page ON rev_page = page_id
JOIN svwiki_p.user ON rev_user = user_id
WHERE page_namespace = 0
AND user_name = '@username'

Different articles edited in total

SELECT COUNT(DISTINCT rev_page) AS 'Articles in total' FROM svwiki_p.revision
JOIN svwiki_p.page ON rev_page = page_id
JOIN svwiki_p.user ON rev_user = user_id
WHERE page_namespace = 0
AND user_name = '@username'