Last modified: 2012-08-30 20:00:03 UTC
(Cannot reproduce due to having a 2.1 android device, someone told me about it.) Some Catalan monuments are missing, only BIC ones are displayed. I suspect this is due to using only the Spanish Wikipedia lists, which have less monuments than the Catalan lists in Catalonia (Catalan lists include lower protection monuments).
This may be because catalan lists are stored with country=es-ct and es-vc in monuments_all, instead of country='es' and adm0='ct'. I fell in that trap before. I'll change the way they are inserted.
(Assiging bug to Platonides, per comment 1)
I have changed the monuments_es-ct_(ca) and monuments_es-vc_(ca) tables to be imported with country = es. They were already imported with adm0='es' and adm1='es-ct'/'es-vc'. Hopefully fixed in r917
Multichill expressed some concerns because the primary key is (country, lang, id). But monuments_es-ct_(ca) and monuments_es-vc_(ca) don't overlap with monuments_es_(ca), so it's not an issue. select ct.bic from `monuments_es-ct_(ca)` as ct join `monuments_es_(ca)` as es on (ct.bic=es.bic) select vc.bic from `monuments_es-vc_(ca)` as vc join `monuments_es_(ca)` as es on (vc.bic=es.bic)