Ошибка выполнения SQL запроса:
SELECT * FROM flo_catalog_values WHERE field_id=7 AND `value` = "Лилия" AND item_id IN (SELECT item_id FROM flo_items WHERE group_id IN (1,5,6,2,3,4,) AND is_show=1) GROUP BY value ORDER BY cast(value as unsigned)