(Новая страница: «<small>__NOCACHE__<!--{{#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= }}}}...»)
 
мНет описания правки
Строка 16: Строка 16:
}}}}-->{{#vardefine:dbafter|{{#cargo_query:
}}}}-->{{#vardefine:dbafter|{{#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 | +6 week}}')
     |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')
     |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

Версия от 19:20, 25 октября 2024

Дни рождения


Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY DATE_FORMAT(`cargo__Persona`.`DateBirth`, '%m-%d') LIMIT 100' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo__Persona`.`_pageID` AS `cargo_backlink_page_id_Persona`,`cargo__Persona`.`_pageName` AS `_pageName`,DATE_FORMAT(`cargo__Persona`.`DateBirth`, '%d.%m.%Y') AS `DateBirth, '%d.%m.%Y')`,DATE_FORMAT(`cargo__Persona`.`DateDeath`, '%d.%m.%Y') AS `DateDeath, '%d.%m.%Y')` FROM `cargo__Persona` WHERE (DATE_FORMAT(`cargo__Persona`.`DateBirth`, '%m-%d') >= '11-01' ORDER BY DATE_FORMAT(`cargo__Persona`.`DateBirth`, '%m-%d') LIMIT 100

Дни памяти