Card pack returns

<div class="list-cards">{{#invoke:Cargo|query|tables=CustomBooster
 |fields=CONCAT("File:", image)=image, CONCAT("")=link, renderName=alt, CONCAT("{{{width|100}}}")=width, CONCAT("100")=height
 |where=(types__full LIKE "%Card set%" OR types__full LIKE "%Available with gold%") AND NOT types__full LIKE "%Golden%" {{#if:{{{1}}}|AND ({{#lstmap:{{{1|THE_BARRENS}}}|,|@@@@|<esc>setsId HOLDS "{{Card set returns|@@@@|id}}"</esc>|\_OR\_}})}} {{#if:{{{classes|}}}|AND ({{#lstmap:{{{classes}}}|&&|@@@@|<esc>classesId__full LIKE "%{{Class returns|@@@@|id}}&&%" OR classesId__full LIKE "%&&{{Class returns|@@@@|id}}%" OR classesId__full="{{Class returns|@@@@|id}}"</esc>|\_OR\_}})}}
 |template=Card layout
 |limit=200
 |orderBy=id ASC
 |groupBy=id
 |intro=
 |outro=
}}{{#invoke:Cargo|query|tables=CustomBooster
 |fields=CONCAT("File:", image)=image, CONCAT("")=link, renderName=alt, CONCAT("{{{width|100}}}")=width, CONCAT("100")=height
 |where=(types__full LIKE "%Year%") {{#if:{{{1}}}|AND 
 ({{#lstmap:{{{1|THE_BARRENS}}}|,|@@@@|<esc>setsId HOLDS "{{Card set returns|@@@@|id}}"</esc>|\_OR\_}})}} {{#if:{{{classes|}}}|AND ({{#lstmap:{{{classes}}}|&&|@@@@|<esc>classesId__full LIKE "%{{Class returns|@@@@|id}}&&%" OR classesId__full LIKE "%&&{{Class returns|@@@@|id}}%" OR classesId__full="{{Class returns|@@@@|id}}"</esc>|\_OR\_}})}}
 |template=Card layout
 |limit=200
 |orderBy=id ASC
 |groupBy=id
 |intro=
 |outro=
}}{{#invoke:Cargo|query|tables=CustomBooster
 |fields=CONCAT("File:", image)=image, CONCAT("")=link, renderName=alt, CONCAT("{{{width|100}}}")=width, CONCAT("100")=height
 |where=(types__full LIKE "%Class%") {{#if:{{{1}}}|AND 
 ({{#lstmap:{{{1|THE_BARRENS}}}|,|@@@@|<esc>setsId HOLDS "{{Card set returns|@@@@|id}}"</esc>|\_OR\_}})}} {{#if:{{{classes|}}}|AND ({{#lstmap:{{{classes}}}|&&|@@@@|<esc>classesId__full LIKE "%{{Class returns|@@@@|id}}&&%" OR classesId__full LIKE "%&&{{Class returns|@@@@|id}}%" OR classesId__full="{{Class returns|@@@@|id}}"</esc>|\_OR\_}})}}
 |template=Card layout
 |limit=200
 |orderBy=id ASC
 |groupBy=id
 |intro=
 |outro=
}}{{#invoke:Cargo|query|tables=CustomBooster
 |fields=CONCAT("File:", image)=image, CONCAT("")=link, renderName=alt, CONCAT("{{{width|100}}}")=width, CONCAT("100")=height
 |where=NOT (types__full LIKE "%Card set%" OR types__full LIKE "%Available with gold%" OR types__full LIKE "%Year%" OR types__full LIKE "%Class%") AND NOT types__full LIKE "%Golden%" {{#if:{{{1}}}|AND 
 ({{#lstmap:{{{1|THE_BARRENS}}}|,|@@@@|<esc>setsId HOLDS "{{Card set returns|@@@@|id}}"</esc>|\_OR\_}})}} {{#if:{{{classes|}}}|AND ({{#lstmap:{{{classes}}}|&&|@@@@|<esc>classesId__full LIKE "%{{Class returns|@@@@|id}}&&%" OR classesId__full LIKE "%&&{{Class returns|@@@@|id}}%" OR classesId__full="{{Class returns|@@@@|id}}"</esc>|\_OR\_}})}}
 |template=Card layout
 |limit=200
 |orderBy=id ASC
 |groupBy=id
 |intro=
 |outro=
}}{{#switch:{{{includesGolden}}}|#default={{#invoke:Cargo|query|tables=CustomBooster
 |fields=CONCAT("File:", image)=image, CONCAT("")=link, renderName=alt, CONCAT("{{{width|100}}}")=width, CONCAT("100")=height
 |where=types__full LIKE "%Golden%" {{#if:{{{1}}}|AND ({{#lstmap:{{{1|THE_BARRENS}}}|,|@@@@|<esc>setsId HOLDS "{{Card set returns|@@@@|id}}"</esc>|\_OR\_}})}} {{#if:{{{classes|}}}|AND ({{#lstmap:{{{classes}}}|&&|@@@@|<esc>classesId__full LIKE "%{{Class returns|@@@@|id}}&&%" OR classesId__full LIKE "%&&{{Class returns|@@@@|id}}%" OR classesId__full="{{Class returns|@@@@|id}}"</esc>|\_OR\_}})}}
 |template=Card layout
 |limit=200
 |orderBy=id ASC
 |groupBy=id
 |intro=
 |outro=
}}|no|0|n|false=}}</div><noinclude>This template returns all card packs that can contain cards from a card set, or multiple card sets.

==Usage==
 <nowiki>{{Card pack returns|<id, name, promotionName, ingameName, or collectionName of card set(s)>|includesGolden=<true or false>|classes=<list of classes>}}</nowiki>

==Examples==
*<code>{{t|Card pack returns|Forged in the Barrens}}</code> returns:<br/>{{Card pack returns|Forged in the Barrens}}
*<code>{{t|Card pack returns|<nowiki>{{All sets|Wild}}</nowiki>}}</code> returns:<br/>{{Card pack returns|{{All sets|Wild}}}}
[[Category:Query templates]]</noinclude>