Ошибка 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 's Brick Wall s/s' GROUP BY a.good_id ' at line 11
в запросе
SELECT a.*, b.title AS `title_category`, b.title_one AS `title_category_one`, b.url AS `url_podcategory`, IF (b.level=0, b.url, (SELECT url FROM catalog_category WHERE cat_id = b.level)) AS `url_category`, br.title AS `title_brand`, br.url AS `url_brand`, att.title_one AS `title_attribute`, (SELECT image FROM goods_photos WHERE good_id=a.good_id AND `image`!='' ORDER BY position ASC LIMIT 1) AS `good_image` FROM goods a LEFT JOIN catalog_brand br ON a.brand_id = br.brand_id LEFT JOIN catalog_category_attributes att ON a.attribute_id = att.attribute_id LEFT JOIN goods_storage st ON a.good_id = st.good_id LEFT JOIN catalog_category_site_list site_list ON a.cat_id = site_list.cat_id LEFT JOIN catalog_category b ON site_list.parent_cat_id = b.cat_id WHERE a.publication=1 AND a.brand_id=23 AND st.suppliers_id IN(1,13,14,19,20,24) AND a.good_id!=3448 AND IF ((a.attribute_id!=0 AND site_list.attribute_id!=''), site_list.attribute_id REGEXP CONCAT('[[:<:]]',a.attribute_id,'[[:>:]]'), 1) AND b.level!=0 AND a.model_group='Men's Brick Wall s/s' GROUP BY a.good_id ORDER BY RAND() LIMIT 0, 10