select rm.*,rm.shortname as roomshortname, wm.shortname, hm.company, hm.url, hm.smphoto1, hm.id, y2.avg_rating, y2.no_rating , y2.avg_rate_yr as avg_rate , substr(yn.occbases,0,730) as av_occ from webervations.members wm, hockinghills.members@hho hm, webervations.rooms rm, nightclerk.room_yn@nc yn, nightclerk.room_2@nc y2 where wm.memberid=hm.ronid and wm.memberid=rm.memberid and yn.roomid=rm.roomid and yn.roomid=y2.roomid and hm.curmember='Y' and hm.hhigmember='Y' and hm.cat1='Accommodations' and rm.active='Y' and rm.showonline='Y' and rm.overnight_accom = 'Y' AND rm.roomtypeid in (1005,1006,1034,1054,1003,1007) ORDER BY rm.DBMS_RANDOM - rm.userid*.01;