select tadplacements.creativeid,tadplacements.placementid,isExclusive,costPerImp from ((((tadplacements inner join tadplacementdetails AS tdays on tadplacements.placementid=tdays.placementid) inner join tadplacementdetails AS thours on tadplacements.placementid=thours.placementid) inner join tadcreatives on tadplacements.creativeid=tadcreatives.creativeid) inner join tadcampaigns on tadplacements.campaignid=tadcampaigns.campaignid) inner join tadzones on tadplacements.adzoneid=tadzones.adzoneid where tadzones.isActive=1 and tadplacements.isActive=1 and tadcampaigns.isActive=1 and tadplacements.startDate <= #createodbcdate(now())# and tadplacements.endDate >= #createodbcdate(now())# and tadcampaigns.startDate <= #createodbcdate(now())# and tadcampaigns.endDate >= #createodbcdate(now())# and tadcreatives.isActive=1 and tadplacements.adzoneid= and tdays.placementType='weekday' and tdays.placementValue=#dayofWeek(now())# and thours.placementType='hour' and thours.placementValue=#hour(now())# and tadplacements.billable < tadplacements.budget select * from rs where isExclusive=1