User:Egocarib/Sandbox: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<syntaxhighlight lang="html">{{#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}}</syntaxhighlight> | <syntaxhighlight lang="html">{{#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}}</syntaxhighlight> | ||
{{#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}} | {{#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}} | ||
<syntaxhighlight lang="html">{{#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}}</syntaxhighlight> | |||
{{#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}} | |||
Revision as of 17:18, 1 September 2019
{{#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}}
Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'HOLDS NOT LIKE 'Not Unequippable') ORDER BY `ItemsTable`.`_pageName` LIMIT 100' at line 1 (localhost)
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'|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
throwing axe
|
4/9 | |
Damage
|
|
Weight
|
1# |
