Subversion Repositories eFlore/Applications.del

Rev

Rev 1932 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1932 Rev 1959
Line 55... Line 55...
55 
SELECT id_commentaire, ce_observation,
55 
SELECT id_commentaire, ce_observation,
56 
	SUM(CASE
56 
	SUM(CASE
57 
	    	WHEN valeur = 1 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' != 0 THEN 3
 57 
	    	WHEN valeur = 1 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' != 0 THEN 3
58 
	    	WHEN valeur = 0 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' != 0 THEN -3
 58 
	    	WHEN valeur = 0 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' != 0 THEN -3
59 
	    	WHEN valeur = 1 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' = 0 THEN 1
 59 
	    	WHEN valeur = 1 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' = 0 THEN 1
60 
	    	WHEN valeur = 0 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' != 0 THEN -1
 60 
	    	WHEN valeur = 0 AND dcv.ce_utilisateur REGEXP '^-?[0-9]+$' = 0 THEN -1
61 
        END
 61 
        END
62 
	) as score
62 
	) as score
63 
FROM del_commentaire dc
63 
FROM del_commentaire dc
64 
INNER JOIN del_commentaire_vote dcv
64 
INNER JOIN del_commentaire_vote dcv
65 
    ON dc.id_commentaire = dcv.ce_proposition
65 
    ON dc.id_commentaire = dcv.ce_proposition