proxima parada time in a circle

Time in a Circle

101
PUNTOS

Siento que esta canción es de las mejores piezas de soul contemporáneo que escuché. No sabía nada de este grupo y desde hace días que no puedo parar de escuchar su último disco, ‘Big Seven’, del que esta canción forma parte. Increíble y desgarradora voz, piano profundo, un bajo bien groovero y unos arreglos de guitarra bien afilados (¡qué delicia el solo!). Qué más decir, es un track de puta madre. Dale play, busca el disco, se feliz.

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 (67632) AND ( wp_fp30vc_term_relationships.term_taxonomy_id IN (19048) ) 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