Symfony Profiler

SELECT
  m0_.name AS name_0,
  m0_.thumbnail AS thumbnail_1,
  m0_.short_description AS short_description_2,
  m0_.description AS description_3,
  m0_.release_date AS release_date_4,
  m0_.publish AS publish_5,
  m0_.complete AS complete_6,
  m0_.updated AS updated_7,
  m0_.position AS position_8,
  m0_.id AS id_9,
  m0_.auto_mainstreet AS auto_mainstreet_10,
  m0_.commission AS commission_11,
  m0_.contact_name AS contact_name_12,
  m0_.email AS email_13,
  m0_.video_link AS video_link_14,
  m0_.spotify_username AS spotify_username_15,
  m0_.spotify_link AS spotify_link_16,
  m0_.sound_cloud_username AS sound_cloud_username_17,
  m0_.sound_cloud_link AS sound_cloud_link_18,
  m0_.tik_tok_username AS tik_tok_username_19,
  m0_.tik_tok_link AS tik_tok_link_20,
  m0_.approve_status AS approve_status_21,
  m0_.old_parents AS old_parents_22,
  m0_.publish_date AS publish_date_23,
  m0_.actual_publish_date AS actual_publish_date_24,
  m0_.youtube_username AS youtube_username_25,
  m0_.youtube_link AS youtube_link_26,
  m0_.instagram_username AS instagram_username_27,
  m0_.instagram_link AS instagram_link_28,
  m0_.twitter_username AS twitter_username_29,
  m0_.twitter_link AS twitter_link_30,
  m0_.facebook_username AS facebook_username_31,
  m0_.facebook_link AS facebook_link_32,
  m0_.website_link AS website_link_33,
  m0_.stripe_customer AS stripe_customer_34,
  m0_.season_id AS season_id_35
FROM
  music_video m0_
  LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id
  LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id
  AND (m1_.publish = 1)
  LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id
  AND (m3_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id)
  LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id
  LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id
  AND (m5_.publish = 1)
  LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id
  LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id
  AND (m8_.publish = 1)
  LEFT JOIN bind_music_video_character_signature_item b9_ ON (
    b9_.music_video_character_signature_id = m8_.id
  )
  LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id
  AND (m7_.artist_id = m10_.artist_id)
  LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id
  AND (m11_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b12_ ON (
    b12_.music_scene_id = m11_.id
    AND b12_.music_video_character_id = m7_.id
  )
  LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id
  AND (m13_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b14_ ON (
    b14_.music_artist_character_id = m10_.id
    AND b14_.music_artist_post_id = m13_.id
  )
  LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id
  AND (m15_.publish = 1)
  LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id
  AND (m16_.publish = 1)
  LEFT JOIN bind_music_video_set_item b17_ ON (
    b17_.music_video_set_id = m16_.id
  )
  LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id
  AND (m18_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b19_ ON (
    b19_.music_artist_post_id = m18_.id
  )
  LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id
  AND (m20_.publish = 1)
  LEFT JOIN bind_music_artist_merch b21_ ON (
    b21_.music_artist_merch_id = m20_.id
  )
WHERE
  (
    b4_.id IS NOT NULL
    OR (
      (
        b9_.id IS NOT NULL
        OR b12_.id IS NOT NULL
        OR b14_.id IS NOT NULL
      )
      AND m10_.id IS NOT NULL
    )
    OR b17_.id IS NOT NULL
    OR b19_.id IS NOT NULL
    OR b21_.id IS NOT NULL
  )
  AND m0_.publish = 1
GROUP BY
  m0_.name,
  m0_.thumbnail,
  m0_.short_description,
  m0_.description,
  m0_.release_date,
  m0_.publish,
  m0_.complete,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.auto_mainstreet,
  m0_.commission,
  m0_.contact_name,
  m0_.email,
  m0_.video_link,
  m0_.spotify_username,
  m0_.spotify_link,
  m0_.sound_cloud_username,
  m0_.sound_cloud_link,
  m0_.tik_tok_username,
  m0_.tik_tok_link,
  m0_.approve_status,
  m0_.old_parents,
  m0_.publish_date,
  m0_.actual_publish_date,
  m0_.youtube_username,
  m0_.youtube_link,
  m0_.instagram_username,
  m0_.instagram_link,
  m0_.twitter_username,
  m0_.twitter_link,
  m0_.facebook_username,
  m0_.facebook_link,
  m0_.website_link,
  m0_.stripe_customer,
  m0_.season_id
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.thumbnail AS thumbnail_1, m0_.short_description AS short_description_2, m0_.description AS description_3, m0_.release_date AS release_date_4, m0_.publish AS publish_5, m0_.complete AS complete_6, m0_.updated AS updated_7, m0_.position AS position_8, m0_.id AS id_9, m0_.auto_mainstreet AS auto_mainstreet_10, m0_.commission AS commission_11, m0_.contact_name AS contact_name_12, m0_.email AS email_13, m0_.video_link AS video_link_14, m0_.spotify_username AS spotify_username_15, m0_.spotify_link AS spotify_link_16, m0_.sound_cloud_username AS sound_cloud_username_17, m0_.sound_cloud_link AS sound_cloud_link_18, m0_.tik_tok_username AS tik_tok_username_19, m0_.tik_tok_link AS tik_tok_link_20, m0_.approve_status AS approve_status_21, m0_.old_parents AS old_parents_22, m0_.publish_date AS publish_date_23, m0_.actual_publish_date AS actual_publish_date_24, m0_.youtube_username AS youtube_username_25, m0_.youtube_link AS youtube_link_26, m0_.instagram_username AS instagram_username_27, m0_.instagram_link AS instagram_link_28, m0_.twitter_username AS twitter_username_29, m0_.twitter_link AS twitter_link_30, m0_.facebook_username AS facebook_username_31, m0_.facebook_link AS facebook_link_32, m0_.website_link AS website_link_33, m0_.stripe_customer AS stripe_customer_34, m0_.season_id AS season_id_35 FROM music_video m0_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id AND (m8_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b9_ ON (b9_.music_video_character_signature_id = m8_.id) LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id AND (m7_.artist_id = m10_.artist_id) LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id AND (m11_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b12_ ON (b12_.music_scene_id = m11_.id AND b12_.music_video_character_id = m7_.id) LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id AND (m13_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b14_ ON (b14_.music_artist_character_id = m10_.id AND b14_.music_artist_post_id = m13_.id) LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id AND (m15_.publish = 1) LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id AND (m16_.publish = 1) LEFT JOIN bind_music_video_set_item b17_ ON (b17_.music_video_set_id = m16_.id) LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id AND (m18_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b19_ ON (b19_.music_artist_post_id = m18_.id) LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id AND (m20_.publish = 1) LEFT JOIN bind_music_artist_merch b21_ ON (b21_.music_artist_merch_id = m20_.id) WHERE (b4_.id IS NOT NULL OR ((b9_.id IS NOT NULL OR b12_.id IS NOT NULL OR b14_.id IS NOT NULL) AND m10_.id IS NOT NULL) OR b17_.id IS NOT NULL OR b19_.id IS NOT NULL OR b21_.id IS NOT NULL) AND m0_.publish = 1 GROUP BY m0_.name, m0_.thumbnail, m0_.short_description, m0_.description, m0_.release_date, m0_.publish, m0_.complete, m0_.updated, m0_.position, m0_.id, m0_.auto_mainstreet, m0_.commission, m0_.contact_name, m0_.email, m0_.video_link, m0_.spotify_username, m0_.spotify_link, m0_.sound_cloud_username, m0_.sound_cloud_link, m0_.tik_tok_username, m0_.tik_tok_link, m0_.approve_status, m0_.old_parents, m0_.publish_date, m0_.actual_publish_date, m0_.youtube_username, m0_.youtube_link, m0_.instagram_username, m0_.instagram_link, m0_.twitter_username, m0_.twitter_link, m0_.facebook_username, m0_.facebook_link, m0_.website_link, m0_.stripe_customer, m0_.season_id ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

SELECT
  m0_.points AS points_0,
  m0_.id AS id_1,
  m0_.updated AS updated_2,
  sum(m0_.points) AS sclr_3,
  sum(m1_.points) AS sclr_4,
  sum(m2_.points) / (
    DATEDIFF(
      ?,
      min(m2_.updated)
    )
  ) AS sclr_5,
  m0_.target_id AS target_id_6
FROM
  music_video_trend m0_
  LEFT JOIN music_video_trend m2_ ON (
    m2_.id = m0_.id
    AND m2_.updated < ?
  )
  LEFT JOIN music_video_trend m1_ ON (
    m1_.id = m0_.id
    AND m1_.updated >= ?
  )
  INNER JOIN music_video m3_ ON m0_.target_id = m3_.id
  AND (m3_.publish = 1)
GROUP BY
  m0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

SELECT m0_.points AS points_0, m0_.id AS id_1, m0_.updated AS updated_2, sum(m0_.points) AS sclr_3, sum(m1_.points) AS sclr_4, sum(m2_.points) / (DATEDIFF('2026-02-18 00:00:00', min(m2_.updated))) AS sclr_5, m0_.target_id AS target_id_6 FROM music_video_trend m0_ LEFT JOIN music_video_trend m2_ ON (m2_.id = m0_.id AND m2_.updated < '2026-02-18 00:00:00') LEFT JOIN music_video_trend m1_ ON (m1_.id = m0_.id AND m1_.updated >= '2026-02-18 00:00:00') INNER JOIN music_video m3_ ON m0_.target_id = m3_.id AND (m3_.publish = 1) GROUP BY m0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

SELECT
  m0_.points AS points_0,
  m0_.id AS id_1,
  m0_.updated AS updated_2,
  sum(m0_.points) AS sclr_3,
  sum(m1_.points) AS sclr_4,
  sum(m2_.points) / (
    DATEDIFF(
      ?,
      min(m2_.updated)
    )
  ) AS sclr_5,
  'music_artist' AS sclr_6,
  m0_.target_id AS target_id_7
FROM
  music_artist_character_trend m0_
  LEFT JOIN music_artist_character_trend m2_ ON (
    m2_.id = m0_.id
    AND m2_.updated < ?
  )
  LEFT JOIN music_artist_character_trend m1_ ON (
    m1_.id = m0_.id
    AND m1_.updated >= ?
  )
  INNER JOIN music_artist_character m3_ ON m0_.target_id = m3_.id
  INNER JOIN music_artist m4_ ON m3_.music_artist_id = m4_.id
  AND (m4_.publish = 1)
  INNER JOIN music_video_character m5_ ON (m5_.artist_id = m3_.artist_id)
GROUP BY
  m0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

SELECT m0_.points AS points_0, m0_.id AS id_1, m0_.updated AS updated_2, sum(m0_.points) AS sclr_3, sum(m1_.points) AS sclr_4, sum(m2_.points) / (DATEDIFF('2026-02-18 00:00:00', min(m2_.updated))) AS sclr_5, 'music_artist' AS sclr_6, m0_.target_id AS target_id_7 FROM music_artist_character_trend m0_ LEFT JOIN music_artist_character_trend m2_ ON (m2_.id = m0_.id AND m2_.updated < '2026-02-18 00:00:00') LEFT JOIN music_artist_character_trend m1_ ON (m1_.id = m0_.id AND m1_.updated >= '2026-02-18 00:00:00') INNER JOIN music_artist_character m3_ ON m0_.target_id = m3_.id INNER JOIN music_artist m4_ ON m3_.music_artist_id = m4_.id AND (m4_.publish = 1) INNER JOIN music_video_character m5_ ON (m5_.artist_id = m3_.artist_id) GROUP BY m0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

SELECT
  e0_.points AS points_0,
  e0_.id AS id_1,
  e0_.updated AS updated_2,
  sum(e0_.points) AS sclr_3,
  sum(e1_.points) AS sclr_4,
  sum(e2_.points) / (
    DATEDIFF(
      ?,
      min(e2_.updated)
    )
  ) AS sclr_5,
  e0_.target_id AS target_id_6
FROM
  e_commerce_item_trend e0_
  LEFT JOIN e_commerce_item_trend e2_ ON (
    e2_.id = e0_.id
    AND e2_.updated < ?
  )
  LEFT JOIN e_commerce_item_trend e1_ ON (
    e1_.id = e0_.id
    AND e1_.updated >= ?
  )
  INNER JOIN e_commerce_item e3_ ON e0_.target_id = e3_.id
  INNER JOIN e_commerce_item_settings_discovery e4_ ON e3_.id = e4_.item_id
  AND (
    e4_.discovery = 1
    AND e4_.quantity_update <> 0
  )
  LEFT JOIN bind_music_video_scene_item_character b5_ ON (b5_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_music_video_character_signature_item b6_ ON (b6_.e_commerce_item_id = e3_.id)
  LEFT JOIN bind_music_video_set_item b7_ ON (b7_.e_commerce_item_id = e3_.id)
  LEFT JOIN music_video_character m8_ ON b5_.music_video_character_id = m8_.id
  LEFT JOIN music_video_character_signature m9_ ON b6_.music_video_character_signature_id = m9_.id
  LEFT JOIN music_video_set m10_ ON b7_.music_video_set_id = m10_.id
  LEFT JOIN music_video m11_ ON m8_.music_video_id = m11_.id
  LEFT JOIN music_video_character m12_ ON m9_.character_id = m12_.id
  LEFT JOIN music_video m13_ ON m12_.music_video_id = m13_.id
  LEFT JOIN music_video_set_category m14_ ON m10_.music_video_set_category_id = m14_.id
  LEFT JOIN music_video m15_ ON m14_.music_video_id = m15_.id
  LEFT JOIN music_scene m16_ ON b5_.music_scene_id = m16_.id
WHERE
  (
    b5_.e_commerce_item_id = e3_.id
    OR b6_.e_commerce_item_id = e3_.id
    OR b7_.e_commerce_item_id = e3_.id
  )
  AND (
    (
      m16_.publish = 1
      AND m11_.publish = 1
    )
    OR m13_.publish = 1
    OR (
      m10_.publish = 1
      AND m14_.publish = 1
      AND m15_.publish = 1
    )
  )
  AND e3_.removed = 0
GROUP BY
  e0_.target_id
ORDER BY
  sclr_3 DESC
LIMIT
  5

SELECT e0_.points AS points_0, e0_.id AS id_1, e0_.updated AS updated_2, sum(e0_.points) AS sclr_3, sum(e1_.points) AS sclr_4, sum(e2_.points) / (DATEDIFF('2026-02-18 00:00:00', min(e2_.updated))) AS sclr_5, e0_.target_id AS target_id_6 FROM e_commerce_item_trend e0_ LEFT JOIN e_commerce_item_trend e2_ ON (e2_.id = e0_.id AND e2_.updated < '2026-02-18 00:00:00') LEFT JOIN e_commerce_item_trend e1_ ON (e1_.id = e0_.id AND e1_.updated >= '2026-02-18 00:00:00') INNER JOIN e_commerce_item e3_ ON e0_.target_id = e3_.id INNER JOIN e_commerce_item_settings_discovery e4_ ON e3_.id = e4_.item_id AND (e4_.discovery = 1 AND e4_.quantity_update <> 0) LEFT JOIN bind_music_video_scene_item_character b5_ ON (b5_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_character_signature_item b6_ ON (b6_.e_commerce_item_id = e3_.id) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.e_commerce_item_id = e3_.id) LEFT JOIN music_video_character m8_ ON b5_.music_video_character_id = m8_.id LEFT JOIN music_video_character_signature m9_ ON b6_.music_video_character_signature_id = m9_.id LEFT JOIN music_video_set m10_ ON b7_.music_video_set_id = m10_.id LEFT JOIN music_video m11_ ON m8_.music_video_id = m11_.id LEFT JOIN music_video_character m12_ ON m9_.character_id = m12_.id LEFT JOIN music_video m13_ ON m12_.music_video_id = m13_.id LEFT JOIN music_video_set_category m14_ ON m10_.music_video_set_category_id = m14_.id LEFT JOIN music_video m15_ ON m14_.music_video_id = m15_.id LEFT JOIN music_scene m16_ ON b5_.music_scene_id = m16_.id WHERE (b5_.e_commerce_item_id = e3_.id OR b6_.e_commerce_item_id = e3_.id OR b7_.e_commerce_item_id = e3_.id) AND ((m16_.publish = 1 AND m11_.publish = 1) OR m13_.publish = 1 OR (m10_.publish = 1 AND m14_.publish = 1 AND m15_.publish = 1)) AND e3_.removed = 0 GROUP BY e0_.target_id ORDER BY sclr_3 DESC LIMIT 5;

SELECT
  m0_.name AS name_0,
  m0_.publish AS publish_1,
  m0_.complete AS complete_2,
  m0_.updated AS updated_3,
  m0_.position AS position_4,
  m0_.id AS id_5,
  m0_.auto_mainstreet AS auto_mainstreet_6,
  m0_.commission AS commission_7,
  m0_.spotify_username AS spotify_username_8,
  m0_.spotify_link AS spotify_link_9,
  m0_.sound_cloud_username AS sound_cloud_username_10,
  m0_.sound_cloud_link AS sound_cloud_link_11,
  m0_.tik_tok_username AS tik_tok_username_12,
  m0_.tik_tok_link AS tik_tok_link_13,
  m0_.imdb_link AS imdb_link_14,
  m0_.wikipedia_link AS wikipedia_link_15,
  m0_.approve_status AS approve_status_16,
  m0_.old_parents AS old_parents_17,
  m0_.thumbnail AS thumbnail_18,
  m0_.description AS description_19,
  m0_.short_description AS short_description_20,
  m0_.actual_publish_date AS actual_publish_date_21,
  m0_.youtube_username AS youtube_username_22,
  m0_.youtube_link AS youtube_link_23,
  m0_.instagram_username AS instagram_username_24,
  m0_.instagram_link AS instagram_link_25,
  m0_.twitter_username AS twitter_username_26,
  m0_.twitter_link AS twitter_link_27,
  m0_.facebook_username AS facebook_username_28,
  m0_.facebook_link AS facebook_link_29,
  m0_.website_link AS website_link_30,
  m0_.stripe_customer AS stripe_customer_31
FROM
  music_artist m0_
  LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id
  LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id
  AND (m1_.publish = 1)
  LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id
  AND (m3_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id)
  LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id
  AND (m5_.publish = 1)
  LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id
  AND (m6_.publish = 1)
  LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id)
  LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id
  LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id
  AND (m9_.artist_id = m8_.artist_id)
  LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id
  AND (m10_.publish = 1)
  LEFT JOIN bind_music_video_character_signature_item b11_ ON (
    b11_.music_video_character_signature_id = m10_.id
  )
  LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id
  AND (m12_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b13_ ON (
    b13_.music_artist_character_id = m8_.id
    AND b13_.music_artist_post_id = m12_.id
  )
  LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id
  LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (
    b15_.music_artist_guest_character_id = m14_.id
    AND b15_.music_artist_post_id = m12_.id
  )
  LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id
  AND (m16_.publish = 1)
  LEFT JOIN bind_music_artist_merch b17_ ON (
    b17_.music_artist_merch_id = m16_.id
  )
WHERE
  (
    b4_.id IS NOT NULL
    OR b7_.id IS NOT NULL
    OR b11_.id IS NOT NULL
    OR b13_.id IS NOT NULL
    OR b15_.id IS NOT NULL
    OR b17_.id IS NOT NULL
  )
  AND m0_.publish = 1
GROUP BY
  m0_.name,
  m0_.publish,
  m0_.complete,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.auto_mainstreet,
  m0_.commission,
  m0_.spotify_username,
  m0_.spotify_link,
  m0_.sound_cloud_username,
  m0_.sound_cloud_link,
  m0_.tik_tok_username,
  m0_.tik_tok_link,
  m0_.imdb_link,
  m0_.wikipedia_link,
  m0_.approve_status,
  m0_.old_parents,
  m0_.thumbnail,
  m0_.description,
  m0_.short_description,
  m0_.actual_publish_date,
  m0_.youtube_username,
  m0_.youtube_link,
  m0_.instagram_username,
  m0_.instagram_link,
  m0_.twitter_username,
  m0_.twitter_link,
  m0_.facebook_username,
  m0_.facebook_link,
  m0_.website_link,
  m0_.stripe_customer
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.publish AS publish_1, m0_.complete AS complete_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.auto_mainstreet AS auto_mainstreet_6, m0_.commission AS commission_7, m0_.spotify_username AS spotify_username_8, m0_.spotify_link AS spotify_link_9, m0_.sound_cloud_username AS sound_cloud_username_10, m0_.sound_cloud_link AS sound_cloud_link_11, m0_.tik_tok_username AS tik_tok_username_12, m0_.tik_tok_link AS tik_tok_link_13, m0_.imdb_link AS imdb_link_14, m0_.wikipedia_link AS wikipedia_link_15, m0_.approve_status AS approve_status_16, m0_.old_parents AS old_parents_17, m0_.thumbnail AS thumbnail_18, m0_.description AS description_19, m0_.short_description AS short_description_20, m0_.actual_publish_date AS actual_publish_date_21, m0_.youtube_username AS youtube_username_22, m0_.youtube_link AS youtube_link_23, m0_.instagram_username AS instagram_username_24, m0_.instagram_link AS instagram_link_25, m0_.twitter_username AS twitter_username_26, m0_.twitter_link AS twitter_link_27, m0_.facebook_username AS facebook_username_28, m0_.facebook_link AS facebook_link_29, m0_.website_link AS website_link_30, m0_.stripe_customer AS stripe_customer_31 FROM music_artist m0_ LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id LEFT JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.publish = 1) LEFT JOIN music_scene m3_ ON m1_.id = m3_.music_video_id AND (m3_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id) LEFT JOIN music_video_set_category m5_ ON m1_.id = m5_.music_video_id AND (m5_.publish = 1) LEFT JOIN music_video_set m6_ ON m5_.id = m6_.music_video_set_category_id AND (m6_.publish = 1) LEFT JOIN bind_music_video_set_item b7_ ON (b7_.music_video_set_id = m6_.id) LEFT JOIN music_artist_character m8_ ON m0_.id = m8_.music_artist_id LEFT JOIN music_video_character m9_ ON m1_.id = m9_.music_video_id AND (m9_.artist_id = m8_.artist_id) LEFT JOIN music_video_character_signature m10_ ON m9_.id = m10_.character_id AND (m10_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b11_ ON (b11_.music_video_character_signature_id = m10_.id) LEFT JOIN music_artist_posts m12_ ON m0_.id = m12_.music_artist_id AND (m12_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b13_ ON (b13_.music_artist_character_id = m8_.id AND b13_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_guest_character m14_ ON m0_.id = m14_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b15_ ON (b15_.music_artist_guest_character_id = m14_.id AND b15_.music_artist_post_id = m12_.id) LEFT JOIN music_artist_merch m16_ ON m0_.id = m16_.music_artist_id AND (m16_.publish = 1) LEFT JOIN bind_music_artist_merch b17_ ON (b17_.music_artist_merch_id = m16_.id) WHERE (b4_.id IS NOT NULL OR b7_.id IS NOT NULL OR b11_.id IS NOT NULL OR b13_.id IS NOT NULL OR b15_.id IS NOT NULL OR b17_.id IS NOT NULL) AND m0_.publish = 1 GROUP BY m0_.name, m0_.publish, m0_.complete, m0_.updated, m0_.position, m0_.id, m0_.auto_mainstreet, m0_.commission, m0_.spotify_username, m0_.spotify_link, m0_.sound_cloud_username, m0_.sound_cloud_link, m0_.tik_tok_username, m0_.tik_tok_link, m0_.imdb_link, m0_.wikipedia_link, m0_.approve_status, m0_.old_parents, m0_.thumbnail, m0_.description, m0_.short_description, m0_.actual_publish_date, m0_.youtube_username, m0_.youtube_link, m0_.instagram_username, m0_.instagram_link, m0_.twitter_username, m0_.twitter_link, m0_.facebook_username, m0_.facebook_link, m0_.website_link, m0_.stripe_customer ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.thumbnail AS thumbnail_2,
  c0_.link AS link_3,
  c0_.page AS page_4,
  c0_.position AS position_5
FROM
  custom_slider c0_
WHERE
  c0_.page = ?
  AND c0_.thumbnail IS NOT NULL
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.thumbnail AS thumbnail_2, c0_.link AS link_3, c0_.page AS page_4, c0_.position AS position_5 FROM custom_slider c0_ WHERE c0_.page = 3 AND c0_.thumbnail IS NOT NULL ORDER BY c0_.position ASC;

SELECT
  m0_.name AS name_0,
  m0_.thumbnail AS thumbnail_1,
  m0_.short_description AS short_description_2,
  m0_.description AS description_3,
  m0_.release_date AS release_date_4,
  m0_.publish AS publish_5,
  m0_.complete AS complete_6,
  m0_.updated AS updated_7,
  m0_.position AS position_8,
  m0_.id AS id_9,
  m0_.auto_mainstreet AS auto_mainstreet_10,
  m0_.commission AS commission_11,
  m0_.contact_name AS contact_name_12,
  m0_.email AS email_13,
  m0_.video_link AS video_link_14,
  m0_.spotify_username AS spotify_username_15,
  m0_.spotify_link AS spotify_link_16,
  m0_.sound_cloud_username AS sound_cloud_username_17,
  m0_.sound_cloud_link AS sound_cloud_link_18,
  m0_.tik_tok_username AS tik_tok_username_19,
  m0_.tik_tok_link AS tik_tok_link_20,
  m0_.approve_status AS approve_status_21,
  m0_.old_parents AS old_parents_22,
  m0_.publish_date AS publish_date_23,
  m0_.actual_publish_date AS actual_publish_date_24,
  m0_.youtube_username AS youtube_username_25,
  m0_.youtube_link AS youtube_link_26,
  m0_.instagram_username AS instagram_username_27,
  m0_.instagram_link AS instagram_link_28,
  m0_.twitter_username AS twitter_username_29,
  m0_.twitter_link AS twitter_link_30,
  m0_.facebook_username AS facebook_username_31,
  m0_.facebook_link AS facebook_link_32,
  m0_.website_link AS website_link_33,
  m0_.stripe_customer AS stripe_customer_34,
  m0_.season_id AS season_id_35
FROM
  music_video m0_
  LEFT JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_video_id
  LEFT JOIN music_artist m1_ ON m1_.id = m2_.music_artist_id
  AND (m1_.publish = 1)
  LEFT JOIN music_scene m3_ ON m0_.id = m3_.music_video_id
  AND (m3_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b4_ ON (b4_.music_scene_id = m3_.id)
  LEFT JOIN music_artist_to_music_video m6_ ON m1_.id = m6_.music_artist_id
  LEFT JOIN music_video m5_ ON m5_.id = m6_.music_video_id
  AND (m5_.publish = 1)
  LEFT JOIN music_video_character m7_ ON m5_.id = m7_.music_video_id
  LEFT JOIN music_video_character_signature m8_ ON m7_.id = m8_.character_id
  AND (m8_.publish = 1)
  LEFT JOIN bind_music_video_character_signature_item b9_ ON (
    b9_.music_video_character_signature_id = m8_.id
  )
  LEFT JOIN music_artist_character m10_ ON m1_.id = m10_.music_artist_id
  AND (m7_.artist_id = m10_.artist_id)
  LEFT JOIN music_scene m11_ ON m5_.id = m11_.music_video_id
  AND (m11_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b12_ ON (
    b12_.music_scene_id = m11_.id
    AND b12_.music_video_character_id = m7_.id
  )
  LEFT JOIN music_artist_posts m13_ ON m1_.id = m13_.music_artist_id
  AND (m13_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b14_ ON (
    b14_.music_artist_character_id = m10_.id
    AND b14_.music_artist_post_id = m13_.id
  )
  LEFT JOIN music_video_set_category m15_ ON m0_.id = m15_.music_video_id
  AND (m15_.publish = 1)
  LEFT JOIN music_video_set m16_ ON m15_.id = m16_.music_video_set_category_id
  AND (m16_.publish = 1)
  LEFT JOIN bind_music_video_set_item b17_ ON (
    b17_.music_video_set_id = m16_.id
  )
  LEFT JOIN music_artist_posts m18_ ON m1_.id = m18_.music_artist_id
  AND (m18_.publish = 1)
  LEFT JOIN bind_music_artist_post_item_character b19_ ON (
    b19_.music_artist_post_id = m18_.id
  )
  LEFT JOIN music_artist_merch m20_ ON m1_.id = m20_.music_artist_id
  AND (m20_.publish = 1)
  LEFT JOIN bind_music_artist_merch b21_ ON (
    b21_.music_artist_merch_id = m20_.id
  )
WHERE
  (
    b4_.id IS NOT NULL
    OR (
      (
        b9_.id IS NOT NULL
        OR b12_.id IS NOT NULL
        OR b14_.id IS NOT NULL
      )
      AND m10_.id IS NOT NULL
    )
    OR b17_.id IS NOT NULL
    OR b19_.id IS NOT NULL
    OR b21_.id IS NOT NULL
  )
  AND m0_.publish = 1
GROUP BY
  m0_.name,
  m0_.thumbnail,
  m0_.short_description,
  m0_.description,
  m0_.release_date,
  m0_.publish,
  m0_.complete,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.auto_mainstreet,
  m0_.commission,
  m0_.contact_name,
  m0_.email,
  m0_.video_link,
  m0_.spotify_username,
  m0_.spotify_link,
  m0_.sound_cloud_username,
  m0_.sound_cloud_link,
  m0_.tik_tok_username,
  m0_.tik_tok_link,
  m0_.approve_status,
  m0_.old_parents,
  m0_.publish_date,
  m0_.actual_publish_date,
  m0_.youtube_username,
  m0_.youtube_link,
  m0_.instagram_username,
  m0_.instagram_link,
  m0_.twitter_username,
  m0_.twitter_link,
  m0_.facebook_username,
  m0_.facebook_link,
  m0_.website_link,
  m0_.stripe_customer,
  m0_.season_id
ORDER BY
  m0_.name ASC