Hi Fabrice I create a menu with option "display the map + listing of places" and i add this code
catid="91" or catid="129" or catid="130" ORDER BY RAND () in the "where condition" textbox but dont work
You can used this code in the module, but not in the component.
You must write : a.catid="91" or a.catid="129" or a.catid="130"
And you can't used ORDE BY RAND().
The Order is choise in the parameters.
The ORDE BY RAND() is impossible if you have more than one page of places. At each page, the query works !