ResourcePage: Difference between revisions
From Dune Awakening DB
mNo edit summary |
mNo edit summary |
||
| Line 51: | Line 51: | ||
<!-- ───── 3. “CRAFTED WITH” PREVIEW ───── --> | <!-- ───── 3. “CRAFTED WITH” PREVIEW ───── --> | ||
{{#get_external_data: | {{#get_external_data: | ||
source=externaldb | source = externaldb | ||
|from=data_recipe_ingredients | |from = data_recipe_ingredients | ||
JOIN data_recipes ON data_recipe_ingredients.recipe_id = data_recipes.id | |||
JOIN data_recipe_stations ON data_recipes.id = data_recipe_stations.recipe_id | |||
|data=OutputItem = primary_output_label, | |data = OutputItem = primary_output_label, | ||
Resources = GROUP_CONCAT(\DISTINCT CONCAT( | |||
ingredient_label\, CHAR(32)\, CHAR(120)\, amount | |||
) SEPARATOR CHAR(59)), | |||
Stations = GROUP_CONCAT(\DISTINCT production_type SEPARATOR CHAR(59)) | |||
|where = ingredient_label = {{PAGENAME}} | |||
|group by = primary_output_label | |||
|order by = primary_output_label | |||
|limit = 5 <!-- preview size --> | |||
|cache = yes | |||
|where=ingredient_label={{PAGENAME}} | |||
|group by=primary_output_label | |||
|order by=primary_output_label | |||
|limit=5 | |||
|cache=yes | |||
}} | }} | ||
<div class="dune-table-wrapper"> | <div class="dune-table-wrapper"> | ||
| Line 94: | Line 90: | ||
<!-- ───── 4. “CRAFTED FROM” PREVIEW ───── --> | <!-- ───── 4. “CRAFTED FROM” PREVIEW ───── --> | ||
{{#get_external_data: | {{#get_external_data: | ||
source=externaldb | source = externaldb | ||
|from=data_recipe_outcomes | |from = data_recipe_outcomes | ||
JOIN data_recipes ON data_recipe_outcomes.recipe_id = data_recipes.id | |||
JOIN data_recipe_ingredients ON data_recipes.id = data_recipe_ingredients.recipe_id | |||
JOIN data_recipe_stations ON data_recipes.id = data_recipe_stations.recipe_id | |||
|data=OutputItem = output_label, | |data = OutputItem = output_label, | ||
Resources = GROUP_CONCAT(\DISTINCT CONCAT( | |||
ingredient_label\, CHAR(32)\, CHAR(120)\, amount | |||
) SEPARATOR CHAR(59)), | |||
Stations = GROUP_CONCAT(\DISTINCT production_type SEPARATOR CHAR(59)) | |||
|where = output_label = {{PAGENAME}} | |||
|group by = output_label | |||
|order by = output_label | |||
|limit = 5 | |||
|cache = yes | |||
|where=output_label={{PAGENAME}} | |||
|group by=output_label | |||
|order by=output_label | |||
|limit=5 | |||
|cache=yes | |||
}} | }} | ||
<div class="dune-table-wrapper"> | <div class="dune-table-wrapper"> | ||
Revision as of 16:31, 26 May 2025
VIDEO TUTORIALS
▶ Resource Guide
≡ Notes
<script id="recipePopupTemplate" type="text/template">
</script>