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, 18

NUESTRAS FAVORITAS

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_term_relationships.term_taxonomy_id IN (19214) ) 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, 18

ARTÍCULOS

MÁS ESCUCHADAS

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 NOT IN (66903,66943,66993,66974,66963,67003,66998,66983,66977,66959,66954,66930) AND ( wp_fp30vc_postmeta.meta_key = 'plays' ) 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, 18

RADIOS DESTACADAS

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 (66993,66974,67003,66903,66943,66930) 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, 66993,66974,67003,66903,66943,66930 ) LIMIT 0, 6