SELECT distinct id,nombre,descripcion, (select count(ar_id) FROM descargas_fotos where ar_parent=id) as fotos FROM vistaDescargas Order by NOMBRE
ppp
1