getNotesCritiques.sql 225 Bytes
select ID_DETAILS as itemId, ID_UTILISATEUR as userId, note as rating from critique, journalisable
where critique.ID_JOURNALISABLE = journalisable.ID_JOURNALISABLE
and ID_UTILISATEUR is not null
order by userId, itemId;
quit