simplified queries by extracting the unaliasing step
added indexes to reference link tables
added plants files and adapted the scripts
removed obsolete files