[rogue]

try this select:

select distinct value as studioname, rand() as random from
$sql_tbl[extra_field_values] WHERE fieldid='4' AND value IS NOT NULL ORDER BY random LIMIT 20