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 'AS `Date, 1, 4) AS Год` FROM `cargo__song` WHERE `cargo__song`.`_pageName' at line 1

Function: CargoSQLQuery::run Query: SELECT `cargo__song`.`_pageID` AS `cargo_backlink_page_id_song`,`cargo__song`.`_pageName` AS `Название`,`cargo__song`.`FirstString` AS `Первая строка`,SUBSTRING(`cargo__song`.`Date`, 1, 4) AS Год AS `Date, 1, 4) AS Год` FROM `cargo__song` WHERE `cargo__song`.`_pageName`<>"Заглавная страница" AND (`cargo__song`.`_ID` IN (SELECT `_rowID` FROM `cargo__song__Lyric` WHERE `_value`= OR `cargo__song`.`_ID` IN (SELECT `_rowID` FROM `cargo__song__Composer` WHERE `_value`= ') ' OR `cargo__song`.`_ID` IN (SELECT `_rowID` FROM `cargo__song__Translation` WHERE `_value`= ') ') ) ORDER BY `cargo__song`.`_pageID`,`cargo__song`.`_pageName`,`cargo__song`.`FirstString`,SUBSTRINGsong.Date__full , 1, 4) AS Год LIMIT 100


Данный шаблон создан для показа таблицы песен автора.

Параметры шаблона

ПараметрОписаниеТипСтатус
Не указано ни одного параметра