User:Teamtoto/Sandbox: Difference between revisions

610 bytes removed ,  01:50, 4 April 2021
m
no edit summary
mNo edit summary
mNo edit summary
Line 1: Line 1:
=== Regen < 5 ===
{{#cargo_query:table=Effects
|fields =CONCAT('[[', _pageName, '{{!}}', PlainName, ']]')
|where = Type RLIKE "111[01]{24}$" AND (Type RLIKE "1[01]{13}$" OR Type RLIKE "1[01]{10}$" OR Type RLIKE "1[01]{4}$" OR Type RLIKE "1[01]{3}$" OR Type RLIKE "1[01]{2}$")
|format = ul
|columns = 3}}
=== Regen >= 5 ===
{{#cargo_query:table=Effects
|fields =CONCAT('[[', _pageName, '{{!}}', PlainName, ']]')
|where = Type RLIKE "110[01]{24}$" AND (Type RLIKE "1[01]{13}$" OR Type RLIKE "1[01]{10}$" OR Type RLIKE "1[01]{4}$" OR Type RLIKE "1[01]{3}$" OR Type RLIKE "1[01]{2}$")
|format = ul
|columns = 3}}


<!--{{#invoke:cargo_query|main
<!--{{#invoke:cargo_query|main
Line 19: Line 6:
| delimiter = </br>
| delimiter = </br>
|where = F.Old="1" AND IsVisible="1"
|where = F.Old="1" AND IsVisible="1"
}}-->
}}
{{#invoke:CargoQuery|main
{{#invoke:CargoQuery|main
  |table=Anatomies=A
  |table=Anatomies=A
Line 29: Line 16:
  | limit = 1000
  | limit = 1000
}}
}}
TODO: concat laterality and include child stuff, format it prettier?
TODO: concat laterality and include child stuff, format it prettier?-->