User:Egocarib/Sandbox
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND GeneralData.ParentObject <> 'NaturalWeapon'|format=template|template=favilink ul query}}
Template:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul query
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND (ItemsTable.Extra HOLDS NOT LIKE 'Not Unequippable')|format=template|template=favilink ul query}}
Function: CargoSQLQuery::run Query: SELECT `ItemsTable`.`_pageName` AS `_pageName` FROM `ItemsTable` LEFT OUTER JOIN `GeneralData` ON ((`ItemsTable`.`_pageName`=`GeneralData`.`_pageName`)) WHERE `ItemsTable`.`_pageNamespace`='0' AND `ItemsTable`.`Vibro`='1' AND (`ItemsTable`.`Extra` HOLDS NOT LIKE 'Not Unequippable') ORDER BY `ItemsTable`.`_pageName` LIMIT 100
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1' AND GeneralData.Image LIKE '%.png'|format=template|template=favilink ul query}}
Template:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul query
{{#cargo_query:table=ItemsTable,GeneralData|fields=ItemsTable._pageName|join on=ItemsTable._pageName=GeneralData._pageName|where=ItemsTable._pageNamespace='0' AND ItemsTable.Vibro='1'|format=template|template=favilink ul query}}
Template:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul queryTemplate:Favilink ul query
/9 4 | |
Damage
|
2d122-24 (Avg: 13) |
Weight
|
1# |