List of league-specific items

From Path of Exile Wiki
Revision as of 09:30, 30 August 2021 by Blvcksvn (talk | contribs)
Jump to navigation Jump to search

Lua error: 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 LIKE "%" AND `cargo__items`.`is_drop_restricted` = "0")) AND `cargo__it...' at line 6 Function: CargoSQLQuery::run Query: SELECT `cargo__items`.`_pageID` AS `items._pageID`,`cargo__items`.`_pageName` AS `items._pageName`,`cargo__items`.`name` AS `items.name`,`cargo__items`.`inventory_icon` AS `items.inventory_icon`,`cargo__items`.`html` AS `items.html`,`cargo__items`.`size_x` AS `items.size_x`,`cargo__items`.`size_y` AS `items.size_y`,`cargo__items`.`base_item` AS `items.base_item`,`cargo__items`.`base_item_page` AS `items.base_item_page`,`cargo__items`.`required_level_range_maximum` AS `items.required_level_range_maximum`,`cargo__items`.`required_level_range_text` AS `items.required_level_range_text`,`cargo__items`.`required_level_range_colour` AS `items.required_level_range_colour`,`cargo__items`.`stat_text` AS `items.stat_text` FROM `cargo__items` LEFT OUTER JOIN `cargo__versions` ON ((`cargo__items`.`release_version`=`cargo__versions`.`version`)) LEFT OUTER JOIN `cargo__item_stats` ON ((`cargo__items`.`_pageName`=`cargo__item_stats`.`_pageName`)) WHERE (`cargo__items`.`drop_enabled` = true

 AND (`cargo__items`.`release_version` IS NULL 
   OR `cargo__items`.`release_version` IS NOT NULL
   AND `cargo__versions`.`release_date` < 20240519040633
 ) AND `cargo__items`.`rarity_id` = "unique"
 AND (`cargo__items`.`rarity_id` = "unique" AND `cargo__items`.`drop_leagues` HOLDS LIKE "%" AND `cargo__items`.`is_drop_restricted` = "0")) AND `cargo__items`.`_pageNamespace` IN (0,10016)  GROUP BY `cargo__items`.`_pageID` ORDER BY `cargo__items`.`required_level_range_maximum`,`cargo__items`.`name` LIMIT 5000  

.