Beach House Chariot

Chariot

20
PUNTOS

Ese órgano MIDI que nos recuerda lo mejor y lo peor de los 80s, empieza a envolvernos y desde lejos oímos llegar la voz angelical de Victoria Legrand que canta desconsolada sobre los buenos tiempos de un romance que acabó mal. La letra de esta canción de Beach House es una postal de los días soleados de una pareja, sin embargo, su música contrasta los detalles con esos teclados cada vez son más amargos; y el puente de la canción que parece acabar en un mar de penas, es ciertamente emotivo. Sin dudas, es uno de esos temas que -si te sientes heartbroken- te emocionará hasta las lágrimas.

SELECT SQL_CALC_FOUND_ROWS wp_fp30vc_posts.ID FROM wp_fp30vc_posts LEFT JOIN wp_fp30vc_term_relationships ON (wp_fp30vc_posts.ID = wp_fp30vc_term_relationships.object_id) INNER JOIN wp_fp30vc_postmeta ON ( wp_fp30vc_posts.ID = wp_fp30vc_postmeta.post_id ) WHERE 1=1 AND wp_fp30vc_posts.ID NOT IN (68044) AND ( wp_fp30vc_term_relationships.term_taxonomy_id IN (19011,19024) ) AND ( ( wp_fp30vc_postmeta.meta_key = 'music_type' AND wp_fp30vc_postmeta.meta_value = 'single' ) ) AND wp_fp30vc_posts.post_type = 'download' AND (wp_fp30vc_posts.post_status = 'publish' OR wp_fp30vc_posts.post_status = 'inactive' OR wp_fp30vc_posts.post_status = 'active' OR wp_fp30vc_posts.post_status = 'processing' OR wp_fp30vc_posts.post_status = 'abandoned' OR wp_fp30vc_posts.post_status = 'revoked' OR wp_fp30vc_posts.post_status = 'failed' OR wp_fp30vc_posts.post_status = 'refunded') GROUP BY wp_fp30vc_posts.ID ORDER BY wp_fp30vc_posts.post_date DESC LIMIT 0, 6

MÚSICA RELACIONADA

Deja un comentario

SELECT SQL_CALC_FOUND_ROWS wp_fp30vc_posts.ID FROM wp_fp30vc_posts INNER JOIN wp_fp30vc_postmeta ON ( wp_fp30vc_posts.ID = wp_fp30vc_postmeta.post_id ) INNER JOIN wp_fp30vc_postmeta AS mt1 ON ( wp_fp30vc_posts.ID = mt1.post_id ) WHERE 1=1 AND wp_fp30vc_posts.ID NOT IN (66903,66943,66993,66974,66963,67003,66998,66983,66977,66959,66954,66930) AND ( wp_fp30vc_postmeta.meta_key = 'plays' AND ( ( mt1.meta_key = 'music_type' AND mt1.meta_value = 'single' ) ) ) AND wp_fp30vc_posts.post_type = 'download' AND (wp_fp30vc_posts.post_status = 'publish' OR wp_fp30vc_posts.post_status = 'inactive' OR wp_fp30vc_posts.post_status = 'active' OR wp_fp30vc_posts.post_status = 'processing' OR wp_fp30vc_posts.post_status = 'abandoned' OR wp_fp30vc_posts.post_status = 'revoked' OR wp_fp30vc_posts.post_status = 'failed' OR wp_fp30vc_posts.post_status = 'refunded') GROUP BY wp_fp30vc_posts.ID ORDER BY wp_fp30vc_postmeta.meta_value+0 DESC LIMIT 0, 5

MÚSICA MÁS ESCUCHADA

SELECT SQL_CALC_FOUND_ROWS wp_fp30vc_posts.ID FROM wp_fp30vc_posts INNER JOIN wp_fp30vc_postmeta ON ( wp_fp30vc_posts.ID = wp_fp30vc_postmeta.post_id ) WHERE 1=1 AND wp_fp30vc_posts.ID IN (67003,66977,66983,66998,66959,66954,66930,66903,66943,66993,66974,66963) AND ( ( wp_fp30vc_postmeta.meta_key = 'music_type' AND wp_fp30vc_postmeta.meta_value = 'single' ) ) AND wp_fp30vc_posts.post_type = 'download' AND (wp_fp30vc_posts.post_status = 'publish' OR wp_fp30vc_posts.post_status = 'inactive' OR wp_fp30vc_posts.post_status = 'active' OR wp_fp30vc_posts.post_status = 'processing' OR wp_fp30vc_posts.post_status = 'abandoned' OR wp_fp30vc_posts.post_status = 'revoked' OR wp_fp30vc_posts.post_status = 'failed' OR wp_fp30vc_posts.post_status = 'refunded') GROUP BY wp_fp30vc_posts.ID ORDER BY FIELD( wp_fp30vc_posts.ID, 67003,66977,66983,66998,66959,66954,66930,66903,66943,66993,66974,66963 ) LIMIT 0, 5

RADIOS