bug #9785
Updated by Andreas Müller over 2 years ago
for details see #9772#note-24 #9772 The problem existed already befor so there are lots of data with missing unit_id (e.g. 745 records in greece_bupleurum). As recommended measurement units is usually only 1 unit per character it should be possible to reconstruct them. ~~~ SELECT deb.unit_id, deb.* FROM DescriptionElementBase deb WHERE deb.DTYPE LIKE 'Quant%' AND deb.unit_id IS NULL ORDER BY id DESC ~~~