User:Kaimbe/weapons: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 5: | Line 5: | ||
|order by=eq.rarity_order DESC | |order by=eq.rarity_order DESC | ||
|format=dynamic table | |format=dynamic table | ||
|limit=500 | |||
|details fields=wp.finesse | |details fields=wp.finesse | ||
|hidden fields= | |hidden fields=where_to_find | ||
|searchable columns=yes | |searchable columns=yes | ||
}} | }} | ||
Revision as of 11:51, 26 August 2023
Error 1054: Unknown column 'wp.where_to_find' in 'on clause'
Function: CargoSQLQuery::run Query: SELECT `wp`.`_pageID` AS `cargo_backlink_page_id_wp`,`eq`.`_pageID` AS `cargo_backlink_page_id_eq`,`eq`.`_pageName` AS `_pageName`,`eq`.`image` AS `image`,`eq`.`proficiency` AS `proficiency`,`eq`.`rarity` AS `rarity`,`eq`.`special` AS `special`,`wp`.`finesse` AS `finesse`,`eq`.`where_to_find` AS `where to find` FROM `cargo__equipment` `eq` LEFT OUTER JOIN `cargo__weapons` `wp` ON ((`eq`.`_pageName`=`wp`.`_pageName`) AND (`eq`.`image`=`wp`.`image`) AND (`eq`.`special`=`wp`.`special`) AND (`eq`.`where_to_find`=`wp`.`where_to_find`) AND (`eq`.`rarity`=`wp`.`rarity`) AND (`eq`.`rarity_order`=`wp`.`rarity_order`) AND (`eq`.`proficiency`=`wp`.`type`)) ORDER BY `eq`.`rarity_order` DESC LIMIT 100