eTickets.ca takes pride in offering you a seamless way to witness the electrifying performance of your favorite team or player, & Juliet - Musical Our platform is designed to make your ticket purchasing experience hassle-free and enjoyable, with a wide range of options to suit all your theatre needs.
We offer an extensive selection of tickets, from budget-friendly standard options to exclusive VIP experiences. This variety ensures that every fan finds the perfect ticket to experience their favorite team or player & Juliet - Musical live. Keep an eye on the.& Juliet - Musicaltheatre event dates, and grab the opportunity to book your tickets online at the most competitive prices.
For those spontaneous theatre-goers, our last-minute section is a lifesaver, offering the best available tickets for your impromptu plans. This feature ensures that you never miss out on experiencing a memorable live theatre event, even at the eleventh hour.
Remember, the early bird gets the worm! Securing your tickets early is crucial to avoid disappointment and get the best possible seats. However, if you do find yourself in need of last-minute tickets, don't worry – we've got you covered.
At eTickets.ca, we understand the exhilaration of attending live theatre. We are committed to providing you with the best seats for an unforgettable experience. Delaying your decision could mean missing out on the best seats, so be prompt in securing your spot at & Juliet - Musical's theatre. This is your chance to make your social profiles buzz with the excitement of a live theatre event.
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.
1 x Application (79.81%) | 244.51ms |
1 x Booting (20.16%) | 61.78ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
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` asc
7.42ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
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.13ms/packages/Powerpanel/Menu/src/Models/Menu.php:233etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'juliet-musical-tickets' limit 1
1.13ms/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 29390 and `chrIsPreview` = 'N' limit 1
1.07ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `fkIntPageId`, `fkModuleId`, `varTitle`, `varPopUpOn`, `varDsplyOn`, `varLink`, `txtDescription`, `fkIntImgId`, `dtStartDateTime`, `dtEndDateTime`, `chrPublish` from `nq_pop_up_content` where (`chrPublish` = 'Y') and `fkIntPageId` = 29390 and (`chrDelete` = 'N') limit 1
1.01ms/app/Http/Controllers/FrontController.php:799etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
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.02ms/packages/Powerpanel/PopupContent/src/Models/PopUpContent.php:89etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'performers' and `intFkModuleCode` = 3 limit 1
1.04ms/app/Alias.php:50etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
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` asc
1.73ms/packages/Powerpanel/Banner/src/Models/Banner.php:108etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
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 1
1.04ms/packages/Powerpanel/Offer/src/Models/Offer.php:66etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `varAlias` = 'juliet-musical-tickets' limit 1
970μs/app/Alias.php:35etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intCategoryId` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 29390 limit 1
1.28ms/packages/Powerpanel/Performers/src/Models/Performers.php:594etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intCategoryId`, `intParentCatId`, `intChildCatId`, `id`, `varTitle`, `txtDescription` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 29390 limit 1
1.13ms/packages/Powerpanel/Performers/src/Models/Performers.php:154etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id` from `nq_peformers` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and `intAliasId` = 29390 limit 1
970μs/packages/Powerpanel/Performers/src/Models/Performers.php:1288etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
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` = 28380 and `fkModuleId` = 158
1.35ms/packages/Powerpanel/Banner/src/Models/Banner.php:157etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `nq_event_performers`.`eventid`, `nq_events`.`varCity` from `nq_event_performers` inner join `nq_events` on `nq_event_performers`.`eventid` = `nq_events`.`fkeventGlcode` where `nq_events`.`chrPublish` = 'Y' and `nq_events`.`intParentCatId` = 3 and `nq_events`.`intChildCatId` = 38 and `nq_event_performers`.`performerid` = 148161 and `nq_events`.`chrDelete` = 'N'
12.66ms/app/EventPerformer.php:37etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `varCity`, `varStateProvince`, count(fkeventGlcode) as event_count from `nq_events` where `fkeventGlcode` in (5704145, 5704146, 5704147, 5704148, 5704149, 5704150, 5704151, 5704152, 6212634, 6212635, 6212636, 6212637, 6212638, 6212639, 6212640, 6212641, 6212642, 6212643, 6212644, 6212645, 6212646, 6212647, 6212648, 6212649, 6228319, 6228320, 6228321, 6228322, 6228323, 6228324, 6228325, 6228326, 6228327, 6228328, 6228329, 6228330, 6228331, 6228332, 6228333, 6228334, 6233936, 6233937, 6233938, 6233939, 6233940, 6233941, 6233942, 6233943, 6237227, 6237228, 6237229, 6237230, 6237231, 6237232, 6237233, 6237234, 6255920, 6255968, 6256641, 6257066, 6257343, 6258132, 6258133, 6258134, 6258135, 6258136, 6258137, 6258138, 6258139, 6258400, 6260937, 6260938, 6260939, 6260940, 6260941, 6260942, 6260943, 6260944, 6261864, 6261865, 6266560, 6266561, 6266563, 6266564, 6266565, 6266566, 6266567, 6266568, 6277276, 6277277, 6277278, 6277279, 6277280, 6277281, 6277282, 6277283, 6278881, 6279024, 6279026, 6279027, 6279030, 6279031, 6279033, 6279035, 6279036, 6279037, 6279038, 6279039, 6279041, 6279042, 6279043, 6279044, 6281310, 6281311, 6281312, 6281314, 6281315, 6281316, 6281317, 6281318, 6282959, 6282960, 6282961, 6282962, 6282963, 6282964, 6282965, 6282966, 6282967, 6282968, 6282969, 6282970, 6282971, 6282972, 6282973, 6282974, 6282975, 6282976, 6282977, 6282978, 6282979, 6282980, 6282981, 6282982, 6282983, 6282984, 6282985, 6282986, 6282987, 6282988, 6282989, 6282990, 6287137, 6287138, 6287139, 6287140, 6287141, 6287142, 6287143, 6287144, 6293938, 6293940, 6293941, 6293945, 6293946, 6293948, 6293950, 6293952, 6299390, 6299439, 6299440, 6299441, 6299442, 6299443, 6299444, 6299445, 6308883, 6312042, 6312043, 6312044, 6312045, 6312046, 6312047, 6312048, 6312052, 6312053, 6312054, 6312055, 6312056, 6312057, 6312058, 6312066, 6317161, 6317162, 6317420, 6317421, 6317422, 6317423, 6317424, 6317425, 6322578, 6322579, 6322580, 6322581, 6322582, 6322583, 6322584, 6322585, 6330863, 6330864, 6330865, 6330866, 6330867, 6330868, 6330869, 6330870, 6330871, 6330872, 6330873, 6330874, 6330875, 6330876, 6330877, 6331275, 6331276, 6331334, 6331367, 6331488, 6331495, 6331496, 6331497, 6337398, 6337400, 6337401, 6337403, 6337404, 6343521, 6343522, 6343523, 6343524, 6343525, 6343526, 6343527, 6343528, 6343529, 6343530, 6343531, 6343532, 6343533, 6343534, 6343535, 6343537, 6356866, 6356867, 6356868, 6356869, 6356870, 6356871, 6356872, 6356873, 6357060, 6357061, 6357062, 6357063, 6357064, 6357065, 6357066, 6357067, 6357068, 6357069, 6357070, 6357071, 6357072, 6357073, 6357074, 6357075, 6358147, 6358148, 6358149, 6358150, 6358151, 6358152, 6358153, 6358154, 6379116, 6379117, 6379118, 6379119, 6379120, 6379121, 6379122, 6379123, 6387522, 6337399, 6337402, 6337405, 6398871, 6408321, 6414371, 6414372, 6414373, 6414374, 6414375, 6414376, 6414377, 6416475, 6416476, 6416477, 6416478, 6416479, 6416480, 6416481, 6416534, 6416535, 6416536, 6416537, 6416538, 6425780, 6425781, 6425782, 6425783, 6443725, 6443726, 6443727, 6443728, 6443729, 6443730, 6443731, 6451727, 6459222, 6459181, 6459182, 6459183, 6459184, 6459185, 6459186, 6459191, 6459192, 6459193, 6470203, 6470205, 6470206, 6470207, 6477089, 6505321, 6505322, 6505323, 6505324, 6505325, 6505326, 6505327, 6505328, 6546937, 6548325, 6548326, 6548327, 6548328, 6548329, 6548330, 6548331, 6552119, 6561030, 6561031, 6561032, 6567998, 6567999, 6579203, 6621675, 6621676, 6621677, 6621678, 6621679, 6621680, 6621681, 6621682, 6563584, 6680055, 6680056, 6680057, 6680478, 6680479, 6680480, 6680481, 6680482, 6680483, 6685789, 6807073, 6807074, 6807075, 6807076, 6807077, 6807078, 6807079, 6807080, 6830569, 6876675, 6876676, 6876677, 6876678, 6876679, 6876680, 6876681, 6876682, 6876683, 6876684, 6884945, 6884946, 6935486, 6935487, 6935488, 6935489, 6935490, 6935491, 6935492, 6935493, 6944521, 6973864, 6975215, 6975216, 6975217, 6975218, 6975219, 6975220, 6975221, 6991359, 6991360, 6991361, 6991362, 6991363, 6991364, 6991365, 6991366, 6991367, 6991368, 6991370, 6991371, 6991372, 6991373, 6991374, 6991375, 6991683, 6991684, 6991685, 6991686, 6991687, 6991688, 6991689, 6997385, 6997386, 6997387, 6997388, 6997389, 6997390, 6997391, 6997394, 6997499, 6997500, 6997501, 6997503, 6997504, 6997506, 6997508, 6997509, 6998655, 6998656, 6998657, 6998658, 6998659, 6998660, 6998661, 6998662, 6998663, 6998664, 6998665, 6998666, 6998667, 6998668, 6998669, 6998670, 7003004, 7003005, 7003006, 7003007, 7003008, 7003009, 7003010, 7003011, 7007954, 7007955, 7007956, 7007957, 7007958, 7007959, 7007960, 7007961, 7008046, 7008047, 7008049, 7008050, 7008051, 7008052, 7008053, 7008054, 7009849, 7009850, 7009851, 7009852, 7009853, 7009854, 7009855, 7009857, 7017949, 7017950, 7017951, 7017952, 7017953, 7017954, 7017955, 7019075, 7017948, 7019076, 7019077, 7019078, 7019079, 7019080, 7019081, 7019082, 7021862, 7021863, 7021864, 7021865, 7021866, 7021867, 7021868, 7021869, 7022167, 7022168, 7022169, 7022170, 7022171, 7022172, 7022173, 7022174, 7034756, 7034757, 7034758, 7034759, 7034760, 7034761, 7034762, 7034763, 7037380, 7037381, 7037382, 7037383, 7037384, 7037385, 7037386, 7037387, 7037988, 7037989, 7037990, 7037991, 7037992, 7037993, 7037994, 7037995, 7037289, 7042942, 7042943, 7042944, 7042945, 7042946, 7042947, 7042948, 7042949, 7047011, 7050174, 7050175, 7050176, 7050177, 7050178, 7050179, 7050180, 7050181, 7050488, 7050489, 7050490, 7050491, 7050492, 7050493, 7050494, 7052682, 7052683, 7052684, 7052685, 7052686, 7052687, 7052688, 7052689, 7060479, 7060480, 7060481, 7060482, 7060483, 7060484, 7060485, 7060486, 7080633, 7081968, 7081969, 7081970, 7081971, 7081972, 7081973, 7081974, 7082577, 7082578, 7082579, 7082580, 7082581, 7082582, 7082583, 7082584, 7082704, 7082705, 7082706, 7082707, 7082708, 7082709, 7082710, 7082711, 7097232, 7097233, 7097234, 7097235, 7097236, 7097237, 7097238, 7037294, 7037296, 7111557, 7111558, 7111559, 7111560, 7111561, 7111562, 7111563, 7111564) group by `varCity`) as `aggregate_table`
8.63ms/packages/Powerpanel/Performers/src/Controllers/PerformerController.php:218etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `varCity`, `varStateProvince`, count(fkeventGlcode) as event_count from `nq_events` where `fkeventGlcode` in (5704145, 5704146, 5704147, 5704148, 5704149, 5704150, 5704151, 5704152, 6212634, 6212635, 6212636, 6212637, 6212638, 6212639, 6212640, 6212641, 6212642, 6212643, 6212644, 6212645, 6212646, 6212647, 6212648, 6212649, 6228319, 6228320, 6228321, 6228322, 6228323, 6228324, 6228325, 6228326, 6228327, 6228328, 6228329, 6228330, 6228331, 6228332, 6228333, 6228334, 6233936, 6233937, 6233938, 6233939, 6233940, 6233941, 6233942, 6233943, 6237227, 6237228, 6237229, 6237230, 6237231, 6237232, 6237233, 6237234, 6255920, 6255968, 6256641, 6257066, 6257343, 6258132, 6258133, 6258134, 6258135, 6258136, 6258137, 6258138, 6258139, 6258400, 6260937, 6260938, 6260939, 6260940, 6260941, 6260942, 6260943, 6260944, 6261864, 6261865, 6266560, 6266561, 6266563, 6266564, 6266565, 6266566, 6266567, 6266568, 6277276, 6277277, 6277278, 6277279, 6277280, 6277281, 6277282, 6277283, 6278881, 6279024, 6279026, 6279027, 6279030, 6279031, 6279033, 6279035, 6279036, 6279037, 6279038, 6279039, 6279041, 6279042, 6279043, 6279044, 6281310, 6281311, 6281312, 6281314, 6281315, 6281316, 6281317, 6281318, 6282959, 6282960, 6282961, 6282962, 6282963, 6282964, 6282965, 6282966, 6282967, 6282968, 6282969, 6282970, 6282971, 6282972, 6282973, 6282974, 6282975, 6282976, 6282977, 6282978, 6282979, 6282980, 6282981, 6282982, 6282983, 6282984, 6282985, 6282986, 6282987, 6282988, 6282989, 6282990, 6287137, 6287138, 6287139, 6287140, 6287141, 6287142, 6287143, 6287144, 6293938, 6293940, 6293941, 6293945, 6293946, 6293948, 6293950, 6293952, 6299390, 6299439, 6299440, 6299441, 6299442, 6299443, 6299444, 6299445, 6308883, 6312042, 6312043, 6312044, 6312045, 6312046, 6312047, 6312048, 6312052, 6312053, 6312054, 6312055, 6312056, 6312057, 6312058, 6312066, 6317161, 6317162, 6317420, 6317421, 6317422, 6317423, 6317424, 6317425, 6322578, 6322579, 6322580, 6322581, 6322582, 6322583, 6322584, 6322585, 6330863, 6330864, 6330865, 6330866, 6330867, 6330868, 6330869, 6330870, 6330871, 6330872, 6330873, 6330874, 6330875, 6330876, 6330877, 6331275, 6331276, 6331334, 6331367, 6331488, 6331495, 6331496, 6331497, 6337398, 6337400, 6337401, 6337403, 6337404, 6343521, 6343522, 6343523, 6343524, 6343525, 6343526, 6343527, 6343528, 6343529, 6343530, 6343531, 6343532, 6343533, 6343534, 6343535, 6343537, 6356866, 6356867, 6356868, 6356869, 6356870, 6356871, 6356872, 6356873, 6357060, 6357061, 6357062, 6357063, 6357064, 6357065, 6357066, 6357067, 6357068, 6357069, 6357070, 6357071, 6357072, 6357073, 6357074, 6357075, 6358147, 6358148, 6358149, 6358150, 6358151, 6358152, 6358153, 6358154, 6379116, 6379117, 6379118, 6379119, 6379120, 6379121, 6379122, 6379123, 6387522, 6337399, 6337402, 6337405, 6398871, 6408321, 6414371, 6414372, 6414373, 6414374, 6414375, 6414376, 6414377, 6416475, 6416476, 6416477, 6416478, 6416479, 6416480, 6416481, 6416534, 6416535, 6416536, 6416537, 6416538, 6425780, 6425781, 6425782, 6425783, 6443725, 6443726, 6443727, 6443728, 6443729, 6443730, 6443731, 6451727, 6459222, 6459181, 6459182, 6459183, 6459184, 6459185, 6459186, 6459191, 6459192, 6459193, 6470203, 6470205, 6470206, 6470207, 6477089, 6505321, 6505322, 6505323, 6505324, 6505325, 6505326, 6505327, 6505328, 6546937, 6548325, 6548326, 6548327, 6548328, 6548329, 6548330, 6548331, 6552119, 6561030, 6561031, 6561032, 6567998, 6567999, 6579203, 6621675, 6621676, 6621677, 6621678, 6621679, 6621680, 6621681, 6621682, 6563584, 6680055, 6680056, 6680057, 6680478, 6680479, 6680480, 6680481, 6680482, 6680483, 6685789, 6807073, 6807074, 6807075, 6807076, 6807077, 6807078, 6807079, 6807080, 6830569, 6876675, 6876676, 6876677, 6876678, 6876679, 6876680, 6876681, 6876682, 6876683, 6876684, 6884945, 6884946, 6935486, 6935487, 6935488, 6935489, 6935490, 6935491, 6935492, 6935493, 6944521, 6973864, 6975215, 6975216, 6975217, 6975218, 6975219, 6975220, 6975221, 6991359, 6991360, 6991361, 6991362, 6991363, 6991364, 6991365, 6991366, 6991367, 6991368, 6991370, 6991371, 6991372, 6991373, 6991374, 6991375, 6991683, 6991684, 6991685, 6991686, 6991687, 6991688, 6991689, 6997385, 6997386, 6997387, 6997388, 6997389, 6997390, 6997391, 6997394, 6997499, 6997500, 6997501, 6997503, 6997504, 6997506, 6997508, 6997509, 6998655, 6998656, 6998657, 6998658, 6998659, 6998660, 6998661, 6998662, 6998663, 6998664, 6998665, 6998666, 6998667, 6998668, 6998669, 6998670, 7003004, 7003005, 7003006, 7003007, 7003008, 7003009, 7003010, 7003011, 7007954, 7007955, 7007956, 7007957, 7007958, 7007959, 7007960, 7007961, 7008046, 7008047, 7008049, 7008050, 7008051, 7008052, 7008053, 7008054, 7009849, 7009850, 7009851, 7009852, 7009853, 7009854, 7009855, 7009857, 7017949, 7017950, 7017951, 7017952, 7017953, 7017954, 7017955, 7019075, 7017948, 7019076, 7019077, 7019078, 7019079, 7019080, 7019081, 7019082, 7021862, 7021863, 7021864, 7021865, 7021866, 7021867, 7021868, 7021869, 7022167, 7022168, 7022169, 7022170, 7022171, 7022172, 7022173, 7022174, 7034756, 7034757, 7034758, 7034759, 7034760, 7034761, 7034762, 7034763, 7037380, 7037381, 7037382, 7037383, 7037384, 7037385, 7037386, 7037387, 7037988, 7037989, 7037990, 7037991, 7037992, 7037993, 7037994, 7037995, 7037289, 7042942, 7042943, 7042944, 7042945, 7042946, 7042947, 7042948, 7042949, 7047011, 7050174, 7050175, 7050176, 7050177, 7050178, 7050179, 7050180, 7050181, 7050488, 7050489, 7050490, 7050491, 7050492, 7050493, 7050494, 7052682, 7052683, 7052684, 7052685, 7052686, 7052687, 7052688, 7052689, 7060479, 7060480, 7060481, 7060482, 7060483, 7060484, 7060485, 7060486, 7080633, 7081968, 7081969, 7081970, 7081971, 7081972, 7081973, 7081974, 7082577, 7082578, 7082579, 7082580, 7082581, 7082582, 7082583, 7082584, 7082704, 7082705, 7082706, 7082707, 7082708, 7082709, 7082710, 7082711, 7097232, 7097233, 7097234, 7097235, 7097236, 7097237, 7097238, 7037294, 7037296, 7111557, 7111558, 7111559, 7111560, 7111561, 7111562, 7111563, 7111564) group by `varCity` order by `event_count` desc limit 12 offset 0
8.03ms/packages/Powerpanel/Performers/src/Controllers/PerformerController.php:218etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `fkeventGlcode`, `VarDisplayDate`, `varTitle`, `intParentCatId`, `intChildCatId`, `intGrandChildCatId`, `varStateProvince`, `varticketsAvailable`, `varPrice`, `intStateProvinceID`, `varCity`, `varVenue`, `intVenueConfigurationID`, `intVenueID`, `dtEventDate`, `intCountryID` from `nq_events` where (`chrDelete` = 'N') and `fkeventGlcode` in (5704145, 5704146, 5704147, 5704148, 5704149, 5704150, 5704151, 5704152, 6212634, 6212635, 6212636, 6212637, 6212638, 6212639, 6212640, 6212641, 6212642, 6212643, 6212644, 6212645, 6212646, 6212647, 6212648, 6212649, 6228319, 6228320, 6228321, 6228322, 6228323, 6228324, 6228325, 6228326, 6228327, 6228328, 6228329, 6228330, 6228331, 6228332, 6228333, 6228334, 6233936, 6233937, 6233938, 6233939, 6233940, 6233941, 6233942, 6233943, 6237227, 6237228, 6237229, 6237230, 6237231, 6237232, 6237233, 6237234, 6255920, 6255968, 6256641, 6257066, 6257343, 6258132, 6258133, 6258134, 6258135, 6258136, 6258137, 6258138, 6258139, 6258400, 6260937, 6260938, 6260939, 6260940, 6260941, 6260942, 6260943, 6260944, 6261864, 6261865, 6266560, 6266561, 6266563, 6266564, 6266565, 6266566, 6266567, 6266568, 6277276, 6277277, 6277278, 6277279, 6277280, 6277281, 6277282, 6277283, 6278881, 6279024, 6279026, 6279027, 6279030, 6279031, 6279033, 6279035, 6279036, 6279037, 6279038, 6279039, 6279041, 6279042, 6279043, 6279044, 6281310, 6281311, 6281312, 6281314, 6281315, 6281316, 6281317, 6281318, 6282959, 6282960, 6282961, 6282962, 6282963, 6282964, 6282965, 6282966, 6282967, 6282968, 6282969, 6282970, 6282971, 6282972, 6282973, 6282974, 6282975, 6282976, 6282977, 6282978, 6282979, 6282980, 6282981, 6282982, 6282983, 6282984, 6282985, 6282986, 6282987, 6282988, 6282989, 6282990, 6287137, 6287138, 6287139, 6287140, 6287141, 6287142, 6287143, 6287144, 6293938, 6293940, 6293941, 6293945, 6293946, 6293948, 6293950, 6293952, 6299390, 6299439, 6299440, 6299441, 6299442, 6299443, 6299444, 6299445, 6308883, 6312042, 6312043, 6312044, 6312045, 6312046, 6312047, 6312048, 6312052, 6312053, 6312054, 6312055, 6312056, 6312057, 6312058, 6312066, 6317161, 6317162, 6317420, 6317421, 6317422, 6317423, 6317424, 6317425, 6322578, 6322579, 6322580, 6322581, 6322582, 6322583, 6322584, 6322585, 6330863, 6330864, 6330865, 6330866, 6330867, 6330868, 6330869, 6330870, 6330871, 6330872, 6330873, 6330874, 6330875, 6330876, 6330877, 6331275, 6331276, 6331334, 6331367, 6331488, 6331495, 6331496, 6331497, 6337398, 6337400, 6337401, 6337403, 6337404, 6343521, 6343522, 6343523, 6343524, 6343525, 6343526, 6343527, 6343528, 6343529, 6343530, 6343531, 6343532, 6343533, 6343534, 6343535, 6343537, 6356866, 6356867, 6356868, 6356869, 6356870, 6356871, 6356872, 6356873, 6357060, 6357061, 6357062, 6357063, 6357064, 6357065, 6357066, 6357067, 6357068, 6357069, 6357070, 6357071, 6357072, 6357073, 6357074, 6357075, 6358147, 6358148, 6358149, 6358150, 6358151, 6358152, 6358153, 6358154, 6379116, 6379117, 6379118, 6379119, 6379120, 6379121, 6379122, 6379123, 6387522, 6337399, 6337402, 6337405, 6398871, 6408321, 6414371, 6414372, 6414373, 6414374, 6414375, 6414376, 6414377, 6416475, 6416476, 6416477, 6416478, 6416479, 6416480, 6416481, 6416534, 6416535, 6416536, 6416537, 6416538, 6425780, 6425781, 6425782, 6425783, 6443725, 6443726, 6443727, 6443728, 6443729, 6443730, 6443731, 6451727, 6459222, 6459181, 6459182, 6459183, 6459184, 6459185, 6459186, 6459191, 6459192, 6459193, 6470203, 6470205, 6470206, 6470207, 6477089, 6505321, 6505322, 6505323, 6505324, 6505325, 6505326, 6505327, 6505328, 6546937, 6548325, 6548326, 6548327, 6548328, 6548329, 6548330, 6548331, 6552119, 6561030, 6561031, 6561032, 6567998, 6567999, 6579203, 6621675, 6621676, 6621677, 6621678, 6621679, 6621680, 6621681, 6621682, 6563584, 6680055, 6680056, 6680057, 6680478, 6680479, 6680480, 6680481, 6680482, 6680483, 6685789, 6807073, 6807074, 6807075, 6807076, 6807077, 6807078, 6807079, 6807080, 6830569, 6876675, 6876676, 6876677, 6876678, 6876679, 6876680, 6876681, 6876682, 6876683, 6876684, 6884945, 6884946, 6935486, 6935487, 6935488, 6935489, 6935490, 6935491, 6935492, 6935493, 6944521, 6973864, 6975215, 6975216, 6975217, 6975218, 6975219, 6975220, 6975221, 6991359, 6991360, 6991361, 6991362, 6991363, 6991364, 6991365, 6991366, 6991367, 6991368, 6991370, 6991371, 6991372, 6991373, 6991374, 6991375, 6991683, 6991684, 6991685, 6991686, 6991687, 6991688, 6991689, 6997385, 6997386, 6997387, 6997388, 6997389, 6997390, 6997391, 6997394, 6997499, 6997500, 6997501, 6997503, 6997504, 6997506, 6997508, 6997509, 6998655, 6998656, 6998657, 6998658, 6998659, 6998660, 6998661, 6998662, 6998663, 6998664, 6998665, 6998666, 6998667, 6998668, 6998669, 6998670, 7003004, 7003005, 7003006, 7003007, 7003008, 7003009, 7003010, 7003011, 7007954, 7007955, 7007956, 7007957, 7007958, 7007959, 7007960, 7007961, 7008046, 7008047, 7008049, 7008050, 7008051, 7008052, 7008053, 7008054, 7009849, 7009850, 7009851, 7009852, 7009853, 7009854, 7009855, 7009857, 7017949, 7017950, 7017951, 7017952, 7017953, 7017954, 7017955, 7019075, 7017948, 7019076, 7019077, 7019078, 7019079, 7019080, 7019081, 7019082, 7021862, 7021863, 7021864, 7021865, 7021866, 7021867, 7021868, 7021869, 7022167, 7022168, 7022169, 7022170, 7022171, 7022172, 7022173, 7022174, 7034756, 7034757, 7034758, 7034759, 7034760, 7034761, 7034762, 7034763, 7037380, 7037381, 7037382, 7037383, 7037384, 7037385, 7037386, 7037387, 7037988, 7037989, 7037990, 7037991, 7037992, 7037993, 7037994, 7037995, 7037289, 7042942, 7042943, 7042944, 7042945, 7042946, 7042947, 7042948, 7042949, 7047011, 7050174, 7050175, 7050176, 7050177, 7050178, 7050179, 7050180, 7050181, 7050488, 7050489, 7050490, 7050491, 7050492, 7050493, 7050494, 7052682, 7052683, 7052684, 7052685, 7052686, 7052687, 7052688, 7052689, 7060479, 7060480, 7060481, 7060482, 7060483, 7060484, 7060485, 7060486, 7080633, 7081968, 7081969, 7081970, 7081971, 7081972, 7081973, 7081974, 7082577, 7082578, 7082579, 7082580, 7082581, 7082582, 7082583, 7082584, 7082704, 7082705, 7082706, 7082707, 7082708, 7082709, 7082710, 7082711, 7097232, 7097233, 7097234, 7097235, 7097236, 7097237, 7097238, 7037294, 7037296, 7111557, 7111558, 7111559, 7111560, 7111561, 7111562, 7111563, 7111564) and date(`dtEventDate`) >= '2025-04-26' order by `dtEventDate` asc limit 12
8.25ms/app/Events.php:380etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `nq_events` where `dtEventDate` between '2025-04-26 19:09:49' and '2025-12-31 23:59:59' and (`chrDelete` = 'N') and `fkeventGlcode` in (5704145, 5704146, 5704147, 5704148, 5704149, 5704150, 5704151, 5704152, 6212634, 6212635, 6212636, 6212637, 6212638, 6212639, 6212640, 6212641, 6212642, 6212643, 6212644, 6212645, 6212646, 6212647, 6212648, 6212649, 6228319, 6228320, 6228321, 6228322, 6228323, 6228324, 6228325, 6228326, 6228327, 6228328, 6228329, 6228330, 6228331, 6228332, 6228333, 6228334, 6233936, 6233937, 6233938, 6233939, 6233940, 6233941, 6233942, 6233943, 6237227, 6237228, 6237229, 6237230, 6237231, 6237232, 6237233, 6237234, 6255920, 6255968, 6256641, 6257066, 6257343, 6258132, 6258133, 6258134, 6258135, 6258136, 6258137, 6258138, 6258139, 6258400, 6260937, 6260938, 6260939, 6260940, 6260941, 6260942, 6260943, 6260944, 6261864, 6261865, 6266560, 6266561, 6266563, 6266564, 6266565, 6266566, 6266567, 6266568, 6277276, 6277277, 6277278, 6277279, 6277280, 6277281, 6277282, 6277283, 6278881, 6279024, 6279026, 6279027, 6279030, 6279031, 6279033, 6279035, 6279036, 6279037, 6279038, 6279039, 6279041, 6279042, 6279043, 6279044, 6281310, 6281311, 6281312, 6281314, 6281315, 6281316, 6281317, 6281318, 6282959, 6282960, 6282961, 6282962, 6282963, 6282964, 6282965, 6282966, 6282967, 6282968, 6282969, 6282970, 6282971, 6282972, 6282973, 6282974, 6282975, 6282976, 6282977, 6282978, 6282979, 6282980, 6282981, 6282982, 6282983, 6282984, 6282985, 6282986, 6282987, 6282988, 6282989, 6282990, 6287137, 6287138, 6287139, 6287140, 6287141, 6287142, 6287143, 6287144, 6293938, 6293940, 6293941, 6293945, 6293946, 6293948, 6293950, 6293952, 6299390, 6299439, 6299440, 6299441, 6299442, 6299443, 6299444, 6299445, 6308883, 6312042, 6312043, 6312044, 6312045, 6312046, 6312047, 6312048, 6312052, 6312053, 6312054, 6312055, 6312056, 6312057, 6312058, 6312066, 6317161, 6317162, 6317420, 6317421, 6317422, 6317423, 6317424, 6317425, 6322578, 6322579, 6322580, 6322581, 6322582, 6322583, 6322584, 6322585, 6330863, 6330864, 6330865, 6330866, 6330867, 6330868, 6330869, 6330870, 6330871, 6330872, 6330873, 6330874, 6330875, 6330876, 6330877, 6331275, 6331276, 6331334, 6331367, 6331488, 6331495, 6331496, 6331497, 6337398, 6337400, 6337401, 6337403, 6337404, 6343521, 6343522, 6343523, 6343524, 6343525, 6343526, 6343527, 6343528, 6343529, 6343530, 6343531, 6343532, 6343533, 6343534, 6343535, 6343537, 6356866, 6356867, 6356868, 6356869, 6356870, 6356871, 6356872, 6356873, 6357060, 6357061, 6357062, 6357063, 6357064, 6357065, 6357066, 6357067, 6357068, 6357069, 6357070, 6357071, 6357072, 6357073, 6357074, 6357075, 6358147, 6358148, 6358149, 6358150, 6358151, 6358152, 6358153, 6358154, 6379116, 6379117, 6379118, 6379119, 6379120, 6379121, 6379122, 6379123, 6387522, 6337399, 6337402, 6337405, 6398871, 6408321, 6414371, 6414372, 6414373, 6414374, 6414375, 6414376, 6414377, 6416475, 6416476, 6416477, 6416478, 6416479, 6416480, 6416481, 6416534, 6416535, 6416536, 6416537, 6416538, 6425780, 6425781, 6425782, 6425783, 6443725, 6443726, 6443727, 6443728, 6443729, 6443730, 6443731, 6451727, 6459222, 6459181, 6459182, 6459183, 6459184, 6459185, 6459186, 6459191, 6459192, 6459193, 6470203, 6470205, 6470206, 6470207, 6477089, 6505321, 6505322, 6505323, 6505324, 6505325, 6505326, 6505327, 6505328, 6546937, 6548325, 6548326, 6548327, 6548328, 6548329, 6548330, 6548331, 6552119, 6561030, 6561031, 6561032, 6567998, 6567999, 6579203, 6621675, 6621676, 6621677, 6621678, 6621679, 6621680, 6621681, 6621682, 6563584, 6680055, 6680056, 6680057, 6680478, 6680479, 6680480, 6680481, 6680482, 6680483, 6685789, 6807073, 6807074, 6807075, 6807076, 6807077, 6807078, 6807079, 6807080, 6830569, 6876675, 6876676, 6876677, 6876678, 6876679, 6876680, 6876681, 6876682, 6876683, 6876684, 6884945, 6884946, 6935486, 6935487, 6935488, 6935489, 6935490, 6935491, 6935492, 6935493, 6944521, 6973864, 6975215, 6975216, 6975217, 6975218, 6975219, 6975220, 6975221, 6991359, 6991360, 6991361, 6991362, 6991363, 6991364, 6991365, 6991366, 6991367, 6991368, 6991370, 6991371, 6991372, 6991373, 6991374, 6991375, 6991683, 6991684, 6991685, 6991686, 6991687, 6991688, 6991689, 6997385, 6997386, 6997387, 6997388, 6997389, 6997390, 6997391, 6997394, 6997499, 6997500, 6997501, 6997503, 6997504, 6997506, 6997508, 6997509, 6998655, 6998656, 6998657, 6998658, 6998659, 6998660, 6998661, 6998662, 6998663, 6998664, 6998665, 6998666, 6998667, 6998668, 6998669, 6998670, 7003004, 7003005, 7003006, 7003007, 7003008, 7003009, 7003010, 7003011, 7007954, 7007955, 7007956, 7007957, 7007958, 7007959, 7007960, 7007961, 7008046, 7008047, 7008049, 7008050, 7008051, 7008052, 7008053, 7008054, 7009849, 7009850, 7009851, 7009852, 7009853, 7009854, 7009855, 7009857, 7017949, 7017950, 7017951, 7017952, 7017953, 7017954, 7017955, 7019075, 7017948, 7019076, 7019077, 7019078, 7019079, 7019080, 7019081, 7019082, 7021862, 7021863, 7021864, 7021865, 7021866, 7021867, 7021868, 7021869, 7022167, 7022168, 7022169, 7022170, 7022171, 7022172, 7022173, 7022174, 7034756, 7034757, 7034758, 7034759, 7034760, 7034761, 7034762, 7034763, 7037380, 7037381, 7037382, 7037383, 7037384, 7037385, 7037386, 7037387, 7037988, 7037989, 7037990, 7037991, 7037992, 7037993, 7037994, 7037995, 7037289, 7042942, 7042943, 7042944, 7042945, 7042946, 7042947, 7042948, 7042949, 7047011, 7050174, 7050175, 7050176, 7050177, 7050178, 7050179, 7050180, 7050181, 7050488, 7050489, 7050490, 7050491, 7050492, 7050493, 7050494, 7052682, 7052683, 7052684, 7052685, 7052686, 7052687, 7052688, 7052689, 7060479, 7060480, 7060481, 7060482, 7060483, 7060484, 7060485, 7060486, 7080633, 7081968, 7081969, 7081970, 7081971, 7081972, 7081973, 7081974, 7082577, 7082578, 7082579, 7082580, 7082581, 7082582, 7082583, 7082584, 7082704, 7082705, 7082706, 7082707, 7082708, 7082709, 7082710, 7082711, 7097232, 7097233, 7097234, 7097235, 7097236, 7097237, 7097238, 7037294, 7037296, 7111557, 7111558, 7111559, 7111560, 7111561, 7111562, 7111563, 7111564) and date(`dtEventDate`) >= '2025-04-26'
7.59ms/app/Events.php:338etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from (select `nq_peformers`.`intCategoryId`, `nq_peformers`.`varTitle`, `nq_peformers`.`intAliasId` from `nq_peformers` where `nq_peformers`.`chrPublish` = 'Y' and `nq_peformers`.`chrDelete` = 'N' and `nq_peformers`.`intParentCatId` = 'KY' and `nq_peformers`.`intChildCatId` = 29390 and `nq_peformers`.`total_count` != 0 group by `nq_peformers`.`id`) as `aggregate_table`
1.25ms/packages/Powerpanel/Performers/src/Models/Performers.php:202etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intAliasId`, `varTitle`, `txtDescription`, `fkIntImgId`, `intCategoryId`, `intParentCatId`, `intChildCatId` from `nq_peformers` where `chrPublish` = 'Y' and `chrDelete` = 'N' and `intAliasId` = 29390 limit 1
1.08ms/packages/Powerpanel/Performers/src/Models/Performers.php:1299etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 3 limit 1
990μs/packages/Powerpanel/Categories/src/Models/Categories.php:962etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `varTitle`, `intCategoryId` from `nq_categories` where `intCategoryId` = 38 and `intParentCategoryId` = 3 limit 1
1.09ms/packages/Powerpanel/Categories/src/Models/Categories.php:975etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'San Francisco') and (`varStateProvince` = 'CA') limit 1
1.57ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 100871 and `chrIsPreview` = 'N' limit 1
1.11ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Chicago') and (`varStateProvince` = 'IL') limit 1
1.8ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101237 and `chrIsPreview` = 'N' limit 1
980μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Cleveland') and (`varStateProvince` = 'OH') limit 1
2.28ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 102067 and `chrIsPreview` = 'N' limit 1
990μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Washington') and (`varStateProvince` = 'DC') limit 1
1.58ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 100996 and `chrIsPreview` = 'N' limit 1
960μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Denver') and (`varStateProvince` = 'CO') limit 1
1.48ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 100941 and `chrIsPreview` = 'N' limit 1
1.04ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Cincinnati') and (`varStateProvince` = 'OH') limit 1
2.3ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 102066 and `chrIsPreview` = 'N' limit 1
960μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Dallas') and (`varStateProvince` = 'TX') limit 1
2.62ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 102392 and `chrIsPreview` = 'N' limit 1
1.27ms/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Boston') and (`varStateProvince` = 'MA') limit 1
2.07ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101437 and `chrIsPreview` = 'N' limit 1
950μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Detroit') and (`varStateProvince` = 'MI') limit 1
1.98ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101548 and `chrIsPreview` = 'N' limit 1
900μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Costa Mesa') and (`varStateProvince` = 'CA') limit 1
1.39ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 100763 and `chrIsPreview` = 'N' limit 1
920μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'Philadelphia') and (`varStateProvince` = 'PA') limit 1
1.62ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 102245 and `chrIsPreview` = 'N' limit 1
860μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `intAliasId` from `nq_city` where (`chrDelete` = 'N') and (`chrPublish` = 'Y') and (`varTitle` = 'St. Louis') and (`varStateProvince` = 'MO') limit 1
1.38ms/app/City.php:65etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `id`, `intFkModuleCode`, `varAlias` from `nq_alias` where `id` = 101673 and `chrIsPreview` = 'N' limit 1
850μs/app/Alias.php:62etickets_liveMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
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.05ms/packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
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')
950μs/packages/Powerpanel/ContactInfo/src/Models/ContactInfo.php:111etickets_liveMetadata | |
---|---|
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array: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 => "18.188.193.228" ] "x-real-ip" => array:1 [▶ 0 => "18.188.193.228" ] "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 => "" ] ]
0 of 0array: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" => "18.188.193.228" "HTTP_X_REAL_IP" => "18.188.193.228" "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" => "-71.1028" "GEOIP_LATITUDE" => "42.3646" "GEOIP_CITY_CONTINENT_CODE" => "NA" "GEOIP_POSTAL_CODE" => "02139" "GEOIP_CITY" => "Cambridge" "GEOIP_REGION" => "MA" "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" => "18.188.193.228" "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" => "/performers/juliet-musical-tickets" "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" => 1745712589.111 "REQUEST_TIME" => 1745712589 ]
[]
0 of 0array:7 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "private, must-revalidate" ] "date" => array:1 [▶ 0 => "Sun, 27 Apr 2025 00:09:49 GMT" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "expires" => array:1 [▶ 0 => "-1" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklmTExjbUNGUFRXR3h2WGk4cVJoekE9PSIsInZhbHVlIjoiTThjV0djUHhWMDV3Tm8yaTVnRzdMMEoydVlMaDlNMjJ3Q09EaDhhdnErdGMzTWJ3Qk9FSkwrS1dxWjgrYlZZRXBQclJMTDFFQ1BxZnVOU3ltc2dkempVR3pGSWJvamZjQWJwMDZ5VERFSEJpM3RHRStPa2N2V3JkbHkyaTRhZEEiLCJtYWMiOiIwMTgxNGE5NjdjOWI4MGRmMmFhNTFiOGQ5MmU2MDY4ZmUyMjkzY2Y3NWY1MmRiMzdlZTA3MTBlYzI0YjFhOGM4IiwidGFnIjoiIn0%3D; expires=Sun, 27 Apr 2025 02:09:49 GMT; Max-Age=7200; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IklmTExjbUNGUFRXR3h2WGk4cVJoekE9PSIsInZhbHVlIjoiTThjV0djUHhWMDV3Tm8yaTVnRzdMMEoydVlMaDlNMjJ3Q09EaDhhdnErdGMzTWJ3Qk9FSkwrS1dxWjgrYlZZRXBQclJMT ▶" 1 => "recently_viewed=17TcW34Al0eZtVUnh9EF; expires=Mon, 28 Apr 2025 00:09:49 GMT; Max-Age=86400; path=/; secure; httponly" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IklmTExjbUNGUFRXR3h2WGk4cVJoekE9PSIsInZhbHVlIjoiTThjV0djUHhWMDV3Tm8yaTVnRzdMMEoydVlMaDlNMjJ3Q09EaDhhdnErdGMzTWJ3Qk9FSkwrS1dxWjgrYlZZRXBQclJMTDFFQ1BxZnVOU3ltc2dkempVR3pGSWJvamZjQWJwMDZ5VERFSEJpM3RHRStPa2N2V3JkbHkyaTRhZEEiLCJtYWMiOiIwMTgxNGE5NjdjOWI4MGRmMmFhNTFiOGQ5MmU2MDY4ZmUyMjkzY2Y3NWY1MmRiMzdlZTA3MTBlYzI0YjFhOGM4IiwidGFnIjoiIn0%3D; expires=Sun, 27-Apr-2025 02:09:49 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IklmTExjbUNGUFRXR3h2WGk4cVJoekE9PSIsInZhbHVlIjoiTThjV0djUHhWMDV3Tm8yaTVnRzdMMEoydVlMaDlNMjJ3Q09EaDhhdnErdGMzTWJ3Qk9FSkwrS1dxWjgrYlZZRXBQclJMT ▶" 1 => "recently_viewed=17TcW34Al0eZtVUnh9EF; expires=Mon, 28-Apr-2025 00:09:49 GMT; path=/; secure; httponly" ] ]
0 of 0array:2 [▼ "_token" => "3hrsVfzudtO9lUBqGWis4Ucy22k66QVIQ5vcqM0z" "PHPDEBUGBAR_STACK_DATA" => [] ]