21 lines
1,006 B
Markdown
21 lines
1,006 B
Markdown
## Data Sources
|
|
|
|
For original / canon information, the following sources are used:
|
|
|
|
* Files ``pokedex_pokemon.${lang}.dic`` are fed from Bulbapedia's page of "List of Pokémon in other languages" and from a veekun schema-compatible database listing.
|
|
* Files ``moves.${lang}.dic`` are fed from Bulbapedia's page of "List of moves in other languages" and from a veekun schema-compatible database listing.
|
|
* Other files are fed from Bulbapedia's tabular data pages on internationalization, such as ["List of locations in other languages"](https://bulbapedia.bulbagarden.net/wiki/List_of_locations_in_other_languages)
|
|
|
|
The following SQL query, applied to a Veekun "pokedex" schema, extracts in its second column the names for Pokémon in a given ISO language code ("``{lang}``"):
|
|
|
|
```
|
|
select P.id, PN.name
|
|
FROM
|
|
pokemon P
|
|
left join pokemon_species_names PN
|
|
on PN.pokemon_species_id = P.id
|
|
join languages L on PN.local_language_id=L.id
|
|
and L.identifier={lang}
|
|
where P.id is not null
|
|
order by P.id, L.id
|
|
```
|