Statistiche votazione CD Nazionale

SELECT pc.id,pc.bp_poll_id,pc.bp_survey_name,count(pv.bp_survey_id) AS cnt, pc.bp_survey_proposal,pc.bp_survey_photo,pc.bp_survey_cv FROM wp_bp_polls_content AS pc JOIN wp_bp_polls_votes AS pv ON pc.id= pv.bp_survey_id WHERE pv.bp_poll_id = 11 GROUP BY pc.id ORDER BY cnt desc