346.34 ms (99.22%)
|
1 |
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.created_at AS created_at_12, e0_.is_show_chat AS is_show_chat_13, e0_.is_registration AS is_registration_14, e0_.is_calendar AS is_calendar_15, e0_.is_nmo AS is_nmo_16, e0_.is_show_slider AS is_show_slider_17, e0_.image_name AS image_name_18, e0_.image_original_name AS image_original_name_19, e0_.image_mime_type AS image_mime_type_20, e0_.image_size AS image_size_21, e0_.image_updated_at AS image_updated_at_22, e0_.card_image_name AS card_image_name_23, e0_.card_image_original_name AS card_image_original_name_24, e0_.card_image_mime_type AS card_image_mime_type_25, e0_.card_image_size AS card_image_size_26, e0_.card_image_updated_at AS card_image_updated_at_27, e1_.id AS id_28, e1_.title AS title_29, e1_.seo_title AS seo_title_30, e1_.seo_description AS seo_description_31, e1_.content AS content_32, l2_.id AS id_33, l2_.name AS name_34, s3_.id AS id_35, s3_.is_enabled AS is_enabled_36, s3_.created_at AS created_at_37, s3_.image_name AS image_name_38, s3_.image_original_name AS image_original_name_39, s3_.image_mime_type AS image_mime_type_40, s3_.image_size AS image_size_41, s3_.image_updated_at AS image_updated_at_42, s4_.id AS id_43, s4_.name AS name_44, s4_.content AS content_45, l5_.id AS id_46, l5_.name AS name_47, s6_.id AS id_48, s6_.is_enabled AS is_enabled_49, s6_.created_at AS created_at_50, s6_.image_name AS image_name_51, s6_.image_original_name AS image_original_name_52, s6_.image_mime_type AS image_mime_type_53, s6_.image_size AS image_size_54, s6_.image_updated_at AS image_updated_at_55, s7_.id AS id_56, s7_.name AS name_57, s7_.content AS content_58, l8_.id AS id_59, l8_.name AS name_60, s9_.id AS id_61, s9_.name AS name_62, s9_.type AS type_63, e10_.id AS id_64, e10_.website_url AS website_url_65, e10_.is_enabled AS is_enabled_66, e10_.created_at AS created_at_67, e10_.image_name AS image_name_68, e10_.image_original_name AS image_original_name_69, e10_.image_mime_type AS image_mime_type_70, e10_.image_size AS image_size_71, e10_.image_updated_at AS image_updated_at_72, e11_.id AS id_73, e11_.title AS title_74, e11_.short_description AS short_description_75, l12_.id AS id_76, l12_.name AS name_77, e13_.id AS id_78, e13_.website_url AS website_url_79, e13_.is_enabled AS is_enabled_80, e13_.created_at AS created_at_81, e13_.image_name AS image_name_82, e13_.image_original_name AS image_original_name_83, e13_.image_mime_type AS image_mime_type_84, e13_.image_size AS image_size_85, e13_.image_updated_at AS image_updated_at_86, e14_.id AS id_87, e14_.title AS title_88, e14_.short_description AS short_description_89, l15_.id AS id_90, l15_.name AS name_91, e16_.id AS id_92, e16_.website_url AS website_url_93, e16_.is_enabled AS is_enabled_94, e16_.created_at AS created_at_95, e16_.image_name AS image_name_96, e16_.image_original_name AS image_original_name_97, e16_.image_mime_type AS image_mime_type_98, e16_.image_size AS image_size_99, e16_.image_updated_at AS image_updated_at_100, e17_.id AS id_101, e17_.title AS title_102, e17_.short_description AS short_description_103, l18_.id AS id_104, l18_.name AS name_105, e19_.id AS id_106, e19_.website_url AS website_url_107, e19_.is_enabled AS is_enabled_108, e19_.created_at AS created_at_109, e19_.image_name AS image_name_110, e19_.image_original_name AS image_original_name_111, e19_.image_mime_type AS image_mime_type_112, e19_.image_size AS image_size_113, e19_.image_updated_at AS image_updated_at_114, e20_.id AS id_115, e20_.title AS title_116, e20_.short_description AS short_description_117, l21_.id AS id_118, l21_.name AS name_119, e22_.id AS id_120, e22_.website_url AS website_url_121, e22_.is_enabled AS is_enabled_122, e22_.created_at AS created_at_123, e22_.image_name AS image_name_124, e22_.image_original_name AS image_original_name_125, e22_.image_mime_type AS image_mime_type_126, e22_.image_size AS image_size_127, e22_.image_updated_at AS image_updated_at_128, e23_.id AS id_129, e23_.title AS title_130, e23_.short_description AS short_description_131, l24_.id AS id_132, l24_.name AS name_133, e25_.id AS id_134, e25_.iframe AS iframe_135, e25_.title AS title_136, e25_.sort AS sort_137, l26_.id AS id_138, l26_.name AS name_139, e0_.poll_id AS poll_id_140, e0_.event_group_id AS event_group_id_141, e1_.lang_id AS lang_id_142, e1_.event_id AS event_id_143, s4_.speaker_id AS speaker_id_144, s4_.lang_id AS lang_id_145, s7_.speaker_id AS speaker_id_146, s7_.lang_id AS lang_id_147, e11_.lang_id AS lang_id_148, e11_.event_organization_id AS event_organization_id_149, e14_.lang_id AS lang_id_150, e14_.event_organization_id AS event_organization_id_151, e17_.lang_id AS lang_id_152, e17_.event_organization_id AS event_organization_id_153, e20_.lang_id AS lang_id_154, e20_.event_organization_id AS event_organization_id_155, e23_.lang_id AS lang_id_156, e23_.event_organization_id AS event_organization_id_157, e25_.lang_id AS lang_id_158, e25_.event_id AS event_id_159 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_speaker e27_ ON e0_.id = e27_.event_id LEFT JOIN speaker s3_ ON s3_.id = e27_.speaker_id LEFT JOIN speaker_translate s4_ ON s3_.id = s4_.speaker_id LEFT JOIN language l5_ ON s4_.lang_id = l5_.id LEFT JOIN event_organizational_committee e28_ ON e0_.id = e28_.event_id LEFT JOIN speaker s6_ ON s6_.id = e28_.speaker_id LEFT JOIN speaker_translate s7_ ON s6_.id = s7_.speaker_id LEFT JOIN language l8_ ON s7_.lang_id = l8_.id LEFT JOIN event_specialty e29_ ON e0_.id = e29_.event_id LEFT JOIN specialty s9_ ON s9_.id = e29_.specialty_id LEFT JOIN event_organizer e30_ ON e0_.id = e30_.event_id LEFT JOIN event_organization e10_ ON e10_.id = e30_.event_organization_id LEFT JOIN event_organization_translate e11_ ON e10_.id = e11_.event_organization_id LEFT JOIN language l12_ ON e11_.lang_id = l12_.id LEFT JOIN event_co_organizer e31_ ON e0_.id = e31_.event_id LEFT JOIN event_organization e13_ ON e13_.id = e31_.event_organization_id LEFT JOIN event_organization_translate e14_ ON e13_.id = e14_.event_organization_id LEFT JOIN language l15_ ON e14_.lang_id = l15_.id LEFT JOIN event_supporter e32_ ON e0_.id = e32_.event_id LEFT JOIN event_organization e16_ ON e16_.id = e32_.event_organization_id LEFT JOIN event_organization_translate e17_ ON e16_.id = e17_.event_organization_id LEFT JOIN language l18_ ON e17_.lang_id = l18_.id LEFT JOIN event_partner e33_ ON e0_.id = e33_.event_id LEFT JOIN event_organization e19_ ON e19_.id = e33_.event_organization_id LEFT JOIN event_organization_translate e20_ ON e19_.id = e20_.event_organization_id LEFT JOIN language l21_ ON e20_.lang_id = l21_.id LEFT JOIN event_information_partner e34_ ON e0_.id = e34_.event_id LEFT JOIN event_organization e22_ ON e22_.id = e34_.event_organization_id LEFT JOIN event_organization_translate e23_ ON e22_.id = e23_.event_organization_id LEFT JOIN language l24_ ON e23_.lang_id = l24_.id LEFT JOIN event_tab e25_ ON e0_.id = e25_.event_id LEFT JOIN language l26_ ON e25_.lang_id = l26_.id WHERE e0_.slug = ? AND e0_.is_enabled = ? AND e0_.is_activated = ?
Parameters: [
"ii-regionalnyy-endokrinologicheskiy-sezd-vyzovy-i-perspektivy-privolzhya-den-2"
1
1
]
SELECT
e0_.id AS id_0,
e0_.slug AS slug_1,
e0_.program_name AS program_name_2,
e0_.program_original_name AS program_original_name_3,
e0_.program_mime_type AS program_mime_type_4,
e0_.program_size AS program_size_5,
e0_.program_updated_at AS program_updated_at_6,
e0_.is_activated AS is_activated_7,
e0_.is_enabled AS is_enabled_8,
e0_.start_at AS start_at_9,
e0_.end_at AS end_at_10,
e0_.status AS status_11,
e0_.created_at AS created_at_12,
e0_.is_show_chat AS is_show_chat_13,
e0_.is_registration AS is_registration_14,
e0_.is_calendar AS is_calendar_15,
e0_.is_nmo AS is_nmo_16,
e0_.is_show_slider AS is_show_slider_17,
e0_.image_name AS image_name_18,
e0_.image_original_name AS image_original_name_19,
e0_.image_mime_type AS image_mime_type_20,
e0_.image_size AS image_size_21,
e0_.image_updated_at AS image_updated_at_22,
e0_.card_image_name AS card_image_name_23,
e0_.card_image_original_name AS card_image_original_name_24,
e0_.card_image_mime_type AS card_image_mime_type_25,
e0_.card_image_size AS card_image_size_26,
e0_.card_image_updated_at AS card_image_updated_at_27,
e1_.id AS id_28,
e1_.title AS title_29,
e1_.seo_title AS seo_title_30,
e1_.seo_description AS seo_description_31,
e1_.content AS content_32,
l2_.id AS id_33,
l2_.name AS name_34,
s3_.id AS id_35,
s3_.is_enabled AS is_enabled_36,
s3_.created_at AS created_at_37,
s3_.image_name AS image_name_38,
s3_.image_original_name AS image_original_name_39,
s3_.image_mime_type AS image_mime_type_40,
s3_.image_size AS image_size_41,
s3_.image_updated_at AS image_updated_at_42,
s4_.id AS id_43,
s4_.name AS name_44,
s4_.content AS content_45,
l5_.id AS id_46,
l5_.name AS name_47,
s6_.id AS id_48,
s6_.is_enabled AS is_enabled_49,
s6_.created_at AS created_at_50,
s6_.image_name AS image_name_51,
s6_.image_original_name AS image_original_name_52,
s6_.image_mime_type AS image_mime_type_53,
s6_.image_size AS image_size_54,
s6_.image_updated_at AS image_updated_at_55,
s7_.id AS id_56,
s7_.name AS name_57,
s7_.content AS content_58,
l8_.id AS id_59,
l8_.name AS name_60,
s9_.id AS id_61,
s9_.name AS name_62,
s9_.type AS type_63,
e10_.id AS id_64,
e10_.website_url AS website_url_65,
e10_.is_enabled AS is_enabled_66,
e10_.created_at AS created_at_67,
e10_.image_name AS image_name_68,
e10_.image_original_name AS image_original_name_69,
e10_.image_mime_type AS image_mime_type_70,
e10_.image_size AS image_size_71,
e10_.image_updated_at AS image_updated_at_72,
e11_.id AS id_73,
e11_.title AS title_74,
e11_.short_description AS short_description_75,
l12_.id AS id_76,
l12_.name AS name_77,
e13_.id AS id_78,
e13_.website_url AS website_url_79,
e13_.is_enabled AS is_enabled_80,
e13_.created_at AS created_at_81,
e13_.image_name AS image_name_82,
e13_.image_original_name AS image_original_name_83,
e13_.image_mime_type AS image_mime_type_84,
e13_.image_size AS image_size_85,
e13_.image_updated_at AS image_updated_at_86,
e14_.id AS id_87,
e14_.title AS title_88,
e14_.short_description AS short_description_89,
l15_.id AS id_90,
l15_.name AS name_91,
e16_.id AS id_92,
e16_.website_url AS website_url_93,
e16_.is_enabled AS is_enabled_94,
e16_.created_at AS created_at_95,
e16_.image_name AS image_name_96,
e16_.image_original_name AS image_original_name_97,
e16_.image_mime_type AS image_mime_type_98,
e16_.image_size AS image_size_99,
e16_.image_updated_at AS image_updated_at_100,
e17_.id AS id_101,
e17_.title AS title_102,
e17_.short_description AS short_description_103,
l18_.id AS id_104,
l18_.name AS name_105,
e19_.id AS id_106,
e19_.website_url AS website_url_107,
e19_.is_enabled AS is_enabled_108,
e19_.created_at AS created_at_109,
e19_.image_name AS image_name_110,
e19_.image_original_name AS image_original_name_111,
e19_.image_mime_type AS image_mime_type_112,
e19_.image_size AS image_size_113,
e19_.image_updated_at AS image_updated_at_114,
e20_.id AS id_115,
e20_.title AS title_116,
e20_.short_description AS short_description_117,
l21_.id AS id_118,
l21_.name AS name_119,
e22_.id AS id_120,
e22_.website_url AS website_url_121,
e22_.is_enabled AS is_enabled_122,
e22_.created_at AS created_at_123,
e22_.image_name AS image_name_124,
e22_.image_original_name AS image_original_name_125,
e22_.image_mime_type AS image_mime_type_126,
e22_.image_size AS image_size_127,
e22_.image_updated_at AS image_updated_at_128,
e23_.id AS id_129,
e23_.title AS title_130,
e23_.short_description AS short_description_131,
l24_.id AS id_132,
l24_.name AS name_133,
e25_.id AS id_134,
e25_.iframe AS iframe_135,
e25_.title AS title_136,
e25_.sort AS sort_137,
l26_.id AS id_138,
l26_.name AS name_139,
e0_.poll_id AS poll_id_140,
e0_.event_group_id AS event_group_id_141,
e1_.lang_id AS lang_id_142,
e1_.event_id AS event_id_143,
s4_.speaker_id AS speaker_id_144,
s4_.lang_id AS lang_id_145,
s7_.speaker_id AS speaker_id_146,
s7_.lang_id AS lang_id_147,
e11_.lang_id AS lang_id_148,
e11_.event_organization_id AS event_organization_id_149,
e14_.lang_id AS lang_id_150,
e14_.event_organization_id AS event_organization_id_151,
e17_.lang_id AS lang_id_152,
e17_.event_organization_id AS event_organization_id_153,
e20_.lang_id AS lang_id_154,
e20_.event_organization_id AS event_organization_id_155,
e23_.lang_id AS lang_id_156,
e23_.event_organization_id AS event_organization_id_157,
e25_.lang_id AS lang_id_158,
e25_.event_id AS event_id_159
FROM
event e0_
LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id
LEFT JOIN language l2_ ON e1_.lang_id = l2_.id
LEFT JOIN event_speaker e27_ ON e0_.id = e27_.event_id
LEFT JOIN speaker s3_ ON s3_.id = e27_.speaker_id
LEFT JOIN speaker_translate s4_ ON s3_.id = s4_.speaker_id
LEFT JOIN language l5_ ON s4_.lang_id = l5_.id
LEFT JOIN event_organizational_committee e28_ ON e0_.id = e28_.event_id
LEFT JOIN speaker s6_ ON s6_.id = e28_.speaker_id
LEFT JOIN speaker_translate s7_ ON s6_.id = s7_.speaker_id
LEFT JOIN language l8_ ON s7_.lang_id = l8_.id
LEFT JOIN event_specialty e29_ ON e0_.id = e29_.event_id
LEFT JOIN specialty s9_ ON s9_.id = e29_.specialty_id
LEFT JOIN event_organizer e30_ ON e0_.id = e30_.event_id
LEFT JOIN event_organization e10_ ON e10_.id = e30_.event_organization_id
LEFT JOIN event_organization_translate e11_ ON e10_.id = e11_.event_organization_id
LEFT JOIN language l12_ ON e11_.lang_id = l12_.id
LEFT JOIN event_co_organizer e31_ ON e0_.id = e31_.event_id
LEFT JOIN event_organization e13_ ON e13_.id = e31_.event_organization_id
LEFT JOIN event_organization_translate e14_ ON e13_.id = e14_.event_organization_id
LEFT JOIN language l15_ ON e14_.lang_id = l15_.id
LEFT JOIN event_supporter e32_ ON e0_.id = e32_.event_id
LEFT JOIN event_organization e16_ ON e16_.id = e32_.event_organization_id
LEFT JOIN event_organization_translate e17_ ON e16_.id = e17_.event_organization_id
LEFT JOIN language l18_ ON e17_.lang_id = l18_.id
LEFT JOIN event_partner e33_ ON e0_.id = e33_.event_id
LEFT JOIN event_organization e19_ ON e19_.id = e33_.event_organization_id
LEFT JOIN event_organization_translate e20_ ON e19_.id = e20_.event_organization_id
LEFT JOIN language l21_ ON e20_.lang_id = l21_.id
LEFT JOIN event_information_partner e34_ ON e0_.id = e34_.event_id
LEFT JOIN event_organization e22_ ON e22_.id = e34_.event_organization_id
LEFT JOIN event_organization_translate e23_ ON e22_.id = e23_.event_organization_id
LEFT JOIN language l24_ ON e23_.lang_id = l24_.id
LEFT JOIN event_tab e25_ ON e0_.id = e25_.event_id
LEFT JOIN language l26_ ON e25_.lang_id = l26_.id
WHERE
e0_.slug = ?
AND e0_.is_enabled = ?
AND e0_.is_activated = ?
SELECT e0_.id AS id_0, e0_.slug AS slug_1, e0_.program_name AS program_name_2, e0_.program_original_name AS program_original_name_3, e0_.program_mime_type AS program_mime_type_4, e0_.program_size AS program_size_5, e0_.program_updated_at AS program_updated_at_6, e0_.is_activated AS is_activated_7, e0_.is_enabled AS is_enabled_8, e0_.start_at AS start_at_9, e0_.end_at AS end_at_10, e0_.status AS status_11, e0_.created_at AS created_at_12, e0_.is_show_chat AS is_show_chat_13, e0_.is_registration AS is_registration_14, e0_.is_calendar AS is_calendar_15, e0_.is_nmo AS is_nmo_16, e0_.is_show_slider AS is_show_slider_17, e0_.image_name AS image_name_18, e0_.image_original_name AS image_original_name_19, e0_.image_mime_type AS image_mime_type_20, e0_.image_size AS image_size_21, e0_.image_updated_at AS image_updated_at_22, e0_.card_image_name AS card_image_name_23, e0_.card_image_original_name AS card_image_original_name_24, e0_.card_image_mime_type AS card_image_mime_type_25, e0_.card_image_size AS card_image_size_26, e0_.card_image_updated_at AS card_image_updated_at_27, e1_.id AS id_28, e1_.title AS title_29, e1_.seo_title AS seo_title_30, e1_.seo_description AS seo_description_31, e1_.content AS content_32, l2_.id AS id_33, l2_.name AS name_34, s3_.id AS id_35, s3_.is_enabled AS is_enabled_36, s3_.created_at AS created_at_37, s3_.image_name AS image_name_38, s3_.image_original_name AS image_original_name_39, s3_.image_mime_type AS image_mime_type_40, s3_.image_size AS image_size_41, s3_.image_updated_at AS image_updated_at_42, s4_.id AS id_43, s4_.name AS name_44, s4_.content AS content_45, l5_.id AS id_46, l5_.name AS name_47, s6_.id AS id_48, s6_.is_enabled AS is_enabled_49, s6_.created_at AS created_at_50, s6_.image_name AS image_name_51, s6_.image_original_name AS image_original_name_52, s6_.image_mime_type AS image_mime_type_53, s6_.image_size AS image_size_54, s6_.image_updated_at AS image_updated_at_55, s7_.id AS id_56, s7_.name AS name_57, s7_.content AS content_58, l8_.id AS id_59, l8_.name AS name_60, s9_.id AS id_61, s9_.name AS name_62, s9_.type AS type_63, e10_.id AS id_64, e10_.website_url AS website_url_65, e10_.is_enabled AS is_enabled_66, e10_.created_at AS created_at_67, e10_.image_name AS image_name_68, e10_.image_original_name AS image_original_name_69, e10_.image_mime_type AS image_mime_type_70, e10_.image_size AS image_size_71, e10_.image_updated_at AS image_updated_at_72, e11_.id AS id_73, e11_.title AS title_74, e11_.short_description AS short_description_75, l12_.id AS id_76, l12_.name AS name_77, e13_.id AS id_78, e13_.website_url AS website_url_79, e13_.is_enabled AS is_enabled_80, e13_.created_at AS created_at_81, e13_.image_name AS image_name_82, e13_.image_original_name AS image_original_name_83, e13_.image_mime_type AS image_mime_type_84, e13_.image_size AS image_size_85, e13_.image_updated_at AS image_updated_at_86, e14_.id AS id_87, e14_.title AS title_88, e14_.short_description AS short_description_89, l15_.id AS id_90, l15_.name AS name_91, e16_.id AS id_92, e16_.website_url AS website_url_93, e16_.is_enabled AS is_enabled_94, e16_.created_at AS created_at_95, e16_.image_name AS image_name_96, e16_.image_original_name AS image_original_name_97, e16_.image_mime_type AS image_mime_type_98, e16_.image_size AS image_size_99, e16_.image_updated_at AS image_updated_at_100, e17_.id AS id_101, e17_.title AS title_102, e17_.short_description AS short_description_103, l18_.id AS id_104, l18_.name AS name_105, e19_.id AS id_106, e19_.website_url AS website_url_107, e19_.is_enabled AS is_enabled_108, e19_.created_at AS created_at_109, e19_.image_name AS image_name_110, e19_.image_original_name AS image_original_name_111, e19_.image_mime_type AS image_mime_type_112, e19_.image_size AS image_size_113, e19_.image_updated_at AS image_updated_at_114, e20_.id AS id_115, e20_.title AS title_116, e20_.short_description AS short_description_117, l21_.id AS id_118, l21_.name AS name_119, e22_.id AS id_120, e22_.website_url AS website_url_121, e22_.is_enabled AS is_enabled_122, e22_.created_at AS created_at_123, e22_.image_name AS image_name_124, e22_.image_original_name AS image_original_name_125, e22_.image_mime_type AS image_mime_type_126, e22_.image_size AS image_size_127, e22_.image_updated_at AS image_updated_at_128, e23_.id AS id_129, e23_.title AS title_130, e23_.short_description AS short_description_131, l24_.id AS id_132, l24_.name AS name_133, e25_.id AS id_134, e25_.iframe AS iframe_135, e25_.title AS title_136, e25_.sort AS sort_137, l26_.id AS id_138, l26_.name AS name_139, e0_.poll_id AS poll_id_140, e0_.event_group_id AS event_group_id_141, e1_.lang_id AS lang_id_142, e1_.event_id AS event_id_143, s4_.speaker_id AS speaker_id_144, s4_.lang_id AS lang_id_145, s7_.speaker_id AS speaker_id_146, s7_.lang_id AS lang_id_147, e11_.lang_id AS lang_id_148, e11_.event_organization_id AS event_organization_id_149, e14_.lang_id AS lang_id_150, e14_.event_organization_id AS event_organization_id_151, e17_.lang_id AS lang_id_152, e17_.event_organization_id AS event_organization_id_153, e20_.lang_id AS lang_id_154, e20_.event_organization_id AS event_organization_id_155, e23_.lang_id AS lang_id_156, e23_.event_organization_id AS event_organization_id_157, e25_.lang_id AS lang_id_158, e25_.event_id AS event_id_159 FROM event e0_ LEFT JOIN event_translate e1_ ON e0_.id = e1_.event_id LEFT JOIN language l2_ ON e1_.lang_id = l2_.id LEFT JOIN event_speaker e27_ ON e0_.id = e27_.event_id LEFT JOIN speaker s3_ ON s3_.id = e27_.speaker_id LEFT JOIN speaker_translate s4_ ON s3_.id = s4_.speaker_id LEFT JOIN language l5_ ON s4_.lang_id = l5_.id LEFT JOIN event_organizational_committee e28_ ON e0_.id = e28_.event_id LEFT JOIN speaker s6_ ON s6_.id = e28_.speaker_id LEFT JOIN speaker_translate s7_ ON s6_.id = s7_.speaker_id LEFT JOIN language l8_ ON s7_.lang_id = l8_.id LEFT JOIN event_specialty e29_ ON e0_.id = e29_.event_id LEFT JOIN specialty s9_ ON s9_.id = e29_.specialty_id LEFT JOIN event_organizer e30_ ON e0_.id = e30_.event_id LEFT JOIN event_organization e10_ ON e10_.id = e30_.event_organization_id LEFT JOIN event_organization_translate e11_ ON e10_.id = e11_.event_organization_id LEFT JOIN language l12_ ON e11_.lang_id = l12_.id LEFT JOIN event_co_organizer e31_ ON e0_.id = e31_.event_id LEFT JOIN event_organization e13_ ON e13_.id = e31_.event_organization_id LEFT JOIN event_organization_translate e14_ ON e13_.id = e14_.event_organization_id LEFT JOIN language l15_ ON e14_.lang_id = l15_.id LEFT JOIN event_supporter e32_ ON e0_.id = e32_.event_id LEFT JOIN event_organization e16_ ON e16_.id = e32_.event_organization_id LEFT JOIN event_organization_translate e17_ ON e16_.id = e17_.event_organization_id LEFT JOIN language l18_ ON e17_.lang_id = l18_.id LEFT JOIN event_partner e33_ ON e0_.id = e33_.event_id LEFT JOIN event_organization e19_ ON e19_.id = e33_.event_organization_id LEFT JOIN event_organization_translate e20_ ON e19_.id = e20_.event_organization_id LEFT JOIN language l21_ ON e20_.lang_id = l21_.id LEFT JOIN event_information_partner e34_ ON e0_.id = e34_.event_id LEFT JOIN event_organization e22_ ON e22_.id = e34_.event_organization_id LEFT JOIN event_organization_translate e23_ ON e22_.id = e23_.event_organization_id LEFT JOIN language l24_ ON e23_.lang_id = l24_.id LEFT JOIN event_tab e25_ ON e0_.id = e25_.event_id LEFT JOIN language l26_ ON e25_.lang_id = l26_.id WHERE e0_.slug = 'ii-regionalnyy-endokrinologicheskiy-sezd-vyzovy-i-perspektivy-privolzhya-den-2' AND e0_.is_enabled = 1 AND e0_.is_activated = 1;
|