No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=entity;fields=types1,{{ConcatImage|name}}=,{{ConcatImage|'Arrow_left'}}=,{{ConcatImage|ingredient1}}=,amount1=,{{ConcatImage|ingredient2}}=,amount2=,{{ConcatImage|ingredient3}}=,amount3=,{{ConcatImage|ingredient4}}=,amount4=,{{ConcatImage|producer1}}=,time1=,{{ConcatImage|producer2}}=,time2=;where='{{{1}}}' in (ingredient1,ingredient2,ingredient3,ingredient4) | tables=entity;fields=types1=,{{ConcatImage|name}}=,{{ConcatImage|'Arrow_left'}}=,{{ConcatImage|ingredient1}}=,amount1=,{{ConcatImage|ingredient2}}=,amount2=,{{ConcatImage|ingredient3}}=,amount3=,{{ConcatImage|ingredient4}}=,amount4=,{{ConcatImage|producer1}}=,time1=,{{ConcatImage|producer2}}=,time2=;where='{{{1}}}' in (ingredient1,ingredient2,ingredient3,ingredient4) | ||
|tables=item;fields='Item',{{ConcatImage|name}}=,{{ConcatImage|'Arrow_left'}}=,{{ConcatImage|ingredient1}}=,amount1=,{{ConcatImage|ingredient2}}=,amount2=,{{ConcatImage|ingredient3}}=,amount3=,{{ConcatImage|ingredient4}}=,amount4=,{{ConcatImage|producer1}}=,time1=,{{ConcatImage|producer2}}=,time2=;where='{{{1}}}' in (ingredient1,ingredient2,ingredient3,ingredient4) | |tables=item;fields=CONCAT('Item')=,{{ConcatImage|name}}=,{{ConcatImage|'Arrow_left'}}=,{{ConcatImage|ingredient1}}=,amount1=,{{ConcatImage|ingredient2}}=,amount2=,{{ConcatImage|ingredient3}}=,amount3=,{{ConcatImage|ingredient4}}=,amount4=,{{ConcatImage|producer1}}=,time1=,{{ConcatImage|producer2}}=,time2=;where='{{{1}}}' in (ingredient1,ingredient2,ingredient3,ingredient4) | ||
|tables=component;fields='Component',{{ConcatImage|name}}=,{{ConcatImage|'Arrow_left'}}=,{{ConcatImage|ingredient1}}=,amount1=,{{ConcatImage|ingredient2}}=,amount2=,{{ConcatImage|ingredient3}}=,amount3=,{{ConcatImage|ingredient4}}=,amount4=,{{ConcatImage|producer1}}=,time1=,{{ConcatImage|producer2}}=,time2=;where='{{{1}}}' in (ingredient1,ingredient2,ingredient3,ingredient4) | |tables=component;fields=CONCAT('Component')=,{{ConcatImage|name}}=,{{ConcatImage|'Arrow_left'}}=,{{ConcatImage|ingredient1}}=,amount1=,{{ConcatImage|ingredient2}}=,amount2=,{{ConcatImage|ingredient3}}=,amount3=,{{ConcatImage|ingredient4}}=,amount4=,{{ConcatImage|producer1}}=,time1=,{{ConcatImage|producer2}}=,time2=;where='{{{1}}}' in (ingredient1,ingredient2,ingredient3,ingredient4) | ||
|format=table | |format=table | ||
}} | }} | ||