MySQL order by + rand()

[fritz85]

Hallo

bin jetzt gerade dran.. jedoch seh ich denn Fehler nix. Denn meine Abfrage macht genau das gleiche wie vorhin.

$query = $db->dbquery("  
		(SELECT `s`.*, `k`.name AS `kname` FROM `eintraege` AS `s` LEFT JOIN `region` AS `k` ON k.id = s.kanton WHERE s.name != '' AND s.cat LIKE '".$catdb."' AND s.status = '1' ORDER BY s.premium DESC, s.time DESC LIMIT $start,$ins_page)  
		UNION  
		(SELECT `s`.*, `k`.name AS `kname` FROM `eintraege` AS `s` LEFT JOIN `region` AS `k` ON k.id = s.kanton WHERE s.name != '' AND s.cat LIKE '".$catdb."' AND s.status = '1' AND s.premium = '1' ORDER BY RAND() LIMIT $start,$ins_page)");