User talk:Softspoken: Difference between revisions
Softspoken (talk | contribs) |
Softspoken (talk | contribs) |
||
| Line 7: | Line 7: | ||
|type=0 | |type=0 | ||
|no_html=1 | |no_html=1 | ||
|q_where= | |q_where=passive_skills | ||
|q_limit=15 | |q_limit=15 | ||
}}</div> | }}</div> | ||
</onlyinclude> | </onlyinclude> | ||
Revision as of 18:24, 28 August 2021
Just a testing zone.
Anointment Query
Lua error: Error 1054: Unknown column 'passive_skills' in 'where clause' Function: CargoSQLQuery::run Query: SELECT `cargo__blight_crafting_recipes`.`id` AS `blight_crafting_recipes.id`,`cargo__blight_crafting_recipes`.`type` AS `blight_crafting_recipes.type`,`cargo__blight_crafting_recipes_items`.`item_id` AS `blight_crafting_recipes_items.item_id`,`cargo__mods`.`_pageName` AS `mods._pageName`,`cargo__mods`.`id` AS `mods.id`,`cargo__mods`.`name` AS `mods.name`,`cargo__mods`.`stat_text` AS `mods.stat_text`,`cargo__passive_skills`.`_pageName` AS `passive_skills._pageName`,`cargo__passive_skills`.`id` AS `passive_skills.id`,`cargo__passive_skills`.`stat_text` AS `passive_skills.stat_text`,`cargo__passive_skills`.`main_page` AS `passive_skills.main_page`,`cargo__passive_skills`.`name` AS `passive_skills.name`,`cargo__passive_skills`.`icon` AS `passive_skills.icon`,`cargo__passive_skills`.`is_keystone` AS `passive_skills.is_keystone`,`cargo__passive_skills`.`is_notable` AS `passive_skills.is_notable`,`cargo__passive_skills`.`ascendancy_class` AS `passive_skills.ascendancy_class` FROM `cargo__blight_crafting_recipes` LEFT OUTER JOIN `cargo__blight_crafting_recipes_items` ON ((`cargo__blight_crafting_recipes`.`id`=`cargo__blight_crafting_recipes_items`.`recipe_id`)) LEFT OUTER JOIN `cargo__mods` ON ((`cargo__blight_crafting_recipes`.`modifier_id`=`cargo__mods`.`id`)) LEFT OUTER JOIN `cargo__passive_skills` ON ((`cargo__blight_crafting_recipes`.`passive_id`=`cargo__passive_skills`.`id`)) WHERE `cargo__blight_crafting_recipes_items`.`item_id` IS NOT NULL
AND (passive_skills)
ORDER BY `cargo__blight_crafting_recipes_items`.`ordinal` LIMIT 15
.