[MySQL] GROUP BY con ORDER BY su INNER JOIN

[Luigi636]

SELECT click.idLink, link.titolo, link.tipo, link.url, link.imgUrl, link.dataScadenza, link.data, link.attivoFROM click INNER JOIN link 
ON click.idLink = link.id 
WHERE idUtente = $idUtente $where 
GROUP BY click.idLink 
ORDER BY MAX(click.share_date) DESC, link.data DESC