No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=entity;fields=types1=,{{ConcatImage|name}}=, | tables=entity;fields=types1=,{{ConcatImage|name}}=,name=,{{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}}=, | |tables=item;fields=CONCAT('Item')=,{{ConcatImage|name}}=,name=,{{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}}=, | |tables=component;fields=CONCAT('Component')=,{{ConcatImage|name}}=,name=,{{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 | ||
|merge similar cells=yes | |merge similar cells=yes | ||