Mysql其他

select *   from 
    (select city,usage_percent from cdn_usage_city_5min where time='{getTime()}'  and city  not like '%未知%' ) as a 
    LEFT  JOIN 
    (select city,carton_rate_percent from carton_city_5min where time ={getTime()}) as b on a.city=b.city
    LEFT JOIN (select cdn_city,rate_percent from schedule_rate_5min where bras_city=cdn_city and time ={getTime()} ) as d on d.cdn_city=b.city
    LEFT JOIN (select city,avg_hot_covered_rate_percent from db_ott_{yestaday_date}.hot_covered_cdn_city where city !="未知CDN") as e on e.city=a.city
    LEFT JOIN (select city,total_count from user_count_city_5min where    time ={getTime()} ) as f on f.city=a.city
    　

连表范例