dappled cities stone men

Stone Men

17
PUNTOS

Que los Dappled Cities hacen contundentes canciones no es ninguna novedad. El grupo australiano lo viene demostrando hace varios años. Este track tiene (casi) todo: buen groove, sintetizadores precisos, guitarras de todos los colores, una encantadora voz y hasta un vocoder de fondo. Imposible no quedar pegado.

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