Difference between revisions of "SQLAllNames"

From Sega Retro

(Created page with "<includeonly>{{#vardefine:namefield|{{{1|}}}}}{{#cargo_query: table=localisednames |fields=localisedname |where=pagename="{{{2|}}}" |limit=10000 |format=template |template=SQL...")
 
Line 1: Line 1:
<includeonly>{{#vardefine:namefield|{{{1|}}}}}{{#cargo_query:
+
<includeonly>{{#vardefine:namefield|{{{1|}}}}} {{#var:namefield}}="{{{2|}}}" OR {{#sub:{{#cargo_query:
 
table=localisednames
 
table=localisednames
 
|fields=localisedname
 
|fields=localisedname
Line 6: Line 6:
 
|format=template
 
|format=template
 
|template=SQLAllNames/Cargo
 
|template=SQLAllNames/Cargo
}}</includeonly><noinclude>
+
}}|0|-3}}</includeonly><noinclude>
  
 
Template for handling localised names in SQL queries
 
Template for handling localised names in SQL queries

Revision as of 08:42, 7 May 2022


Template for handling localised names in SQL queries

e.g.

{{SQLAllNames|name|The Jungle Book}}
name="The Jungle Book" OR name="Das Dschungelbuch" OR name="El Libro de la Selva" OR name="Il Libro Della Giungla" OR name="Le Livre de la Jungle" OR name="O livro da Selva"