This particular repository was made for Mists of Pandaria(5.4.8), but it probably will work with other versions. If you are going to run it on other version, you will need to get a new list of zones ...
The headline is xpath_array + UNNEST: it turns a column of XML documents into shredded rows, one per matching node, in a single SQL statement: ...