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 IN ({{#invoke:LuaVar|var|name=List}})
|where=Items._pageName NOT IN ({{User:Kiokurashi/sandbox2}})
|order by=Items._pageName
|order by=Items._pageName
|format:ul
|format:ul

Revision as of 21:10, 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 ') ORDER BY `mw_cargo__Items`.`_pageName` LIMIT 500' 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 () ORDER BY `mw_cargo__Items`.`_pageName` LIMIT 500