ERROR :
select mc.id, mcxi.nombre, mc.id_padre from mc_categoria mc join mc_categoriaxidioma mcxi on (mcxi.id_categoria = mc.id) where mcxi.idioma='es' and mc.id in ( 1,2,6,8,113,114,117,96,97,103,106,81,82,86,88,67,68,73,75,38,39,44,46,227,41413,209,218,220,211,215,29,30,34,35,,175,176,177,178) and id_padre='175' order by mcxi.nombre asc