User:Kaimbe/weapons: Difference between revisions
Jump to navigation
Jump to search
(Created page with "{{#cargo_query: tables=equipment=eq, weapons=wp |join on=eq._pageName=wp._pageName, eq.image=wp.image, eq.special=wp.special, eq.where_to_find=wp.where_to_find, eq.rarity=wp.rarity, eq.rarity_order=wp.rarity_order, eq.proficiency=wp.type |fields=eq._pageName, eq.image, eq.proficiency, eq.rarity, eq.special, eq.where_to_find |order by=eq.rarity_order DESC |format=dynamic table |details fields= |hidden fields=eq.where_to_find |searchable columns=yes }}") |
No edit summary |
||
| Line 2: | Line 2: | ||
tables=equipment=eq, weapons=wp | tables=equipment=eq, weapons=wp | ||
|join on=eq._pageName=wp._pageName, eq.image=wp.image, eq.special=wp.special, eq.where_to_find=wp.where_to_find, eq.rarity=wp.rarity, eq.rarity_order=wp.rarity_order, eq.proficiency=wp.type | |join on=eq._pageName=wp._pageName, eq.image=wp.image, eq.special=wp.special, eq.where_to_find=wp.where_to_find, eq.rarity=wp.rarity, eq.rarity_order=wp.rarity_order, eq.proficiency=wp.type | ||
|fields=eq._pageName, eq.image, eq.proficiency, eq.rarity, eq.special, eq.where_to_find | |fields=eq._pageName, eq.image, eq.proficiency, eq.rarity, eq.special, wp.finesse, eq.where_to_find | ||
|order by=eq.rarity_order DESC | |order by=eq.rarity_order DESC | ||
|format=dynamic table | |format=dynamic table | ||
|details fields= | |details fields=wp.finesse | ||
|hidden fields=eq.where_to_find | |hidden fields=eq.where_to_find, wp.where_to_find | ||
|searchable columns=yes | |searchable columns=yes | ||
}} | }} | ||
Revision as of 11:50, 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