| SQL | SELECT a.ad_id, a.position_id, a.media_type, a.ad_link, a.ad_code, a.ad_name,a.ad_title,a.ad_content, p.ad_width, p.ad_height, p.position_style, RAND() AS rnd FROM `damostar`.`ecs_ad` AS a LEFT JOIN `damostar`.`ecs_ad_position` AS p ON a.position_id = p.position_id WHERE enabled = 1 AND start_time <= '1566565480' AND end_time >= '1566565480' AND a.position_id = '66' ORDER BY rnd LIMIT 3 |