Участник:Admin/песочница: различия между версиями

Версия от 17:54, 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%) between Date_Format(NOW() - 5 month, %m%d%) and Date_Format(NOW() + 5 mo' 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%) between Date_Format(NOW() - 5 month, %m%d%) and Date_Format(NOW() + 5 month, %m%d%) ORDER BY `cargo__Persona`.`_pageID`,`cargo__Persona`.`_pageName`,`cargo__Persona`.`DateBirth` LIMIT 100

@@ Строка 1: / Строка 1: @@
 {{#cargo_query:
      tables=Persona
-     |where=DATE_FORMAT(Persona.DateBirth, '%m-%d') >= {{#time: m-d | -72week}} AND DATE_FORMAT(Persona.DateBirth, '%m-%d') <= {{#time: m-d | +72 week}}
+     |where=Date_Format (DateBirth, %m%d%) between Date_Format(NOW() - 5 month,  %m%d%) and Date_Format(NOW() + 5 month,  %m%d%)
      |fields=Persona._pageName, Persona.DateBirth
 }}