SELECT `rn_banneraccess`.`BannerCode`, `rn_banneraccess`.`PlaceCode`, `rn_banneraccess`.`BannerId`, `rn_banneraccess`.`BannerLifeTime` 
FROM `rn_banners`, `rn_banneraccess` LEFT JOIN `rn_stoplist` ON `rn_banneraccess`.`BannerId`=`rn_stoplist`.`BannerId` 
WHERE `rn_banneraccess`.`BannerId` = `rn_banners`.`BannerId` AND (((`rn_stoplist`.`BannerId` IS NULL) AND 
(`rn_banneraccess`.`URL`="all" OR INSTR("",`rn_banneraccess`.`URL`)=1 OR "" REGEXP 
CONCAT('^',REPLACE(REPLACE(`rn_banneraccess`.`URL`,'?','.'),'*','.*'),'$')) AND 
((`rn_banneraccess`.`CookieName`="region" AND `rn_banneraccess`.`CookieValue`="65") OR `rn_banneraccess`.`CookieName`="") 
AND (`rn_banneraccess`.`PlaceId`=35)) OR (((`rn_banneraccess`.`URL`="all" OR INSTR("",`rn_banneraccess`.`URL`)=1 OR "" 
REGEXP CONCAT('^',REPLACE(REPLACE(`rn_banneraccess`.`URL`,'?','.'),'*','.*'),'$')) AND ((`rn_banneraccess`.`CookieName`="region" 
AND `rn_banneraccess`.`CookieValue`="65") OR `rn_banneraccess`.`CookieName`="") AND (`rn_banneraccess`.`PlaceId`=35) 
AND (SELECT COUNT(*) FROM `rn_stoplist` WHERE `rn_stoplist`.`BannerId`=`rn_banneraccess`.`BannerId` 
AND `rn_stoplist`.`VisitorId`="c4d1927671cacc619469f936325c3938" AND 
(UNIX_TIMESTAMP()-(UNIX_TIMESTAMP(`rn_stoplist`.`ShowTime`)+`rn_stoplist`.`LifeTime`*60))<0)=0))) 
ORDER BY `rn_banneraccess`.`BannerPriority`+CAST((RAND()*10/2) AS UNSIGNED) DESC LIMIT 1