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
  m0_.id = ?
  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

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 m0_.id = '8' 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;

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_
  INNER JOIN music_scene m1_ ON m0_.id = m1_.music_video_id
  AND (m1_.publish = 1)
  INNER JOIN bind_music_video_scene_item_character b2_ ON (b2_.music_scene_id = m1_.id)
WHERE
  m0_.publish = 1
  AND m0_.id = ?

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_ INNER JOIN music_scene m1_ ON m0_.id = m1_.music_video_id AND (m1_.publish = 1) INNER JOIN bind_music_video_scene_item_character b2_ ON (b2_.music_scene_id = m1_.id) WHERE m0_.publish = 1 AND m0_.id = 8;

SELECT
  m0_.name AS name_0,
  m0_.thumbnail AS thumbnail_1,
  m0_.description AS description_2,
  m0_.updated AS updated_3,
  m0_.position AS position_4,
  m0_.id AS id_5,
  m0_.publish AS publish_6,
  m0_.actual_publish_date AS actual_publish_date_7,
  m0_.music_video_id AS music_video_id_8,
  m0_.image_to_music_video_id AS image_to_music_video_id_9
FROM
  music_video_set_category m0_
  INNER JOIN music_video_set m1_ ON m0_.id = m1_.music_video_set_category_id
  AND (m1_.publish = 1)
  INNER JOIN bind_music_video_set_item b2_ ON (b2_.music_video_set_id = m1_.id)
WHERE
  m0_.publish = 1
  AND m0_.music_video_id = ?
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.thumbnail AS thumbnail_1, m0_.description AS description_2, m0_.updated AS updated_3, m0_.position AS position_4, m0_.id AS id_5, m0_.publish AS publish_6, m0_.actual_publish_date AS actual_publish_date_7, m0_.music_video_id AS music_video_id_8, m0_.image_to_music_video_id AS image_to_music_video_id_9 FROM music_video_set_category m0_ INNER JOIN music_video_set m1_ ON m0_.id = m1_.music_video_set_category_id AND (m1_.publish = 1) INNER JOIN bind_music_video_set_item b2_ ON (b2_.music_video_set_id = m1_.id) WHERE m0_.publish = 1 AND m0_.music_video_id = 8 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_
  INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id
  INNER JOIN music_video m1_ ON m1_.id = m2_.music_video_id
  AND (m1_.id = ?)
WHERE
  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_.id DESC

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_ INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id INNER JOIN music_video m1_ ON m1_.id = m2_.music_video_id AND (m1_.id = 8) WHERE 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_.id DESC;

SELECT
  m0_.thumbnail AS thumbnail_0,
  m0_.position AS position_1,
  m0_.updated AS updated_2,
  m0_.name AS name_3,
  m0_.description AS description_4,
  m0_.id AS id_5,
  m0_.actual_publish_date AS actual_publish_date_6,
  m0_.music_artist_id AS music_artist_id_7,
  m0_.music_performer_id AS music_performer_id_8,
  m0_.artist_id AS artist_id_9,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_10
FROM
  music_artist_character m0_
  INNER JOIN music_video m1_ ON (
    m1_.id = ?
    AND m1_.publish = 1
  )
  INNER JOIN music_artist_to_music_video m3_ ON m1_.id = m3_.music_video_id
  INNER JOIN music_artist m2_ ON m2_.id = m3_.music_artist_id
  AND (m2_.publish = 1)
  INNER JOIN music_artist_to_music_video m5_ ON m2_.id = m5_.music_artist_id
  INNER JOIN music_video m4_ ON m4_.id = m5_.music_video_id
  AND (m4_.publish = 1)
  INNER JOIN music_video_character m6_ ON m4_.id = m6_.music_video_id
  AND (m6_.artist_id = m0_.artist_id)
  LEFT JOIN music_video_character_signature m7_ ON (
    m7_.character_id = m6_.id
    AND m7_.publish = 1
  )
  LEFT JOIN bind_music_video_character_signature_item b8_ ON (
    b8_.music_video_character_signature_id = m7_.id
  )
  LEFT JOIN music_scene m9_ ON m4_.id = m9_.music_video_id
  AND (m9_.publish = 1)
  LEFT JOIN bind_music_video_scene_item_character b10_ ON (
    b10_.music_scene_id = m9_.id
    AND b10_.music_video_character_id = m6_.id
  )
  LEFT JOIN music_artist_posts m11_ ON (
    m11_.music_artist_id = m2_.id
    AND m11_.publish = 1
  )
  LEFT JOIN bind_music_artist_post_item_character b12_ ON (
    b12_.music_artist_character_id = m0_.id
    AND b12_.music_artist_post_id = m11_.id
  )
  LEFT JOIN music_artist_guest_character m13_ ON m2_.id = m13_.music_artist_id
  LEFT JOIN bind_music_artist_post_item_guest_character b14_ ON (
    b14_.music_artist_guest_character_id = m13_.id
    AND b14_.music_artist_post_id = m11_.id
  )
WHERE
  m0_.music_artist_id = m2_.id
  AND (
    (
      b12_.id IS NOT NULL
      OR b10_.id IS NOT NULL
      OR b8_.id IS NOT NULL
    )
    OR (
      b8_.id IS NOT NULL
      AND b14_.id IS NOT NULL
    )
  )
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.thumbnail AS thumbnail_0, m0_.position AS position_1, m0_.updated AS updated_2, m0_.name AS name_3, m0_.description AS description_4, m0_.id AS id_5, m0_.actual_publish_date AS actual_publish_date_6, m0_.music_artist_id AS music_artist_id_7, m0_.music_performer_id AS music_performer_id_8, m0_.artist_id AS artist_id_9, m0_.image_to_music_artist_id AS image_to_music_artist_id_10 FROM music_artist_character m0_ INNER JOIN music_video m1_ ON (m1_.id = 8 AND m1_.publish = 1) INNER JOIN music_artist_to_music_video m3_ ON m1_.id = m3_.music_video_id INNER JOIN music_artist m2_ ON m2_.id = m3_.music_artist_id AND (m2_.publish = 1) INNER JOIN music_artist_to_music_video m5_ ON m2_.id = m5_.music_artist_id INNER JOIN music_video m4_ ON m4_.id = m5_.music_video_id AND (m4_.publish = 1) INNER JOIN music_video_character m6_ ON m4_.id = m6_.music_video_id AND (m6_.artist_id = m0_.artist_id) LEFT JOIN music_video_character_signature m7_ ON (m7_.character_id = m6_.id AND m7_.publish = 1) LEFT JOIN bind_music_video_character_signature_item b8_ ON (b8_.music_video_character_signature_id = m7_.id) LEFT JOIN music_scene m9_ ON m4_.id = m9_.music_video_id AND (m9_.publish = 1) LEFT JOIN bind_music_video_scene_item_character b10_ ON (b10_.music_scene_id = m9_.id AND b10_.music_video_character_id = m6_.id) LEFT JOIN music_artist_posts m11_ ON (m11_.music_artist_id = m2_.id AND m11_.publish = 1) LEFT JOIN bind_music_artist_post_item_character b12_ ON (b12_.music_artist_character_id = m0_.id AND b12_.music_artist_post_id = m11_.id) LEFT JOIN music_artist_guest_character m13_ ON m2_.id = m13_.music_artist_id LEFT JOIN bind_music_artist_post_item_guest_character b14_ ON (b14_.music_artist_guest_character_id = m13_.id AND b14_.music_artist_post_id = m11_.id) WHERE m0_.music_artist_id = m2_.id AND ((b12_.id IS NOT NULL OR b10_.id IS NOT NULL OR b8_.id IS NOT NULL) OR (b8_.id IS NOT NULL AND b14_.id IS NOT NULL)) ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

SELECT
  m0_.name AS name_0,
  m0_.updated AS updated_1,
  m0_.position AS position_2,
  m0_.id AS id_3,
  m0_.publish AS publish_4,
  m0_.publish_date AS publish_date_5,
  m0_.actual_publish_date AS actual_publish_date_6,
  m0_.music_artist_id AS music_artist_id_7,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_8
FROM
  music_artist_merch m0_
  INNER JOIN bind_music_artist_merch b1_ ON (
    b1_.music_artist_merch_id = m0_.id
  )
WHERE
  m0_.publish = 1
  AND m0_.music_artist_id = ?
GROUP BY
  m0_.name,
  m0_.updated,
  m0_.position,
  m0_.id,
  m0_.publish,
  m0_.publish_date,
  m0_.actual_publish_date,
  m0_.music_artist_id,
  m0_.image_to_music_artist_id
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.updated AS updated_1, m0_.position AS position_2, m0_.id AS id_3, m0_.publish AS publish_4, m0_.publish_date AS publish_date_5, m0_.actual_publish_date AS actual_publish_date_6, m0_.music_artist_id AS music_artist_id_7, m0_.image_to_music_artist_id AS image_to_music_artist_id_8 FROM music_artist_merch m0_ INNER JOIN bind_music_artist_merch b1_ ON (b1_.music_artist_merch_id = m0_.id) WHERE m0_.publish = 1 AND m0_.music_artist_id = 2 GROUP BY m0_.name, m0_.updated, m0_.position, m0_.id, m0_.publish, m0_.publish_date, m0_.actual_publish_date, m0_.music_artist_id, m0_.image_to_music_artist_id ORDER BY m0_.actual_publish_date DESC, m0_.position ASC;

SELECT
  m0_.name AS name_0,
  m0_.updated AS updated_1,
  m0_.id AS id_2,
  m0_.position AS position_3,
  m0_.soc_link AS soc_link_4,
  m0_.soc_type AS soc_type_5,
  m0_.publish AS publish_6,
  m0_.publish_date AS publish_date_7,
  m0_.actual_publish_date AS actual_publish_date_8,
  m0_.music_artist_id AS music_artist_id_9,
  m0_.image_to_music_artist_id AS image_to_music_artist_id_10
FROM
  music_artist_posts m0_
  LEFT JOIN bind_music_artist_post_item_character b1_ ON (
    b1_.music_artist_post_id = m0_.id
  )
  LEFT JOIN bind_music_artist_post_item_guest_character b2_ ON (
    b2_.music_artist_post_id = m0_.id
  )
WHERE
  m0_.publish = 1
  AND m0_.music_artist_id = ?
  AND (
    b1_.id IS NOT NULL
    OR b2_.id IS NOT NULL
  )
GROUP BY
  m0_.name,
  m0_.updated,
  m0_.id,
  m0_.position,
  m0_.soc_link,
  m0_.soc_type,
  m0_.publish,
  m0_.publish_date,
  m0_.actual_publish_date,
  m0_.music_artist_id,
  m0_.image_to_music_artist_id
ORDER BY
  m0_.actual_publish_date DESC,
  m0_.position ASC

SELECT m0_.name AS name_0, m0_.updated AS updated_1, m0_.id AS id_2, m0_.position AS position_3, m0_.soc_link AS soc_link_4, m0_.soc_type AS soc_type_5, m0_.publish AS publish_6, m0_.publish_date AS publish_date_7, m0_.actual_publish_date AS actual_publish_date_8, m0_.music_artist_id AS music_artist_id_9, m0_.image_to_music_artist_id AS image_to_music_artist_id_10 FROM music_artist_posts m0_ LEFT JOIN bind_music_artist_post_item_character b1_ ON (b1_.music_artist_post_id = m0_.id) LEFT JOIN bind_music_artist_post_item_guest_character b2_ ON (b2_.music_artist_post_id = m0_.id) WHERE m0_.publish = 1 AND m0_.music_artist_id = 2 AND (b1_.id IS NOT NULL OR b2_.id IS NOT NULL) GROUP BY m0_.name, m0_.updated, m0_.id, m0_.position, m0_.soc_link, m0_.soc_type, m0_.publish, m0_.publish_date, m0_.actual_publish_date, m0_.music_artist_id, m0_.image_to_music_artist_id 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_
  INNER JOIN music_artist_to_music_video m2_ ON m0_.id = m2_.music_artist_id
  INNER JOIN music_video m1_ ON m1_.id = m2_.music_video_id
  AND (m1_.id = ?)
WHERE
  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_.id DESC