мНет описания правки
мНет описания правки
Строка 1: Строка 1:
{{#cargo_query:
{{#cargo_query:
     tables=Persona
     tables=Persona
     |where=Date_Format (DateBirth, %m%d%) between '0101' and '1201'
     |where=Date_Format (DateBirth, %m%d%) > '0101' and Date_Format (DateBirth, %m%d%) < '1201'
     |fields=Persona._pageName, Persona.DateBirth
     |fields=Persona._pageName, Persona.DateBirth
}}
}}

Версия от 17:56, 3 июля 2023

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 '%m%d%) > '0101' and Date_Format (DateBirth, %m%d%) < '1201' ORDER BY `cargo__Pe' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo__Persona`.`_pageID` AS `cargo_backlink_page_id_Persona`,`cargo__Persona`.`_pageName` AS `_pageName`,`cargo__Persona`.`DateBirth` AS `DateBirth`,`cargo__Persona`.`DateBirth__precision` AS `DateBirth__precision` FROM `cargo__Persona` WHERE Date_Format (DateBirth, %m%d%) > '0101' and Date_Format (DateBirth, %m%d%) < '1201' ORDER BY `cargo__Persona`.`_pageID`,`cargo__Persona`.`_pageName`,`cargo__Persona`.`DateBirth` LIMIT 100