So I got this view in mysql :
CREATE VIEW vote_question_totals AS SELECT question_id , SUM((vote_question_type)='1') question_total_plus , SUM((vote_question_type)='-1') question_total_minus , count(*) question_total_mixed ,(SUM((vote_question_type)='1') - SUM((vote_question_type)='-1')) question_total_score FROM vote_question GROUP BY question_id;
and I'm doing a RIGHT JOIN with the question table using the question_id
but then I wanna ORDER by question_total_score and this is where it get problematical. The question with no vote get a question_total_score which is NULL and cant get properly ordered. (I would like my NULL row to be considered like a 0)
What should I do ?