Template:GetS1enemies: Difference between revisions

Revision as of 03:12, 13 December 2025

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 'HOLDS "" ORDER BY `1e`.`_pageID`,`lv`,`name`,`hp`,`potch` LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT `1e`.`_pageID` AS `cargo_backlink_page_id_1e`,`lv` AS `lv`,`name` AS `name`,`hp` AS `hp`,`potch` AS `potch`,`item_1` AS `item 1`,`rate_1` AS `rate 1`,`item_2` AS `item 2`,`rate_2` AS `rate 2`,`item_3` AS `item 3`,`rate_3` AS `rate 3`,`_pageName` AS `_pageName`,`image` AS `image`,`location` AS `location` FROM `cargo__S1_enemies` `1e` WHERE location HOLDS "" ORDER BY `1e`.`_pageID`,`lv`,`name`,`hp`,`potch` LIMIT 100

@@ Line 3: / Line 3: @@
    S1_enemies=1e
 |fields =
-   lv, name, hp, potch, item_1, rate_1, item_2, rate_2, item_3, rate_3, _pageName, image, location, location2
+   lv, name, hp, potch, item_1, rate_1, item_2, rate_2, item_3, rate_3, _pageName, image, location
-|where=location = "{{{location|}}}" OR location2 = "{{{location2|}}}"
+|where=location HOLDS "{{{location|}}}"
 |format=template
 |limit=240