Votazione GdP Trattamento Conservativo della Malattia Renale Cronica
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 = 56
GROUP BY pc.id
ORDER BY cnt desc
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 = 57
GROUP BY pc.id
ORDER BY cnt desc