SELECTt0.idASid_1,t0.legal_statusASlegal_status_2,t0.emailASemail_3,t0.rolesASroles_4,t0.passwordASpassword_5,t0.nameASname_6,t0.yandexASyandex_7,t0.last_nameASlast_name_8,t0.phoneASphone_9,t0.bank_accountASbank_account_10,t0.created_atAScreated_at_11,t0.activeASactive_12,t0.verifiedASverified_13,t0.localeASlocale_14,t0.payment_account_idASpayment_account_id_15,t0.deleted_atASdeleted_at_16,t0.hashAShash_17,t0.photo_idASphoto_id_18,t0.city_idAScity_id_19,t0.country_idAScountry_id_20,t0.type,t0.artist_roleASartist_role_21,t0.ageASage_22,t0.socialASsocial_23,t0.socialASsocial_24FROMusert0WHEREt0.id=?ANDt0.typeIN ('system','new','artist','location','manager','organizer','label') AND ((t0.deleted_atISNULL))
SELECTt0.idASid_1,t0.legal_statusASlegal_status_2,t0.emailASemail_3,t0.rolesASroles_4,t0.passwordASpassword_5,t0.nameASname_6,t0.yandexASyandex_7,t0.last_nameASlast_name_8,t0.phoneASphone_9,t0.bank_accountASbank_account_10,t0.created_atAScreated_at_11,t0.activeASactive_12,t0.verifiedASverified_13,t0.localeASlocale_14,t0.payment_account_idASpayment_account_id_15,t0.deleted_atASdeleted_at_16,t0.hashAShash_17,t0.photo_idASphoto_id_18,t0.city_idAScity_id_19,t0.country_idAScountry_id_20,t0.type,t0.artist_roleASartist_role_21,t0.ageASage_22,t0.socialASsocial_23,t0.socialASsocial_24FROMusert0WHEREt0.id=?ANDt0.typeIN (
'system','new','artist','location','manager','organizer','label'
)
AND (
(t0.deleted_atISNULL)
)
SELECTt0.idASid_1,t0.legal_statusASlegal_status_2,t0.emailASemail_3,t0.rolesASroles_4,t0.passwordASpassword_5,t0.nameASname_6,t0.yandexASyandex_7,t0.last_nameASlast_name_8,t0.phoneASphone_9,t0.bank_accountASbank_account_10,t0.created_atAScreated_at_11,t0.activeASactive_12,t0.verifiedASverified_13,t0.localeASlocale_14,t0.payment_account_idASpayment_account_id_15,t0.deleted_atASdeleted_at_16,t0.hashAShash_17,t0.photo_idASphoto_id_18,t0.city_idAScity_id_19,t0.country_idAScountry_id_20,t0.type,t0.artist_roleASartist_role_21,t0.ageASage_22,t0.socialASsocial_23,t0.socialASsocial_24FROMusert0WHEREt0.id=145ANDt0.typeIN ('system','new','artist','location','manager','organizer','label') AND ((t0.deleted_atISNULL));
SELECTe0_.idASid_0,e0_.start_atASstart_at_1,e0_.end_atASend_at_2,e0_.archiveASarchive_3,e0_.deleted_atASdeleted_at_4,e1_.idASid_5,e1_.activeASactive_6,e1_.archiveASarchive_7,e1_.placesASplaces_8,e1_.used_placesASused_places_9,e2_.idASid_10,e2_.unitedASunited_11,e2_.archiveASarchive_12,e3_.idASid_13,e3_.row_nameASrow_name_14,e3_.numberASnumber_15,e3_.activeASactive_16,e3_.reserveASreserve_17,e3_.archiveASarchive_18,e4_.idASid_19,e4_.maxASmax_20,e4_.usedASused_21,e4_.freeASfree_22,e4_.activeASactive_23,e4_.typeAStype_24,e4_.deleted_atASdeleted_at_25,e0_.event_idASevent_id_26,e0_.event_zone_idASevent_zone_id_27,e0_.ticket_type_idASticket_type_id_28,e0_.event_seat_group_idASevent_seat_group_id_29,e0_.event_seat_idASevent_seat_id_30,e1_.event_hall_idASevent_hall_id_31,e1_.zone_idASzone_id_32,e1_.event_idASevent_id_33,e3_.event_idASevent_id_34,e3_.event_zone_idASevent_zone_id_35,e3_.seat_idASseat_id_36,e3_.event_seat_group_idASevent_seat_group_id_37,e4_.event_idASevent_id_38FROMevent_pricee0_LEFT JOINevent_zonee1_ONe0_.event_zone_id=e1_.idLEFT JOINevent_seat_groupe2_ONe0_.event_seat_group_id=e2_.idLEFT JOINevent_seate3_ONe0_.event_seat_id=e3_.idLEFT JOINevent_ticket_typee4_ONe0_.ticket_type_id=e4_.idAND (e4_.deleted_atISNULL) WHERE (e2_.archive=?ORe2_.archiveISNULL) ANDe0_.event_id=?ANDe0_.deleted_atISNULLAND ((e0_.start_at<=?ORe0_.start_atISNULL) AND (e0_.end_at>=?ORe0_.end_atISNULL)) ORDER BYe0_.idASC
SELECTe0_.idASid_0,e0_.hashAShash_1,e0_.location_confirmASlocation_confirm_2,e0_.split_typeASsplit_type_3,e0_.commissionAScommission_4,e0_.typeAStype_5,e0_.count_artistsAScount_artists_6,e0_.count_musiciansAScount_musicians_7,e0_.liveASlive_8,e0_.pre_saleASpre_sale_9,e0_.durationASduration_10,e0_.statusASstatus_11,e0_.sell_statusASsell_status_12,e0_.recommended_ageASrecommended_age_13,e0_.age_restrictionsASage_restrictions_14,e0_.socialASsocial_15,e0_.localeASlocale_16,e0_.taxAStax_17,e0_.free_placesASfree_places_18,e0_.buyed_ticketsASbuyed_tickets_19,e0_.favorites_countASfavorites_count_20,e0_.min_sell_goalASmin_sell_goal_21,e0_.max_sell_goalASmax_sell_goal_22,e0_.activeASactive_23,e0_.sellASsell_24,e0_.dateASdate_25,e0_.start_dateASstart_date_26,e0_.end_dateASend_date_27,e0_.doorsASdoors_28,e0_.start_sale_atASstart_sale_at_29,e0_.end_sale_atASend_sale_at_30,e0_.created_atAScreated_at_31,e0_.slugASslug_32,e0_.deleted_atASdeleted_at_33,e0_.moderation_statusASmoderation_status_34,e0_.creator_idAScreator_id_35,e0_.location_idASlocation_id_36,e0_.country_idAScountry_id_37,e0_.city_idAScity_id_38,e0_.currency_idAScurrency_id_39,e0_.cover_idAScover_id_40,e0_.gallery_idASgallery_id_41,e0_.video_gallery_idASvideo_gallery_id_42FROMevente0_WHERE (e0_.slug=?ORe0_.hash=?) AND (e0_.deleted_atISNULL)
SELECTe0_.idASid_0,e0_.hashAShash_1,e0_.location_confirmASlocation_confirm_2,e0_.split_typeASsplit_type_3,e0_.commissionAScommission_4,e0_.typeAStype_5,e0_.count_artistsAScount_artists_6,e0_.count_musiciansAScount_musicians_7,e0_.liveASlive_8,e0_.pre_saleASpre_sale_9,e0_.durationASduration_10,e0_.statusASstatus_11,e0_.sell_statusASsell_status_12,e0_.recommended_ageASrecommended_age_13,e0_.age_restrictionsASage_restrictions_14,e0_.socialASsocial_15,e0_.localeASlocale_16,e0_.taxAStax_17,e0_.free_placesASfree_places_18,e0_.buyed_ticketsASbuyed_tickets_19,e0_.favorites_countASfavorites_count_20,e0_.min_sell_goalASmin_sell_goal_21,e0_.max_sell_goalASmax_sell_goal_22,e0_.activeASactive_23,e0_.sellASsell_24,e0_.dateASdate_25,e0_.start_dateASstart_date_26,e0_.end_dateASend_date_27,e0_.doorsASdoors_28,e0_.start_sale_atASstart_sale_at_29,e0_.end_sale_atASend_sale_at_30,e0_.created_atAScreated_at_31,e0_.slugASslug_32,e0_.deleted_atASdeleted_at_33,e0_.moderation_statusASmoderation_status_34,e0_.creator_idAScreator_id_35,e0_.location_idASlocation_id_36,e0_.country_idAScountry_id_37,e0_.city_idAScity_id_38,e0_.currency_idAScurrency_id_39,e0_.cover_idAScover_id_40,e0_.gallery_idASgallery_id_41,e0_.video_gallery_idASvideo_gallery_id_42FROMevente0_WHERE
(
e0_.slug=?ORe0_.hash=?
)
AND (e0_.deleted_atISNULL)
SELECTe0_.idASid_0,e0_.hashAShash_1,e0_.location_confirmASlocation_confirm_2,e0_.split_typeASsplit_type_3,e0_.commissionAScommission_4,e0_.typeAStype_5,e0_.count_artistsAScount_artists_6,e0_.count_musiciansAScount_musicians_7,e0_.liveASlive_8,e0_.pre_saleASpre_sale_9,e0_.durationASduration_10,e0_.statusASstatus_11,e0_.sell_statusASsell_status_12,e0_.recommended_ageASrecommended_age_13,e0_.age_restrictionsASage_restrictions_14,e0_.socialASsocial_15,e0_.localeASlocale_16,e0_.taxAStax_17,e0_.free_placesASfree_places_18,e0_.buyed_ticketsASbuyed_tickets_19,e0_.favorites_countASfavorites_count_20,e0_.min_sell_goalASmin_sell_goal_21,e0_.max_sell_goalASmax_sell_goal_22,e0_.activeASactive_23,e0_.sellASsell_24,e0_.dateASdate_25,e0_.start_dateASstart_date_26,e0_.end_dateASend_date_27,e0_.doorsASdoors_28,e0_.start_sale_atASstart_sale_at_29,e0_.end_sale_atASend_sale_at_30,e0_.created_atAScreated_at_31,e0_.slugASslug_32,e0_.deleted_atASdeleted_at_33,e0_.moderation_statusASmoderation_status_34,e0_.creator_idAScreator_id_35,e0_.location_idASlocation_id_36,e0_.country_idAScountry_id_37,e0_.city_idAScity_id_38,e0_.currency_idAScurrency_id_39,e0_.cover_idAScover_id_40,e0_.gallery_idASgallery_id_41,e0_.video_gallery_idASvideo_gallery_id_42FROMevente0_WHERE (e0_.slug='sdf-29-august-2024'ORe0_.hash='sdf-29-august-2024') AND (e0_.deleted_atISNULL);
SELECTc0_.idASid_0,c0_.slugASslug_1,c0_.localesASlocales_2,c0_.activeASactive_3,c0_.enableASenable_4,c0_.codeAScode_5,c0_.commissionAScommission_6,c0_.deleted_atASdeleted_at_7,c0_.currency_idAScurrency_id_8FROMcountryc0_WHERE (c0_.slug=?) AND (c0_.deleted_atISNULL)
SELECTc0_.idASid_0,c0_.slugASslug_1,c0_.localesASlocales_2,c0_.activeASactive_3,c0_.enableASenable_4,c0_.codeAScode_5,c0_.commissionAScommission_6,c0_.deleted_atASdeleted_at_7,c0_.currency_idAScurrency_id_8FROMcountryc0_WHERE
(c0_.slug=?)
AND (c0_.deleted_atISNULL)
SELECTc0_.idASid_0,c0_.slugASslug_1,c0_.localesASlocales_2,c0_.activeASactive_3,c0_.enableASenable_4,c0_.codeAScode_5,c0_.commissionAScommission_6,c0_.deleted_atASdeleted_at_7,c0_.currency_idAScurrency_id_8FROMcountryc0_WHERE (c0_.slug='RU') AND (c0_.deleted_atISNULL);
SELECTt0.idASid_1,t0.legal_statusASlegal_status_2,t0.emailASemail_3,t0.rolesASroles_4,t0.passwordASpassword_5,t0.nameASname_6,t0.yandexASyandex_7,t0.last_nameASlast_name_8,t0.phoneASphone_9,t0.bank_accountASbank_account_10,t0.created_atAScreated_at_11,t0.activeASactive_12,t0.verifiedASverified_13,t0.localeASlocale_14,t0.payment_account_idASpayment_account_id_15,t0.deleted_atASdeleted_at_16,t0.hashAShash_17,t0.artist_roleASartist_role_18,t0.ageASage_19,t0.socialASsocial_20,t0.photo_idASphoto_id_21,t0.city_idAScity_id_22,t0.country_idAScountry_id_23,t0.typeFROMusert0INNER JOINevent_band_artist_userONt0.id=event_band_artist_user.artist_user_idWHEREevent_band_artist_user.event_band_id=?ANDt0.typeIN ('artist') AND ((t0.deleted_atISNULL))
SELECTt0.idASid_1,t0.legal_statusASlegal_status_2,t0.emailASemail_3,t0.rolesASroles_4,t0.passwordASpassword_5,t0.nameASname_6,t0.yandexASyandex_7,t0.last_nameASlast_name_8,t0.phoneASphone_9,t0.bank_accountASbank_account_10,t0.created_atAScreated_at_11,t0.activeASactive_12,t0.verifiedASverified_13,t0.localeASlocale_14,t0.payment_account_idASpayment_account_id_15,t0.deleted_atASdeleted_at_16,t0.hashAShash_17,t0.artist_roleASartist_role_18,t0.ageASage_19,t0.socialASsocial_20,t0.photo_idASphoto_id_21,t0.city_idAScity_id_22,t0.country_idAScountry_id_23,t0.typeFROMusert0INNER JOINevent_band_artist_userONt0.id=event_band_artist_user.artist_user_idWHEREevent_band_artist_user.event_band_id=?ANDt0.typeIN ('artist')
AND (
(t0.deleted_atISNULL)
)
SELECTt0.idASid_1,t0.legal_statusASlegal_status_2,t0.emailASemail_3,t0.rolesASroles_4,t0.passwordASpassword_5,t0.nameASname_6,t0.yandexASyandex_7,t0.last_nameASlast_name_8,t0.phoneASphone_9,t0.bank_accountASbank_account_10,t0.created_atAScreated_at_11,t0.activeASactive_12,t0.verifiedASverified_13,t0.localeASlocale_14,t0.payment_account_idASpayment_account_id_15,t0.deleted_atASdeleted_at_16,t0.hashAShash_17,t0.artist_roleASartist_role_18,t0.ageASage_19,t0.socialASsocial_20,t0.photo_idASphoto_id_21,t0.city_idAScity_id_22,t0.country_idAScountry_id_23,t0.typeFROMusert0INNER JOINevent_band_artist_userONt0.id=event_band_artist_user.artist_user_idWHEREevent_band_artist_user.event_band_id=24ANDt0.typeIN ('artist') AND ((t0.deleted_atISNULL));