Database
Queries: 23 (0.0224)
0.0006 (7)
SELECT URL.target_name AS TargetName, URL.path AS Path FROM DM_URLs URL WHERE URL.target_type = 'entity' AND ( URL.target_name = 'MemberHomePage' OR URL.target_name = 'MemberProfilePage' OR URL.target_name = 'MemberSignInPage' OR URL.target_name = 'MemberSignUpPage' OR URL.target_name = 'MemberActivatePage' OR URL.target_name = 'MemberResetPasswordPage' OR URL.target_name = 'MemberForgotPasswordPage');
0.0007 (0)
SELECT URL.url_id, PP.tags FROM GRI_ProgrammaticPages PP JOIN Web_Pages Page ON Page.title = PP.template JOIN Web_PagesURLs URL ON URL.page_id = Page.page_id AND URL.is_default = 1 WHERE PP.path = 'travel-insurance-plans/trip-cancellation-plans' AND PP.is_active = 1;
0.0004 (1)
SELECT URL.url_id AS URLId, URL.path AS Path, URL.target_type AS TargetType, URL.target_name AS TargetName FROM DM_URLs URL WHERE URL.path = 'travel-insurance-plans/trip-cancellation-plans';
0.0005 (1)
SELECT URL.url_id AS "Id", PageURL.page_id AS "PageId", PageURL.path AS "Path", URL.path AS "FullPath", URL.target_type AS "TargetType", URL.target_name AS "TargetName", PageURL.is_default AS "Default", UNIX_TIMESTAMP(PageURL.modified) AS "Modified", URL.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageURL.created) AS "Created", URL.created_by AS "CreatedBy", URL.cue_source AS "CueSource", URL.cue_source_id AS "CueSourceId", URL.cue_ver AS "CueVersion" FROM DM_URLs URL JOIN Web_PagesURLs PageURL ON PageURL.url_id = URL.url_id WHERE URL.url_id = '36';
0.0008 (1)
SELECT Page.page_id AS "Id", Page.entity AS "Entity", Page.title AS "Title", Page.subtitle AS "Subtitle", Page.title_tag AS "TitleTag", Page.body_class AS "BodyClass", Page.meta_description AS "MetaDescription", Page.meta_robots AS "MetaRobots", Page.canonical_url AS "CanonicalURL", Page.body AS "Body", Page.excerpt AS "Excerpt", Page.search_public_keywords AS "PublicSearchKeywords", Page.javascript AS "JavaScript", Page.stylesheet AS "StyleSheet", Page.hide_page_title AS "HidePageTitle", Page.exclude_sitemap AS "ExcludeSitemap", Page.exclude_widgets AS "ExcludeWidgets", Page.exclude_search AS "ExcludeSearch", Page.require_ssl AS "RequireSSL", Page.require_signin AS "RequireSignIn", Page.can_cache AS "CanCache", Page.is_system_page AS "IsSystemPage", Page.sort_order AS "SortOrder", Page.image_id AS "Image", Page.author_id AS "Author", Page.status_id AS "Status", UNIX_TIMESTAMP(Page.status_date) AS "StatusDate", Page.channel_id AS "Channel", DefaultLayout.layout_code AS "DefaultLayout", DefaultURL.url_id AS "DefaultURLId", DefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL", LOWER(CONCAT('Page/', Page.page_id)) AS "Permalink", UNIX_TIMESTAMP(Page.modified) AS "Modified", Page.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Page.created) AS "Created", Page.created_by AS "CreatedBy", Page.cue_source AS "CueSource", Page.cue_source_id AS "CueSourceId", Page.cue_ver AS "CueVersion" FROM Web_Pages Page LEFT JOIN Web_PagesLayouts DefaultLayout ON DefaultLayout.page_id = Page.page_id AND DefaultLayout.is_default = 1 LEFT JOIN Web_PagesURLs DefaultURL ON DefaultURL.page_id = Page.page_id AND DefaultURL.is_default = 1 LEFT JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = DefaultURL.url_id LEFT JOIN DM_Statuses Status ON Status.status_id = Page.status_id WHERE Page.page_id = 34 AND Status.is_public = true AND UNIX_TIMESTAMP(Page.status_date) <= 1758141829;
0.0063 (16)
SELECT DISTINCT Widget.widget_id AS "Id", Widget.widget_code AS "Code", Widget.admin_title AS "Title", Widget.default_region AS "DefaultRegion", Widget.properties AS "Properties", UNIX_TIMESTAMP(Widget.effective_on) AS "EffectiveOn", UNIX_TIMESTAMP(Widget.expires_on) AS "ExpiresOn", Widget.show_not_signed_in AS "ShowNotSignedIn", Widget.show_signed_in AS "ShowSignedIn", Widget.can_cache AS "CanCache", Widget.is_active AS "Active", UNIX_TIMESTAMP(Widget.modified) AS "Modified", Widget.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(Widget.created) AS "Created", Widget.created_by AS "CreatedBy.Id", Widget.cue_source AS "CueSource", Widget.cue_source_id AS "CueSourceId", Widget.cue_ver AS "CueVersion", WidgetPage.region AS "Region" FROM Web_WidgetsPages WidgetPage JOIN Web_Widgets Widget ON Widget.widget_id = WidgetPage.widget_id WHERE ( Widget.widget_id IN (SELECT widget_id FROM Web_WidgetsChannels WHERE channel_id = '0') OR Widget.widget_id IN (SELECT widget_id FROM Web_WidgetsEntities WHERE entity_name = 'Page') OR WidgetPage.page_id = '34' ) AND ( Widget.widget_id NOT IN (SELECT widget_id FROM Web_WidgetsPages WHERE page_id = '34' AND excluded = 1) ) ORDER BY WidgetPage.sort_order ASC;
SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '1281846';
SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '3';
SELECT ChannelLite.page_id AS "Id", ChannelLite.channel_id AS "ChannelId", ChannelLite.title AS "Title", webGetPageHierarchy(Channel.page_id, 'title') AS "FullTitle", ChannelStatus.is_public AS "Public", ChannelDefaultURL.path AS "DefaultURL", DefaultFullURL.path AS "DefaultFullURL", Channel.page_entity AS "PageEntity", Channel.default_page_layout AS "DefaultPageLayout", Channel.sort_property AS "SortProperty", Channel.pages_per_index AS "PagesPerIndex", Channel.show_full_content AS "ShowFullContent", Channel.words_per_excerpt AS "WordsPerExcerpt", CONCAT_WS('/', MediaFile.path, ImageFile.thumbnail_filename) AS "ImageThumbnailURL", CONCAT_WS('/', MediaFile.path, ImageFile.small_filename) AS "ImageSmallURL", CONCAT_WS('/', MediaFile.path, ImageFile.medium_filename) AS "ImageMediumURL", CONCAT_WS('/', MediaFile.path, ImageFile.large_filename) AS "ImageLargeURL" FROM Web_Pages ChannelLite JOIN DM_Statuses ChannelStatus ON ChannelStatus.status_id = ChannelLite.status_id LEFT JOIN Web_PagesURLs ChannelDefaultURL ON ChannelDefaultURL.page_id = ChannelLite.page_id AND ChannelDefaultURL.is_default = 1 LEFT JOIN DM_URLs DefaultFullURL ON DefaultFullURL.url_id = ChannelDefaultURL.url_id JOIN Web_Channels Channel ON Channel.page_id = ChannelLite.page_id LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = ChannelLite.image_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = ChannelLite.image_id WHERE ChannelLite.page_id = '0';
SELECT PageCategory.page_category_id AS "Id", PageCategory.page_id AS "PageId", PageCategory.taxonomy_id AS "TaxonomyId", Taxonomy.label AS "Label", Taxonomy.description AS "Description", UNIX_TIMESTAMP(PageCategory.modified) AS "Modified", PageCategory.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageCategory.created) AS "Created", PageCategory.created_by AS "CreatedBy", PageCategory.cue_source AS "CueSource", PageCategory.cue_source_id AS "CueSourceId", PageCategory.cue_ver AS "CueVersion" FROM Web_PagesCategories PageCategory JOIN DM_Taxonomies Taxonomy ON Taxonomy.taxonomy_id = PageCategory.taxonomy_id WHERE PageCategory.page_id = 34 ORDER BY Taxonomy.label ASC;
SELECT PageImage.page_image_id AS "Id", PageImage.page_id AS "PageId", PageImage.media_file_id AS "MediaFileId", PageImage.tag_id AS "TagId", PageImage.tag_class AS "TagClass", PageImage.sort_order AS "SortOrder", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.mime_type AS "MimeType", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(PageImage.modified) AS "Modified", PageImage.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageImage.created) AS "Created", PageImage.created_by AS "CreatedBy", PageImage.cue_source AS "CueSource", PageImage.cue_source_id AS "CueSourceId", PageImage.cue_ver AS "CueVersion" FROM Web_PagesImages PageImage LEFT JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = PageImage.media_file_id LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = PageImage.media_file_id WHERE PageImage.page_id = 34 ORDER BY PageImage.sort_order ASC;
SELECT PageTag.page_tag_id AS "Id", PageTag.page_id AS "PageId", PageTag.taxonomy_id AS "TaxonomyId", Taxonomy.label AS "Label", Taxonomy.description AS "Description", UNIX_TIMESTAMP(PageTag.modified) AS "Modified", PageTag.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageTag.created) AS "Created", PageTag.created_by AS "CreatedBy", PageTag.cue_source AS "CueSource", PageTag.cue_source_id AS "CueSourceId", PageTag.cue_ver AS "CueVersion" FROM Web_PagesTags PageTag JOIN DM_Taxonomies Taxonomy ON Taxonomy.taxonomy_id = PageTag.taxonomy_id WHERE PageTag.page_id = 34 ORDER BY Taxonomy.label ASC;
SELECT URL.url_id AS "Id", PageURL.page_id AS "PageId", PageURL.path AS "Path", URL.path AS "FullPath", URL.target_type AS "TargetType", URL.target_name AS "TargetName", PageURL.is_default AS "Default", UNIX_TIMESTAMP(PageURL.modified) AS "Modified", URL.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(PageURL.created) AS "Created", URL.created_by AS "CreatedBy", URL.cue_source AS "CueSource", URL.cue_source_id AS "CueSourceId", URL.cue_ver AS "CueVersion" FROM DM_URLs URL JOIN Web_PagesURLs PageURL ON PageURL.url_id = URL.url_id WHERE PageURL.page_id = 34 ORDER BY PageURL.is_default DESC;
0.0004 (1)
SELECT policy_type FROM April_Products WHERE product_code = '4GRTCCW';
0.0027 (7)
SELECT OptionPackage.product_option_package_id AS `PackageId`, CoverageType.title AS `CoverageType`, Coverage.title AS `CoverageTitle`, OptionPackage.option_type AS `OptionType`, SUM(OptionPackage.cfar_included) AS `CFARIncluded`, Coverage.description AS `CoverageDescription`, OptionPackagesCoverage.suppress_if_no_event_cost AS `CoverageSuppressIfNoEventCost`, Product.cfar_purchase_days AS `CFARPurchaseDays`, OptionPackage.max_event_cost AS `MaxEventCost`, OptionPackage.max_event_days AS `MaxEventDays`, OptionPackage.cutoff_purchase_days AS `CutoffPurchaseDays`, OptionPackage.suppress_if_no_event_cost AS `OptionSuppressIfNoEventCost`, IF(OptionPackagesCoverage.use_default_limit, Coverage.default_limit, OptionPackagesCoverage.coverage_limit) AS "Limit" FROM April_ProductsOptionPackagesCoverages OptionPackagesCoverage JOIN April_ProductsOptionPackages OptionPackage ON OptionPackagesCoverage.product_option_package_id = OptionPackage.product_option_package_id JOIN April_Coverages Coverage ON OptionPackagesCoverage.coverage_id = Coverage.coverage_id JOIN April_CoverageTypes CoverageType ON Coverage.coverage_type_id = CoverageType.coverage_type_id JOIN April_Products Product ON OptionPackage.product_id = Product.product_id WHERE Product.product_code = '4GRTCCW' AND OptionPackage.option_type IN ('Base','Upgrade','Add-on') GROUP BY Coverage.title, OptionPackage.product_id, OptionPackage.option_type ORDER BY CoverageType.sort_order , Coverage.sort_order , Coverage.title , OptionPackage.option_type;
0.0012 (1)
SELECT Product.product_id AS "Id", Product.product_code AS "ProductCode", Product.product_family AS "ProductFamily", Product.report_group_code AS "ReportGroupCode", Product.title AS "Title", Product.description AS "Description", Product.policy_type AS "PolicyType", Product.pricing_method AS "PricingMethod", Product.price_value AS "PriceValue", Product.family_plan_included AS "FamilyPlanIncluded", Product.cfar_included AS "CFARIncluded", Product.schengen_visa_compliant AS "SchengenVisaCompliant", Product.use_proof_of_coverage_letter AS "UseProofOfCoverageLetter", Product.terms_and_conditions_file_id AS "TermsAndConditionsFileId", TermsFile.target_file AS "TermsAndConditionsFile", TermsFile.filename AS "TermsAndConditionsFileName", CONCAT(TermsFile.path, TermsFile.target_file) AS "TermsAndConditionsFileURL", Product.terms_and_conditions_alt1_file_id AS "TermsAndConditionsAlt1FileId", TermsFileAlt1.target_file AS "TermsAndConditionsAlt1File", TermsFileAlt1.filename AS "TermsAndConditionsAlt1FileName", CONCAT(TermsFileAlt1.path, TermsFileAlt1.target_file) AS "TermsAndConditionsAlt1FileURL", Product.free_look_days AS "FreeLookDays", Product.cfar_purchase_days AS "CFARPurchaseDays", Product.cfar_insure_trip_cost_days AS "CFARInsureTripCostDays", Product.cfar_cancellation_notice_hours AS "CFARCancellationNoticeHours", Product.preexisting_waiver AS "PreExistingWaiver", Product.preexisting_waiver_value AS "PreExistingWaiverValue", Product.preexisting_waiver_type AS "PreExistingWaiverType", Product.preexisting_waiver_lookback AS "PreExistingWaiverLookBack", Product.claim_filing_sol_days AS "ClaimFilingSOLDays", Product.lock_days AS "LockDays", Product.max_child_age AS "MaxChildAge", Product.max_eligible_age AS "MaxEligibleAge", Product.max_event_days AS "MaxEventDays", Product.event_day_surcharge_threshold AS "EventDaySurchargeThreshold", Product.event_day_surcharge AS "EventDaySurcharge", Product.max_event_cost AS "MaxEventCost", Product.max_event_cost_insured AS "MaxEventCostPerInsured", Product.event_cost_surcharge_threshold AS "EventCostSurchargeThreshold", Product.event_cost_surcharge AS "EventCostSurcharge", Product.cutoff_purchase_days AS "PurchaseCutoffDays", Product.max_event_date_months AS "MaxEventDateMonths", Product.min_insured_premium AS "MinInsuredPremium", Product.underwriter_id AS "UnderwriterId", Underwriter.company_name AS "UnderwriterName", Underwriter.underwriter_code AS "UnderwriterCode", Product.underwriter_product_code AS "UnderwriterProductCode", Underwriter.payment_gateway AS "UnderwriterPaymentGateway", Underwriter.payment_settings_key AS "UnderwriterPaymentSettingsKey", Underwriter.policy_number_format AS "UnderwriterPolicyNoFormat", Underwriter.policy_number_counter AS "UnderwriterPolicyNoCounter", Product.underwriter_fee_type AS "UnderwriterFeeType", Product.underwriter_fee_value AS "UnderwriterFeeValue", Product.claims_administrator_fee_type AS "ClaimsAdministratorFeeType", Product.claims_administrator_fee_value AS "ClaimsAdministratorFeeValue", Product.partner_commission_type AS "PartnerCommissionType", Product.partner_commission_value AS "PartnerCommissionValue", Product.broker1_commission_type AS "Broker1CommissionType", Product.broker1_commission_value AS "Broker1CommissionValue", Product.broker2_commission_type AS "Broker2CommissionType", Product.broker2_commission_value AS "Broker2CommissionValue", Product.merchant_fee_type AS "MerchantFeeType", Product.merchant_fee_value AS "MerchantFeeValue", Product.transaction_fee_type AS "TransactionFeeType", Product.transaction_fee_value AS "TransactionFeeValue", DATEDIFF(Product.effective_date, FROM_UNIXTIME(0))*24*3600 AS "EffectiveDate", DATEDIFF(Product.discontinued_date, FROM_UNIXTIME(0))*24*3600 AS "DiscontinuedDate", Product.in_al AS "AL", Product.in_ak AS "AK", Product.in_az AS "AZ", Product.in_ar AS "AR", Product.in_ca AS "CA", Product.in_co AS "CO", Product.in_ct AS "CT", Product.in_de AS "DE", Product.in_fl AS "FL", Product.in_ga AS "GA", Product.in_hi AS "HI", Product.in_id AS "ID", Product.in_il AS "IL", Product.in_in AS "IN", Product.in_ia AS "IA", Product.in_ks AS "KS", Product.in_ky AS "KY", Product.in_la AS "LA", Product.in_me AS "ME", Product.in_md AS "MD", Product.in_ma AS "MA", Product.in_mi AS "MI", Product.in_mn AS "MN", Product.in_ms AS "MS", Product.in_mo AS "MO", Product.in_mt AS "MT", Product.in_ne AS "NE", Product.in_nv AS "NV", Product.in_nh AS "NH", Product.in_nj AS "NJ", Product.in_nm AS "NM", Product.in_ny AS "NY", Product.in_nc AS "NC", Product.in_nd AS "ND", Product.in_oh AS "OH", Product.in_ok AS "OK", Product.in_or AS "OR", Product.in_pa AS "PA", Product.in_ri AS "RI", Product.in_sc AS "SC", Product.in_sd AS "SD", Product.in_tn AS "TN", Product.in_tx AS "TX", Product.in_ut AS "UT", Product.in_vt AS "VT", Product.in_va AS "VA", Product.in_wa AS "WA", Product.in_dc AS "DC", Product.in_wv AS "WV", Product.in_wi AS "WI", Product.in_wy AS "WY", Product.status_id AS "StatusId", ProductStatus.label AS "StatusLabel", UNIX_TIMESTAMP(Product.status_date) AS "StatusDate", UNIX_TIMESTAMP(Product.modified) AS "Modified", Product.modified_by AS "ModifiedById", TRIM(CONCAT(ProductModifiedBy.first_name, ' ', ProductModifiedBy.last_name, IF(ProductModifiedBy.suffix <> '', CONCAT(' ', ProductModifiedBy.suffix), ''))) AS "ModifiedBy", UNIX_TIMESTAMP(Product.created) AS "Created", Product.created_by AS "CreatedById", TRIM(CONCAT(ProductCreatedBy.first_name, ' ', ProductCreatedBy.last_name, IF(ProductCreatedBy.suffix <> '', CONCAT(' ', ProductCreatedBy.suffix), ''))) AS "CreatedBy", Product.cue_source AS "CueSource", Product.cue_source_id AS "CueSourceId", Product.cue_ver AS "CueVersion" FROM April_Products Product LEFT JOIN FM_MediaFiles TermsFile ON TermsFile.media_file_id = Product.terms_and_conditions_file_id LEFT JOIN FM_MediaFiles TermsFileAlt1 ON TermsFileAlt1.media_file_id = Product.terms_and_conditions_alt1_file_id LEFT JOIN April_Underwriters Underwriter ON Underwriter.underwriter_id = Product.underwriter_id JOIN DM_Statuses ProductStatus ON ProductStatus.status_id = Product.status_id LEFT JOIN DM_AdminUsers ProductModifiedBy ON ProductModifiedBy.admin_user_id = Product.modified_by LEFT JOIN DM_AdminUsers ProductCreatedBy ON ProductCreatedBy.admin_user_id = Product.created_by WHERE Product.product_code = '4GRTCCW';
0.0007 (1)
SELECT SQL_CALC_FOUND_ROWS ProductAttachment.product_attachment_id AS "Id", ProductAttachment.product_id AS "ProductId", ProductAttachment.media_file_id AS "MediaFileId", ProductAttachment.tag_class AS "TagClass", ProductAttachment.sort_order AS "SortOrder", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.mime_type AS "MimeType", MediaFile.hash AS "Hash", MediaFile.status_id AS "StatusId", AttachmentStatus.label AS "StatusLabel", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", UNIX_TIMESTAMP(ProductAttachment.modified) AS "Modified", ProductAttachment.modified_by AS "ModifiedById", TRIM(CONCAT(AttachmentModifiedBy.first_name, ' ', AttachmentModifiedBy.last_name, IF(AttachmentModifiedBy.suffix <> '', CONCAT(' ', AttachmentModifiedBy.suffix), ''))) AS "ModifiedBy", UNIX_TIMESTAMP(ProductAttachment.created) AS "Created", ProductAttachment.created_by AS "CreatedById", TRIM(CONCAT(AttachmentCreatedBy.first_name, ' ', AttachmentCreatedBy.last_name, IF(AttachmentCreatedBy.suffix <> '', CONCAT(' ', AttachmentCreatedBy.suffix), ''))) AS "CreatedBy", ProductAttachment.cue_source AS "CueSource", ProductAttachment.cue_source_id AS "CueSourceId", ProductAttachment.cue_ver AS "CueVersion" FROM April_ProductsAttachments ProductAttachment JOIN FM_MediaFiles MediaFile ON MediaFile.media_file_id = ProductAttachment.media_file_id JOIN DM_Statuses AttachmentStatus ON AttachmentStatus.status_id = MediaFile.status_id LEFT JOIN DM_AdminUsers AttachmentModifiedBy ON AttachmentModifiedBy.admin_user_id = ProductAttachment.modified_by LEFT JOIN DM_AdminUsers AttachmentCreatedBy ON AttachmentCreatedBy.admin_user_id = ProductAttachment.created_by WHERE ProductAttachment.product_id = 682;
SELECT FOUND_ROWS() AS `Rows`;
0.0005 (0)
SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'goready-mobile-menu' AND Menu.is_active = 1;
0.0005 (1)
SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'goready-primary-menu' AND Menu.is_active = 1;
0.0009 (29)
SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 24 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0005 (1)
SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'goready-account-mobile-menu-signed-out' AND Menu.is_active = 1;
0.0006 (3)
SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 22 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0005 (1)
SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'goready-top-bar-menu-right' AND Menu.is_active = 1;
0.0007 (10)
SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 26 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0007 (1)
SELECT MediaFile.media_file_id AS "Id", MediaFile.media_type AS "MediaType", MediaFile.title AS "Title", MediaFile.version AS "Version", MediaFile.description AS "Description", MediaFile.filename AS "Filename", MediaFile.path AS "Path", MediaFile.target_file AS "File", MediaFile.file_bytes AS "FileBytes", CONCAT(MediaFile.path, MediaFile.target_file) AS "FileURL", MediaFile.hash AS "Hash", MediaFile.mime_type AS "MimeType", MediaFile.show_in_media AS "ShowInMedia", UNIX_TIMESTAMP(MediaFile.status_date) AS "StatusDate", MediaFile.status_id AS "Status", UNIX_TIMESTAMP(MediaFile.modified) AS "Modified", MediaFile.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(MediaFile.created) AS "Created", MediaFile.created_by AS "CreatedBy", MediaFile.cue_source AS "CueSource", MediaFile.cue_source_id AS "CueSourceId", MediaFile.cue_ver AS "CueVersion", ImageFile.alt_text AS "AltText", ImageFile.source_width AS "SourceWidth", ImageFile.source_height AS "SourceHeight", ImageFile.micro_filename AS "MicroFilename", ImageFile.micro_width AS "MicroWidth", ImageFile.micro_height AS "MicroHeight", ImageFile.micro_bytes AS "MicroBytes", CONCAT(MediaFile.path, ImageFile.micro_filename) AS "MicroURL", ImageFile.thumbnail_filename AS "ThumbnailFilename", ImageFile.thumbnail_width AS "ThumbnailWidth", ImageFile.thumbnail_height AS "ThumbnailHeight", ImageFile.thumbnail_bytes AS "ThumbnailBytes", CONCAT(MediaFile.path, ImageFile.thumbnail_filename) AS "ThumbnailURL", ImageFile.small_filename AS "SmallFilename", ImageFile.small_width AS "SmallWidth", ImageFile.small_height AS "SmallHeight", ImageFile.small_bytes AS "SmallBytes", CONCAT(MediaFile.path, ImageFile.small_filename) AS "SmallURL", ImageFile.medium_filename AS "MediumFilename", ImageFile.medium_width AS "MediumWidth", ImageFile.medium_height AS "MediumHeight", ImageFile.medium_bytes AS "MediumBytes", CONCAT(MediaFile.path, ImageFile.medium_filename) AS "MediumURL", ImageFile.large_filename AS "LargeFilename", ImageFile.large_width AS "LargeWidth", ImageFile.large_height AS "LargeHeight", ImageFile.large_bytes AS "LargeBytes", CONCAT(MediaFile.path, ImageFile.large_filename) AS "LargeURL" FROM FM_MediaFiles MediaFile LEFT JOIN FM_ImageFiles ImageFile ON ImageFile.media_file_id = MediaFile.media_file_id WHERE MediaFile.media_file_id = '1583672';
0.0007 (2)
SELECT Status.status_id AS "Id", Status.entity_name AS "Entity", Status.label AS "Label", Status.is_entity_active AS "EntityIsActive", Status.is_entity_inactive AS "EntityIsInactive", Status.is_default AS "Default", Status.is_public AS "Public", Status.is_active AS "Active", Status.sort_order AS "SortOrder", Status.modified AS "Modified", Status.modified_by AS "ModifiedBy", Status.created AS "Created", Status.created_by AS "CreatedBy", Status.cue_source AS "CueSource", Status.cue_source_id AS "CueSourceId", Status.cue_ver AS "CueVersion" FROM DM_Statuses Status WHERE Status.status_id = '9';
SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '0';
SELECT Author.admin_user_id AS "Id", Author.first_name AS "FirstName", Author.last_name AS "LastName", Author.email AS "Email", TRIM(CONCAT(Author.first_name, ' ', Author.last_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayFirstLast", TRIM(CONCAT(Author.last_name, ', ', Author.first_name, IF(Author.suffix <> '', CONCAT(' ', Author.suffix), ''))) AS "DisplayLastFirst" FROM DM_AdminUsers Author WHERE Author.admin_user_id = '3';
0.0005 (1)
SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'goready-footer-menu' AND Menu.is_active = 1;
0.0008 (23)
SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 20 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
0.0005 (1)
SELECT Menu.menu_id AS "Id", Menu.name AS "Name", Menu.title AS "Title", Menu.tag_id AS "TagId", Menu.tag_class AS "TagClass", Menu.icon_class AS "IconClass", Menu.is_auto_events_enabled AS "EnableAutoEvents", Menu.is_admin AS "Admin", Menu.is_visible AS "Visible", Menu.show_children AS "ShowChildren", Menu.is_active AS "Active", UNIX_TIMESTAMP(Menu.modified) AS "Modified", Menu.modified_by AS "ModifiedBy", UNIX_TIMESTAMP(Menu.created) AS "Created", Menu.created_by AS "CreatedBy", Menu.cue_source AS "CueSource", Menu.cue_source_id AS "CueSourceId", Menu.cue_ver AS "CueVersion" FROM Menu_Menus Menu WHERE Menu.tag_id = 'goready-subfooter-menu' AND Menu.is_active = 1;
0.0007 (2)
SELECT MenuItem.menu_item_id AS "Id", MenuItem.menu_id AS "MenuId", MenuItem.name AS "Name", MenuItem.item_type AS "ItemType", MenuItem.tag_id AS "TagId", MenuItem.tag_class AS "TagClass", MenuItem.link_to AS "LinkTo", MenuItem.url_id AS "URLId", MenuItem.tag_url AS "TagURL", MenuItem.tag_title AS "TagTitle", MenuItem.tag_target_blank AS "TagTargetBlank", MenuItem.icon_class AS "IconClass", MenuItem.onclick_event AS "OnClickEvent", MenuItem.html AS "HTML", MenuItem.is_visible AS "Visible", MenuItem.show_children AS "ShowChildren", MenuItem.sort_order AS "SortOrder", MenuItem.depth AS "Depth", MenuItem.allowed_roles AS "AllowedRoles", MenuItem.is_active AS "Active", UNIX_TIMESTAMP(MenuItem.modified) AS "Modified", MenuItem.modified_by AS "ModifiedBy.Id", UNIX_TIMESTAMP(MenuItem.created) AS "Created", MenuItem.created_by AS "CreatedBy.Id", MenuItem.cue_source AS "CueSource", MenuItem.cue_source_id AS "CueSourceId", MenuItem.cue_ver AS "CueVersion", URL.path AS "ContentURL" FROM Menu_MenusItems MenuItem LEFT JOIN DM_URLs URL ON URL.url_id = MenuItem.url_id LEFT JOIN DM_AdminUsers ModifiedBy ON ModifiedBy.admin_user_id = MenuItem.modified_by LEFT JOIN DM_AdminUsers CreatedBy ON CreatedBy.admin_user_id = MenuItem.created_by WHERE MenuItem.menu_id = 25 ORDER BY MenuItem.sort_order ASC, MenuItem.sort_order;
All of Aegis's policies automatically include our exclusive
Stress Less Benefits. This amazing feature allows our clients to
potentially avoid fronting their own monies and going through a claim
reimbursement process. By contacting Aegis General immediately when
experiencing any covered event such as a flight disruption, illness,
or injury, our team can coordinate the solution and pay for it on the
spot. This includes booking or rearranging flights and hotels,
coordinating medical care, or arranging a medical evacuation or
repatriation.*
