Template:Sandbox/Aurelain/SpellsNavbox/row

Input:

{{Sandbox/Aurelain/SpellsNavbox/row
|lang=en
|school=day
}}

Output:
| No results

|

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 '~='bonus_magic_kill_summon'\x0A AND `S`.`id` ~='neutral_1_magic_back_to_ga...' at line 4

Function: CargoSQLQuery::run Query: SELECT `E`.`_pageID` AS `cargo_backlink_page_id_E`,`T`.`_pageID` AS `cargo_backlink_page_id_T`,`S`.`_pageID` AS `cargo_backlink_page_id_S`,`S`.`id` AS `id`,`T`.`language` AS `lang`,`T`.`name` AS `name`,`E`.`name` AS `name_en` FROM `mw4v_cargo__Spell` `S` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`S`.`id`=`T`.`target_id`)) LEFT OUTER JOIN `mw4v_cargo__Translation` `E` ON ((`S`.`id`=`E`.`target_id`)) WHERE `S`.`school` = 'day'

   AND `S`.`id` not like '%_special'
   AND `S`.`id` not like '%astral_summon_%'
   AND `S`.`id` ~='bonus_magic_kill_summon'
   AND `S`.`id` ~='neutral_1_magic_back_to_garrison'
   AND `S`.`id` ~='neutral_1_magic_mana_transfer'
   AND `S`.`id` ~='night_bonus_magic_1_magic'
   AND `S`.`id` ~='primal_bonus_magic_1_magic'
   AND `T`.`type` = 'spell'
   AND `T`.`language` = 'en'
   AND `E`.`type` = 'spell'
   AND `E`.`language` = 'en'  ORDER BY `S`.`rank` LIMIT 100

}