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 '\'%,1,%\')

GROUP BY 
    a.home_design_id,
    b.virtual_tour_id

ORDER BY 
...' at line 23