User:Kiokurashi/sandbox: Difference between revisions
From IdleOn MMO Wiki
imported>Kiokurashi No edit summary |
imported>Kiokurashi No edit summary |
||
Line 1: | Line 1: | ||
https://idleon.info/wiki/Special:CargoTables </br> | https://idleon.info/wiki/Special:CargoTables </br> | ||
{{#invoke:LuaVar|varDefine | |||
|name=List | |||
|value={{#cargo_query: | |||
tables=Items__NEXT | |||
|fields=CONCAT('"',Items__NEXT._pageName,'"') | |||
|order by=Items__NEXT._pageName | |||
|format:ul | |||
|limit=1000 | |||
}} | |||
}} | |||
{{#cargo_query: | {{#cargo_query: | ||
tables=Items | tables=Items | ||
|fields=Items._pageName | |fields=Items._pageName | ||
|where=Items._pageName NOT | |where=Items._pageName NOT IN ({{#invoke:LuaVar|var|name=List}}) | ||
|order by=Items._pageName | |order by=Items._pageName | ||
|format:ul | |format:ul |
Revision as of 21:08, 24 March 2022
https://idleon.info/wiki/Special:CargoTables
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 '<div class="error">Error: Table Items__NEXT not found.</div>) ORDER BY `mw_c...' at line 1
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Items`.`_pageName` AS `_pageName` FROM `mw_cargo__Items` WHERE `mw_cargo__Items`.`_pageName` NOT IN (<div class="error">Error: Table Items__NEXT not found.</div>) ORDER BY `mw_cargo__Items`.`_pageName` LIMIT 500