Skip to content

Instantly share code, notes, and snippets.

@alexander-arce

alexander-arce/Mexican cities

Last active August 29, 2015 14:13
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alexander-arce/50ca8e9b2c13623e178b to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alexander-arce/50ca8e9b2c13623e178b to your computer and use it in GitHub Desktop.
Download ZIP
States, cities Id's from OpenErp
Raw
Mexican cities
SELECT RCSC.ID, RCSC.NAME,MD.NAME,RCSC.state_id
FROM IR_MODEL_DATA AS MD
JOIN res_country_state_city AS RCSC ON RCSC.ID=MD.RES_ID
WHERE MODULE='l10n_mx_cities'
Raw
Mexican states
SELECT MD.RES_ID , RCS.ID,RCS.NAME,MD.NAME
FROM IR_MODEL_DATA AS MD
JOIN RES_COUNTRY_STATE AS RCS ON RCS.ID=MD.RES_ID
WHERE MODULE='l10n_mx_states'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment