USE trwiki_p;

set @tmp = "Temizleme";

set @kat = replace("Vikipedi temizleme"," ","_");

set @pgad = "Firefly";

​

select * from page 

join categorylinks on cl_from = page_id 

-- left join templatelinks on tl_from = page_id

​

where page_title = @pgad and page_namespace = 0

and cl_to = @kat

​

​

​

limit 50;

​

​

​

​

;