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','handjobs:*')) and type_id=0 and exists (select videa_id from category_videa where category_id=48 and videa_id=v.id) offset 0 limit 100 ) as foo order by random() limit 24