SELECT `Channel`.`median_30d_future_views`, `Channel`.`average_30d_future_views`, `Channel`.`average_30d_future_views_risk`, `Channel`.`future_views_30d_warning_level`, `Channel`.`10_quantile_views`, `Channel`.`90_quantile_views`, `Channel`.`ratio_potential_views_1w`, `Channel`.`average_30d_future_views_shorts`, `Channel`.`average_30d_future_views_shorts_risk`, `Channel`.`future_views_30d_warning_level_shorts`, `Channel`.`10_quantile_views_shorts`, `Channel`.`90_quantile_views_shorts`, `Channel`.`ratio_shorts_potential_views_1w`, `Channel`.`has_demography`, `Channel`.`type_demographies`, `Channel`.`demographyF`, `Channel`.`demographyM`, `Channel`.`reliability_index`, `Channel`.`shorts_views_ratio`, `Channel`.`subscribers_1m`, `Channel`.`videos_uploaded_1m`, `Channel`.`videos_views_1m`, `Channel`.`30d_best_engagement_rate`, `Channel`.`f_age13-17`, `Channel`.`m_age13-17`, `Channel`.`f_age18-24`, `Channel`.`m_age18-24`, `Channel`.`f_age25-34`, `Channel`.`m_age25-34`, `Channel`.`f_age35-44`, `Channel`.`m_age35-44`, `Channel`.`f_age45-54`, `Channel`.`m_age45-54`, `Channel`.`f_age55-64`, `Channel`.`m_age55-64`, `Channel`.`f_age65-`, `Channel`.`m_age65-`, `Channel`.`true_f_age13-17`, `Channel`.`true_m_age13-17`, `Channel`.`true_f_age18-24`, `Channel`.`true_m_age18-24`, `Channel`.`true_f_age25-34`, `Channel`.`true_m_age25-34`, `Channel`.`true_f_age35-44`, `Channel`.`true_m_age35-44`, `Channel`.`true_f_age45-54`, `Channel`.`true_m_age45-54`, `Channel`.`true_f_age55-64`, `Channel`.`true_m_age55-64`, `Channel`.`true_f_age65-`, `Channel`.`true_m_age65-`, `Channel`.`min_price_youtube_video`, `Channel`.`max_price_youtube_video`, `Channel`.`min_price_youtube_mention`, `Channel`.`max_price_youtube_mention`, `Channel`.`min_price_instagram_post`, `Channel`.`max_price_instagram_post`, `Channel`.`min_price_instagram_story`, `Channel`.`max_price_instagram_story`, `Channel`.`min_price_twitter_post`, `Channel`.`max_price_twitter_post`, `Channel`.`banner`, `Channel`.`country`, `Channel`.`display_name`, `Channel`.`followers_facebook`, `Channel`.`followers_instagram`, `Channel`.`followers_twitter`, `Channel`.`handle`, `Channel`.`id`, `Channel`.`id_facebook`, `Channel`.`id_instagram`, `Channel`.`id_twitter`, `Channel`.`is_brand`, `Channel`.`is_media`, `Channel`.`language`, `Channel`.`logo`, `Channel`.`made_for_kids`, `Channel`.`made_for_kids_ratio`, `Channel`.`score`, `Channel`.`subscribers`, `Channel`.`summary`, `Channel`.`tracking_level`, `Channel`.`tiktok_followers`, `Channel`.`tiktok_username`, `Channel`.`twitch_channel_id`, `Channel`.`videos`, `Channel`.`videos_views`, `Channel`.`yt_user_id`, `Channel`.`auto_summary_fr`, `Channel`.`auto_themes_fr`, `Channel`.`auto_summary_en`, `Channel`.`auto_themes_en`, `YtmpContentOwner`.`id`, `YtmpContentOwner`.`display_name`, `TwitchChannel`.`id`, `TwitchChannel`.`login`, `TwitchChannel`.`followers`, `TwitchChannel`.`avg_viewers_3m`, `TwitchChannel`.`tracking_level`, `TwitchChannel`.`potential_avg_viewers`, `TwitchChannel`.`10_quantile_viewers`, `TwitchChannel`.`90_quantile_viewers`, `TwitchChannel`.`ratio_potential_viewers_1w`, `TwitchChannel`.`streams_1m`, ((`Channel`.`earnings` / `Channel`.`true_views`) * 1000) AS `Channel__rpm`, ((`Channel`.`earnings_1m` / `Channel`.`true_views_1m`) * 1000) AS `Channel__rpm_1m`, (ROUND(`Channel`.`max_price_youtube_video`/2.22)) AS `Channel__youtube_video_pricing_computed`, (ROUND(`Channel`.`max_price_youtube_mention`/1.6)) AS `Channel__youtube_mention_pricing_computed`, (ROUND(`Channel`.`max_price_instagram_post`/1.4)) AS `Channel__instagram_post_pricing_computed`, (ROUND(`Channel`.`max_price_instagram_story`/0.45)) AS `Channel__instagram_story_pricing_computed`, (ROUND(`Channel`.`max_price_twitter_post`/1.25)) AS `Channel__twitter_post_pricing_computed`, (IF(ISNULL(`Channel`.`portfolio_youtube_mention_pricing`),
IF(ISNULL(`Channel`.`youtube_mention_pricing`),
IF(ISNULL(`Channel`.`max_price_youtube_mention`),
NULL,
ROUND(`Channel`.`max_price_youtube_mention` / (1.6 * 100)) * 100
),
`Channel`.`youtube_mention_pricing`
),
`Channel`.`portfolio_youtube_mention_pricing`
)) AS `Channel__default_youtube_mention_pricing`, (ROUND(IF(
ISNULL(average_30d_future_views) OR ISNULL(IF(ISNULL(`Channel`.`portfolio_youtube_mention_pricing`),
IF(ISNULL(`Channel`.`youtube_mention_pricing`),
IF(ISNULL(`Channel`.`max_price_youtube_mention`),
NULL,
ROUND(`Channel`.`max_price_youtube_mention` / (1.6 * 100)) * 100
),
`Channel`.`youtube_mention_pricing`
),
`Channel`.`portfolio_youtube_mention_pricing`
)),
null,
1000 * IF(ISNULL(`Channel`.`portfolio_youtube_mention_pricing`),
IF(ISNULL(`Channel`.`youtube_mention_pricing`),
IF(ISNULL(`Channel`.`max_price_youtube_mention`),
NULL,
ROUND(`Channel`.`max_price_youtube_mention` / (1.6 * 100)) * 100
),
`Channel`.`youtube_mention_pricing`
),
`Channel`.`portfolio_youtube_mention_pricing`
) / average_30d_future_views), 2)) AS `Channel__cpm_youtube_mention_pricing` FROM `wiztracker`.`channels` AS `Channel` LEFT JOIN `wiztracker`.`ytmp_content_owners` AS `YtmpContentOwner` ON (`Channel`.`ytmp_content_owner_id` = `YtmpContentOwner`.`id`) LEFT JOIN `wiztracker`.`twitch_channels` AS `TwitchChannel` ON (`Channel`.`twitch_channel_id` = `TwitchChannel`.`id` AND `TwitchChannel`.`tracking_level` < 300) WHERE `Channel`.`id` = 2728156 AND `Channel`.`tracking_level` < 300 # cible : "http://refonte.wiztracker.net/fr/channels/2728156-John_Nellis" | 1 | 1 | 3 | maybe slow |