1 | SELECT `Event`.`id`, `Event`.`event_name`, `Event`.`event_details`, `Event`.`content`, `Event`.`event_place`, `Event`.`event_date`, `Event`.`event_dateb`, `Event`.`event_logo`, `Event`.`exhibition`, `Event`.`networking`, `Event`.`testimonials`, `Event`.`isactive`, `Event`.`isdeleted`, `Event`.`isblocked`, `Event`.`created`, `Event`.`modified`, `Event`.`event_title_css`, `Event`.`event_details_css`, `Event`.`event_date_css`, `Event`.`event_location_css`, `Event`.`fee_text`, `Event`.`fee_text_flag`, `Event`.`terms_condition_text`, `Event`.`terms_condition_flag`, `Event`.`credit_card_text`, `Event`.`credit_card_text_flag`, `Event`.`bank_transfer_text`, `Event`.`bank_transfer_text_flag`, `Event`.`pay_check_text`, `Event`.`payby_cheque_address`, `Event`.`pay_check_text_flag` FROM `mcimedia_media`.`mci_events` AS `Event` WHERE `Event`.`isblocked` = 0 AND `Event`.`id` = 5 | | 0 | 0 | 0 |
2 | SELECT `Sponsor`.`id`, `Sponsor`.`event_id`, `Sponsor`.`sponsor_name`, `Sponsor`.`sponsor_logo`, `Sponsor`.`type`, `Sponsor`.`link`, `Sponsor`.`created`, `Sponsor`.`isactive`, `Sponsor`.`isblocked`, `Sponsor`.`isdeleted`, `Event`.`id`, `Event`.`event_name`, `Event`.`event_details`, `Event`.`content`, `Event`.`event_place`, `Event`.`event_date`, `Event`.`event_dateb`, `Event`.`event_logo`, `Event`.`exhibition`, `Event`.`networking`, `Event`.`testimonials`, `Event`.`isactive`, `Event`.`isdeleted`, `Event`.`isblocked`, `Event`.`created`, `Event`.`modified`, `Event`.`event_title_css`, `Event`.`event_details_css`, `Event`.`event_date_css`, `Event`.`event_location_css`, `Event`.`fee_text`, `Event`.`fee_text_flag`, `Event`.`terms_condition_text`, `Event`.`terms_condition_flag`, `Event`.`credit_card_text`, `Event`.`credit_card_text_flag`, `Event`.`bank_transfer_text`, `Event`.`bank_transfer_text_flag`, `Event`.`pay_check_text`, `Event`.`payby_cheque_address`, `Event`.`pay_check_text_flag` FROM `mcimedia_media`.`mci_sponsors` AS `Sponsor` LEFT JOIN `mcimedia_media`.`mci_events` AS `Event` ON (`Sponsor`.`event_id` = `Event`.`id`) WHERE `Sponsor`.`isblocked` = 0 AND `Sponsor`.`event_id` = 5 | | 12 | 12 | 2 |
3 | SELECT `Sponsor`.`id`, `Sponsor`.`event_id`, `Sponsor`.`sponsor_name`, `Sponsor`.`sponsor_logo`, `Sponsor`.`type`, `Sponsor`.`link`, `Sponsor`.`created`, `Sponsor`.`isactive`, `Sponsor`.`isblocked`, `Sponsor`.`isdeleted`, `Event`.`id`, `Event`.`event_name`, `Event`.`event_details`, `Event`.`content`, `Event`.`event_place`, `Event`.`event_date`, `Event`.`event_dateb`, `Event`.`event_logo`, `Event`.`exhibition`, `Event`.`networking`, `Event`.`testimonials`, `Event`.`isactive`, `Event`.`isdeleted`, `Event`.`isblocked`, `Event`.`created`, `Event`.`modified`, `Event`.`event_title_css`, `Event`.`event_details_css`, `Event`.`event_date_css`, `Event`.`event_location_css`, `Event`.`fee_text`, `Event`.`fee_text_flag`, `Event`.`terms_condition_text`, `Event`.`terms_condition_flag`, `Event`.`credit_card_text`, `Event`.`credit_card_text_flag`, `Event`.`bank_transfer_text`, `Event`.`bank_transfer_text_flag`, `Event`.`pay_check_text`, `Event`.`payby_cheque_address`, `Event`.`pay_check_text_flag` FROM `mcimedia_media`.`mci_sponsors` AS `Sponsor` LEFT JOIN `mcimedia_media`.`mci_events` AS `Event` ON (`Sponsor`.`event_id` = `Event`.`id`) WHERE `Sponsor`.`isblocked` = 0 AND `Sponsor`.`event_id` = 5 LIMIT 6 | | 6 | 6 | 0 |
4 | SELECT `Sponsor`.`id`, `Sponsor`.`event_id`, `Sponsor`.`sponsor_name`, `Sponsor`.`sponsor_logo`, `Sponsor`.`type`, `Sponsor`.`link`, `Sponsor`.`created`, `Sponsor`.`isactive`, `Sponsor`.`isblocked`, `Sponsor`.`isdeleted`, `Event`.`id`, `Event`.`event_name`, `Event`.`event_details`, `Event`.`content`, `Event`.`event_place`, `Event`.`event_date`, `Event`.`event_dateb`, `Event`.`event_logo`, `Event`.`exhibition`, `Event`.`networking`, `Event`.`testimonials`, `Event`.`isactive`, `Event`.`isdeleted`, `Event`.`isblocked`, `Event`.`created`, `Event`.`modified`, `Event`.`event_title_css`, `Event`.`event_details_css`, `Event`.`event_date_css`, `Event`.`event_location_css`, `Event`.`fee_text`, `Event`.`fee_text_flag`, `Event`.`terms_condition_text`, `Event`.`terms_condition_flag`, `Event`.`credit_card_text`, `Event`.`credit_card_text_flag`, `Event`.`bank_transfer_text`, `Event`.`bank_transfer_text_flag`, `Event`.`pay_check_text`, `Event`.`payby_cheque_address`, `Event`.`pay_check_text_flag` FROM `mcimedia_media`.`mci_sponsors` AS `Sponsor` LEFT JOIN `mcimedia_media`.`mci_events` AS `Event` ON (`Sponsor`.`event_id` = `Event`.`id`) WHERE `Sponsor`.`isblocked` = 0 AND `Sponsor`.`event_id` = 5 ORDER BY `Sponsor`.`id` DESC LIMIT 6 | | 6 | 6 | 1 |
5 | SELECT `Announcement`.`id`, `Announcement`.`event_id`, `Announcement`.`content`, `Announcement`.`isactive`, `Announcement`.`isblocked`, `Announcement`.`isdeleted`, `Announcement`.`created`, `Event`.`id`, `Event`.`event_name`, `Event`.`event_details`, `Event`.`content`, `Event`.`event_place`, `Event`.`event_date`, `Event`.`event_dateb`, `Event`.`event_logo`, `Event`.`exhibition`, `Event`.`networking`, `Event`.`testimonials`, `Event`.`isactive`, `Event`.`isdeleted`, `Event`.`isblocked`, `Event`.`created`, `Event`.`modified`, `Event`.`event_title_css`, `Event`.`event_details_css`, `Event`.`event_date_css`, `Event`.`event_location_css`, `Event`.`fee_text`, `Event`.`fee_text_flag`, `Event`.`terms_condition_text`, `Event`.`terms_condition_flag`, `Event`.`credit_card_text`, `Event`.`credit_card_text_flag`, `Event`.`bank_transfer_text`, `Event`.`bank_transfer_text_flag`, `Event`.`pay_check_text`, `Event`.`payby_cheque_address`, `Event`.`pay_check_text_flag` FROM `mcimedia_media`.`mci_announcements` AS `Announcement` LEFT JOIN `mcimedia_media`.`mci_events` AS `Event` ON (`Announcement`.`event_id` = `Event`.`id`) WHERE `Announcement`.`event_id` = '5' AND `Announcement`.`isblocked` = '0' | | 1 | 1 | 2 |
6 | SELECT `Eventsubpage`.`id`, `Eventsubpage`.`event_id`, `Eventsubpage`.`subpage_name`, `Eventsubpage`.`content`, `Eventsubpage`.`isactive`, `Eventsubpage`.`isdeleted`, `Eventsubpage`.`isblocked`, `Eventsubpage`.`creation`, `Event`.`id`, `Event`.`event_name`, `Event`.`event_details`, `Event`.`content`, `Event`.`event_place`, `Event`.`event_date`, `Event`.`event_dateb`, `Event`.`event_logo`, `Event`.`exhibition`, `Event`.`networking`, `Event`.`testimonials`, `Event`.`isactive`, `Event`.`isdeleted`, `Event`.`isblocked`, `Event`.`created`, `Event`.`modified`, `Event`.`event_title_css`, `Event`.`event_details_css`, `Event`.`event_date_css`, `Event`.`event_location_css`, `Event`.`fee_text`, `Event`.`fee_text_flag`, `Event`.`terms_condition_text`, `Event`.`terms_condition_flag`, `Event`.`credit_card_text`, `Event`.`credit_card_text_flag`, `Event`.`bank_transfer_text`, `Event`.`bank_transfer_text_flag`, `Event`.`pay_check_text`, `Event`.`payby_cheque_address`, `Event`.`pay_check_text_flag` FROM `mcimedia_media`.`mci_eventsubpages` AS `Eventsubpage` LEFT JOIN `mcimedia_media`.`mci_events` AS `Event` ON (`Eventsubpage`.`event_id` = `Event`.`id`) WHERE `Eventsubpage`.`event_id` = '5' AND `Eventsubpage`.`isblocked` = 0 AND `Eventsubpage`.`subpage_name` = 'Sponsorship' | | 1 | 1 | 5 |
7 | SELECT `Eventimage`.`id`, `Eventimage`.`event_id`, `Eventimage`.`img_label`, `Eventimage`.`image_name`, `Eventimage`.`event_img_path`, `Eventimage`.`coverFlag`, `Eventimage`.`title`, `Eventimage`.`isactive`, `Eventimage`.`isblocked`, `Eventimage`.`isdeleted`, `Event`.`id`, `Event`.`event_name`, `Event`.`event_details`, `Event`.`content`, `Event`.`event_place`, `Event`.`event_date`, `Event`.`event_dateb`, `Event`.`event_logo`, `Event`.`exhibition`, `Event`.`networking`, `Event`.`testimonials`, `Event`.`isactive`, `Event`.`isdeleted`, `Event`.`isblocked`, `Event`.`created`, `Event`.`modified`, `Event`.`event_title_css`, `Event`.`event_details_css`, `Event`.`event_date_css`, `Event`.`event_location_css`, `Event`.`fee_text`, `Event`.`fee_text_flag`, `Event`.`terms_condition_text`, `Event`.`terms_condition_flag`, `Event`.`credit_card_text`, `Event`.`credit_card_text_flag`, `Event`.`bank_transfer_text`, `Event`.`bank_transfer_text_flag`, `Event`.`pay_check_text`, `Event`.`payby_cheque_address`, `Event`.`pay_check_text_flag` FROM `mcimedia_media`.`mci_eventimages` AS `Eventimage` LEFT JOIN `mcimedia_media`.`mci_events` AS `Event` ON (`Eventimage`.`event_id` = `Event`.`id`) WHERE `Eventimage`.`isactive` = 1 AND `Eventimage`.`isblocked` = 0 AND `Eventimage`.`event_id` = 5 | | 2 | 2 | 0 |
8 | SELECT `Uploadfile`.`id`, `Uploadfile`.`event_id`, `Uploadfile`.`subpage_name`, `Uploadfile`.`name`, `Uploadfile`.`type`, `Uploadfile`.`file_name`, `U |