After Party: Bad Dessert

A.B.O.B. Music es un dúo que tiene sus raíces en Jamaica y Miami, algo de lo que su sonido da claros indicios. Esto es lo primero que conozco de ellos. After Party: Bad Dessert es un track que mezcla elementos de trap, Hip Hop y dancehall con una atmósfera intensa y, por momentos, oscura. Según ellos mismos describen, la canción hace referencia al hecho de ser consciente de que uno no es consciente de nada la mayoría del tiempo. Para pensar.

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 (68691) AND ( wp_fp30vc_term_relationships.term_taxonomy_id IN (19023,19209) ) 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

LO MEJOR DE 2017

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) WHERE 1=1 AND ( wp_fp30vc_term_relationships.term_taxonomy_id IN (19214) ) 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 NUEVA

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_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