Template:State Saints: Difference between revisions

Template:State Saints (view source)

71 bytes added , Wednesday at 03:52

loosen

13,561

edits

@@ Line 2: / Line 2: @@
 tables=Saints
 |fields=Saints.SaintName, Saints.SaintStage
-|where=Saints.SaintBirthPlace = '{{PAGENAME}}' OR Saints.DeathPlace = '{{PAGENAME}}' OR Saints.NotableAddress1 = '{{PAGENAME}}' OR Saints.NotableAddress2 = '{{PAGENAME}}' OR Saints.NotableAddress3 = '{{PAGENAME}}' OR Saints.NotableAddress4 = '{{PAGENAME}}' OR Saints.NotableAddress5 = '{{PAGENAME}}' OR Saints.BeatificationLocation = '{{PAGENAME}}' OR Saints.CanonizationLocation = '{{PAGENAME}}' OR Saints.AssocSubdivisions = '{{PAGENAME}}'
+|where=
+  Saints.SaintBirthPlace LIKE '%{{PAGENAME}}%' OR
+  Saints.DeathPlace LIKE '%{{PAGENAME}}%' OR
+  Saints.NotableAddress1 LIKE '%{{PAGENAME}}%' OR
+  Saints.NotableAddress2 LIKE '%{{PAGENAME}}%' OR
+  Saints.NotableAddress3 LIKE '%{{PAGENAME}}%' OR
+  Saints.NotableAddress4 LIKE '%{{PAGENAME}}%' OR
+  Saints.NotableAddress5 LIKE '%{{PAGENAME}}%' OR
+  Saints.BeatificationLocation LIKE '%{{PAGENAME}}%' OR
+  Saints.CanonizationLocation LIKE '%{{PAGENAME}}%' OR
+  Saints.AssocSubdivisions LIKE '%{{PAGENAME}}%'
 |format=table
 }}