SELECT P.podcast_id, podcast_title, podcast_status, nb_episodes, T.twitter_user_id, podcast_desc, podcast_author, podcast_creadt, podcast_upddt, podcast_num, P.plan_id, podcast_tz, plan_name, podcast_quota, storage_allowed, max_size_per_file, itunes_id, itunes_url, IM.image_name, user_email, P.downloads, P.plays, facebook_id, target_id, P.user_id, P.itunes_category_id, itunes_explicit, itunes_category_feed, P.cat_id, cat_rewrite, cat_title, podcast_city, P.country_id, SCL.country_name, rank, google_id, google_url, google_code, GP.submit_creadt AS google_code_expire, spotify_id, spotify_url, spotify_code, SP.submit_creadt AS spotify_code_expire, deezer_id, deezer_url, deezer_code, DP.submit_creadt AS deezer_code_expire, ROUND(podcast_quota/storage_allowed*100,1) AS percent, link_url, link_id, CONCAT("https://djpod.com/",LOWER(P.podcast_id)) AS podcast_url, CONCAT("http://feeds.djpod.com/",LOWER(P.podcast_id)) AS podcast_feed, CONCAT("https://i1-static.djpod.com/podcasts/",LOWER(P.podcast_id)) AS static_url, CONCAT("https://i1-cloud.djpod.com/",LOWER(P.podcast_id)) AS cloud_url, CONCAT("https://download.djpod.com/",LOWER(P.podcast_id)) AS download_url, CONCAT(IM.image_file,"_120x120.",IM.image_type) AS image_120px, CONCAT(IM.image_file,"_200x200.",IM.image_type) AS image_200px, CONCAT(IM.image_file,"_320x320.",IM.image_type) AS image_320px, CONCAT(IM.image_file,"_640x640.",IM.image_type) AS image_640px, CONCAT(IM.image_file,"_1400x1400.",IM.image_type) AS image_1400px, podcast_lang, P.subscription_id FROM djpod_podcast P LEFT JOIN djpod_image IM ON IM.podcast_id = P.podcast_id AND IM.episode_id IS NULL AND IM.image_status = 1 INNER JOIN djpod_plan PL ON PL.plan_id = P.plan_id INNER JOIN djpod_user U ON U.user_id = P.user_id LEFT JOIN djpod_facebook F ON F.podcast_id = P.podcast_id LEFT JOIN djpod_twitter T ON T.podcast_id = P.podcast_id LEFT JOIN djpod_itunes_category IC ON IC.itunes_category_id = P.itunes_category_id LEFT JOIN djpod_itunes I ON I.podcast_id = P.podcast_id AND I.submit_status = 1 LEFT JOIN djpod_google GP ON GP.podcast_id = P.podcast_id LEFT JOIN djpod_spotify SP ON SP.podcast_id = P.podcast_id LEFT JOIN djpod_deezer DP ON DP.podcast_id = P.podcast_id LEFT JOIN djpod_podcast_web PW ON PW.podcast_id = P.podcast_id AND PW.itunes_link = 1 LEFT JOIN djpod_category C ON C.cat_id = P.cat_id LEFT JOIN djpod_category_lang CL ON CL.cat_id = C.cat_id AND CL.lang = "en" LEFT JOIN djpod_country_lang SCL ON SCL.country_id = P.country_id AND SCL.lang = "en" LEFT JOIN djpod_rank R ON R.podcast_id = P.podcast_id AND rank_dt = "2024-01-30" WHERE NULL IS NULL AND P.podcast_status IN(-5,-1,0,1) AND P.podcast_id = 'unabistestosteroneboostergummyus' ORDER BY P.podcast_id ASC