User:Teamtoto/Sandbox: Difference between revisions

User:Teamtoto/Sandbox (view source)

517 bytes added , 17:12, 8 June 2021

m

no edit summary

8,756

edits

@@ Line 25: / Line 25: @@
 |where = F.Old="1" AND IsVisible="1"
 }}-->
+<table class="wikitable"><tr><th>Body Parts of a {{{name|Turret}}}</th></tr><tr><td>
+<ul><li>[[List of Body Parts#Body|Body]]
+<li>[[List of Body Parts#Floating Nearby|Floating Nearby]]
+{{#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>", childType, " (", childBaseType, ")</ul>") ELSE "" END))=Page
+ | template=single query result
+ | delimiter = </br>
+ | limit = 1000
+}}
+</ul></td></tr></table>
 <table class="wikitable"><tr><th>Blueprint</th><th>Body Parts</th></tr>
 {{#invoke:CargoQuery|main
   |table=Anatomies=A
   |fields=Name=blueprint
-  |one_to_many=(CONCAT("<li> [[List of Body Parts#",
+  |one_to_many=(CONCAT("<li> [[List of Body Parts#", BaseType, "{{!}}", COALESCE(CONCAT(Laterality, " "), ""), Type, "]]", (CASE WHEN childType <> "" THEN CONCAT("<ul><li>", childType, " (", childBaseType, ")</ul>")ELSE "" END)))=bodyparts
-   BaseType, "{{!}}",
-   COALESCE(CONCAT(Laterality, " "), ""),
-   Type, "]]",
-   (CASE
-     WHEN childType <> ""
-     THEN CONCAT("<ul><li>",
-                  childType, " (",
-                  childBaseType, ")</ul>")
-     ELSE ""
-     END)))=bodyparts
   |one_to_many_group=blueprint
   |one_to_many_sep=&nbsp;