Elezioni Lombardia 21

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 = 117
GROUP BY pc.id
ORDER BY cnt desc