Template:CityQuerySaints: Difference between revisions

Jump to navigation Jump to search
fix headers
(doc)
(fix headers)
Line 1: Line 1:
{{#cargo_query:
{{#cargo_query:
|tables=Saints
|tables=Saints
|fields=Saints._pageName, Saints.SaintBirthPlace, Saints.DeathPlace,  
|fields=
        Saints.NotableAddress1, Saints.NotableAddress2, Saints.NotableAddress3,  
    Saints._pageName= Saint,
        Saints.NotableAddress4, Saints.NotableAddress5
    Saints.SaintBirthPlace= Birth Place,
    Saints.DeathPlace= Death Place,
    Saints.NotableAddress1= Notable Address 1,
    Saints.NotableAddress2= Notable Address 2,
    Saints.NotableAddress3= Notable Address 3,
    Saints.NotableAddress4= Notable Address 4,
    Saints.NotableAddress5= Notable Address 5
|where=
|where=
     Saints.SaintBirthPlace LIKE CONCAT("%", "{{PAGENAME}}", "%")
     Saints.SaintBirthPlace LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.DeathPlace LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.DeathPlace       LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress1 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress1 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress2 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress2 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress3 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress3 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress4 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress4 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress5 LIKE CONCAT("%", "{{PAGENAME}}", "%")
   OR Saints.NotableAddress5 LIKE CONCAT("%", "{{PAGENAME}}", "%")
|order by=Saints._pageName
|order by=Saints._pageName
|limit=500
|limit=500
}}<noinclude>{{Doc}}</noinclude>
}}<noinclude>{{Doc}}</noinclude>

Navigation menu