Untitled query #84840

SQL

SELECT CONCAT('[[',
	CASE page_namespace
    	WHEN   0 THEN ''
    	WHEN   1 THEN 'Disccussion:'
        WHEN   2 THEN 'Utilisateur:'
        WHEN   3 THEN 'Discussion Utilisateur:'
    	WHEN   4 THEN 'Wikipedia:'
    	WHEN   5 THEN 'Disccussion Wikipedia:'
    	WHEN   8 THEN 'Mediawiki:'
        WHEN   9 THEN 'Discussion Mediawiki:'
        WHEN  10 THEN 'Modèle:'
    	WHEN  11 THEN 'Discussion Modèle:'
        WHEN  12 THEN 'Aide:'
    	WHEN  13 THEN 'Discussion Aide:'
        WHEN  14 THEN 'Categorie:'
    	WHEN  15 THEN 'Disccussion categorie:'
    	WHEN 100 THEN 'Portail:'
        WHEN 101 THEN 'Discussion Portail:'
        WHEN 102 THEN 'Projet:'
        WHEN 103 THEN 'Discussion Projet:'
        WHEN 828 THEN 'Module:'     
        WHEN 829 THEN 'Discussion Module:'
        ELSE page_namespace
    END, REPLACE(page_title,'_',' '), ']]') AS link,
	rev_timestamp AS timestamp, 
    comment_text AS `comment`, 
    actor_name AS `user`
FROM page, revision, `comment`, actor
WHERE page_len=0 AND page_namepsace <> 3 AND page_latest=rev_id AND rev_comment_id=comment_id AND rev_actor=actor_id
ORDER BY rev_timestamp DESC
SQL

Checking query status...
