test image table

SQL

#use ruwiki_p;
/*slow
select c.img_name, ru.img_name, ru.img_size, ru.img_width, ru.img_height, c.img_user_text, ru.img_user_text, ru.img_timestamp, ru.img_sha1
from image ru join commonswiki_p.image c on ru.img_sha1=c.img_sha1*/
/*where #img_name = "Флаг_Люботина.Jpg";
img_sha1 in (select img_sha1 from commonswiki_p.image)*/
use ukwiki_p;
select CONCAT('#[[:File:',img_name,']]')
from image
where /*img_name in (select img_name from rowiki_p.image) and */
img_sha1 in (select img_sha1 from rowiki_p.image)
SQL

Checking query status...
