Bureaucrats, Moderators (CommentStreams), Interface administrators, Push subscription managers, Suppressors, Administrators
13,284
edits
Template:CityQuerySaints: Difference between revisions
Jump to navigation
Jump to search
add color
(fix headers) |
(add color) |
||
| Line 1: | Line 1: | ||
{| class="wikitable sortable" style="width:100%; border-collapse:collapse; border:1px solid #aaa; background-color:#ffffff; font-size:95%;" | |||
! Saint !! Birth Place !! Death Place !! Notable Address 1 !! Notable Address 2 !! Notable Address 3 !! Notable Address 4 !! Notable Address 5 | |||
{{#cargo_query: | {{#cargo_query: | ||
|tables=Saints | |tables=Saints | ||
|fields= | |fields= | ||
Saints._pageName= Saint, | Saints._pageName=Saint, | ||
Saints.SaintBirthPlace= Birth Place, | Saints.SaintBirthPlace=Birth Place, | ||
Saints.DeathPlace= Death Place, | Saints.DeathPlace=Death Place, | ||
Saints.NotableAddress1= Notable Address 1, | Saints.NotableAddress1=Notable Address 1, | ||
Saints.NotableAddress2= Notable Address 2, | Saints.NotableAddress2=Notable Address 2, | ||
Saints.NotableAddress3= Notable Address 3, | Saints.NotableAddress3=Notable Address 3, | ||
Saints.NotableAddress4= Notable Address 4, | Saints.NotableAddress4=Notable Address 4, | ||
Saints.NotableAddress5= Notable Address 5 | Saints.NotableAddress5=Notable Address 5 | ||
|where= | |where= | ||
Saints.SaintBirthPlace LIKE CONCAT("%", "{{PAGENAME}}", "%") | Saints.SaintBirthPlace LIKE CONCAT("%", "{{PAGENAME}}", "%") | ||
| Line 18: | Line 21: | ||
OR Saints.NotableAddress4 LIKE CONCAT("%", "{{PAGENAME}}", "%") | OR Saints.NotableAddress4 LIKE CONCAT("%", "{{PAGENAME}}", "%") | ||
OR Saints.NotableAddress5 LIKE CONCAT("%", "{{PAGENAME}}", "%") | OR Saints.NotableAddress5 LIKE CONCAT("%", "{{PAGENAME}}", "%") | ||
|format=template | |||
|template=Saint Connection Row | |||
|named args=yes | |||
|order by=Saints._pageName | |order by=Saints._pageName | ||
|limit=500 | |limit=500 | ||
}}<noinclude>{{Doc}}</noinclude> | }} | ||
|}<noinclude>{{Doc}}</noinclude> | |||