Not fully the topic, but i think worth to mention: few SQL stuff in the forum for list all Keywords in PL (with various aspects), and Keyword import + Keyword+Photo link SQL script. The latter is for flat (non-hierarchy) import, but i think possible to modify to handle.