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 ')    
GROUP BY id
union
select subcategory.name as name ,shop.subcategory ...' at line 10