Untitled query #51996

SQL

#USE trwiki_p;
#SELECT CONCAT('# [[Dosya:',il_to,']]') AS "link_to",  COUNT(il_to) AS counting
#FROM page INNER JOIN imagelinks ON page_id = il_from 
#WHERE (NOT EXISTS( SELECT 1 FROM image WHERE img_name = il_to))
#AND (NOT EXISTS(SELECT 1 FROM commonswiki_p.page WHERE page_title = il_to AND page_namespace = 6))

#ORDER BY page_title
#LIMIT 100;


USE trwiki_p;
SELECT CONCAT('# [[Dosya:',il_to,']]') AS "link_to", CASE 
                                                            WHEN il_from_namespace=0 THEN CONCAT('[[',page_title,']]')
                                                            WHEN il_from_namespace=1 THEN CONCAT('[[Tartışma:',page_title,']]') 
                                                            WHEN il_from_namespace=2 THEN CONCAT('[[Kullanıcı:',page_title,']]')
                                                            WHEN il_from_namespace=3 THEN CONCAT('[[Kullanıcı_mesaj:',page_title,']]')
                                                            WHEN il_from_namespace=4 THEN CONCAT('[[Vikipedi:',page_title,']]')
                                                            WHEN il_from_namespace=5 THEN CONCAT('[Vikipedi_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=6 THEN CONCAT('[[Dosya:',page_title,']]')
                                                            WHEN il_from_namespace=7 THEN CONCAT('[Dosya_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=8 THEN CONCAT('[[MediaWiki:',page_title,']]')
                                                            WHEN il_from_namespace=9 THEN CONCAT('[MediaWiki_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=10 THEN CONCAT('[[Şablon:',page_title,']]')
                                                            WHEN il_from_namespace=11 THEN CONCAT('[[Şablon_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=12 THEN CONCAT('[[Yardım:',page_title,']]')
                                                            WHEN il_from_namespace=13 THEN CONCAT('[[Yardım_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=14 THEN CONCAT('[[Kategori:',page_title,']]')
                                                            WHEN il_from_namespace=15 THEN CONCAT('[[Kategori_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=100 THEN CONCAT('[[Portal:',page_title,']]')
                                                            WHEN il_from_namespace=101 THEN CONCAT('[[Portal_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=102 THEN CONCAT('[[Vikiproje:',page_title,']]')
                                                            WHEN il_from_namespace=103 THEN CONCAT('[[Vikiproje_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=828 THEN CONCAT('[[Modül:',page_title,']]')
                                                            WHEN il_from_namespace=829 THEN CONCAT('[[Modül_tartışma:',page_title,']]')
                                                            WHEN il_from_namespace=2300 THEN CONCAT('[[Gadget:',page_title,']]')
                                                            WHEN il_from_namespace=2301 THEN CONCAT('[[Gadget_talk:',page_title,']]')
                                                            WHEN il_from_namespace=2302 THEN CONCAT('[[Gadget_definition:',page_title,']]')
                                                            WHEN il_from_namespace=2303 THEN CONCAT('[[Gadget_definition_talk:',page_title,']]')
                                                            ELSE CONCAT('[[Diğer:',page_title,']]')
                                                            END
                                                            AS  "Madde"
FROM page JOIN imagelinks ON page_id = il_from 
WHERE (NOT EXISTS( SELECT 1 FROM image WHERE img_name = il_to))
AND (NOT EXISTS(SELECT 1 FROM commonswiki_p.page WHERE page_title = il_to AND page_namespace = 6))
ORDER BY Madde;
SQL

Checking query status...
