some issues with patstat

here you can find the presentation I made in Rio about 7 mayor issues in patstat data, referred to version 2012, and ways to sole them.
Sooner or later I'll also post some sql coce for implementing the proposed solutions...