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> | ||
{{#cargo_query: | |||
tables=Cards | |||
|fields=Cards._pageName | |||
|where=Cards._pageName NOT IN ({{#cargo_query: | |||
tables=Cards__NEXT | |||
|fields=CONCAT('"',Cards__NEXT._pageName,'"') | |||
|order by=Cards__NEXT._pageName | |||
|format:ul | |||
|limit=1500 | |||
|default="None" | |||
|no html | |||
}}) | |||
|order by=Cards._pageName | |||
|format=ol | |||
|columns=4 | |||
|limit=2000 | |||
}} | |||
Revision as of 05:39, 31 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 Cards__NEXT not found.</div>) ORDER BY `mw_c...' at line 1
Function: CargoSQLQuery::run Query: SELECT `mw_cargo__Cards`.`_pageName` AS `_pageName` FROM `mw_cargo__Cards` WHERE `mw_cargo__Cards`.`_pageName` NOT IN (<div class="error">Error: Table Cards__NEXT not found.</div>) ORDER BY `mw_cargo__Cards`.`_pageName` LIMIT 2000
