Exception: Query error 42000: SQLSTATE[42000]: Syntax error or access violation: 1
064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near
'SELECT `shop_filter_seo_properties`.`shop_filter_seo_id`, COUNT(*) AS `dataCond' at line 4.
Query: SELECT `shop_filter_seos`.*, `t1`.`dataConditionsCount`, COUNT(*) AS `dataOriginalCount`
FROM `shop_filter_seos`
LEFT OUTER JOIN SELECT `shop_filter_seo_properties`.`shop_filter_seo_id`, COUNT(*) AS `dataConditionsCount`
FROM `shop_filter_seo_properties` GROUP BY `shop_filter_seo_properties`.`shop_filter_seo_id` HAVING `dataConditionsCount` = 0 AS `t1`
ON `shop_filter_seos`.`id` = `t1`.`shop_filter_seo_id`
LEFT OUTER JOIN `shop_filter_seo_properties`
ON `shop_filter_seo_properties`.`shop_filter_seo_id` = `shop_filter_seos`.`id`
WHERE `shop_filter_seos`.`shop_id` = '1' AND `shop_filter_seos`.`active` = 1 AND `shop_filter_seos`.`shop_producer_id` = 0
AND `shop_filter_seo_properties`.`id` IS NULL AND `shop_filter_seos`.`shop_group_id` = 0 GROUP BY `shop_filter_seos`.`id`
ORDER BY `dataOriginalCount` DESC LIMIT 1
Сервер: MySQL (Localhost via UNIX socket)
Тип сервера: MariaDB
Версия сервера: 5.5.60-MariaDB - MariaDB Server
Версия протокола: 10
Кодировка сервера: UTF-8 Unicode (utf8)