SELECT notations_objets.id_objet, notations_objets.note_ponderee
FROM spip_notations_objets AS `notations_objets`  
INNER JOIN{{ spip_articles}} AS L1 ON ( L1.id_article = notations_objets.id_objet AND notations_objets.objet='article')
WHERE (notations_objets.objet = 'rubrique')
	AND (L1.lang = 'fr')
GROUP BY notations_objets.objet,notations_objets.id_objet
ORDER BY notations_objets.note_ponderee DESC