#0 Select( SELECT a.version AS a__version, a.publication_date AS a__publication_date, a.case_id AS a__case_id, a.case_id.dissertation_type.name AS a__case_id__dissertation_type__name, a.last_name AS a__last_name, a.first_name AS a__first_name, a.middle_name AS a__middle_name, a.dissertation_name AS a__dissertation_name, a.speciality.code AS a__speciality__code, a.speciality.name AS a__speciality__name, a.second_speciality AS a__second_speciality, a.second_speciality.code AS a__second_speciality__code, a.second_speciality.name AS a__second_speciality__name, a.branch.name AS a__branch__name, a.case_id.council_state.council.name AS a__case_id__council_state__council__name, a.card_site AS a__card_site, a.fulltext_site AS a__fulltext_site, a.autoref_site AS a__autoref_site, a.defend_date AS a__defend_date, a.version_comment AS a__version_comment, ( SELECT a.case_id AS a__case_id, a.version AS a__version FROM adverts a WHERE a.case_id = ext.case_id ORDER BY version ) AS ARRAY ver , (SELECT MIN(publication_date) FROM adverts WHERE case_id = ext.case_id) AS min_pd , (SELECT MAX(version) FROM adverts WHERE a.publication_date IS NOT NULL AND a.case_id = ext.case_id) as max_version FROM adverts a WHERE a.case_id = 91469772002 AND a.version = , Array ()) called at [/var/www/vak/html/az/server/php/processor.php:125] #1 process_query( SELECT a.version AS a__version, a.publication_date AS a__publication_date, a.case_id AS a__case_id, a.case_id.dissertation_type.name AS a__case_id__dissertation_type__name, a.last_name AS a__last_name, a.first_name AS a__first_name, a.middle_name AS a__middle_name, a.dissertation_name AS a__dissertation_name, a.speciality.code AS a__speciality__code, a.speciality.name AS a__speciality__name, a.second_speciality AS a__second_speciality, a.second_speciality.code AS a__second_speciality__code, a.second_speciality.name AS a__second_speciality__name, a.branch.name AS a__branch__name, a.case_id.council_state.council.name AS a__case_id__council_state__council__name, a.card_site AS a__card_site, a.fulltext_site AS a__fulltext_site, a.autoref_site AS a__autoref_site, a.defend_date AS a__defend_date, a.version_comment AS a__version_comment, ( SELECT a.case_id AS a__case_id, a.version AS a__version FROM adverts a WHERE a.case_id = ext.case_id ORDER BY version ) AS ARRAY ver , (SELECT MIN(publication_date) FROM adverts WHERE case_id = ext.case_id) AS min_pd , (SELECT MAX(version) FROM adverts WHERE a.publication_date IS NOT NULL AND a.case_id = ext.case_id) as max_version FROM adverts a WHERE a.case_id = 91469772002 AND a.version = , Array ()) called at [/var/www/vak/html/cache/ais%2Fvak%2Ftemplates%2Fvak_new%2Fadvert_independent.php.t:47] #2 {closure}(, Array (), smap Object ([___base] => ,[___map] => Array ([rid] => 91469772002))) called at [/var/www/vak/html/az/server/php/template-runtime.php:544] #3 dispatch_template(, Array ()) called at [/var/www/vak/html/cache/ais%2Fvak%2Ftemplates%2Fvak_new%2Fadvert_independent.php.t:271] #4 include(/var/www/vak/html/cache/ais%2Fvak%2Ftemplates%2Fvak_new%2Fadvert_independent.php.t) called at [/var/www/vak/html/az/server/php/templater-cache.php:11] Exception: SQLSTATE[42601]: Syntax error: 7 ОШИБКА: ошибка синтаксиса (примерное положение: "LIMIT") LINE 1: ... WHERE a1.case_id = 91469772002 AND a1.version = LIMIT 1000 ^ SELECT a1.version AS a__version, a1.publication_date AS a__publication_date, a1.case_id AS a__case_id, a3.name AS a__case_id__dissertation_type__name, a1.last_name AS a__last_name, a1.first_name AS a__first_name, a1.middle_name AS a__middle_name, a1.dissertation_name AS a__dissertation_name, a4.code AS a__speciality__code, a4.name AS a__speciality__name, a1.second_speciality AS a__second_speciality, a5.code AS a__second_speciality__code, a5.name AS a__second_speciality__name, a6.name AS a__branch__name, a8.name AS a__case_id__council_state__council__name, a1.card_site AS a__card_site, a1.fulltext_site AS a__fulltext_site, a1.autoref_site AS a__autoref_site, a1.defend_date AS a__defend_date, a1.version_comment AS a__version_comment, a1.case_id AS ver , ( SELECT MIN( a9.publication_date) FROM adverts a9 WHERE a9.case_id = a1.case_id) AS min_pd , ( SELECT MAX( a10.version) FROM adverts a10 WHERE a10.publication_date IS NOT NULL AND a10.case_id = a1.case_id) as max_version FROM adverts a1 LEFT JOIN ( cases a2 LEFT JOIN att_case_typedis a3 ON a2.dissertation_type = a3.id LEFT JOIN ( council_states a7 LEFT JOIN councils a8 ON a7.council = a8.id ) ON a2.council_state = a7.id ) ON a1.case_id = a2.id LEFT JOIN speciality_list a4 ON a1.speciality = a4.code LEFT JOIN speciality_list a5 ON a1.second_speciality = a5.code LEFT JOIN branch_list a6 ON a1.branch = a6.id WHERE a1.case_id = 91469772002 AND a1.version = LIMIT 1000 -