View source for Show news recent row

<includeonly>*{{#if:{{{no date|}}}||{{#time: d/m/y | {{{RSS pubdate|}}} }} }}<div class="RSS_pubdate"> {{#time: (Hi) | {{{RSS pubdate|}}} }}</div>: {{#switch: {{{Which table|}}}

|Cases = '''Case ({{#cargo_query:tables=Cases
|fields=Sentence
|where=_pageName="{{{Name|}}}"
|group by=Sentence
|default=
}}).''' [[{{{Name|}}}]] <span class="RSS_desc">— {{#cargo_query:table=Cases
|fields=Summary
|group by=Summary
|where=_pageName="{{{Name|}}}" 
|default=
}}</span>

|Legislation='''Legislation.''' [[{{{Name|}}}]] <span class="RSS_desc">— {{#cargo_query:table=Legislation|fields=Summary|group by=Summary|where=_pageName="{{{Name|}}}" }}</span>

|Resources='''{{#cargo_query:tables=Resources
|fields=Sentence
|where=Resources._pageName LIKE "{{#replace: {{{Name|}}} | " | _ }}"
|group by=Sentence
|default=
}}.''' [[{{{Name|}}}]] <span class="RSS_desc">— {{#cargo_query:table=Resources
|fields=Abstract
|where=Resources._pageName LIKE "{{#replace: {{{Name|}}} | " | _ }}" AND Abstract IS NOT NULL
|group by=Abstract
|default=
}}</span>

|Jobs='''Job advert.''' [[{{{Name|}}}]]. <span class="RSS_desc">See [[Jobs]]</span>

|Events='''Event.'''  [[{{{Name|}}}|{{#sub:{{{Name|}}}|6}}]] <span class="RSS_desc">— {{#cargo_query:table=Events|fields=Description|group by=Description|where=_pageName="{{{Name|}}}" }}</span>

|News = '''{{{RSS title|}}}''' <span class="RSS_desc">— {{{RSS description}}}</span>

|Error: No table specified
}}
</includeonly><noinclude>Used by [[Template:Show news recent]]. Used in [[Special:Email]], [[Updates]] etc. GROUP BY gets rid of Cargo duplicates within the query result. So far just used for Cases. Event substring is to get rid of Event: namespace</noinclude>