User:Kiokurashi/sandbox: Difference between revisions
From IdleOn MMO Wiki
imported>Kiokurashi (Replaced content with "https://idleon.info/wiki/Special:CargoTables </br> {{Test|{{#cargo_query: tables=Items__NEXT |fields=CONCAT('"',Items__NEXT._pageName,'"') |order by=Items__NEXT._pageName |format:ul |limit=1500 |no html=yes }}}}") |
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=Items | |||
|fields=Items._pageName | |||
|where=Items._pageName NOT IN ({{#cargo_query: | |||
tables=Items__NEXT | tables=Items__NEXT | ||
|fields=CONCAT('"',Items__NEXT._pageName,'"') | |fields=CONCAT('"',Items__NEXT._pageName,'"') | ||
| Line 7: | Line 11: | ||
|format:ul | |format:ul | ||
|limit=1500 | |limit=1500 | ||
|no html | |no html | ||
}}}} | }}) | ||
|order by=Items._pageName | |||
|format=ol | |||
|columns=4 | |||
|limit=2000 | |||
}} | |||
[[User:Kiokurashi/sandbox2|Get Data]] | |||
Revision as of 21:36, 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 2000
