Benutzer Diskussion:SirJective/Wartungslisten/Identische Bildbeschreibung

Verwendete Abfrage:

drop table if exists de_commons;
create table de_commons
select de.cur_title
from cur as de,
commons_20050203.cur as other
where de.cur_namespace = 6
and other.cur_namespace = 6
and de.cur_title = other.cur_title
and de.cur_text = other.cur_text;

select concat('*[[:Bild:', cur_title,']]',
if (im.img_name IS NULL,'',concat(' ',im.img_size,' Bytes ')),
' - [[:commons:Image:', cur_title,'|commons]]',
if (cim.img_name IS NULL,'',concat(' ',cim.img_size,' Bytes ')))
from de_commons left join
image as im on (cur_title = im.img_name)
left join commons_20050203.image as cim on (cur_title = cim.img_name)
order by cur_title;

--SirJective 20:22, 8. Feb 2005 (CET)