distinct log_type

SQL

# Most edited visual arts articles
SELECT article.page_title, COUNT(*)
	FROM page 
    	AS article
		INNER JOIN categorylinks 
			ON cl_from = article.page_id
		INNER JOIN revision 
        	ON rev_page = article.page_id
	WHERE rev_timestamp > (NOW() - INTERVAL 7 DAY)
	AND cl_to IN ("21st-century_Canadian_artists","21st-century_Canadian_painters", "21st-century_Canadian_sculptors", 
                  "21st-century_American_artists","21st-century_American_painters", "21st-century_American_sculptors",
                  "American_installation_artists", "American_women_installation_artists", 
                  "Native_American_installation_artists"
                  "21st-century_women_artists", "Installation_artists", "Installation_artists_by_nationality", 
                  "American_installation_artists", "American_women_installation_artists", 
                  "Native_American_installation_artists", "Australian_installation_artists", 
                  "Austrian_installation_artists", "Belgian_installation_artists", "British_installation_artists", 
                  "English_installation_artists", "Canadian_installation_artists", "First_Nations_installation_artists", 
                  "Chinese_installation_artists", "Costa_Rican_installation_artists", "Danish_installation_artists", 
                  "Dutch_installation_artists", "Finnish_installation_artists", "French_installation_artists", 
                  "German_installation_artists", "Indian_installation_artists", "Iranian_installation_artists", 
                  "Irish_installation_artists", "Israeli_installation_artists", "Italian_installation_artists", 
                  "Polish_installation_artists", "Singaporean_installation_artists", "Spanish_installation_artists", 
                  "Swiss_installation_artists", "Tunisian_installation_artists", 
                  "Indigenous_installation_artists_of_the_Americas", "First_Nations_installation_artists", 
                  "Métis_installation_artists", "Native_American_installation_artists", "Land_artists", 
                  "Women_installation_artists", "Women_installation_artists_by_nationality", 
                  "American_women_installation_artists" 
                 )
	AND article.page_namespace = 0
GROUP BY article.page_title
ORDER BY COUNT(*) DESC
LIMIT 10;
SQL

Checking query status...
