Untitled query #19149

SQL

#USE dewiki_p;
##SELECT rev_user_text AS IP, rev_timestamp AS Datetime
#FROM [dewiki_p].[dbo].[revision] JOIN [dewiki_p].[dbo].[page] ON page_id = rev_page 
#WHERE page_title = "Palina_Rojinski" AND page_namespace = "0"
#AND rev_user = 0
#ORDER BY Datetime DESC

USE simplewiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime, page_title
FROM page JOIN categorylinks ON cl_from = page_id
JOIN revision ON page_id = rev_page 
WHERE cl_to = "Computer_science" AND page_namespace = "0"
AND rev_user = 0
GROUP BY IP, Datetime
ORDER BY Datetime DESC

#Output_devices
SQL

Checking query status...
