Difference between revisions of "Template:LookupCountry"
m (Zocky moved page LookupCountries to LookupCountry without leaving a redirect) |
|||
Line 1: | Line 1: | ||
− | {"pfautocomplete":[{{#arr:join|{{#data:selectcolumn|title = CONCAT('{"title":',to_json(Event.Country)::text, '}')|#where=Event.Country <>'' AND Event.Country ILIKE '%{{#cgi:q|}}%'|#limit=2000}}|,}}]} | + | {"pfautocomplete":[{{#arr:join|{{#data:selectcolumn|title = CONCAT('{"title":',to_json(Event.Country)::text, '}')|#where=Event.Country <>'' AND Event.Country ILIKE '%{{#cgi:q|}}%'|#limit=2000|#orderby=1}}|,}}]} |
Latest revision as of 17:49, 14 November 2024
{"pfautocomplete":[{"title":"Albania"},{"title":"Algeria"},{"title":"Argentina"},{"title":"Armenia"},{"title":"Australia"},{"title":"Austria"},{"title":"Azerbaijan"},{"title":"Belarus"},{"title":"Belgium"},{"title":"Bolivia"},{"title":"Bosnia_and_Herzegovina"},{"title":"Botswana"},{"title":"Brazil"},{"title":"Bulgaria"},{"title":"Burkina_Faso"},{"title":"Cameroon"},{"title":"Canada"},{"title":"Chile"},{"title":"China"},{"title":"Colombia"},{"title":"Costa_Rica"},{"title":"Croatia"},{"title":"Cuba"},{"title":"Cyprus"},{"title":"Czech_Republic"},{"title":"Denmark"},{"title":"Dominican_Republic"},{"title":"Ecuador"},{"title":"Egypt"},{"title":"Estonia"},{"title":"Ethiopia"},{"title":"Finland"},{"title":"France"},{"title":"Georgia"},{"title":"Germany"},{"title":"Ghana"},{"title":"Greece"},{"title":"Hungary"},{"title":"Iceland"},{"title":"India"},{"title":"Indonesia"},{"title":"Iran"},{"title":"Ireland"},{"title":"Israel"},{"title":"Italy"},{"title":"Ivory_Coast"},{"title":"Japan"},{"title":"Jordan"},{"title":"Kazakhstan"},{"title":"Kosovo"},{"title":"Kuwait"},{"title":"Kyrgyzstan"},{"title":"Latvia"},{"title":"Lebanon"},{"title":"Lithuania"},{"title":"Luxembourg"},{"title":"Malta"},{"title":"Mauritius"},{"title":"Mexico"},{"title":"Mongolia"},{"title":"Montenegro"},{"title":"Nepal"},{"title":"Netherlands"},{"title":"Nicaragua"},{"title":"Nigeria"},{"title":"Northern_Ireland"},{"title":"North_Korea"},{"title":"North_Macedonia"},{"title":"Norway"},{"title":"Oman"},{"title":"Paraguay"},{"title":"People's_Republic_of_China"},{"title":"Peru"},{"title":"Philippines"},{"title":"Poland"},{"title":"Portugal"},{"title":"Romania"},{"title":"Russia"},{"title":"Saudi_Arabia"},{"title":"Serbia"},{"title":"Singapore"},{"title":"Slovakia"},{"title":"South_Africa"},{"title":"South_Korea"},{"title":"Spain"},{"title":"Sri_Lanka"},{"title":"Swaziland"},{"title":"Sweden"},{"title":"Switzerland"},{"title":"Taiwan"},{"title":"Thailand"},{"title":"Trinidad_and_Tobago"},{"title":"Tunisia"},{"title":"Turkey"},{"title":"Ukraine"},{"title":"United_Arab_Emirates"},{"title":"United_Kingdom"},{"title":"Uruguay"},{"title":"USA"},{"title":"Uzbekistan"},{"title":"Vatican_City"},{"title":"Venezuela"},{"title":"Vietnam"}]}