(Created page with "<includeonly>{{#vardefine:CHARACTER|{{#replace:{{{1|}}}|'|}}}}{{#cargo_query: tables=Files, BBRadio_Cuts |fields=Files._pageName, Files.Caption |join on=Files._pageName=BBRadi...") |
mNo edit summary |
||
| Line 1: | Line 1: | ||
<includeonly>{{#vardefine:CHARACTER|{{#replace:{{{1|}}}|'|}}}}{{#cargo_query: | <includeonly>{{#vardefine:CHARACTER|{{#replace:{{{1|}}}|'|}}}} | ||
{{#cargo_query: | |||
tables=Files, BBRadio_Cuts | tables=Files, BBRadio_Cuts | ||
|fields=Files._pageName, Files.Caption | |fields=Files._pageName, Files.Caption | ||
|join on=Files._pageName=BBRadio_Cuts._pageName | |join on=Files._pageName=BBRadio_Cuts._pageName | ||
|where=Files.Characters HOLDS "{{#var:CHARACTER}}" AND BBRadio_Cuts.Season="{{{season|}}}" {{#if:{{{episode|}}}|AND BBRadio_Cuts.Episode="{{{episode|}}}" | |where=Files.Characters HOLDS "{{#var:CHARACTER}}" AND BBRadio_Cuts.Season="{{{season|}}}" {{#if:{{{episode|}}}|AND BBRadio_Cuts.Episode="{{{episode|}}}"}} | ||
|order by={{{sort|}}} | |order by={{{sort|}}} | ||
|limit={{{limit|4}}} | |limit={{{limit|4}}} | ||