Symfony Profiler

SELECT
  e0_.id AS id_0,
  e0_.date_event AS date_event_1,
  e0_.location AS location_2,
  e0_.address AS address_3,
  e0_.latitude AS latitude_4,
  e0_.longitude AS longitude_5,
  e0_.poster_name AS poster_name_6,
  e0_.poster_thumb_name AS poster_thumb_name_7,
  e0_.active AS active_8,
  e0_.deleted AS deleted_9,
  e0_.bandsintown_event_id AS bandsintown_event_id_10,
  e0_.venue_pending AS venue_pending_11,
  e0_.excluded_from_ranking AS excluded_from_ranking_12,
  e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13,
  e0_.price AS price_14,
  e0_.access AS access_15,
  e0_.date_add AS date_add_16,
  e0_.date_upd AS date_upd_17,
  e0_.followers_notified_at AS followers_notified_at_18,
  e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19,
  e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20,
  e1_.id AS id_21,
  e1_.title AS title_22,
  e1_.slug AS slug_23,
  e1_.description AS description_24,
  e1_.notes AS notes_25,
  b2_.id AS id_26,
  b2_.active AS active_27,
  b2_.name AS name_28,
  b2_.slug AS slug_29,
  b2_.foundation_year AS foundation_year_30,
  b2_.website AS website_31,
  b2_.facebook AS facebook_32,
  b2_.instagram AS instagram_33,
  b2_.tiktok AS tiktok_34,
  b2_.soundcloud AS soundcloud_35,
  b2_.youtube AS youtube_36,
  b2_.discord AS discord_37,
  b2_.twitter AS twitter_38,
  b2_.spotify AS spotify_39,
  b2_.twitch AS twitch_40,
  b2_.bandsintown AS bandsintown_41,
  b2_.bandsintown_api_key AS bandsintown_api_key_42,
  b2_.cover_name AS cover_name_43,
  b2_.cover_thumb AS cover_thumb_44,
  b2_.date_add AS date_add_45,
  b2_.date_upd AS date_upd_46,
  b2_.total_points AS total_points_47,
  b2_.ranking_position AS ranking_position_48,
  e0_.venue_id AS venue_id_49,
  e0_.artist_id AS artist_id_50,
  e0_.band_id AS band_id_51,
  e0_.opener_id AS opener_id_52,
  e1_.event_id AS event_id_53,
  e1_.language_id AS language_id_54,
  b2_.city_id AS city_id_55,
  b2_.owner_id AS owner_id_56,
  b2_.current_tier_id AS current_tier_id_57
FROM
  event e0_
  LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id
  AND (e1_.language_id = ?)
  LEFT JOIN band b2_ ON e0_.band_id = b2_.id
WHERE
  e0_.date_event >= ?
  AND e0_.venue_pending = 0
  AND e0_.date_event <= ?
  AND e0_.access = ?
ORDER BY
  e0_.date_event ASC
LIMIT
  8

SELECT e0_.id AS id_0, e0_.date_event AS date_event_1, e0_.location AS location_2, e0_.address AS address_3, e0_.latitude AS latitude_4, e0_.longitude AS longitude_5, e0_.poster_name AS poster_name_6, e0_.poster_thumb_name AS poster_thumb_name_7, e0_.active AS active_8, e0_.deleted AS deleted_9, e0_.bandsintown_event_id AS bandsintown_event_id_10, e0_.venue_pending AS venue_pending_11, e0_.excluded_from_ranking AS excluded_from_ranking_12, e0_.excluded_from_ranking_notified_at AS excluded_from_ranking_notified_at_13, e0_.price AS price_14, e0_.access AS access_15, e0_.date_add AS date_add_16, e0_.date_upd AS date_upd_17, e0_.followers_notified_at AS followers_notified_at_18, e0_.reminder_day_before_sent_at AS reminder_day_before_sent_at_19, e0_.reminder_starting_soon_sent_at AS reminder_starting_soon_sent_at_20, e1_.id AS id_21, e1_.title AS title_22, e1_.slug AS slug_23, e1_.description AS description_24, e1_.notes AS notes_25, b2_.id AS id_26, b2_.active AS active_27, b2_.name AS name_28, b2_.slug AS slug_29, b2_.foundation_year AS foundation_year_30, b2_.website AS website_31, b2_.facebook AS facebook_32, b2_.instagram AS instagram_33, b2_.tiktok AS tiktok_34, b2_.soundcloud AS soundcloud_35, b2_.youtube AS youtube_36, b2_.discord AS discord_37, b2_.twitter AS twitter_38, b2_.spotify AS spotify_39, b2_.twitch AS twitch_40, b2_.bandsintown AS bandsintown_41, b2_.bandsintown_api_key AS bandsintown_api_key_42, b2_.cover_name AS cover_name_43, b2_.cover_thumb AS cover_thumb_44, b2_.date_add AS date_add_45, b2_.date_upd AS date_upd_46, b2_.total_points AS total_points_47, b2_.ranking_position AS ranking_position_48, e0_.venue_id AS venue_id_49, e0_.artist_id AS artist_id_50, e0_.band_id AS band_id_51, e0_.opener_id AS opener_id_52, e1_.event_id AS event_id_53, e1_.language_id AS language_id_54, b2_.city_id AS city_id_55, b2_.owner_id AS owner_id_56, b2_.current_tier_id AS current_tier_id_57 FROM event e0_ LEFT JOIN event_lang e1_ ON e0_.id = e1_.event_id AND (e1_.language_id = 1) LEFT JOIN band b2_ ON e0_.band_id = b2_.id WHERE e0_.date_event >= '2026-11-02 00:00:00' AND e0_.venue_pending = 0 AND e0_.date_event <= '2026-11-08 23:59:59' AND e0_.access = 'FREE' ORDER BY e0_.date_event ASC LIMIT 8;

SELECT
  b0_.id AS id_0
FROM
  band b0_

SELECT b0_.id AS id_0 FROM band b0_;

SELECT
  b0_.id AS id_0,
  b0_.active AS active_1,
  b0_.name AS name_2,
  b0_.slug AS slug_3,
  b0_.foundation_year AS foundation_year_4,
  b0_.website AS website_5,
  b0_.facebook AS facebook_6,
  b0_.instagram AS instagram_7,
  b0_.tiktok AS tiktok_8,
  b0_.soundcloud AS soundcloud_9,
  b0_.youtube AS youtube_10,
  b0_.discord AS discord_11,
  b0_.twitter AS twitter_12,
  b0_.spotify AS spotify_13,
  b0_.twitch AS twitch_14,
  b0_.bandsintown AS bandsintown_15,
  b0_.bandsintown_api_key AS bandsintown_api_key_16,
  b0_.cover_name AS cover_name_17,
  b0_.cover_thumb AS cover_thumb_18,
  b0_.date_add AS date_add_19,
  b0_.date_upd AS date_upd_20,
  b0_.total_points AS total_points_21,
  b0_.ranking_position AS ranking_position_22,
  b1_.id AS id_23,
  b1_.description_short AS description_short_24,
  b1_.description AS description_25,
  b1_.date_add AS date_add_26,
  b1_.date_upd AS date_upd_27,
  b2_.id AS id_28,
  b2_.type AS type_29,
  b2_.file_name AS file_name_30,
  b2_.position AS position_31,
  b2_.date_add AS date_add_32,
  t3_.id AS id_33,
  t3_.min_points AS min_points_34,
  t3_.position AS position_35,
  t3_.badge AS badge_36,
  t3_.stars AS stars_37,
  t3_.hex_code AS hex_code_38,
  t3_.date_add AS date_add_39,
  t3_.date_upd AS date_upd_40,
  t4_.id AS id_41,
  t4_.name AS name_42,
  m5_.id AS id_43,
  m5_.position AS position_44,
  m5_.active AS active_45,
  m5_.date_add AS date_add_46,
  m5_.date_upd AS date_upd_47,
  m6_.id AS id_48,
  m6_.name AS name_49,
  b0_.city_id AS city_id_50,
  b0_.owner_id AS owner_id_51,
  b0_.current_tier_id AS current_tier_id_52,
  b1_.band_id AS band_id_53,
  b1_.lang_id AS lang_id_54,
  b2_.band_id AS band_id_55,
  t4_.tier_id AS tier_id_56,
  t4_.language_id AS language_id_57,
  m6_.music_genre_id AS music_genre_id_58,
  m6_.language_id AS language_id_59
FROM
  band b0_
  LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id
  AND (
    b0_.id = b1_.band_id
    AND b1_.lang_id = ?
  )
  LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id
  LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id
  LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id
  AND (
    t3_.id = t4_.tier_id
    AND t4_.language_id = ?
  )
  LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id
  LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id
  LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id
  AND (m6_.language_id = ?)
WHERE
  b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b2_.position ASC

SELECT b0_.id AS id_0, b0_.active AS active_1, b0_.name AS name_2, b0_.slug AS slug_3, b0_.foundation_year AS foundation_year_4, b0_.website AS website_5, b0_.facebook AS facebook_6, b0_.instagram AS instagram_7, b0_.tiktok AS tiktok_8, b0_.soundcloud AS soundcloud_9, b0_.youtube AS youtube_10, b0_.discord AS discord_11, b0_.twitter AS twitter_12, b0_.spotify AS spotify_13, b0_.twitch AS twitch_14, b0_.bandsintown AS bandsintown_15, b0_.bandsintown_api_key AS bandsintown_api_key_16, b0_.cover_name AS cover_name_17, b0_.cover_thumb AS cover_thumb_18, b0_.date_add AS date_add_19, b0_.date_upd AS date_upd_20, b0_.total_points AS total_points_21, b0_.ranking_position AS ranking_position_22, b1_.id AS id_23, b1_.description_short AS description_short_24, b1_.description AS description_25, b1_.date_add AS date_add_26, b1_.date_upd AS date_upd_27, b2_.id AS id_28, b2_.type AS type_29, b2_.file_name AS file_name_30, b2_.position AS position_31, b2_.date_add AS date_add_32, t3_.id AS id_33, t3_.min_points AS min_points_34, t3_.position AS position_35, t3_.badge AS badge_36, t3_.stars AS stars_37, t3_.hex_code AS hex_code_38, t3_.date_add AS date_add_39, t3_.date_upd AS date_upd_40, t4_.id AS id_41, t4_.name AS name_42, m5_.id AS id_43, m5_.position AS position_44, m5_.active AS active_45, m5_.date_add AS date_add_46, m5_.date_upd AS date_upd_47, m6_.id AS id_48, m6_.name AS name_49, b0_.city_id AS city_id_50, b0_.owner_id AS owner_id_51, b0_.current_tier_id AS current_tier_id_52, b1_.band_id AS band_id_53, b1_.lang_id AS lang_id_54, b2_.band_id AS band_id_55, t4_.tier_id AS tier_id_56, t4_.language_id AS language_id_57, m6_.music_genre_id AS music_genre_id_58, m6_.language_id AS language_id_59 FROM band b0_ LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id AND (b0_.id = b1_.band_id AND b1_.lang_id = 1) LEFT JOIN band_media b2_ ON b0_.id = b2_.band_id LEFT JOIN tier t3_ ON b0_.current_tier_id = t3_.id LEFT JOIN tier_lang t4_ ON t3_.id = t4_.tier_id AND (t3_.id = t4_.tier_id AND t4_.language_id = 1) LEFT JOIN band_music_genre b7_ ON b0_.id = b7_.band_id LEFT JOIN music_genre m5_ ON m5_.id = b7_.music_genre_id LEFT JOIN music_genre_lang m6_ ON m5_.id = m6_.music_genre_id AND (m6_.language_id = 1) WHERE b0_.id IN (31, 83, 106, 1, 13, 72, 50, 66) ORDER BY b2_.position ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      ranking_position_22,
      total_points_21,
      name_2
    FROM
      (
        SELECT
          b0_.id AS id_0,
          b0_.active AS active_1,
          b0_.name AS name_2,
          b0_.slug AS slug_3,
          b0_.foundation_year AS foundation_year_4,
          b0_.website AS website_5,
          b0_.facebook AS facebook_6,
          b0_.instagram AS instagram_7,
          b0_.tiktok AS tiktok_8,
          b0_.soundcloud AS soundcloud_9,
          b0_.youtube AS youtube_10,
          b0_.discord AS discord_11,
          b0_.twitter AS twitter_12,
          b0_.spotify AS spotify_13,
          b0_.twitch AS twitch_14,
          b0_.bandsintown AS bandsintown_15,
          b0_.bandsintown_api_key AS bandsintown_api_key_16,
          b0_.cover_name AS cover_name_17,
          b0_.cover_thumb AS cover_thumb_18,
          b0_.date_add AS date_add_19,
          b0_.date_upd AS date_upd_20,
          b0_.total_points AS total_points_21,
          b0_.ranking_position AS ranking_position_22,
          b1_.id AS id_23,
          b1_.description_short AS description_short_24,
          b1_.description AS description_25,
          b1_.date_add AS date_add_26,
          b1_.date_upd AS date_upd_27,
          t2_.id AS id_28,
          t2_.min_points AS min_points_29,
          t2_.position AS position_30,
          t2_.badge AS badge_31,
          t2_.stars AS stars_32,
          t2_.hex_code AS hex_code_33,
          t2_.date_add AS date_add_34,
          t2_.date_upd AS date_upd_35,
          t3_.id AS id_36,
          t3_.name AS name_37,
          a4_.id AS id_38,
          a4_.firstname AS firstname_39,
          a4_.lastname AS lastname_40,
          a4_.nickname AS nickname_41,
          a4_.slug AS slug_42,
          a4_.excerpt AS excerpt_43,
          a4_.mood AS mood_44,
          a4_.exhibition AS exhibition_45,
          a4_.crew AS crew_46,
          a4_.biography AS biography_47,
          a4_.original AS original_48,
          a4_.cover AS cover_49,
          a4_.instrumentation AS instrumentation_50,
          a4_.willingness AS willingness_51,
          a4_.www AS www_52,
          a4_.facebook AS facebook_53,
          a4_.twitter AS twitter_54,
          a4_.soundcloud AS soundcloud_55,
          a4_.youtube AS youtube_56,
          a4_.avatar AS avatar_57,
          a4_.wide AS wide_58,
          a4_.thumb AS thumb_59,
          a4_.privacy AS privacy_60,
          a4_.solo_artist AS solo_artist_61,
          a4_.avatar_name AS avatar_name_62,
          a4_.avatar_thumb_name AS avatar_thumb_name_63,
          a4_.cover_name AS cover_name_64,
          a4_.date_add AS date_add_65,
          a4_.date_upd AS date_upd_66,
          a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67,
          a4_.inactivity_reminder_count AS inactivity_reminder_count_68
        FROM
          band b0_
          LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id
          AND (
            b0_.id = b1_.band_id
            AND b1_.lang_id = ?
          )
          LEFT JOIN tier t2_ ON b0_.current_tier_id = t2_.id
          LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id
          AND (
            t2_.id = t3_.tier_id
            AND t3_.language_id = ?
          )
          LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id
          LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id
      ) dctrn_result_inner
    ORDER BY
      ranking_position_22 ASC,
      total_points_21 DESC,
      name_2 ASC
  ) dctrn_result
LIMIT
  6

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, ranking_position_22, total_points_21, name_2 FROM (SELECT b0_.id AS id_0, b0_.active AS active_1, b0_.name AS name_2, b0_.slug AS slug_3, b0_.foundation_year AS foundation_year_4, b0_.website AS website_5, b0_.facebook AS facebook_6, b0_.instagram AS instagram_7, b0_.tiktok AS tiktok_8, b0_.soundcloud AS soundcloud_9, b0_.youtube AS youtube_10, b0_.discord AS discord_11, b0_.twitter AS twitter_12, b0_.spotify AS spotify_13, b0_.twitch AS twitch_14, b0_.bandsintown AS bandsintown_15, b0_.bandsintown_api_key AS bandsintown_api_key_16, b0_.cover_name AS cover_name_17, b0_.cover_thumb AS cover_thumb_18, b0_.date_add AS date_add_19, b0_.date_upd AS date_upd_20, b0_.total_points AS total_points_21, b0_.ranking_position AS ranking_position_22, b1_.id AS id_23, b1_.description_short AS description_short_24, b1_.description AS description_25, b1_.date_add AS date_add_26, b1_.date_upd AS date_upd_27, t2_.id AS id_28, t2_.min_points AS min_points_29, t2_.position AS position_30, t2_.badge AS badge_31, t2_.stars AS stars_32, t2_.hex_code AS hex_code_33, t2_.date_add AS date_add_34, t2_.date_upd AS date_upd_35, t3_.id AS id_36, t3_.name AS name_37, a4_.id AS id_38, a4_.firstname AS firstname_39, a4_.lastname AS lastname_40, a4_.nickname AS nickname_41, a4_.slug AS slug_42, a4_.excerpt AS excerpt_43, a4_.mood AS mood_44, a4_.exhibition AS exhibition_45, a4_.crew AS crew_46, a4_.biography AS biography_47, a4_.original AS original_48, a4_.cover AS cover_49, a4_.instrumentation AS instrumentation_50, a4_.willingness AS willingness_51, a4_.www AS www_52, a4_.facebook AS facebook_53, a4_.twitter AS twitter_54, a4_.soundcloud AS soundcloud_55, a4_.youtube AS youtube_56, a4_.avatar AS avatar_57, a4_.wide AS wide_58, a4_.thumb AS thumb_59, a4_.privacy AS privacy_60, a4_.solo_artist AS solo_artist_61, a4_.avatar_name AS avatar_name_62, a4_.avatar_thumb_name AS avatar_thumb_name_63, a4_.cover_name AS cover_name_64, a4_.date_add AS date_add_65, a4_.date_upd AS date_upd_66, a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67, a4_.inactivity_reminder_count AS inactivity_reminder_count_68 FROM band b0_ LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id AND (b0_.id = b1_.band_id AND b1_.lang_id = 1) LEFT JOIN tier t2_ ON b0_.current_tier_id = t2_.id LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id AND (t2_.id = t3_.tier_id AND t3_.language_id = 1) LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id) dctrn_result_inner ORDER BY ranking_position_22 ASC, total_points_21 DESC, name_2 ASC) dctrn_result LIMIT 6;

SELECT
  b0_.id AS id_0,
  b0_.active AS active_1,
  b0_.name AS name_2,
  b0_.slug AS slug_3,
  b0_.foundation_year AS foundation_year_4,
  b0_.website AS website_5,
  b0_.facebook AS facebook_6,
  b0_.instagram AS instagram_7,
  b0_.tiktok AS tiktok_8,
  b0_.soundcloud AS soundcloud_9,
  b0_.youtube AS youtube_10,
  b0_.discord AS discord_11,
  b0_.twitter AS twitter_12,
  b0_.spotify AS spotify_13,
  b0_.twitch AS twitch_14,
  b0_.bandsintown AS bandsintown_15,
  b0_.bandsintown_api_key AS bandsintown_api_key_16,
  b0_.cover_name AS cover_name_17,
  b0_.cover_thumb AS cover_thumb_18,
  b0_.date_add AS date_add_19,
  b0_.date_upd AS date_upd_20,
  b0_.total_points AS total_points_21,
  b0_.ranking_position AS ranking_position_22,
  b1_.id AS id_23,
  b1_.description_short AS description_short_24,
  b1_.description AS description_25,
  b1_.date_add AS date_add_26,
  b1_.date_upd AS date_upd_27,
  t2_.id AS id_28,
  t2_.min_points AS min_points_29,
  t2_.position AS position_30,
  t2_.badge AS badge_31,
  t2_.stars AS stars_32,
  t2_.hex_code AS hex_code_33,
  t2_.date_add AS date_add_34,
  t2_.date_upd AS date_upd_35,
  t3_.id AS id_36,
  t3_.name AS name_37,
  a4_.id AS id_38,
  a4_.firstname AS firstname_39,
  a4_.lastname AS lastname_40,
  a4_.nickname AS nickname_41,
  a4_.slug AS slug_42,
  a4_.excerpt AS excerpt_43,
  a4_.mood AS mood_44,
  a4_.exhibition AS exhibition_45,
  a4_.crew AS crew_46,
  a4_.biography AS biography_47,
  a4_.original AS original_48,
  a4_.cover AS cover_49,
  a4_.instrumentation AS instrumentation_50,
  a4_.willingness AS willingness_51,
  a4_.www AS www_52,
  a4_.facebook AS facebook_53,
  a4_.twitter AS twitter_54,
  a4_.soundcloud AS soundcloud_55,
  a4_.youtube AS youtube_56,
  a4_.avatar AS avatar_57,
  a4_.wide AS wide_58,
  a4_.thumb AS thumb_59,
  a4_.privacy AS privacy_60,
  a4_.solo_artist AS solo_artist_61,
  a4_.avatar_name AS avatar_name_62,
  a4_.avatar_thumb_name AS avatar_thumb_name_63,
  a4_.cover_name AS cover_name_64,
  a4_.date_add AS date_add_65,
  a4_.date_upd AS date_upd_66,
  a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67,
  a4_.inactivity_reminder_count AS inactivity_reminder_count_68,
  b0_.city_id AS city_id_69,
  b0_.owner_id AS owner_id_70,
  b0_.current_tier_id AS current_tier_id_71,
  b1_.band_id AS band_id_72,
  b1_.lang_id AS lang_id_73,
  t3_.tier_id AS tier_id_74,
  t3_.language_id AS language_id_75,
  a4_.user_id AS user_id_76,
  a4_.preferred_band_id AS preferred_band_id_77,
  a4_.invited_by_id AS invited_by_id_78
FROM
  band b0_
  LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id
  AND (
    b0_.id = b1_.band_id
    AND b1_.lang_id = ?
  )
  LEFT JOIN tier t2_ ON b0_.current_tier_id = t2_.id
  LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id
  AND (
    t2_.id = t3_.tier_id
    AND t3_.language_id = ?
  )
  LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id
  LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id
WHERE
  b0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.ranking_position ASC,
  b0_.total_points DESC,
  b0_.name ASC

SELECT b0_.id AS id_0, b0_.active AS active_1, b0_.name AS name_2, b0_.slug AS slug_3, b0_.foundation_year AS foundation_year_4, b0_.website AS website_5, b0_.facebook AS facebook_6, b0_.instagram AS instagram_7, b0_.tiktok AS tiktok_8, b0_.soundcloud AS soundcloud_9, b0_.youtube AS youtube_10, b0_.discord AS discord_11, b0_.twitter AS twitter_12, b0_.spotify AS spotify_13, b0_.twitch AS twitch_14, b0_.bandsintown AS bandsintown_15, b0_.bandsintown_api_key AS bandsintown_api_key_16, b0_.cover_name AS cover_name_17, b0_.cover_thumb AS cover_thumb_18, b0_.date_add AS date_add_19, b0_.date_upd AS date_upd_20, b0_.total_points AS total_points_21, b0_.ranking_position AS ranking_position_22, b1_.id AS id_23, b1_.description_short AS description_short_24, b1_.description AS description_25, b1_.date_add AS date_add_26, b1_.date_upd AS date_upd_27, t2_.id AS id_28, t2_.min_points AS min_points_29, t2_.position AS position_30, t2_.badge AS badge_31, t2_.stars AS stars_32, t2_.hex_code AS hex_code_33, t2_.date_add AS date_add_34, t2_.date_upd AS date_upd_35, t3_.id AS id_36, t3_.name AS name_37, a4_.id AS id_38, a4_.firstname AS firstname_39, a4_.lastname AS lastname_40, a4_.nickname AS nickname_41, a4_.slug AS slug_42, a4_.excerpt AS excerpt_43, a4_.mood AS mood_44, a4_.exhibition AS exhibition_45, a4_.crew AS crew_46, a4_.biography AS biography_47, a4_.original AS original_48, a4_.cover AS cover_49, a4_.instrumentation AS instrumentation_50, a4_.willingness AS willingness_51, a4_.www AS www_52, a4_.facebook AS facebook_53, a4_.twitter AS twitter_54, a4_.soundcloud AS soundcloud_55, a4_.youtube AS youtube_56, a4_.avatar AS avatar_57, a4_.wide AS wide_58, a4_.thumb AS thumb_59, a4_.privacy AS privacy_60, a4_.solo_artist AS solo_artist_61, a4_.avatar_name AS avatar_name_62, a4_.avatar_thumb_name AS avatar_thumb_name_63, a4_.cover_name AS cover_name_64, a4_.date_add AS date_add_65, a4_.date_upd AS date_upd_66, a4_.last_inactivity_reminder_at AS last_inactivity_reminder_at_67, a4_.inactivity_reminder_count AS inactivity_reminder_count_68, b0_.city_id AS city_id_69, b0_.owner_id AS owner_id_70, b0_.current_tier_id AS current_tier_id_71, b1_.band_id AS band_id_72, b1_.lang_id AS lang_id_73, t3_.tier_id AS tier_id_74, t3_.language_id AS language_id_75, a4_.user_id AS user_id_76, a4_.preferred_band_id AS preferred_band_id_77, a4_.invited_by_id AS invited_by_id_78 FROM band b0_ LEFT JOIN band_lang b1_ ON b0_.id = b1_.band_id AND (b0_.id = b1_.band_id AND b1_.lang_id = 1) LEFT JOIN tier t2_ ON b0_.current_tier_id = t2_.id LEFT JOIN tier_lang t3_ ON t2_.id = t3_.tier_id AND (t2_.id = t3_.tier_id AND t3_.language_id = 1) LEFT JOIN band_artist b5_ ON b0_.id = b5_.band_id LEFT JOIN artist a4_ ON a4_.id = b5_.artist_id WHERE b0_.id IN (18, 32, 1, 9, 20, 13) ORDER BY b0_.ranking_position ASC, b0_.total_points DESC, b0_.name ASC;

SELECT
  a0_.id AS id_0
FROM
  artist a0_
WHERE
  a0_.nickname IS NOT NULL
  AND (a0_.nickname REGEXP ?) = 0
  AND a0_.avatar_name IS NOT NULL

SELECT a0_.id AS id_0 FROM artist a0_ WHERE a0_.nickname IS NOT NULL AND (a0_.nickname REGEXP '^artist_[0-9]+$') = 0 AND a0_.avatar_name IS NOT NULL;