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'

Diálogo iniciado por Mathew Mcvinish sobre:

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

Mathew Mcvinish

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.

Greta Sánchez

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. :-)