Tango.info venue code

A tango.info venue code (formerly location code) is a tango.info object code composed of a city code, mostly a lower case representation of a UN/LOCODE, and a substring, consisting of two letters and 3 numbers.

regex: [a-z]{7}[0-9]{3}

e.g. deberms001, deberms002

• city by UN/LOCODE: DEBER, lower case: deber
• venue 2-char short code: MS, lower case ms
• serial number: 001, 002

Codes before 2011-09-08

e.g. ARBUE, UN/LOCODE for Buenos Aires (https://tango.info/ARBUE)

• ARBUE-CN - Salon Canning (http://www.tango.info/ARBUE-CN)
• ARBUE-CS - Club Castel (http://www.tango.info/ARBUE-CS)

Duplicates in the old system

• DEBER-BL https://tango.info/deberbl001 https://tango.info/deberbl002
  • Gasthaus Babel, Belle Etage
• DEBER-BP https://tango.info/deberbp001 https://tango.info/deberbp002
  • new address in 2011
• DEBER-MS https://tango.info/deberms001 https://tango.info/deberms002
  • address change
• DEBER-OB https://tango.info/deberob001 https://tango.info/deberob002
  • name change in ??
• DEBER-RW https://tango.info/deberrw001 https://tango.info/deberrw002
  • room change
• DEBER-VV https://tango.info/debervv001 https://tango.info/debervv002
  • one address until 2009

SQL - Find wiki articles with an old code

SELECT page_id, page_title, page_is_redirect 
FROM mul_page 
WHERE 1 AND page_namespace = 0 
 AND mul_page.page_title RLIKE '_[A-Z]{5}-[A-Z]{2}_' 
 AND page_is_redirect = 0 
ORDER BY page_title