Template:Hansard-mp-record-month: Difference between revisions
SGPolitico (talk | contribs) No edit summary |
SGPolitico (talk | contribs) No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly><div class="mw-collapsible mw-collapsed" style="margin:0.2em 0 0.2em 1.5em;border:1px solid #c8ccd1;clear:both;"><div class="mw-collapsible-toggle" style="display:block;float:none;clear:both;cursor:pointer;background:#eaecf0;padding:0.25em 0.6em;font-weight:bold;">{{{MonthLabel|{{{YearMonth|}}}}}}</div><div class="mw-collapsible-content" style="clear:both;">{{#cargo_query:tables=hansard_items,hansard_sittings|join on=hansard_items.sitting_id=hansard_sittings.sitting_id|fields=hansard_items.sitting_date=Date,hansard_items.item_type=Type,hansard_items.subject=Subject,CONCAT("[[",hansard_items._pageName,"#",hansard_items.item_id,"|→]]")=Link|where=(hansard_items.asking_mp_id="{{{MPId|}}}" OR hansard_items.speaker_mp_id="{{{MPId|}}}") AND DATE_FORMAT(hansard_items.sitting_date,"%Y-%m")="{{{YearMonth|}}}"|order by=hansard_items.sitting_date|format=dynamictable}}</div></div></includeonly><noinclude> | <includeonly><div class="mw-collapsible mw-collapsed" style="margin:0.2em 0 0.2em 1.5em;border:1px solid #c8ccd1;clear:both;"><div class="mw-collapsible-toggle" style="display:block;float:none;clear:both;cursor:pointer;background:#eaecf0;padding:0.25em 0.6em;font-weight:bold;">{{{MonthLabel|{{{YearMonth|}}}}}}</div><div class="mw-collapsible-content" style="clear:both;">{{#cargo_query:tables=hansard_items,hansard_sittings|join on=hansard_items.sitting_id=hansard_sittings.sitting_id|fields=hansard_items.sitting_date=Date,hansard_items.item_type=Type,hansard_items.subject=Subject,CONCAT("[[",hansard_items._pageName,"#",hansard_items.item_id,"|→]]")=Link|where=(hansard_items.asking_mp_id="{{{MPId|}}}" OR hansard_items.speaker_mp_id="{{{MPId|}}}") AND DATE_FORMAT(hansard_items.sitting_date,"%Y-%m")="{{{YearMonth|}}}" AND hansard_items.item_type!="supplementary_question"|order by=hansard_items.sitting_date|format=dynamictable}}</div></div></includeonly><noinclude> | ||
[[Category:Cargo templates]] | [[Category:Cargo templates]] | ||
[[Category:Hansard templates]] | [[Category:Hansard templates]] | ||
</noinclude> | </noinclude> | ||
Latest revision as of 20:44, 16 July 2026