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','rough:*')) and type_id=0 offset 0 limit 100 ) as foo order by random() limit 24