List of unique items with legacy variants: Difference between revisions
>Illviljan m (Replaced content with "{{see also|List of legacy base items}} This is a list of all unique items that have one or more legacy variants. {{Query unique items |tables = legacy_variants |...") |
>Nutarama No edit summary |
||
| Line 6: | Line 6: | ||
|tables = legacy_variants | |tables = legacy_variants | ||
|join = items._pageID=legacy_variants._pageID | |join = items._pageID=legacy_variants._pageID | ||
|where = | |where = legacy_items.removal_version!=null | ||
|large=1 | |large=1 | ||
|stat=1 | |stat=1 | ||
Revision as of 01:49, 28 October 2020
This is a list of all unique items that have one or more legacy variants.
Lua error: Error 1054: Unknown column 'legacy_items.removal_version' in 'where clause' 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`.`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__legacy_variants` ON ((`cargo__items`.`_pageID`=`cargo__legacy_variants`.`_pageID`)) 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` < 20240611111933 ) AND `cargo__items`.`rarity_id` = "unique" AND (legacy_items.removal_version!=null)) 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
.