SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '42780'
Mcvinish sobre «Creatividad versus innovación» | FOROALFA

Diálogo iniciado por Mathew Mcvinish sobre:

Ilustración principal del artículo Creatividad versus innovación

Greta Sánchez

Creatividad versus innovación

A menudo se suele referir a los diseños sorprendentes como «muy creativos e innovadores», pero muchas ideas creativas no desembocan en innovaciones.

Ver este artículo

Retrato de Mathew Mcvinish
5
Jun 2012

soy un estudiante de diseño industrial de la Universidad de Bogota Jorge Tadeo Lozano el cual esta en la búsqueda de su proyecto de grado y tu articulo claro y puntual es de gran ayuda para poder emprender con un proyecto con las características que mencionas.

0
Retrato de Greta Sánchez
78
Jun 2012

Qué gusto Mathew, me alegra saber que te sea de utilidad. Hay mucha bibliografía interesante sobre el tema, aunque la mayoría en inglés. Tenemos como reto generar nuestras propias publicaciones, vistas desde nuestra realidad latinoamericana. :-)

2
Retrato de Mathew Mcvinish
5
Jun 2012

Es sierto, muchas gracias por tu respuesta...

0
Responder

Este video podría interesarte👇👇👇

		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '50552'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '47890'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '47890'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '1'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '101102'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '4'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '4'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '4'
		SELECT *,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 1) nombre,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 2) apellido,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 17) sexo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 9) ciudad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 12) provincia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 10) id_pais,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 4) domicilio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 8) codigo_postal,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 11) telefono,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 26) nacimiento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 13) practica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 14) trabaja,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 15) ensena,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 16) estudia,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 18) areas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 28) sitio,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 30) movil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 3) trayectoria,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 5) twitter,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 48) instagram,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 49) linkedin,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 50) behance,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 51) pinterest,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 52) flickr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 53) tumblr,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 54) youtube,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 33) facebook_id,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 34) facebook_token,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 35) facebook,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 47) facebook_link,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 19) skype,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 20) msn,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 6) horario,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 7) documento,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 21) email_alternativo,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 32) email_alternativo_2,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 22) politica,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 23) perfil,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 24) cv,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 36) profesion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 37) especialidad,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 25) org,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 39) idiomas_articulos,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 40) idiomas_edicion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 41) idiomas_traduccion,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 45) cliente,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 46) notificaciones_vistas,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 55) rescate_intentado,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 56) banned,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 2) suscriptor_es,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 30) suscriptor_pt,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 39) suscriptor_en,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 44) suscriptor_it,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 23) suscriptor_cursos,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND listid = 1) suscriptor_clap,
		(SELECT listid FROM phplist_listuser WHERE a.id = userid AND (listid = 133 OR listid = 8)) suscriptor_no_confirmado,
		(SELECT url FROM phplist_listattr_pais WHERE id = id_pais) url_pais,
		(SELECT moneda FROM phplist_listattr_pais WHERE id = id_pais) moneda_pais,
		(SELECT country_code FROM phplist_listattr_pais WHERE id = id_pais) country_code,
		(SELECT value FROM phplist_user_user_attribute WHERE a.id = userid AND attributeid = 38) id_idioma,
		(SELECT lang FROM phplist_listattr_idioma WHERE id = id_idioma) idioma,
		(SELECT name FROM phplist_listattr_sexo WHERE id = sexo) sexo_nombre,
		(SELECT dominio FROM phplist_listattr_pais WHERE id = id_pais) dominio,

		(SELECT 1 from phplist_listuser l WHERE l.userid = a.id AND l.listid = 6) activo,
		(SELECT count(*) FROM fa_productos_visitas WHERE id_usuario = a.id) visitas_productos,
		(SELECT count(*) FROM fa_mensajes WHERE m_usuario = a.id) mensajes,
		(SELECT count(*) FROM fa_prospectos WHERE v_usuario = a.id) prospectos,
		(SELECT count(*) FROM fa_ventas WHERE v_usuario = a.id) ventas,
		(SELECT count(*) FROM fa_contenidos_votos WHERE usuario = a.id) votados,
		(SELECT count(*) FROM fa_contenidos_visitas WHERE id_usuario = a.id) vistas_contenidos,
		(SELECT count(*) FROM phplist_usermessage WHERE userid = a.id AND viewed is not null) mensajes_vistos


		FROM phplist_user_user a
		WHERE id = '4'

Te podrían interesar

Ilustración principal del artículo Sexo en la publicidad
Autor:
Maria del Pilar Rovira Serrano
Título:
Sexo en la publicidad
Sinopsis:
Los últimos 75 años fueron marcados por la revolución sexual, transformando profundamente todos los ámbitos de la sociedad occidental y se ha instaurado también en la publicidad.
Compartir:
Ilustración principal del artículo Cuál es la diferencia entre diseño UI y diseño UX
Autor:
Enrique Iturriaga
Título:
Cuál es la diferencia entre diseño UI y diseño UX
Sinopsis:
Dos conceptos que están muy de moda pero que suelen confundirse. Conoce las diferencias y la relación entre ambos.
Traducciones:
Compartir:
Ilustración principal del artículo Diálogos con diseñadores
Autor:
FOROALFA
Título:
Diálogos con diseñadores
Sinopsis:
Reflexiones sobre el deterioro profesional en el diseño gráfico, los intentos habituales para enfrentarlo y nuevas propuestas desde la administración.
Compartir:
Retrato de Guillermo Dufranc
Autor:
Guillermo Dufranc
Título:
Rediseño de packaging: ¿evolución o revolución?
Sinopsis:
Al momento de realizar una actualización de diseño de envase, se debe plantear cuánto y cómo cambiar la identidad existente, para ganar relevancia sin perder reconocimento.
Compartir:
Retrato de André Ricard
Autor:
André Ricard
Título:
El plagio en el diseño y sus matices
Sinopsis:
Todo diseño reconoce antecedentes, todo lo nuevo se basa en experiencias anteriores, y en ese proceso, inevitable y legítimo, también hay lugar para la mala fe.
Traducciones:
Compartir:
Retrato de André Ricard
Autor:
André Ricard
Título:
Definir territorio
Sinopsis:
Extracto de mi libro «Hitos del diseño», donde acoto el ámbito creativo que le corresponde al diseño.
Compartir:

Próximos seminarios online

Seminarios de actualización para especializarte junto a los que más saben

Branding Corporativo

Branding Corporativo

Cómo planificar, construir y gestionar la marca de empresas e instituciones

20 horas (aprox.)
1 diciembre

Compartir:
Auditoría de Marca

Auditoría de Marca

Taller de práctica profesional: análisis, diagnóstico y programa de marca sobre casos reales

30 horas (aprox.)
1 diciembre

Compartir:
Rediseño Estratégico de Marca

Rediseño Estratégico de Marca

Guía analítica y método de trabajo para determinar estrategias de cambio de marca

15 horas (aprox.)
1 enero

Compartir:
Relecturas del Diseño

Relecturas del Diseño

Una inmersión en el discurso sobre el diseño para despejar sus nociones más controvertidas: creatividad, innovación, arte, tecnología...

20 horas (aprox.)
1 enero

Compartir:
Branding: Diseñador y Cliente

Branding: Diseñador y Cliente

Tratar con el cliente, hacer presupuestos y planificar las etapas de la creación de una marca

15 horas (aprox.)
1 enero

Compartir:
Estrategia de Marca

Estrategia de Marca

Claves para programar el diseño de símbolos y logotipos de alto rendimiento

20 horas (aprox.)
1 febrero

Compartir: