SELECT a_id, a_nom, a_prenom, a_marine, a_description, o_id FROM galerie_artistes LEFT JOIN (SELECT o_id, o_artiste FROM galerie_oeuvres ORDER BY RAND()) t ON a_id=o_artiste WHERE a_visible='o' GROUP BY a_id ORDER BY a_nom
Disk full (/tmp/#sql_406d_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")