Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.version AS version_1,
  c0_.featured_image AS featured_image_2,
  c0_.media_url AS media_url_3,
  c0_.type AS type_4,
  c0_.template AS template_5,
  c0_.title AS title_6,
  c0_.slug AS slug_7,
  c0_.searchable AS searchable_8,
  c0_.exclude_from_list AS exclude_from_list_9,
  c0_.permission AS permission_10,
  c0_.status AS status_11,
  c0_.members_only AS members_only_12,
  c0_.include_author_byline AS include_author_byline_13,
  c0_.include_author_bio AS include_author_bio_14,
  c0_.include_customer_call_to_action AS include_customer_call_to_action_15,
  c0_.include_customer_bio AS include_customer_bio_16,
  c0_.total_impressions AS total_impressions_17,
  c0_.total_clicks AS total_clicks_18,
  c0_.published_at AS published_at_19,
  c0_.modified_at AS modified_at_20,
  c0_.created_at AS created_at_21,
  c0_.content_intro AS content_intro_22,
  c0_.content_full AS content_full_23,
  c0_.meta_description AS meta_description_24,
  c0_.meta_keywords AS meta_keywords_25,
  c0_.content_builder AS content_builder_26,
  c0_.show_title AS show_title_27,
  c0_.old_id AS old_id_28,
  c0_.featured AS featured_29,
  c0_.announcement AS announcement_30,
  c0_.announcement_sites AS announcement_sites_31,
  c0_.expires_at AS expires_at_32,
  c0_.hootsuite_content AS hootsuite_content_33,
  c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34,
  c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35,
  c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36,
  c0_.hootsuite_to_publish AS hootsuite_to_publish_37,
  c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38,
  c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39,
  c0_.hootsuite_published_at AS hootsuite_published_at_40,
  c0_.prnt_id AS prnt_id_41,
  c0_.media_id AS media_id_42,
  c0_.dummy_media_id AS dummy_media_id_43,
  c0_.video_media_id AS video_media_id_44,
  c0_.author_id AS author_id_45,
  c0_.category_id AS category_id_46,
  c0_.primary_customer_id AS primary_customer_id_47,
  c0_.form_id AS form_id_48,
  c0_.popout_ad_id AS popout_ad_id_49,
  c0_.hootsuite_media_id AS hootsuite_media_id_50
FROM
  content c0_
  INNER JOIN content_meta c1_ ON c0_.id = c1_.content_id
  AND (
    c1_.metakey = '_EventStartDate'
    AND c1_.metavalue <= ?
  )
  INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id
  AND (c2_.metakey = '_EventEndDate')
  LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id
  AND (c3_.metakey = '_IsEvent')
WHERE
  (
    c0_.status = 1
    AND (
      c0_.type = 7
      OR c3_.metavalue = 'yes'
    )
    AND c1_.metavalue <> ''
    AND c2_.metavalue <> ''
  )
  AND (
    c1_.metavalue < ?
    OR c0_.title < ?
  )
ORDER BY
  c1_.metavalue DESC,
  c0_.title DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_meta c1_ ON c0_.id = c1_.content_id AND (c1_.metakey = '_EventStartDate' AND c1_.metavalue <= '2021-04-07 08:00:00') INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id AND (c2_.metakey = '_EventEndDate') LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id AND (c3_.metakey = '_IsEvent') WHERE (c0_.status = 1 AND (c0_.type = 7 OR c3_.metavalue = 'yes') AND c1_.metavalue <> '' AND c2_.metavalue <> '') AND (c1_.metavalue < '2021-04-07 08:00:00' OR c0_.title < 'Virtual Qualified Trainer Conference') ORDER BY c1_.metavalue DESC, c0_.title DESC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.version AS version_1,
  c0_.featured_image AS featured_image_2,
  c0_.media_url AS media_url_3,
  c0_.type AS type_4,
  c0_.template AS template_5,
  c0_.title AS title_6,
  c0_.slug AS slug_7,
  c0_.searchable AS searchable_8,
  c0_.exclude_from_list AS exclude_from_list_9,
  c0_.permission AS permission_10,
  c0_.status AS status_11,
  c0_.members_only AS members_only_12,
  c0_.include_author_byline AS include_author_byline_13,
  c0_.include_author_bio AS include_author_bio_14,
  c0_.include_customer_call_to_action AS include_customer_call_to_action_15,
  c0_.include_customer_bio AS include_customer_bio_16,
  c0_.total_impressions AS total_impressions_17,
  c0_.total_clicks AS total_clicks_18,
  c0_.published_at AS published_at_19,
  c0_.modified_at AS modified_at_20,
  c0_.created_at AS created_at_21,
  c0_.content_intro AS content_intro_22,
  c0_.content_full AS content_full_23,
  c0_.meta_description AS meta_description_24,
  c0_.meta_keywords AS meta_keywords_25,
  c0_.content_builder AS content_builder_26,
  c0_.show_title AS show_title_27,
  c0_.old_id AS old_id_28,
  c0_.featured AS featured_29,
  c0_.announcement AS announcement_30,
  c0_.announcement_sites AS announcement_sites_31,
  c0_.expires_at AS expires_at_32,
  c0_.hootsuite_content AS hootsuite_content_33,
  c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34,
  c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35,
  c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36,
  c0_.hootsuite_to_publish AS hootsuite_to_publish_37,
  c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38,
  c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39,
  c0_.hootsuite_published_at AS hootsuite_published_at_40,
  c0_.prnt_id AS prnt_id_41,
  c0_.media_id AS media_id_42,
  c0_.dummy_media_id AS dummy_media_id_43,
  c0_.video_media_id AS video_media_id_44,
  c0_.author_id AS author_id_45,
  c0_.category_id AS category_id_46,
  c0_.primary_customer_id AS primary_customer_id_47,
  c0_.form_id AS form_id_48,
  c0_.popout_ad_id AS popout_ad_id_49,
  c0_.hootsuite_media_id AS hootsuite_media_id_50
FROM
  content c0_
  INNER JOIN content_meta c1_ ON c0_.id = c1_.content_id
  AND (
    c1_.metakey = '_EventStartDate'
    AND c1_.metavalue >= ?
  )
  INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id
  AND (c2_.metakey = '_EventEndDate')
  LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id
  AND (c3_.metakey = '_IsEvent')
WHERE
  (
    c0_.status = 1
    AND (
      c0_.type = 7
      OR c3_.metavalue = 'yes'
    )
    AND c1_.metavalue <> ''
    AND c2_.metavalue <> ''
  )
  AND (
    c1_.metavalue > ?
    OR c0_.title > ?
  )
ORDER BY
  c1_.metavalue ASC,
  c0_.title ASC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_meta c1_ ON c0_.id = c1_.content_id AND (c1_.metakey = '_EventStartDate' AND c1_.metavalue >= '2021-04-07 08:00:00') INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id AND (c2_.metakey = '_EventEndDate') LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id AND (c3_.metakey = '_IsEvent') WHERE (c0_.status = 1 AND (c0_.type = 7 OR c3_.metavalue = 'yes') AND c1_.metavalue <> '' AND c2_.metavalue <> '') AND (c1_.metavalue > '2021-04-07 08:00:00' OR c0_.title > 'Virtual Qualified Trainer Conference') ORDER BY c1_.metavalue ASC, c0_.title ASC LIMIT 1;

"COMMIT"

"COMMIT";

INSERT INTO content_impression (
  site_id, requested_at, hash, content_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO content_impression (site_id, requested_at, hash, content_id) VALUES (1, '2024-07-25 08:06:17', '42a61e3425cfec70a83e3324d37a40e6', '110983');

SELECT
  m0_.id AS id_0,
  m0_.version AS version_1,
  m0_.title AS title_2,
  m0_.display_title AS display_title_3,
  m0_.description AS description_4,
  m0_.sort AS sort_5,
  m0_.modified_at AS modified_at_6,
  m0_.created_at AS created_at_7,
  m0_.published_at AS published_at_8,
  m0_.expires_at AS expires_at_9,
  m0_.status AS status_10,
  m0_.total_impressions AS total_impressions_11,
  m0_.total_clicks AS total_clicks_12,
  m0_.attributes AS attributes_13,
  m0_.external_url AS external_url_14,
  m0_.youtube_url AS youtube_url_15,
  m0_.french_url AS french_url_16,
  m0_.spanish_url AS spanish_url_17,
  m0_.countdown AS countdown_18,
  m0_.question_slider AS question_slider_19,
  m0_.site_default AS site_default_20,
  m0_.pinned_uuid AS pinned_uuid_21,
  m0_.media_id AS media_id_22,
  m0_.secondary_media_id AS secondary_media_id_23,
  m0_.french_media_id AS french_media_id_24,
  m0_.spanish_media_id AS spanish_media_id_25,
  m0_.media_group_id AS media_group_id_26,
  m0_.gallery_id AS gallery_id_27,
  m0_.pop_out_poll_id AS pop_out_poll_id_28
FROM
  media_group_item m0_
  INNER JOIN media_group m1_ ON m0_.media_group_id = m1_.id
  AND (m1_.position = 'ad-sidebar')
  INNER JOIN ad_site a3_ ON m0_.id = a3_.media_group_item_id
  INNER JOIN site s2_ ON s2_.id = a3_.site_id
  AND (s2_.id = ?)
  INNER JOIN ad_pin a4_ ON m0_.id = a4_.media_group_item_id
  AND (a4_.site_id = ?)
  INNER JOIN mega_menu m5_ ON (
    m5_.uuid = a4_.mega_menu_uuid
    AND m5_.status = 1
  )
  LEFT JOIN mega_menu m6_ ON (
    m6_.parent = m5_.uuid
    AND m6_.status = 1
  )
  LEFT JOIN mega_menu m7_ ON (
    m7_.parent = m6_.uuid
    AND m7_.status = 1
  )
WHERE
  m0_.status = 1
  AND (
    m5_.link = ?
    OR m6_.link = ?
    OR m7_.link = ?
    OR m5_.link = ?
    OR m6_.link = ?
    OR m7_.link = ?
  )
ORDER BY
  m5_.position ASC,
  m6_.position ASC,
  m7_.position ASC,
  m0_.published_at DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.version AS version_1, m0_.title AS title_2, m0_.display_title AS display_title_3, m0_.description AS description_4, m0_.sort AS sort_5, m0_.modified_at AS modified_at_6, m0_.created_at AS created_at_7, m0_.published_at AS published_at_8, m0_.expires_at AS expires_at_9, m0_.status AS status_10, m0_.total_impressions AS total_impressions_11, m0_.total_clicks AS total_clicks_12, m0_.attributes AS attributes_13, m0_.external_url AS external_url_14, m0_.youtube_url AS youtube_url_15, m0_.french_url AS french_url_16, m0_.spanish_url AS spanish_url_17, m0_.countdown AS countdown_18, m0_.question_slider AS question_slider_19, m0_.site_default AS site_default_20, m0_.pinned_uuid AS pinned_uuid_21, m0_.media_id AS media_id_22, m0_.secondary_media_id AS secondary_media_id_23, m0_.french_media_id AS french_media_id_24, m0_.spanish_media_id AS spanish_media_id_25, m0_.media_group_id AS media_group_id_26, m0_.gallery_id AS gallery_id_27, m0_.pop_out_poll_id AS pop_out_poll_id_28 FROM media_group_item m0_ INNER JOIN media_group m1_ ON m0_.media_group_id = m1_.id AND (m1_.position = 'ad-sidebar') INNER JOIN ad_site a3_ ON m0_.id = a3_.media_group_item_id INNER JOIN site s2_ ON s2_.id = a3_.site_id AND (s2_.id = 1) INNER JOIN ad_pin a4_ ON m0_.id = a4_.media_group_item_id AND (a4_.site_id = 1) INNER JOIN mega_menu m5_ ON (m5_.uuid = a4_.mega_menu_uuid AND m5_.status = 1) LEFT JOIN mega_menu m6_ ON (m6_.parent = m5_.uuid AND m6_.status = 1) LEFT JOIN mega_menu m7_ ON (m7_.parent = m6_.uuid AND m7_.status = 1) WHERE m0_.status = 1 AND (m5_.link = 'https://staging.rooferscoffeeshop.com/events' OR m6_.link = 'https://staging.rooferscoffeeshop.com/events' OR m7_.link = 'https://staging.rooferscoffeeshop.com/events' OR m5_.link = 'https://staging.rooferscoffeeshop.com/events/' OR m6_.link = 'https://staging.rooferscoffeeshop.com/events/' OR m7_.link = 'https://staging.rooferscoffeeshop.com/events/') ORDER BY m5_.position ASC, m6_.position ASC, m7_.position ASC, m0_.published_at DESC LIMIT 1;

INSERT INTO content_view (
  site_id, requested_at, hash, content_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO content_view (site_id, requested_at, hash, content_id) VALUES (1, '2024-07-25 08:06:16', '9b5539df984c69f4ed7aa20a0e272cda', '110983');

INSERT INTO traffic_data (
  hash, user_token, user_ip, user_ua,
  user_refer, user_this_path, user_this_route,
  user_this_route_params, user_last_path,
  user_last_route, user_last_route_params,
  user_request_data, requested_at,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO traffic_data (hash, user_token, user_ip, user_ua, user_refer, user_this_path, user_this_route, user_this_route_params, user_last_path, user_last_route, user_last_route_params, user_request_data, requested_at, user_id) VALUES ('9b5539df984c69f4ed7aa20a0e272cda', 'fe38f8d000d0e67fc910907cb2de24e8a79a9decd84c24e0f46e7fee31cb156f', '3.145.73.79', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '/event/virtual-qualified-trainer-conference-4', 'event_master', '{\"slug\":\"virtual-qualified-trainer-conference-4\"}', '', '', '\"\"', '[]', '2024-07-25 08:06:16', NULL);

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.title AS title_3,
  t0.display_title AS display_title_4,
  t0.description AS description_5,
  t0.sort AS sort_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8,
  t0.published_at AS published_at_9,
  t0.expires_at AS expires_at_10,
  t0.status AS status_11,
  t0.total_impressions AS total_impressions_12,
  t0.total_clicks AS total_clicks_13,
  t0.attributes AS attributes_14,
  t0.external_url AS external_url_15,
  t0.youtube_url AS youtube_url_16,
  t0.french_url AS french_url_17,
  t0.spanish_url AS spanish_url_18,
  t0.countdown AS countdown_19,
  t0.question_slider AS question_slider_20,
  t0.site_default AS site_default_21,
  t0.pinned_uuid AS pinned_uuid_22,
  t0.media_id AS media_id_23,
  t0.secondary_media_id AS secondary_media_id_24,
  t0.french_media_id AS french_media_id_25,
  t0.spanish_media_id AS spanish_media_id_26,
  t0.media_group_id AS media_group_id_27,
  t0.gallery_id AS gallery_id_28,
  t29.id AS id_30,
  t29.version AS version_31,
  t29.title AS title_32,
  t29.description AS description_33,
  t29.published_at AS published_at_34,
  t29.modified_at AS modified_at_35,
  t29.created_at AS created_at_36,
  t29.response_close_date AS response_close_date_37,
  t29.expires_at AS expires_at_38,
  t29.status AS status_39,
  t29.info_url AS info_url_40,
  t29.total_impressions AS total_impressions_41,
  t29.requires_login AS requires_login_42,
  t29.type AS type_43,
  t29.media_id AS media_id_44,
  t29.ad_id AS ad_id_45,
  t0.pop_out_poll_id AS pop_out_poll_id_46
FROM
  media_group_item t0
  LEFT JOIN poll t29 ON t29.ad_id = t0.id
WHERE
  (
    t0.status = ?
    AND t0.media_group_id = ?
  )
ORDER BY
  t0.published_at ASC

SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.display_title AS display_title_4, t0.description AS description_5, t0.sort AS sort_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.published_at AS published_at_9, t0.expires_at AS expires_at_10, t0.status AS status_11, t0.total_impressions AS total_impressions_12, t0.total_clicks AS total_clicks_13, t0.attributes AS attributes_14, t0.external_url AS external_url_15, t0.youtube_url AS youtube_url_16, t0.french_url AS french_url_17, t0.spanish_url AS spanish_url_18, t0.countdown AS countdown_19, t0.question_slider AS question_slider_20, t0.site_default AS site_default_21, t0.pinned_uuid AS pinned_uuid_22, t0.media_id AS media_id_23, t0.secondary_media_id AS secondary_media_id_24, t0.french_media_id AS french_media_id_25, t0.spanish_media_id AS spanish_media_id_26, t0.media_group_id AS media_group_id_27, t0.gallery_id AS gallery_id_28, t29.id AS id_30, t29.version AS version_31, t29.title AS title_32, t29.description AS description_33, t29.published_at AS published_at_34, t29.modified_at AS modified_at_35, t29.created_at AS created_at_36, t29.response_close_date AS response_close_date_37, t29.expires_at AS expires_at_38, t29.status AS status_39, t29.info_url AS info_url_40, t29.total_impressions AS total_impressions_41, t29.requires_login AS requires_login_42, t29.type AS type_43, t29.media_id AS media_id_44, t29.ad_id AS ad_id_45, t0.pop_out_poll_id AS pop_out_poll_id_46 FROM media_group_item t0 LEFT JOIN poll t29 ON t29.ad_id = t0.id WHERE (t0.status = '1' AND t0.media_group_id = '888') ORDER BY t0.published_at ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.modified_at AS modified_at_4,
  t0.created_at AS created_at_5,
  t0.status AS status_6,
  t0.attributes AS attributes_7,
  t0.sort_type AS sort_type_8,
  t0.display_limit AS display_limit_9,
  t0.position AS position_10,
  t0.type AS type_11,
  t12.id AS id_13,
  t12.version AS version_14,
  t12.title AS title_15,
  t12.description AS description_16,
  t12.call_to_action AS call_to_action_17,
  t12.bio AS bio_18,
  t12.modified_at AS modified_at_19,
  t12.created_at AS created_at_20,
  t12.status AS status_21,
  t12.email AS email_22,
  t12.external_request_more AS external_request_more_23,
  t12.website AS website_24,
  t12.facebook AS facebook_25,
  t12.twitter AS twitter_26,
  t12.linkedin AS linkedin_27,
  t12.instagram AS instagram_28,
  t12.tiktok AS tiktok_29,
  t12.youtube AS youtube_30,
  t12.hash_tag AS hash_tag_31,
  t12.location AS location_32,
  t12.state AS state_33,
  t12.keywords AS keywords_34,
  t12.customer_level AS customer_level_35,
  t12.customer_type AS customer_type_36,
  t12.type_work AS type_work_37,
  t12.show_photos AS show_photos_38,
  t12.prnt_id AS prnt_id_39,
  t12.literature_id AS literature_id_40,
  t12.photo_gallery_id AS photo_gallery_id_41,
  t12.video_gallery_id AS video_gallery_id_42,
  t12.logo_id AS logo_id_43,
  t12.media_id AS media_id_44,
  t12.dummy_media_id AS dummy_media_id_45,
  t12.blog_id AS blog_id_46,
  t12.branch_locator_id AS branch_locator_id_47,
  t12.external_events_id AS external_events_id_48,
  t12.newsletters_id AS newsletters_id_49,
  t12.partners_reps_id AS partners_reps_id_50,
  t12.rep_lines_id AS rep_lines_id_51,
  t12.directory_content_id AS directory_content_id_52,
  t53.id AS id_54,
  t53.version AS version_55,
  t53.title AS title_56,
  t53.description AS description_57,
  t53.call_to_action AS call_to_action_58,
  t53.bio AS bio_59,
  t53.modified_at AS modified_at_60,
  t53.created_at AS created_at_61,
  t53.status AS status_62,
  t53.email AS email_63,
  t53.external_request_more AS external_request_more_64,
  t53.website AS website_65,
  t53.facebook AS facebook_66,
  t53.twitter AS twitter_67,
  t53.linkedin AS linkedin_68,
  t53.instagram AS instagram_69,
  t53.tiktok AS tiktok_70,
  t53.youtube AS youtube_71,
  t53.hash_tag AS hash_tag_72,
  t53.location AS location_73,
  t53.state AS state_74,
  t53.keywords AS keywords_75,
  t53.customer_level AS customer_level_76,
  t53.customer_type AS customer_type_77,
  t53.type_work AS type_work_78,
  t53.show_photos AS show_photos_79,
  t53.prnt_id AS prnt_id_80,
  t53.literature_id AS literature_id_81,
  t53.photo_gallery_id AS photo_gallery_id_82,
  t53.video_gallery_id AS video_gallery_id_83,
  t53.logo_id AS logo_id_84,
  t53.media_id AS media_id_85,
  t53.dummy_media_id AS dummy_media_id_86,
  t53.blog_id AS blog_id_87,
  t53.branch_locator_id AS branch_locator_id_88,
  t53.external_events_id AS external_events_id_89,
  t53.newsletters_id AS newsletters_id_90,
  t53.partners_reps_id AS partners_reps_id_91,
  t53.rep_lines_id AS rep_lines_id_92,
  t53.directory_content_id AS directory_content_id_93,
  t94.id AS id_95,
  t94.version AS version_96,
  t94.title AS title_97,
  t94.description AS description_98,
  t94.call_to_action AS call_to_action_99,
  t94.bio AS bio_100,
  t94.modified_at AS modified_at_101,
  t94.created_at AS created_at_102,
  t94.status AS status_103,
  t94.email AS email_104,
  t94.external_request_more AS external_request_more_105,
  t94.website AS website_106,
  t94.facebook AS facebook_107,
  t94.twitter AS twitter_108,
  t94.linkedin AS linkedin_109,
  t94.instagram AS instagram_110,
  t94.tiktok AS tiktok_111,
  t94.youtube AS youtube_112,
  t94.hash_tag AS hash_tag_113,
  t94.location AS location_114,
  t94.state AS state_115,
  t94.keywords AS keywords_116,
  t94.customer_level AS customer_level_117,
  t94.customer_type AS customer_type_118,
  t94.type_work AS type_work_119,
  t94.show_photos AS show_photos_120,
  t94.prnt_id AS prnt_id_121,
  t94.literature_id AS literature_id_122,
  t94.photo_gallery_id AS photo_gallery_id_123,
  t94.video_gallery_id AS video_gallery_id_124,
  t94.logo_id AS logo_id_125,
  t94.media_id AS media_id_126,
  t94.dummy_media_id AS dummy_media_id_127,
  t94.blog_id AS blog_id_128,
  t94.branch_locator_id AS branch_locator_id_129,
  t94.external_events_id AS external_events_id_130,
  t94.newsletters_id AS newsletters_id_131,
  t94.partners_reps_id AS partners_reps_id_132,
  t94.rep_lines_id AS rep_lines_id_133,
  t94.directory_content_id AS directory_content_id_134
FROM
  media_group t0
  LEFT JOIN customer t12 ON t12.literature_id = t0.id
  LEFT JOIN customer t53 ON t53.photo_gallery_id = t0.id
  LEFT JOIN customer t94 ON t94.video_gallery_id = t0.id
WHERE
  t0.position = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.modified_at AS modified_at_4, t0.created_at AS created_at_5, t0.status AS status_6, t0.attributes AS attributes_7, t0.sort_type AS sort_type_8, t0.display_limit AS display_limit_9, t0.position AS position_10, t0.type AS type_11, t12.id AS id_13, t12.version AS version_14, t12.title AS title_15, t12.description AS description_16, t12.call_to_action AS call_to_action_17, t12.bio AS bio_18, t12.modified_at AS modified_at_19, t12.created_at AS created_at_20, t12.status AS status_21, t12.email AS email_22, t12.external_request_more AS external_request_more_23, t12.website AS website_24, t12.facebook AS facebook_25, t12.twitter AS twitter_26, t12.linkedin AS linkedin_27, t12.instagram AS instagram_28, t12.tiktok AS tiktok_29, t12.youtube AS youtube_30, t12.hash_tag AS hash_tag_31, t12.location AS location_32, t12.state AS state_33, t12.keywords AS keywords_34, t12.customer_level AS customer_level_35, t12.customer_type AS customer_type_36, t12.type_work AS type_work_37, t12.show_photos AS show_photos_38, t12.prnt_id AS prnt_id_39, t12.literature_id AS literature_id_40, t12.photo_gallery_id AS photo_gallery_id_41, t12.video_gallery_id AS video_gallery_id_42, t12.logo_id AS logo_id_43, t12.media_id AS media_id_44, t12.dummy_media_id AS dummy_media_id_45, t12.blog_id AS blog_id_46, t12.branch_locator_id AS branch_locator_id_47, t12.external_events_id AS external_events_id_48, t12.newsletters_id AS newsletters_id_49, t12.partners_reps_id AS partners_reps_id_50, t12.rep_lines_id AS rep_lines_id_51, t12.directory_content_id AS directory_content_id_52, t53.id AS id_54, t53.version AS version_55, t53.title AS title_56, t53.description AS description_57, t53.call_to_action AS call_to_action_58, t53.bio AS bio_59, t53.modified_at AS modified_at_60, t53.created_at AS created_at_61, t53.status AS status_62, t53.email AS email_63, t53.external_request_more AS external_request_more_64, t53.website AS website_65, t53.facebook AS facebook_66, t53.twitter AS twitter_67, t53.linkedin AS linkedin_68, t53.instagram AS instagram_69, t53.tiktok AS tiktok_70, t53.youtube AS youtube_71, t53.hash_tag AS hash_tag_72, t53.location AS location_73, t53.state AS state_74, t53.keywords AS keywords_75, t53.customer_level AS customer_level_76, t53.customer_type AS customer_type_77, t53.type_work AS type_work_78, t53.show_photos AS show_photos_79, t53.prnt_id AS prnt_id_80, t53.literature_id AS literature_id_81, t53.photo_gallery_id AS photo_gallery_id_82, t53.video_gallery_id AS video_gallery_id_83, t53.logo_id AS logo_id_84, t53.media_id AS media_id_85, t53.dummy_media_id AS dummy_media_id_86, t53.blog_id AS blog_id_87, t53.branch_locator_id AS branch_locator_id_88, t53.external_events_id AS external_events_id_89, t53.newsletters_id AS newsletters_id_90, t53.partners_reps_id AS partners_reps_id_91, t53.rep_lines_id AS rep_lines_id_92, t53.directory_content_id AS directory_content_id_93, t94.id AS id_95, t94.version AS version_96, t94.title AS title_97, t94.description AS description_98, t94.call_to_action AS call_to_action_99, t94.bio AS bio_100, t94.modified_at AS modified_at_101, t94.created_at AS created_at_102, t94.status AS status_103, t94.email AS email_104, t94.external_request_more AS external_request_more_105, t94.website AS website_106, t94.facebook AS facebook_107, t94.twitter AS twitter_108, t94.linkedin AS linkedin_109, t94.instagram AS instagram_110, t94.tiktok AS tiktok_111, t94.youtube AS youtube_112, t94.hash_tag AS hash_tag_113, t94.location AS location_114, t94.state AS state_115, t94.keywords AS keywords_116, t94.customer_level AS customer_level_117, t94.customer_type AS customer_type_118, t94.type_work AS type_work_119, t94.show_photos AS show_photos_120, t94.prnt_id AS prnt_id_121, t94.literature_id AS literature_id_122, t94.photo_gallery_id AS photo_gallery_id_123, t94.video_gallery_id AS video_gallery_id_124, t94.logo_id AS logo_id_125, t94.media_id AS media_id_126, t94.dummy_media_id AS dummy_media_id_127, t94.blog_id AS blog_id_128, t94.branch_locator_id AS branch_locator_id_129, t94.external_events_id AS external_events_id_130, t94.newsletters_id AS newsletters_id_131, t94.partners_reps_id AS partners_reps_id_132, t94.rep_lines_id AS rep_lines_id_133, t94.directory_content_id AS directory_content_id_134 FROM media_group t0 LEFT JOIN customer t12 ON t12.literature_id = t0.id LEFT JOIN customer t53 ON t53.photo_gallery_id = t0.id LEFT JOIN customer t94 ON t94.video_gallery_id = t0.id WHERE t0.position = 'header-countdown' LIMIT 1;