Template:Scrap Navbox: Difference between revisions

From Caves of Qud Wiki
Jump to navigation Jump to search
mNo edit summary
m (Teamtoto moved page Template:Scrap navbox to Template:Scrap Navbox without leaving a redirect)
(No difference)

Revision as of 21:04, 27 February 2020

v · d · eList of Scrap
Scrap
Error 1054: Unknown column 'IT.Bits' in 'field list' (localhost)

Function: CargoSQLQuery::run Query: SELECT `GD`.`_pageName` AS `_pageName`,CONCAT('{{bits|',`IT`.`Bits`, '}}') AS `Blank value 1` FROM `ItemsTable` `IT` LEFT OUTER JOIN `GeneralData` `GD` ON ((`IT`.`JoinKey`=`GD`.`JoinKey`)) WHERE ParentObject IN ( SELECT `_value` FROM `GeneralData__ParentObject__hierarchy` WHERE `_left` >= ( SELECT `_left` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) AND `_right` <= ( SELECT `_right` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) ) AND `GD`.`ObjectID` NOT LIKE "Med%" ORDER BY `IT`.`Bits` LIMIT 100

Medical Scrap
Error 1054: Unknown column 'IT.Bits' in 'field list' (localhost)

Function: CargoSQLQuery::run Query: SELECT `GD`.`_pageName` AS `_pageName`,CONCAT('{{bits|',`IT`.`Bits`, '}}') AS `Blank value 1` FROM `ItemsTable` `IT` LEFT OUTER JOIN `GeneralData` `GD` ON ((`IT`.`JoinKey`=`GD`.`JoinKey`)) WHERE ParentObject IN ( SELECT `_value` FROM `GeneralData__ParentObject__hierarchy` WHERE `_left` >= ( SELECT `_left` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) AND `_right` <= ( SELECT `_right` FROM `GeneralData__ParentObject__hierarchy` WHERE `_value` = 'Scrap' ) ) AND `GD`.`ObjectID` LIKE "Med%" ORDER BY `IT`.`Bits` LIMIT 100

Retrieved from "https://wiki.cavesofqud.com/index.php?title=Template:Scrap_Navbox&oldid=42105"