Open giletvin opened 9 years ago
select * from bird b where not exists (select 1 from taxonomy t where t.bird_fk=b.id and t.lang='de' and t.taxon<>'');
select distinct(lang) from taxonomy order by lang;
bg cz de dk en es fi fr gr hu is it jp la nl no po pt ro ru se sk sl sr tr zh
Oiseaux islandais http://is.wikipedia.org/wiki/Listi_yfir_fugla_%C3%8Dslands
a faire : sqlite> select count(_) from bird b where not exists (select 1 from taxonomy t where t.birdfk=b.id and t.lang='ro' and t.taxon<>''); 92 sqlite> select count() from bird b where not exists (select 1 from taxonomy t where t.birdfk=b.id and t.taxon<>'' and t.lang='ro'); 92 sqlite> select count() from bird b where not exists (select 1 from taxonomy t where t.birdfk=b.id and t.taxon<>'' and t.lang='sl'); 117 sqlite> select count() from bird b where not exists (select 1 from taxonomy t where t.birdfk=b.id and t.taxon<>'' and t.lang='bg'); 76 sqlite> select count() from bird b where not exists (select 1 from taxonomy t where t.birdfk=b.id and t.taxon<>'' and t.lang='gr'); 71 sqlite> select count() from bird b where not exists (select 1 from taxonomy t where t.birdfk=b.id and t.taxon<>'' and t.lang='hu'); 95 sqlite> select count() from bird b where not exists (select 1 from taxonomy t where t.birdfk=b.id and t.taxon<>'' and t.lang='sr'); 26 sqlite> select count() from bird b where not exists (select 1 from taxonomy t where t.bird_fk=b.id and t.taxon<>'' and t.lang='tr'); 84
Par ex : aigrette garzette, peu traduite : manque l'allemand, l'italien, etc ...