SELECT nano_albums.nombre_album, nano_albums.publicar, nano_imagenes.* FROM (nano_imagenes LEFT JOIN nano_albums ON nano_albums.id=nano_imagenes.id_album) WHERE nano_albums.publicar='Y' AND nano_imagenes.ubicacion="1" AND socio<>"Y":portableadmin_wocwp