8,290
edits
Template:Walls Navbox: Difference between revisions
m
title tweaks
m (exclude Data namespace) |
m (title tweaks) |
||
| Line 79: | Line 79: | ||
| tables = Characters=C, GeneralData=GD | | tables = Characters=C, GeneralData=GD | ||
| join on = C.ObjectID=GD.ObjectID | | join on = C.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{!}}{{(}}lcfirst:',GD._pageName,'{{)}}{{)}}')=Page | ||
| where = GD.Categories = 'Tech Walls' AND GD._pageNamespace = '0' | | where = GD.Categories = 'Tech Walls' AND GD._pageNamespace = '0' | ||
| format = list | | format = list | ||
| Line 107: | Line 107: | ||
| tables = Characters=C, GeneralData=GD | | tables = Characters=C, GeneralData=GD | ||
| join on = C.ObjectID=GD.ObjectID | | join on = C.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{!}}{{(}}lcfirst:',GD._pageName,'{{)}}{{)}}')=Page | ||
| where = GD.Categories = 'Sultan Walls' AND GD._pageNamespace = '0' | | where = GD.Categories = 'Sultan Walls' AND GD._pageNamespace = '0' | ||
| format = list | | format = list | ||
| Line 121: | Line 121: | ||
| tables = Characters=C, GeneralData=GD | | tables = Characters=C, GeneralData=GD | ||
| join on = C.ObjectID=GD.ObjectID | | join on = C.ObjectID=GD.ObjectID | ||
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page | | fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{!}}{{(}}lcfirst:',GD._pageName,'{{)}}{{)}}')=Page | ||
| where = GD.Categories = 'Murals' AND GD._pageNamespace = '0' | | where = GD.Categories = 'Murals' AND GD._pageNamespace = '0' | ||
| format = list | | format = list | ||