User:Toancaro/Template:SpellTable
Function: CargoSQLQuery::run Query: SELECT `cargo__spells`.`_pageID` AS `cargo_backlink_page_id_spells`,`_pageName` AS `spell`,`name` AS `name`,`classes__full` AS `classes`,`description` AS `description`,`spell_school` AS `spell school`,`action_type` AS `casttime`,`damage_type` AS `damage`,`is_concentration` AS `conc`,`is_ritual` AS `ritual`,`spell_level` AS `level`,`can_upcast` AS `upcastable`,`spell_range` AS `range`,`aoe` AS `aoe`,`aoe_size` AS `area`,`has_attack_roll` AS `attack`,`damage_save` AS `save`,`condition_duration` AS `duration` FROM `cargo__spells` WHERE level="1" AND `cargo__spells`.`_ID` IN (SELECT `_rowID` FROM `cargo__spells__classes` WHERE `_value`= "Wizard") ORDER BY `cargo__spells`.`_pageID`,`_pageName`,`name`,`cargo__spells`.`classes__full` ,`description` LIMIT 100