So I have this line of code:

```
$results = mysql_query('
    SELECT * 
    FROM members 
    WHERE category1="Photographers" 
    ORDER BY premium DESC, featured DESC, company ASC');

```

Everything works great, Premium members show up above featured. Featured above regular members, and they are all in alphabetical order. However I want to have featured members show above regular members but randomized and not in alphabetical order. I have tried RAND() but it randomizes all my members, please help.