List of league-specific items: Difference between revisions
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
|tables = item_stats | |tables = item_stats | ||
|join = item_stats._pageName=items._pageName | |join = item_stats._pageName=items._pageName | ||
|where = items.rarity_id = "unique" AND items.is_drop_restricted = "false" AND items.drop_leagues HOLDS LIKE "Ambush" | |where = items.rarity_id = "unique" AND items.is_drop_restricted = "false" AND (items.drop_leagues HOLDS LIKE "Ambush" AND items.drop_leagues HOLDS LIKE "Invasion" OR items.drop_leagues HOLDS LIKE "Anarchy" OR items.drop_leagues HOLDS LIKE "Invasion" OR items.drop_leagues HOLDS LIKE "Beyond" OR items.drop_leagues HOLDS LIKE "Blight" OR items.drop_leagues HOLDS LIKE "Bloodlines" OR items.drop_leagues HOLDS LIKE "Delirium" OR items.drop_leagues HOLDS LIKE "Delve" OR items.drop_leagues HOLDS LIKE "Domination" OR items.drop_leagues HOLDS LIKE "Nemesis" OR items.drop_leagues HOLDS LIKE "Harvest" OR items.drop_leagues HOLDS LIKE "Heist" OR items.drop_leagues HOLDS LIKE "Legion" OR items.drop_leagues HOLDS LIKE "Synthesis" OR items.drop_leagues HOLDS LIKE "Talisman" OR items.drop_leagues HOLDS LIKE "Tempest" OR items.drop_leagues HOLDS LIKE "Torment" OR items.drop_leagues HOLDS LIKE "Rampage" OR items.drop_leagues HOLDS LIKE "Expedition") | ||
|orderBy = items.drop_leagues, items._pageName | |orderBy = items.drop_leagues, items._pageName | ||
|drop_leagues=1 | |drop_leagues=1 | ||
Revision as of 10:35, 30 August 2021
This page is a WIP
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 "Ambush" AND `cargo__items`.`drop_leagues` HOLDS LIKE "Invasion" O...' 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`.`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` < 20240527014323 ) AND `cargo__items`.`rarity_id` = "unique" AND (`cargo__items`.`rarity_id` = "unique" AND `cargo__items`.`is_drop_restricted` = "false" AND (`cargo__items`.`drop_leagues` HOLDS LIKE "Ambush" AND `cargo__items`.`drop_leagues` HOLDS LIKE "Invasion" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Anarchy" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Invasion" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Beyond" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Blight" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Bloodlines" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Delirium" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Delve" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Domination" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Nemesis" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Harvest" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Heist" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Legion" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Synthesis" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Talisman" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Tempest" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Torment" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Rampage" OR `cargo__items`.`drop_leagues` HOLDS LIKE "Expedition"))) 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
.