Coal Mine: Difference between revisions
From Zed Wiki
No edit summary |
|||
| Line 60: | Line 60: | ||
=== Rewards === | === Rewards === | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=ScavengeJobRewards | tables=ScavengeJobRewards, Items | ||
|fields=Codename=Reward, Qty, Chance | |join on=Items.Codename = ScavengeJobRewards.Codename | ||
|where=JobCodename="job_scavenge_coal_mine" | |fields=ScavengeJobRewards.Codename=Reward, Qty, Chance | ||
|where=ScavengeJobRewards.JobCodename="job_scavenge_coal_mine" | |||
|order by=Codename | |order by=Codename | ||
|format=table | |format=table | ||
}} | }} | ||
Revision as of 07:07, 11 July 2025
Requirements
| Item | Qty | TakeItem |
|---|---|---|
| misc_pickaxe | 1 | No |
| rad | 1 | Yes |
Rewards
Error 1052: Column 'Codename' in ORDER BY is ambiguous
Function: CargoSQLQuery::run Query: SELECT `cargo__ScavengeJobRewards`.`_pageID` AS `cargo_backlink_page_id_ScavengeJobRewards`,`cargo__Items`.`_pageID` AS `cargo_backlink_page_id_Items`,`cargo__ScavengeJobRewards`.`Codename` AS `Reward`,`Qty` AS `Qty`,`Chance` AS `Chance` FROM `cargo__Items` LEFT OUTER JOIN `cargo__ScavengeJobRewards` ON ((`cargo__Items`.`Codename`=`cargo__ScavengeJobRewards`.`Codename`)) WHERE `cargo__ScavengeJobRewards`.`JobCodename`="job_scavenge_coal_mine" ORDER BY `Codename` LIMIT 5000