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=64ANDt0.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.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=26ANDt0.typeIN ('artist') AND ((t0.deleted_atISNULL));
SELECTt0.idASid_1,t0.placesASplaces_2,t0.activeASactive_3,t0.created_atAScreated_at_4,t0.deleted_atASdeleted_at_5,t0.hall_idAShall_id_6,t0.scheme_map_idASscheme_map_id_7,t0.scheme_idASscheme_id_8FROMlayoutt0WHEREt0.idIN (?) AND ((t0.deleted_atISNULL))
SELECTt0.idASid_1,t0.placesASplaces_2,t0.activeASactive_3,t0.created_atAScreated_at_4,t0.deleted_atASdeleted_at_5,t0.hall_idAShall_id_6,t0.scheme_map_idASscheme_map_id_7,t0.scheme_idASscheme_id_8FROMlayoutt0WHEREt0.idIN (?)
AND (
(t0.deleted_atISNULL)
)
SELECTt0.idASid_1,t0.placesASplaces_2,t0.activeASactive_3,t0.created_atAScreated_at_4,t0.deleted_atASdeleted_at_5,t0.hall_idAShall_id_6,t0.scheme_map_idASscheme_map_id_7,t0.scheme_idASscheme_id_8FROMlayoutt0WHEREt0.idIN (29) AND ((t0.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_.deleted_atISNULL) ORDER BYe0_.idDESCLIMIT10
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_.deleted_atISNULL)
ORDER BYe0_.idDESCLIMIT10
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_.deleted_atISNULL) ORDER BYe0_.idDESCLIMIT10;
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);