User:Teamtoto/Sandbox: Difference between revisions

Jump to navigation Jump to search
176 bytes added ,  23:06, 23 February 2020
m
no edit summary
mNo edit summary
mNo edit summary
Line 1: Line 1:
==List of Static Water Ritualable Characters==
{{#cargo_query:tables=GeneralData=GD, ExtraInfo=EI
|join on=GD.JoinKey=EI.JoinKey
|fields=GD._pageName
|where=EI.Info LIKE '%Ritualable,,,%'
}}




Line 19: Line 25:
| groupstyle = background:rgba(6,28,23,0.0); font-family:Source Code Pro;
| groupstyle = background:rgba(6,28,23,0.0); font-family:Source Code Pro;
| group1    =Meat
| group1    =Meat
| list1    =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND  ParentObject WITHIN 'Food' AND NOT (ParentObject WITHIN 'Preservable') AND FoodContains LIKE "%Meat%"
| list1    =<span style="display:inline-block">{{#cargo_query:tables=Food=F,GeneralData=GD|join on=F._pageName=GD._pageName|fields=CONCAT('[[',F._pageName,'{{!}}',PlainName,']]')=Page
|where=GD._pageNamespace='0' AND  ParentObject WITHIN 'Food' AND Categories = 'Food' AND FoodContains LIKE "%Meat%"
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>


| group3style = background:rgba(6,28,23,0.2);
| group3style = background:rgba(6,28,23,0.2);
| group3    =Plant
| group3    =Plant
| list3    =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND ParentObject WITHIN 'Food' AND FoodContains LIKE "%Plant%"
| list3    =<span style="display:inline-block">{{#cargo_query:tables=Food=F,GeneralData=GD|join on=F._pageName=GD._pageName|fields=CONCAT('[[',F._pageName,'{{!}}',PlainName,']]')=Page
|where=GD._pageNamespace='0' AND ParentObject WITHIN 'Food' AND Categories = 'Food' AND FoodContains LIKE "%Plant%"
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>


| group4style = background:rgba(6,28,23,0.2);
| group4style = background:rgba(6,28,23,0.2);
| group4    =Fungi
| group4    =Fungi
| list4    =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND ParentObject WITHIN 'Food' AND FoodContains LIKE "%Fungi%"
| list4    =<span style="display:inline-block">{{#cargo_query:tables=Food=F,GeneralData=GD|join on=F._pageName=GD._pageName|fields=CONCAT('[[',F._pageName,'{{!}}',PlainName,']]')=Page
|where=GD._pageNamespace='0' AND ParentObject WITHIN 'Food' AND Categories = 'Food' AND FoodContains LIKE "%Fungi%"
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>


| group5style = background:rgba(6,28,23,0.2);
| group5style = background:rgba(6,28,23,0.2);
| group5    =Etc
| group5    =Etc
| list5    =<span style="display:inline-block">{{#cargo_query:tables=Food,GeneralData|join on=Food._pageName=GeneralData._pageName|fields=CONCAT('[[',Food._pageName,'{{!}}',PlainName,']]')=Page|where=GeneralData._pageNamespace='0' AND ParentObject WITHIN 'Food' AND FoodContains='none'
| list5    =<span style="display:inline-block">{{#cargo_query:tables=Food=F,GeneralData=GD|join on=F._pageName=GD._pageName|fields=CONCAT('[[',F._pageName,'{{!}}',PlainName,']]')=Page
|where=GD._pageNamespace='0' AND ParentObject WITHIN 'Food' AND Categories = 'Food' AND FoodContains = "None"
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
|format=list|delimiter=&nbsp;-&nbsp;</span><span style="display:inline-block">}}</span>
}}
}}

Navigation menu