SELECT id_rooms, particulier_fr, mapnumber,calendrier.id, TRIM(CONCAT(titrefr,', ',stitrefr)) AS titr, id_streets, place, firstimage, numero FROM calendrier WHERE calendrier.cat='parcours' AND typeexpo!='lieu' AND idp='0' AND calendrier.del ='0' AND id_quartiers = '4' AND mapnumber != '0' ORDER BY mapnumber, id_rooms DESC, id_streets, titr