Template:Enemy/GetEnemyBaseDruid
Jump to navigation
Jump to search
Error 1054: Unknown column 'EnemyName.m_key' in 'on clause'
Function: CargoSQLQuery::run Query: SELECT `EnemyName`.`text` AS `title`,IF(`Form`.`Name` is null,GROUP_CONCAT(`EnemyName`.`text`," profile.png" SEPARATOR '$$$'),
GROUP_CONCAT(`EnemyName`.`text`," ",`Form`.`Name`," profile.png:",`Form`.`Name` ORDER BY `Form`.`Sort` ASC SEPARATOR '$$$')) AS `images`,GROUP_CONCAT(`EnemyDescription`.`text` ORDER BY `Form`.`Sort` ASC SEPARATOR '$$$') AS `captions`,`Base`.`Kind` AS `kind`,`Base`.`Gender` AS `gender`,GROUP_CONCAT(`Base`.`RangeType` SEPARATOR '$$$') AS `Range`,GROUP_CONCAT(`Base`.`Attribute` SEPARATOR '$$$') AS `Weapon`,GROUP_CONCAT(`Base`.`Weakness` SEPARATOR '$$$') AS `Weakness`,`Base`.`Species` AS `species`, AS `Location`,GROUP_CONCAT(`Res`.`Slash` SEPARATOR ',') AS `Slash_data`,GROUP_CONCAT(`Res`.`Thrust` SEPARATOR ',') AS `Thrust_data`,GROUP_CONCAT(`Res`.`Smash` SEPARATOR ',') AS `Smash_data`,GROUP_CONCAT(`Res`.`Grapple` SEPARATOR ',') AS `Grapple_data`,GROUP_CONCAT(`Res`.`Throw` SEPARATOR ',') AS `Throw_data`,GROUP_CONCAT(`Res`.`Fire` SEPARATOR ',') AS `Fire_data`,GROUP_CONCAT(`Res`.`Water` SEPARATOR ',') AS `Water_data`,GROUP_CONCAT(`Res`.`Wind` SEPARATOR ',') AS `Wind_data`,GROUP_CONCAT(`Res`.`Earth` SEPARATOR ',') AS `Earth_data`,GROUP_CONCAT(`Res`.`Light` SEPARATOR ',') AS `Light_data`,GROUP_CONCAT(`Res`.`Dark` SEPARATOR ',') AS `Dark_data`,GROUP_CONCAT(`Res`.`Plain` SEPARATOR ',') AS `Plain_data`,GROUP_CONCAT(`Res`.`Poison` SEPARATOR ',') AS `Poison_data`,GROUP_CONCAT(`Res`.`Paralysis` SEPARATOR ',') AS `Paralysis_data`,GROUP_CONCAT(`Res`.`Sleep` SEPARATOR ',') AS `Sleep_data`,GROUP_CONCAT(`Res`.`Confusion` SEPARATOR ',') AS `Confusion_data`,GROUP_CONCAT(`Res`.`Petrification` SEPARATOR ',') AS `Petrify_data`,GROUP_CONCAT(`Res`.`LensSeal` SEPARATOR ',') AS `Seal_data`,GROUP_CONCAT(`Res`.`Blindness` SEPARATOR ',') AS `Blind_data`,GROUP_CONCAT(`Res`.`Death` SEPARATOR ',') AS `Death_data`,GROUP_CONCAT(`Res`.`Teleport` SEPARATOR ',') AS `Teleport_data`,GROUP_CONCAT(`Res`.`Stun` SEPARATOR ',') AS `Stun_data` FROM `cargo__LocalizedText` `EnemyName`,`cargo__LocalizedText` `EnemyDescription` LEFT OUTER JOIN `cargo__EnemyBase` `Base` ON ((`EnemyName`.`m_key`=`Base`.`NameId`) AND (`EnemyDescription`.`m_key`=`Base`.`DescriptionId`)) LEFT OUTER JOIN `cargo__EnemyResistance` `Res` ON ((`Base`.`Id`=`Res`.`Id`)) LEFT OUTER JOIN `cargo__EnemyForm` `Form` ON ((`Base`.`Id`=`Form`.`Id`)) WHERE `EnemyName`.`text` = "{{{name}}}" or `Base`.`Id` = "{{{id}}}" GROUP BY `EnemyName`.`text` ORDER BY `EnemyName`.`text`,IF(`Form`.`Name` is null,GROUP_CONCAT(`EnemyName`.`text`," profile.png" SEPARATOR '$$$'),
GROUP_CONCAT(`EnemyName`.`text`," ",`Form`.`Name`," profile.png:",`Form`.`Name` ORDER BY `Form`.`Sort` ASC SEPARATOR '$$$')),GROUP_CONCAT(`EnemyDescription`.`text` ORDER BY `Form`.`Sort` ASC SEPARATOR '$$$'),`Base`.`Kind`,`Base`.`Gender` LIMIT 2000