MySQL[1064]: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 ') AND pe.tmc IN (SELECT t.id FROM spr_tmc t WHERE t.category=308 AND t.brand=...' at line 1<br /><br />
SELECT pe.value AS enum_value_id, evt.name AS name, COUNT(*) AS products_count, p.rwurl AS property_rwurl FROM spr_property_enum pe LEFT JOIN spr_properties p ON p.id=pe.property_id LEFT JOIN spr_enum_value_translations evt ON evt.enum_value_id=pe.value AND evt.locale="ua" WHERE pe.property_id=397 AND pe.tmc IN (SELECT tmc FROM spr_property_enum pec WHERE pec.property_id=396 AND pec.value=) AND pe.tmc IN (SELECT t.id FROM spr_tmc t WHERE t.category=308 AND t.brand=187 AND t.enabled=1) GROUP BY pe.value ORDER BY evt.name DESC, products_count ASC