Bureaucrats, Moderators (CommentStreams), Interface administrators, Push subscription managers, Suppressors, Administrators
13,262
edits
Template:CityQuerySaints/sandbox: Difference between revisions
add title
(Created page with "{{#cargo_query: |tables=Saints |fields=Saints._pageName, Saints.SaintBirthPlace, Saints.DeathPlace, Saints.NotableAddress1, Saints.NotableAddress2, Saints.NotableAddress3, Saints.NotableAddress4, Saints.NotableAddress5 |where= Saints.SaintBirthPlace LIKE CONCAT("%", "{{PAGENAME}}", "%") OR Saints.DeathPlace LIKE CONCAT("%", "{{PAGENAME}}", "%") OR Saints.NotableAddress1 LIKE CONCAT("%", "{{PAGENAME}}", "%") OR Saints.NotableAddress2 LIKE CONC...") |
(add title) |
||
| Line 1: | Line 1: | ||
{{#cargo_query: | {{#cargo_query: | ||
|tables=Saints | |tables=Saints | ||
|fields=Saints._pageName, Saints.SaintBirthPlace, Saints.DeathPlace, | |fields= | ||
Saints._pageName= Saint, | |||
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 | ||
}} | }} | ||