Use the latest browser recommended by Microsoft.
Get speed, security and privacy with Microsoft Edge.
Please enter search value

Offers

At eTickets.ca we love our customers and always give back to them. With our special promo codes, our customers can save as much as $30 on their purchases of Music Concert Tickets, Sports Tickets & Theater Tickets. This page allows you to find all the active promotions from eTickets.ca the premium event ticket seller in Canada. Find eTickets.ca promo codes and coupons for August, 2024. Buy tickets to save on sports, concerts and more with fan codes from eTickets.ca.

 

A total of 1 active eTickets.ca Promotion Codes & Deals are listed and the latest one is updated on August, 2024. We currently have 1 deals which offer up to $30 Off when you're shopping for eTickets.ca.

Frequently Asked Questions for Event Tickets Promo Codes

  • What is a Promotional Code?

    Promo codes are codes that are offered to customers for special discounts, special events, etc. These codes are entered in the box marked "Promo Code" on the checkout page.

  • Where can I find the promo code?

    When you visit our Promo Codes or Offers page here https://www.eTickets.ca/offer/ you will be able to find all our active promo codes.

  • When does the promo code expire?

    Each promo code that is active will have an expiry date listed on the promo code page, check and read the terms of each promo code before using them.

  • Can I use the same promo code multiple times?

    For some promo codes yes you can use them multiple times but some have a limit and you can find this when you read the terms and conditions.

  • Can I use these promo codes on other sites as well?

    Unfortunately, these promo codes can only be used on eTickets.ca and no other sites.

  • Whats the offer for each promo codes?

    To find out more on savings on each promo codes, you must read through the terms and conditions and understand the codes.

  • How do I redeem a promo code?

    You can redeem the promo codes at the checkout process specifically on Step 2 of the checkout process.

eTickets 100% Ticket Guarantee

Our commitment to our valued customers is unwavering, and we've designed our ticketing service with you in mind. We offer a 100% Ticket Guarantee to ensure your ticket-buying experience is seamless and stress-free.

100% verified tickets
Your seats will be together
Tickets will arrive on time
100% authentic tickets
Safe & Secured transaction
You will get the seats you choose or better
8.1.29PHP Version516msRequest Duration7MBMemory UsageGET offerRouteAuth status
  • warninglog[03:25:09] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias_for_routes i...
  • warninglog[03:25:09] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias_for_routes i...
  • warninglog[03:25:09] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias is deprecate...
  • warninglog[03:25:09] LOG.warning: Calling static trait method App\Http\Traits\slug::resolve_alias is deprecate...
  • Booting (225ms)
  • Application (291ms)
  • 1 x Application (56.45%)
    291.48ms
    1 x Booting (43.51%)
    224.66ms
    10 templates were rendered
    • visualcomposer::frontview.builder-sections.cms (packages/Powerpanel/VisualComposer/src/Resources/views/frontview/builder-sections/cms.blade.php)1bladefile
      Params
      0
      data
    • visualcomposer::frontview.builder-sections.page-elements.description-block (packages/Powerpanel/VisualComposer/src/Resources/views/frontview/builder-sections/page-elements/description-block.blade.php)10bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      data
    • offer::frontview.offer (packages/Powerpanel/Offer/src/Resources/views/frontview/offer.blade.php)4bladefile
      Params
      0
      PageData
      1
      pageContent
      2
      letestOffers
      3
      faqs
    • layouts.inner_banner (resources/views/layouts/inner_banner.blade.php)30bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      secondaryaddress
      13
      PAGE_ID
      14
      META_TITLE
      15
      META_KEYWORD
      16
      META_DESCRIPTION
      17
      PAGE_CONTENT
      18
      PAGE_CONTENT_BOTTOM
      19
      APP_URL
      20
      SHARE_IMG
      21
      VIEWING_PREVIEW
      22
      ADVERTISE_BANNER_IMG
      23
      OFFER_IMG
      24
      errors
      25
      detailPageTitle
      26
      PageData
      27
      pageContent
      28
      letestOffers
      29
      faqs
    • offer-list (resources/views/offer-list.blade.php)30bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      secondaryaddress
      13
      PAGE_ID
      14
      META_TITLE
      15
      META_KEYWORD
      16
      META_DESCRIPTION
      17
      PAGE_CONTENT
      18
      PAGE_CONTENT_BOTTOM
      19
      APP_URL
      20
      SHARE_IMG
      21
      VIEWING_PREVIEW
      22
      ADVERTISE_BANNER_IMG
      23
      OFFER_IMG
      24
      errors
      25
      detailPageTitle
      26
      PageData
      27
      pageContent
      28
      letestOffers
      29
      faqs
    • layouts.app (resources/views/layouts/app.blade.php)33bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      secondaryaddress
      13
      PAGE_ID
      14
      META_TITLE
      15
      META_KEYWORD
      16
      META_DESCRIPTION
      17
      PAGE_CONTENT
      18
      PAGE_CONTENT_BOTTOM
      19
      APP_URL
      20
      SHARE_IMG
      21
      VIEWING_PREVIEW
      22
      ADVERTISE_BANNER_IMG
      23
      OFFER_IMG
      24
      errors
      25
      detailPageTitle
      26
      PageData
      27
      pageContent
      28
      letestOffers
      29
      faqs
      30
      __currentLoopData
      31
      faq
      32
      loop
    • layouts.header (resources/views/layouts/header.blade.php)38bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      secondaryaddress
      13
      PAGE_ID
      14
      META_TITLE
      15
      META_KEYWORD
      16
      META_DESCRIPTION
      17
      PAGE_CONTENT
      18
      PAGE_CONTENT_BOTTOM
      19
      APP_URL
      20
      SHARE_IMG
      21
      VIEWING_PREVIEW
      22
      ADVERTISE_BANNER_IMG
      23
      OFFER_IMG
      24
      errors
      25
      detailPageTitle
      26
      PageData
      27
      pageContent
      28
      letestOffers
      29
      faqs
      30
      __currentLoopData
      31
      faq
      32
      loop
      33
      requestedFullUrl
      34
      homePageUrl
      35
      seg
      36
      encodedSeg
      37
      d_class
    • layouts.header_main (resources/views/layouts/header_main.blade.php)38bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      secondaryaddress
      13
      PAGE_ID
      14
      META_TITLE
      15
      META_KEYWORD
      16
      META_DESCRIPTION
      17
      PAGE_CONTENT
      18
      PAGE_CONTENT_BOTTOM
      19
      APP_URL
      20
      SHARE_IMG
      21
      VIEWING_PREVIEW
      22
      ADVERTISE_BANNER_IMG
      23
      OFFER_IMG
      24
      errors
      25
      detailPageTitle
      26
      PageData
      27
      pageContent
      28
      letestOffers
      29
      faqs
      30
      __currentLoopData
      31
      faq
      32
      loop
      33
      requestedFullUrl
      34
      homePageUrl
      35
      seg
      36
      encodedSeg
      37
      d_class
    • layouts.footer_main (resources/views/layouts/footer_main.blade.php)38bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      secondaryaddress
      13
      PAGE_ID
      14
      META_TITLE
      15
      META_KEYWORD
      16
      META_DESCRIPTION
      17
      PAGE_CONTENT
      18
      PAGE_CONTENT_BOTTOM
      19
      APP_URL
      20
      SHARE_IMG
      21
      VIEWING_PREVIEW
      22
      ADVERTISE_BANNER_IMG
      23
      OFFER_IMG
      24
      errors
      25
      detailPageTitle
      26
      PageData
      27
      pageContent
      28
      letestOffers
      29
      faqs
      30
      __currentLoopData
      31
      faq
      32
      loop
      33
      requestedFullUrl
      34
      homePageUrl
      35
      seg
      36
      encodedSeg
      37
      d_class
    • layouts.footer (resources/views/layouts/footer.blade.php)38bladefile
      Params
      0
      __env
      1
      app
      2
      CDN_PATH
      3
      HeadreMenuhtml
      4
      serviceMenu
      5
      aboutMenu
      6
      questionsMenu
      7
      footerMenu
      8
      popupObj
      9
      currentPageTitle
      10
      inner_banner_data
      11
      objContactInfo
      12
      secondaryaddress
      13
      PAGE_ID
      14
      META_TITLE
      15
      META_KEYWORD
      16
      META_DESCRIPTION
      17
      PAGE_CONTENT
      18
      PAGE_CONTENT_BOTTOM
      19
      APP_URL
      20
      SHARE_IMG
      21
      VIEWING_PREVIEW
      22
      ADVERTISE_BANNER_IMG
      23
      OFFER_IMG
      24
      errors
      25
      detailPageTitle
      26
      PageData
      27
      pageContent
      28
      letestOffers
      29
      faqs
      30
      __currentLoopData
      31
      faq
      32
      loop
      33
      requestedFullUrl
      34
      homePageUrl
      35
      seg
      36
      encodedSeg
      37
      d_class
    uri
    GET offer
    middleware
    web, check-under-maintenance, csp-headers
    controller
    Powerpanel\Offer\Controllers\OfferController@index
    namespace
    prefix
    where
    file
    packages/Powerpanel/Offer/src/Controllers/OfferController.php:37-95
    23 statements were executed, 5 of which were duplicated, 18 unique. Show only duplicated47.09ms
    • select `nq_menu`.`id`, `intParentMenuId`, `intItemOrder`, `intParentItemOrder`, `chrInMobile`, `chrInWeb`, `intAliasId`, `intPageId`, `varTitle`, `txtPageUrl`, `intPosition`, `chrActive`, `chrDisplayFront`, `chrMegaMenu`, `chrDelete`, `chrPublish`, `created_at`, `updated_at`, `chrNewTab`, `intfkMegaMenuId`, `nq_mega_menu_details`.`title` as `mega_menu_inner_title`, `nq_mega_menu_details`.`description`, `nq_mega_menu_details`.`image_id`, `nq_mega_menu_details`.`link`, `nq_mega_menu_details`.`image_caption` from `nq_menu` left join `nq_mega_menu_details` on `nq_mega_menu_details`.`id` = `nq_menu`.`intfkMegaMenuId` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`chrActive` = 'Y') and `chrInWeb` = 'Y' order by `intPosition` asc, `intParentItemOrder` asc, `intItemOrder` asc8.97ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. Y
      • 3. Y
      Backtrace
      • 14. /packages/Powerpanel/Menu/src/Models/Menu.php:233
      • 15. /app/Http/Controllers/FrontController.php:186
      • 16. /app/Http/Controllers/FrontController.php:173
      • 17. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `id`, `varTitle` from `nq_menu_type` where `nq_menu_type`.`id` in (1, 3, 4, 5, 6, 7) and `chrPublish` = 'Y' and (`chrDelete` = 'N')1.29ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. N
      Backtrace
      • 19. /packages/Powerpanel/Menu/src/Models/Menu.php:233
      • 20. /app/Http/Controllers/FrontController.php:186
      • 21. /app/Http/Controllers/FrontController.php:173
      • 22. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
      • 24. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'offer' and `intFkModuleCode` = 3 limit 15.99ms/app/Alias.php:50etickets_live
      Metadata
      Bindings
      • 0. offer
      • 1. 3
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:50
      • 16. /app/Http/Traits/slug.php:36
      • 17. /app/Http/Controllers/FrontController.php:733
      • 18. /app/Http/Controllers/FrontController.php:174
      • 19. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
    • select `intFKModuleCode`, `id` from `nq_cms_page` where `intAliasId` = 1376 limit 16.39ms/app/Http/Controllers/FrontController.php:746etickets_live
      Metadata
      Bindings
      • 0. 1376
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Http/Controllers/FrontController.php:746
      • 16. /app/Http/Controllers/FrontController.php:174
      • 17. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
      • 20. /vendor/laravel/framework/src/Illuminate/Container/Container.php:795
    • select `id`, `fkIntPageId`, `fkModuleId`, `varTitle`, `varPopUpOn`, `varDsplyOn`, `varLink`, `txtDescription`, `fkIntImgId`, `dtStartDateTime`, `dtEndDateTime`, `chrPublish` from `nq_pop_up_content` where (`chrPublish` = 'Y') and `fkModuleId` = 161 and (`chrDelete` = 'N') limit 11.04ms/app/Http/Controllers/FrontController.php:789etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. 161
      • 2. N
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Http/Controllers/FrontController.php:789
      • 16. /app/Http/Controllers/FrontController.php:174
      • 17. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
      • 20. /vendor/laravel/framework/src/Illuminate/Container/Container.php:795
    • select `id`, `fkIntPageId`, `fkModuleId`, `varTitle`, `varPopUpOn`, `varDsplyOn`, `varLink`, `txtDescription`, `fkIntImgId`, `dtStartDateTime`, `dtEndDateTime`, `chrPublish` from `nq_pop_up_content` where (`chrPublish` = 'Y') and (`chrDelete` = 'N')1.1ms/packages/Powerpanel/PopupContent/src/Models/PopUpContent.php:89etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. N
      Backtrace
      • 14. /packages/Powerpanel/PopupContent/src/Models/PopUpContent.php:89
      • 15. /app/Http/Controllers/FrontController.php:808
      • 16. /app/Http/Controllers/FrontController.php:174
      • 17. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
      • 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'offer' and `intFkModuleCode` = 3 limit 11.08ms/app/Alias.php:50etickets_live
      Metadata
      Bindings
      • 0. offer
      • 1. 3
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:50
      • 16. /app/Http/Traits/slug.php:36
      • 17. /app/Http/Controllers/FrontController.php:947
      • 18. /app/Http/Controllers/FrontController.php:177
      • 19. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
    • select `id`, `intAliasId`, `intFKModuleCode`, `varTitle`, `txtShortDescription`, `txtDescription`, `chrPageActive`, `varPassword`, `dtDateTime`, `dtEndDateTime`, `varMetaTitle`, `varMetaDescription` from `nq_cms_page` where `intAliasId` = 1376 and `txtDescription` is not null limit 11.36ms/packages/Powerpanel/CmsPage/src/Models/CmsPage.php:221etickets_live
      Metadata
      Bindings
      • 0. 1376
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/CmsPage/src/Models/CmsPage.php:221
      • 16. /app/Http/Controllers/FrontController.php:974
      • 17. /app/Http/Controllers/FrontController.php:177
      • 18. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
      • 20. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `fkIntImgId`, `fkIntInnerImgId`, `varLink`, `varShortDescription`, `chrDisplayLink`, `chrDisplayVideo`, `varVideoLink`, `varTitle`, `txtDescription`, `chrDraft`, `chrArchive`, `chrTrash`, `chrPublish`, `FavoriteID`, `created_at`, `updated_at` from `nq_banner` where (`chrDefaultBanner` = 'Y') and (`chrDelete` = 'N') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) and `chrMain` = 'Y' and `chrTrash` != 'Y' and (`chrPublish` = 'Y') order by `intDisplayOrder` asc1.21ms/packages/Powerpanel/Banner/src/Models/Banner.php:108etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. N
      • 2. Y
      • 3. Y
      • 4. Y
      Hints
      • The != operator is not standard. Use the <> operator to test for inequality instead.
      Backtrace
      • 14. /packages/Powerpanel/Banner/src/Models/Banner.php:108
      • 15. /app/Http/Controllers/FrontController.php:826
      • 16. /app/Http/Controllers/FrontController.php:983
      • 17. /app/Http/Controllers/FrontController.php:177
      • 18. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'offer' limit 11.09ms/app/Alias.php:35etickets_live
      Metadata
      Bindings
      • 0. offer
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:35
      • 16. /app/Http/Traits/slug.php:24
      • 17. /app/Http/Controllers/FrontController.php:856
      • 18. /app/Http/Controllers/FrontController.php:983
      • 19. /app/Http/Controllers/FrontController.php:177
    • select `intFkModuleCode` from `nq_alias` where `id` = 13761.22ms/app/Alias.php:97etickets_live
      Metadata
      Bindings
      • 0. 1376
      Backtrace
      • 14. /app/Alias.php:97
      • 15. /app/Http/Controllers/FrontController.php:857
      • 16. /app/Http/Controllers/FrontController.php:983
      • 17. /app/Http/Controllers/FrontController.php:177
      • 18. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
    • select `varTitle`, `fkIntImgId`, `fkIntInnerImgId`, `varLink`, `fkIntPageId`, `varShortDescription`, `fkModuleId`, `varVideoLink`, `chrPublish`, `chrDisplayLink`, `chrDisplayVideo`, `txtDescription`, `chrDraft`, `chrArchive`, `chrTrash`, `FavoriteID`, `created_at`, `updated_at` from `nq_banner` where (`chrDelete` = 'N') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) and (`chrPublish` = 'Y') and (`varBannerType` = 'inner_banner') and `fkIntPageId` = 137 and `fkModuleId` = 31.79ms/packages/Powerpanel/Banner/src/Models/Banner.php:157etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. inner_banner
      • 3. 137
      • 4. 3
      Backtrace
      • 14. /packages/Powerpanel/Banner/src/Models/Banner.php:157
      • 15. /app/Http/Controllers/FrontController.php:860
      • 16. /app/Http/Controllers/FrontController.php:983
      • 17. /app/Http/Controllers/FrontController.php:177
      • 18. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
    • select `id`, `intAliasId`, `intFKModuleCode`, `varTitle` from `nq_cms_page` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `varTitle` = 'Pages' limit 11.25ms/packages/Powerpanel/CmsPage/src/Models/CmsPage.php:866etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. Pages
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/CmsPage/src/Models/CmsPage.php:866
      • 16. /app/Http/Controllers/FrontController.php:867
      • 17. /app/Http/Controllers/FrontController.php:983
      • 18. /app/Http/Controllers/FrontController.php:177
      • 19. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
    • select `id`, `varTitle`, `varModuleName`, `varTableName`, `varModelName`, `varModuleClass`, `varModuleNameSpace`, `varModuleName` from `nq_module` where (`chrDelete` = 'N') and `varModuleName` = 'news' limit 11.34ms/app/Modules.php:70etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. news
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Modules.php:70
      • 16. /app/Helpers/MyLibrary.php:1247
      • 17. /app/Helpers/FrontPageContent_Shield.php:20
      • 18. /app/Http/Controllers/FrontController.php:1010
      • 19. /app/Http/Controllers/FrontController.php:177
    • select `id`, `intAliasId`, `intFKModuleCode` from `nq_cms_page` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `chrMain` = 'Y' and `intFKModuleCode` = 27 limit 11.21ms/packages/Powerpanel/CmsPage/src/Models/CmsPage.php:57etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. Y
      • 3. 27
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/CmsPage/src/Models/CmsPage.php:57
      • 16. /app/Helpers/MyLibrary.php:1251
      • 17. /app/Helpers/FrontPageContent_Shield.php:20
      • 18. /app/Http/Controllers/FrontController.php:1010
      • 19. /app/Http/Controllers/FrontController.php:177
    • select `id`, `varTitle`, `fkIntImgId`, `varTitle`, `chrPublish`, `chrDelete`, `dtDateTime` from `nq_offer` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) order by `dtDateTime` desc limit 11.1ms/packages/Powerpanel/Offer/src/Models/Offer.php:66etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      Backtrace
      • 15. /packages/Powerpanel/Offer/src/Models/Offer.php:66
      • 16. /app/Http/Controllers/FrontController.php:1024
      • 17. /app/Http/Controllers/FrontController.php:177
      • 18. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:28
      • 20. /vendor/laravel/framework/src/Illuminate/Container/Container.php:952
    • select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'offer' and `intFkModuleCode` = 3 limit 11.74ms/app/Alias.php:35etickets_live
      Metadata
      Bindings
      • 0. offer
      • 1. 3
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /app/Alias.php:35
      • 16. /app/Http/Traits/slug.php:24
      • 17. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:45
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `txtDescription`, `varTitle`, `txtShortDescription`, `id`, `chrPageActive`, `varPassword`, `UserID` from `nq_cms_page` where (`chrDelete` = 'N') and `fkMainRecord` = 0 and `txtDescription` is not null and `intAliasId` = 1376 limit 11.39ms/packages/Powerpanel/CmsPage/src/Models/CmsPage.php:202etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. 0
      • 2. 1376
      Hints
      • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
      Backtrace
      • 15. /packages/Powerpanel/CmsPage/src/Models/CmsPage.php:202
      • 16. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:51
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as aggregate from `nq_offer` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) and `chrTrash` != 'Y' and `chrDraft` != 'D'1.01ms/packages/Powerpanel/Offer/src/Models/Offer.php:1083etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. Y
      • 3. D
      Hints
      • The != operator is not standard. Use the <> operator to test for inequality instead.
      Backtrace
      • 15. /packages/Powerpanel/Offer/src/Models/Offer.php:1083
      • 16. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:90
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id`, `varTitle`, `intDisplayOrder`, `fkIntImgId`, `txtDisccount`, `dtDateTime`, `dtEndDateTime`, `varShortDescription`, `fkMainRecord`, `chrPublish`, `chrDraft`, `chrTrash`, `created_at`, `updated_at` from `nq_offer` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and ((dtEndDateTime >= NOW() AND NOW() >= dtDateTime) OR (NOW() >= dtDateTime and dtEndDateTime is null)) and `chrTrash` != 'Y' and `chrDraft` != 'D' order by `dtEndDateTime` asc limit 12 offset 01.27ms/packages/Powerpanel/Offer/src/Models/Offer.php:1083etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. Y
      • 3. D
      Hints
      • The != operator is not standard. Use the <> operator to test for inequality instead.
      Backtrace
      • 15. /packages/Powerpanel/Offer/src/Models/Offer.php:1083
      • 16. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:90
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id`, `intFKCategory`, `varTitle`, `txtDescription`, `chrDraft`, `chrTrash`, `intSearchRank`, `FavoriteID`, `created_at`, `updated_at` from `nq_faq` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `fkMainRecord` = 0 and `intFKCategory` = 1 and `chrTrash` = 'N' and `chrDraft` = 'N' order by `intDisplayOrder` asc1.22ms/packages/Powerpanel/Faq/src/Models/Faq.php:234etickets_live
      Metadata
      Bindings
      • 0. N
      • 1. Y
      • 2. 0
      • 3. 1
      • 4. N
      • 5. N
      Backtrace
      • 14. /packages/Powerpanel/Faq/src/Models/Faq.php:234
      • 15. /packages/Powerpanel/Offer/src/Controllers/OfferController.php:91
      • 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `id`, `varTitle`, `varEmail`, `varPhoneNo`, `varEmergencyPhoneNo`, `varCustomerServicePhoneNo`, `varFax`, `txtDescription`, `intDisplayOrder`, `fkIntImgId`, `txtAddress`, `mailingaddress`, `varOpeningHours`, `chrLatitude`, `chrLongitude`, `chrIsPrimary`, `chrPublish`, `chrDelete`, `created_at`, `updated_at` from `nq_contact_info` where `chrIsPrimary` = 'Y' and (`chrDelete` = 'N') and (`chrPublish` = 'Y')1.59ms/packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. N
      • 2. Y
      Backtrace
      • 14. /packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111
      • 15. view::layouts.header_main:2
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    • select `id`, `varTitle`, `varEmail`, `varPhoneNo`, `varEmergencyPhoneNo`, `varCustomerServicePhoneNo`, `varFax`, `txtDescription`, `intDisplayOrder`, `fkIntImgId`, `txtAddress`, `mailingaddress`, `varOpeningHours`, `chrLatitude`, `chrLongitude`, `chrIsPrimary`, `chrPublish`, `chrDelete`, `created_at`, `updated_at` from `nq_contact_info` where `chrIsPrimary` = 'Y' and (`chrDelete` = 'N') and (`chrPublish` = 'Y')1.44ms/packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111etickets_live
      Metadata
      Bindings
      • 0. Y
      • 1. N
      • 2. Y
      Backtrace
      • 14. /packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111
      • 15. view::layouts.footer_main:2
      • 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
      • 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
    Powerpanel\ContactInfo\Models\ContactInfo
    10
    Powerpanel\Faq\Models\Faq
    7
    Powerpanel\Offer\Models\Offer
    3
    App\Modules
    1
    Powerpanel\PopupContent\Models\PopUpContent
    1
    Powerpanel\CmsPage\Models\CmsPage
    3
    App\Alias
    5
    Powerpanel\Menu\Models\MenuType
    6
    Powerpanel\Menu\Models\Menu
    707
    web
    null
    front-user
    null
    api
    null
    sanctum
    null
      _token
      b9kkT1wjqCh3xzAENaYCpw0axtXx4cJ8Luv983Ry
      PHPDEBUGBAR_STACK_DATA
      []
      path_info
      /offer
      status_code
      200
      
      status_text
      OK
      format
      html
      content_type
      text/html; charset=UTF-8
      request_query
      []
      
      request_request
      []
      
      request_headers
      0 of 0
      array:21 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "connection" => array:1 [ 0 => "close" ] "x-forwarded-for" => array:1 [ 0 => "3.144.2.213" ] "x-real-ip" => array:1 [ 0 => "3.144.2.213" ] "x-forwarded-host" => array:1 [ 0 => "cron.etickets.ca" ] "host" => array:1 [ 0 => "cron.etickets.ca" ] "content-length" => array:1 [ 0 => "" ] "content-type" => array:1 [ 0 => "" ] ]
      request_server
      0 of 0
      array:58 [ "USER" => "etickets-cron" "HOME" => "/home/etickets-cron" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_PRAGMA" => "no-cache" "HTTP_CONNECTION" => "close" "HTTP_X_FORWARDED_FOR" => "3.144.2.213" "HTTP_X_REAL_IP" => "3.144.2.213" "HTTP_X_FORWARDED_HOST" => "cron.etickets.ca" "HTTP_HOST" => "cron.etickets.ca" "PHP_VALUE" => """ \n error_log=/home/etickets-cron/logs/php/error.log;\n memory_limit=512M;\n max_execution_time=60;\n max_input_time=60;\n max_input_vars=10000;\n post_max_size=64M;\n upload_max_filesize=64M;\n date.timezone=UTC;\n display_errors=off; """ "HTTPS" => true "MGT" => "1" "GEOIP_LONGITUDE" => "-73.2637" "GEOIP_LATITUDE" => "41.1412" "GEOIP_CITY_CONTINENT_CODE" => "NA" "GEOIP_POSTAL_CODE" => "06828" "GEOIP_CITY" => "Fairfield" "GEOIP_REGION" => "CT" "GEOIP_CITY_COUNTRY_NAME" => "United States" "GEOIP_CITY_COUNTRY_CODE3" => "USA" "GEOIP_CITY_COUNTRY_CODE" => "US" "GEOIP_COUNTRY_NAME" => "United States" "GEOIP_COUNTRY_CODE3" => "USA" "GEOIP_COUNTRY_CODE" => "US" "REDIRECT_STATUS" => "200" "SERVER_NAME" => "cron.etickets.ca" "SERVER_PORT" => "443" "SERVER_ADDR" => "127.0.0.1" "REMOTE_PORT" => "" "REMOTE_ADDR" => "3.144.2.213" "SERVER_SOFTWARE" => "nginx/1.21.4" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.0" "DOCUMENT_ROOT" => "/home/etickets-cron/htdocs/cron.etickets.ca/public_html" "DOCUMENT_URI" => "/index.php" "REQUEST_URI" => "/offer" "SCRIPT_NAME" => "/index.php" "SCRIPT_FILENAME" => "/home/etickets-cron/htdocs/cron.etickets.ca/public_html/index.php" "CONTENT_LENGTH" => "" "CONTENT_TYPE" => "" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "FCGI_ROLE" => "RESPONDER" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744273509.4608 "REQUEST_TIME" => 1744273509 ]
      request_cookies
      []
      
      response_headers
      0 of 0
      array:7 [ "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Thu, 10 Apr 2025 08:25:09 GMT" ] "pragma" => array:1 [ 0 => "no-cache" ] "expires" => array:1 [ 0 => "-1" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndIb3MzOUgxQ28xQnFxaFFzaCtzOEE9PSIsInZhbHVlIjoiU3J1cVVDdk1MNC92RDNTczBDRFJXNDZEZldtczkrQjcxS0x5SFJ3aXZRUXAyci9yQlp4eHY4Q25td00xWlJlYy84RWNqbjB3QzlJMjVqRkFpTnU2UmwyVWpMVCtyQkorczV1cEtKNTJSNTZjaVpIM0FXeXVoYkowV09tK2tWVTQiLCJtYWMiOiJiNjk5ZjU4ZjgwNmE0YTllODg0ZTU0ZTUwMzhlNTBhMzBiOTNjNzY4NjVkMDY2ZDQxYTIzNjc1MzZiMmMxOWY2IiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 10:25:09 GMT; Max-Age=7200; path=/; secureXSRF-TOKEN=eyJpdiI6IndIb3MzOUgxQ28xQnFxaFFzaCtzOEE9PSIsInZhbHVlIjoiU3J1cVVDdk1MNC92RDNTczBDRFJXNDZEZldtczkrQjcxS0x5SFJ3aXZRUXAyci9yQlp4eHY4Q25td00xWlJlYy84RWNqb" 1 => "recently_viewed=PnrXIidwzXkVOWNWVSKv; expires=Fri, 11 Apr 2025 08:25:09 GMT; Max-Age=86400; path=/; secure; httponly" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IndIb3MzOUgxQ28xQnFxaFFzaCtzOEE9PSIsInZhbHVlIjoiU3J1cVVDdk1MNC92RDNTczBDRFJXNDZEZldtczkrQjcxS0x5SFJ3aXZRUXAyci9yQlp4eHY4Q25td00xWlJlYy84RWNqbjB3QzlJMjVqRkFpTnU2UmwyVWpMVCtyQkorczV1cEtKNTJSNTZjaVpIM0FXeXVoYkowV09tK2tWVTQiLCJtYWMiOiJiNjk5ZjU4ZjgwNmE0YTllODg0ZTU0ZTUwMzhlNTBhMzBiOTNjNzY4NjVkMDY2ZDQxYTIzNjc1MzZiMmMxOWY2IiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 10:25:09 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IndIb3MzOUgxQ28xQnFxaFFzaCtzOEE9PSIsInZhbHVlIjoiU3J1cVVDdk1MNC92RDNTczBDRFJXNDZEZldtczkrQjcxS0x5SFJ3aXZRUXAyci9yQlp4eHY4Q25td00xWlJlYy84RWNqb" 1 => "recently_viewed=PnrXIidwzXkVOWNWVSKv; expires=Fri, 11-Apr-2025 08:25:09 GMT; path=/; secure; httponly" ] ]
      session_attributes
      0 of 0
      array:2 [ "_token" => "b9kkT1wjqCh3xzAENaYCpw0axtXx4cJ8Luv983Ry" "PHPDEBUGBAR_STACK_DATA" => [] ]