MySQL - Vnořené selecty

Tabulka : galerie

id, user, nazev, .....

Tabulka : galerie_fotky

id, id_galerie, nazev, url, ...

SELECT a.id,a.nazev, COUNT(b.id)  as pocet b.url 
FROM galerie a, galerie_fotky b 
WHERE a.user=1 
AND a.id=b.id_galerie 
AND b.id IN 
(
SELECT c.id 
FROM galerie_fotky c,galerie d 
WHERE d.user=1 
AND d.id=c.id_galerie 
ORDER BY RAND()) 
ORDER BY a.vytvoreno DESC;

SELECT a.id,a.nazev, COUNT(b.id) as pocet, b.url FROM galerie a, galerie_fotky b WHERE a.user='".db_esc($id)."' AND a.id=b.id_galerie AND b.id IN (SELECT c.id FROM galerie_fotky c,galerie d WHERE d.user='".db_esc($id)."' AND d.id=c.id_galerie ORDER BY c.vytvoreno DESC) GROUP BY a.id ORDER BY a.vytvoreno DESC;