User:Kiokurashi/sandbox: Difference between revisions

From IdleOn MMO Wiki
mNo edit summary
mNo edit summary
Line 1: Line 1:
{|
{{#cargo_query:
|[[File:OrangeBubble1.png]]||[[File:OrangeBubble2.png]]||[[File:OrangeBubble3.png]]||[[File:OrangeBubble4.png]]||[[File:OrangeBubble5.png]]||[[File:OrangeBubble6.png]]||[[File:OrangeBubble7.png]]||[[File:OrangeBubble8.png]]||[[File:OrangeBubble9.png]]||[[File:OrangeBubble10.png]]||[[File:OrangeBubble11.png]]||[[File:OrangeBubble12.png]]||[[File:OrangeBubble13.png]]||[[File:OrangeBubble14.png]]||[[File:OrangeBubble15.png]]||[[File:OrangeBubble16.png]]||[[File:OrangeBubble17.png]]||[[File:OrangeBubble18.png]]||[[File:OrangeBubble19.png]]||[[File:OrangeBubble20.png]]||[[File:OrangeBubble21.png]]||[[File:OrangeBubble22.png]]||[[File:OrangeBubble23.png]]||[[File:OrangeBubble24.png]]||[[File:OrangeBubble25.png]]
tables=Items
|-
|fields=Items._pageName
|[[File:GreenBubble1.png]]||[[File:GreenBubble2.png]]||[[File:GreenBubble3.png]]||[[File:GreenBubble4.png]]||[[File:GreenBubble5.png]]||[[File:GreenBubble6.png]]||[[File:GreenBubble7.png]]||[[File:GreenBubble8.png]]||[[File:GreenBubble9.png]]||[[File:GreenBubble10.png]]||[[File:GreenBubble11.png]]||[[File:GreenBubble12.png]]||[[File:GreenBubble13.png]]||[[File:GreenBubble14.png]]||[[File:GreenBubble15.png]]||[[File:GreenBubble16.png]]||[[File:GreenBubble17.png]]||[[File:GreenBubble18.png]]||[[File:GreenBubble19.png]]||[[File:GreenBubble20.png]]||[[File:GreenBubble21.png]]||[[File:GreenBubble22.png]]||[[File:GreenBubble23.png]]||[[File:GreenBubble24.png]]||[[File:GreenBubble25.png]]
|where=Items._pageName NOT IN ({{#cargo_query:
|-
tables=Items__NEXT
|[[File:PurpleBubble1.png]]||[[File:PurpleBubble2.png]]||[[File:PurpleBubble3.png]]||[[File:PurpleBubble4.png]]||[[File:PurpleBubble5.png]]||[[File:PurpleBubble6.png]]||[[File:PurpleBubble7.png]]||[[File:PurpleBubble8.png]]||[[File:PurpleBubble9.png]]||[[File:PurpleBubble10.png]]||[[File:PurpleBubble11.png]]||[[File:PurpleBubble12.png]]||[[File:PurpleBubble13.png]]||[[File:PurpleBubble14.png]]||[[File:PurpleBubble15.png]]||[[File:PurpleBubble16.png]]||[[File:PurpleBubble17.png]]||[[File:PurpleBubble18.png]]||[[File:PurpleBubble19.png]]||[[File:PurpleBubble20.png]]||[[File:PurpleBubble21.png]]||[[File:PurpleBubble22.png]]||[[File:PurpleBubble23.png]]||[[File:PurpleBubble24.png]]||[[File:PurpleBubble25.png]]
|fields=CONCAT('"',Items__NEXT._pageName,'"')
|-
|order by=Items__NEXT._pageName
|[[File:YellowBubble1.png]]||[[File:YellowBubble2.png]]||[[File:YellowBubble3.png]]||[[File:YellowBubble4.png]]||[[File:YellowBubble5.png]]||[[File:YellowBubble6.png]]||[[File:YellowBubble7.png]]||[[File:YellowBubble8.png]]||[[File:YellowBubble9.png]]||[[File:YellowBubble10.png]]||[[File:YellowBubble11.png]]||[[File:YellowBubble12.png]]||[[File:YellowBubble13.png]]||[[File:YellowBubble14.png]]||[[File:YellowBubble15.png]]||[[File:YellowBubble16.png]]||[[File:YellowBubble17.png]]||[[File:YellowBubble18.png]]||[[File:YellowBubble19.png]]||[[File:YellowBubble20.png]]||[[File:YellowBubble21.png]]||[[File:YellowBubble22.png]]||[[File:YellowBubble23.png]]||[[File:YellowBubble24.png]]||[[File:YellowBubble25.png]]
|format:ul
|}
|limit=1500
 
|default="None"
 
|no html
 
}})
|order by=Items._pageName
|format=ol
|columns=4
|limit=2000
}}





Revision as of 16:53, 12 January 2023

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