SELECT CONCAT('# [[Utente:', rev_user_text, ']] (', COUNT(*), ')')
FROM page, revision
WHERE page_id NOT IN
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'wikibase_item')
AND page_namespace = 0
AND page_is_redirect = 0
AND page_id = rev_page
AND rev_parent_id = 0
GROUP BY rev_user_text
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 1000;
CONNECT itwiki_p itwiki.labsdb;
SELECT CONCAT('# [[Utente:', rev_user_text, ']] (', COUNT(*), ')')
FROM page, revision
WHERE page_id NOT IN
(SELECT pp_page
FROM page_props
WHERE pp_propname = 'wikibase_item')
AND page_namespace = 0
AND page_is_redirect = 0
AND page_id = rev_page
AND rev_parent_id = 0
GROUP BY rev_user_text
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
LIMIT 1000;
Fix db connect in query/voci_senza_elemento_wikidat_per_creatore
Fix db connect in query/voci_senza_elemento_wikidat_per_creatore
