User:Teamtoto/Sandbox: Difference between revisions

681 bytes removed ,  01:33, 13 June 2021
m
no edit summary
mNo edit summary
mNo edit summary
Line 26: Line 26:
|where = F.Old="1" AND IsVisible="1"
|where = F.Old="1" AND IsVisible="1"
}} }} }}-->
}} }} }}-->
{{#invoke:infobox|infobox
|rows={{infobox row||Extra info:</br><ul><li>fhdsjfksd</ul><hr>}}
{{infobox row|field=<div style="text-align:center;padding:2px"><b>Body Plan: {{{bodytype}}}</b></div>}}
{{infobox row||{{#invoke:CargoQuery|main
|table=Anatomies=A
| where = Name="{{{name|Turret}}}"
|fields=CONCAT("<li> [[List of Body Parts#", BaseType, "{{!}}", COALESCE(CONCAT(Laterality, " "), ""), Type, "]]", (CASE WHEN childType <> "" THEN CONCAT("<ul><li> [[List of Body Parts#", childBaseType, "{{!}}", COALESCE(CONCAT(childLaterality, " "), ""), childType, "]]</ul>") ELSE "" END))=Page
| format=ul
| template=single query result
| delimiter = </br>
| limit = 1000
}}}}}}
<table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr>
<table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr>
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main