Column 'PARAMETROS' in field list is ambiguous<BR/><BR/>Select Rubro.ID_RUBRO,RUBRO,PATH_RUBRO,PARAMETROS,Datos.*,count(distinct(Video.ID_VIDEO)) as CONTA_VIDEO,count(distinct(Fotos.ID_FOTO)) as CONTA_FOTOS,count(distinct(Opina.ID_OPINION)) as CONTA_OPINA,Datos.ID_NOTICIA from noticias_rubros Rubro,noticias_datos Datos left join noticias_fotos Fotos on (Datos.ID_NOTICIA=Fotos.ID_NOTICIA and Fotos.MOSTRAR) left join noticias_videos Video on (Datos.ID_NOTICIA=Video.ID_NOTICIA and Video.MOSTRAR) left join noticias_opiniones Opina on (Opina.ID_TABLA=Datos.ID_NOTICIA and Opina.MOSTRAR) where Rubro.MOSTRAR and Datos.MOSTRAR and Datos.ID_RUBRO=Rubro.ID_RUBRO and Datos.ID_NOTICIA='00000001' group by Datos.ID_NOTICIA Order By Datos.FECHA desc