An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 9

select c.c_desc, (select count(*) from remates r where r.i_subcategoria_id in (select sc.i_subcategoria_id from subcategorias sc where sc.i_categoria_id=c.i_categoria_id) ) as cantidad from categorias c where c.i_categoria_id=