One dick for two chicks
select id,xvideos_id,url,pic,name,iframe,tags,length,date,site,pic_prev,prev from
( SELECT v.id,xvideos_id,url,pic,name,iframe,tags,length,date,site,pic_prev,prev FROM videa v WHERE (tsv @@ to_tsquery('simple','hardcore:*')) and type_id=0 offset 0 limit 100 )
as foo order by random() limit 24