SELECT DISTINCT item.itemid,item.name name,item_aquarelle.prefix,item_aquarelle.artist,item_aquarelle.commision,item_aquarelle.startsale,item_aquarelle.endsale,item_aquarelle.price,item_aquarelle.width,item_aquarelle.height,item_aquarelle.adult,item_aquarelle.state,item_aquarelle.media FROM item LEFT JOIN item_aquarelle USING (itemid) LEFT JOIN itemlink subject ON (item.itemid=subject.itema ) LEFT JOIN item_subject ON (subject.itemb = item_subject.itemid AND item_subject.language=2) RIGHT JOIN item artist ON (artist.itemid = item_aquarelle.artist) WHERE item.siteid=22 AND item.trashed=0 AND item.active=1 AND item.type=15 AND artist= ORDER BY name ASC
aquapicta > les artistes
