(Новая страница: «<!--{{#cargo_query: tables=Persona |where=Date_Format (Persona.DateBirth, %m%d%) > '0101' and Date_Format (Persona.DateBirth, %m%d%) < '1201' |fields=Persona._pageName, Persona.DateBirth }}--> == Дни рождения == <div style="line-height: 1.1;"> {{#cargo_query: tables=Persona |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -4 week}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | -1 day}}' |f...»)
 
мНет описания правки
 
(не показано 77 промежуточных версий 2 участников)
Строка 1: Строка 1:
<!--{{#cargo_query:
<small>__NOCACHE__<!--{{#vardefine:dbafter|{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=Date_Format (Persona.DateBirth, %m%d%) > '0101' and Date_Format (Persona.DateBirth, %m%d%) < '1201'
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week}}'
     |fields=Persona._pageName, Persona.DateBirth
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
}}-->
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
== Дни рождения ==
    |format=template
<div style="line-height: 1.1;">
    |template=DateBirth
{{#cargo_query:
    |default=
}}}}{{#vardefine:dbafter2|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '12-31') OR (DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week -1 year}}')
     |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
}}}}-->{{#vardefine:dbafter|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week}}')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=
}}}}{{#vardefine:dbafter1|{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -4 week}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | -1 day}}'
     |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '12-31')
     |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
     |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
     |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
     |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}
    |default=
</div>
}}}}{{#vardefine:dbafter2|{{#cargo_query:
 
'''{{#time: d.m.Y}}'''
 
<div style="line-height: 1.1;">
{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +4 week}}'
     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | +6 week -1 year}}'
     |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
     |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
     |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
     |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}
}}}}{{#vardefine:ddafter|{{#cargo_query:
</div>
    tables=Persona
 
    |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | +6 week}}'
== Дни памяти ==
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
<div style="line-height: 1.1;">
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
{{#cargo_query:
    |format=template
    |template=DateDeath
    |default=
}}}}{{#vardefine:ddafter1|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '12-31')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=
}}}}{{#vardefine:ddafter2|{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d | -4 week}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | -1 day}}'
     |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | +6 week -1 year}}')
     |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
     |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
     |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
     |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
}}}}{{#vardefine:dbbefore|{{#cargo_query:
    tables=Persona
    |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | -1 day}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=   
}}}}{{#vardefine:dbbefore1|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '{{#time: m-d | -6 week +1 year}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '12-31')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}
    |default=   
}}}}{{#vardefine:dbbefore2|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateBirth, '%m-%d') <= '{{#time: m-d | -1 day}}' AND DATE_FORMAT(Persona.DateBirth, '%m-%d') >= '01-01')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateBirth, '%m-%d') ASC
    |format=template
    |template=DateBirth
    |default=   
}}}}{{#vardefine:ddbefore|{{#cargo_query:
    tables=Persona
    |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d | -6 week}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | -1 day}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=   
}}}}{{#vardefine:ddbefore1|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d | -6 week +1 year}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '12-31')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=   
}}}}{{#vardefine:ddbefore2|{{#cargo_query:
    tables=Persona
    |where=(DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '01-01' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | -1 day}}')
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateDeath
    |default=   
}}}}
== Дни рождения ==
<div style="line-height: 1.1;">
{{#if: {{#var:dbbefore}}|{{#var:dbbefore}}|{{#var:dbbefore1}}{{#var:dbbefore2}}}}<!--
{{#var:dbbefore1}}{{#var:dbbefore2}}-->
</div>
</div>
<!--'''{{#time: d.m.Y}}'''-->
----


'''{{#time: d.m.Y}}'''
<div style="line-height: 1.1;">
{{#if: {{#var:dbafter}}|{{#var:dbafter}}|{{#var:dbafter1}}{{#var:dbafter2}}}}


</div>
== Дни памяти ==
<div style="line-height: 1.1;">
<div style="line-height: 1.1;">
{{#cargo_query:
{{#if: {{#var:ddbefore}}|{{#var:ddbefore}}|{{#var:ddbefore1}}{{#var:ddbefore2}}}}
    tables=Persona
    |where=DATE_FORMAT(Persona.DateDeath, '%m-%d') >= '{{#time: m-d}}' AND DATE_FORMAT(Persona.DateDeath, '%m-%d') <= '{{#time: m-d | +4 week}}'
    |fields=Persona._pageName, DATE_FORMAT(Persona.DateBirth, '%d.%m.%Y'), DATE_FORMAT(Persona.DateDeath, '%d.%m.%Y')
    |order by=DATE_FORMAT(Persona.DateDeath, '%m-%d') ASC
    |format=template
    |template=DateBirth
}}
</div>
</div>
----
<div style="line-height: 1.1;">
{{#if: {{#var:ddafter}}|{{#var:ddafter}}|{{#var:ddafter1}}{{#var:ddafter2}}}}
</div></small>
<!--
<!--
{{#cargo_query:
{{#cargo_query:
Строка 61: Строка 140:
     |format=template
     |format=template
     |template=DateBirth
     |template=DateBirth
}}-->
}}-->[[Категория:Даты]]

Текущая версия от 09:49, 16 января 2024

Дни рожденияПравить


Дни памятиПравить