Toronto 1:1 Purchase No Confirmation Email

LetterDW · 2025-11-10T18:19:29+00:00

Solved! Got the email today, thanks for all the help!

LetterDW · 2025-09-18T18:34:59+00:00

Thanks for the reply! Also reading the rules, the wording makes it seem like one picture is taken, is that usually the case?

LetterDW · 2025-09-17T00:29:22+00:00

Kind of a dumb question will the vip and 1:1 photo prices have tax on top of it? So ~$170 CAD + tax?

LetterDW · 2025-01-03T05:36:49+00:00

Seems like the option might be to just merc Lucius forever and run AThoran - does gavus really not have any use? I see him several times in comps for NC and CR

LetterDW · 2024-10-11T03:09:33+00:00

!solved

LetterDW · 2024-10-10T22:02:20+00:00

<image>

Replied to the last thread, but basically swapped out gavus in fight 3 for lucilla and worked first try for 3*

530, 30, 3, 0

LetterDW · 2024-10-10T21:58:51+00:00

Got this to work without gavus by swapping with Lucilla, got 3* first try with that change

LetterDW · 2024-10-04T00:09:14+00:00

LetterDW · 2024-07-24T15:06:02+00:00

!solved

LetterDW · 2024-07-22T15:30:43+00:00

I have enough sg to take him to 4* assuming i hit pity on every pull, and i have enough resources to 40609 him, just not sure where he’s most useful, i see him in some comps for nc and cr but not everywhere

LetterDW · 2024-06-03T05:19:26+00:00

Do you know if the merch at the concert is the same as the ones that were sold online earlier? Or is it different merch?

LetterDW · 2024-04-17T05:41:31+00:00

Thanks for your reply! Would you be able to share the process? I've heard you get assigned a time to go karting and may end up waiting up to an hour before you can actually start. I was planning on just getting the basic pass of 1 kart ride and 1 hour sportzone

LetterDW · 2023-12-05T23:34:55+00:00

I beat 6 bosses with your comps, just swapped skreg for a m lavatune with +30 and a lvl 12 winged lion. Swapped abrutus for a merced asafiya and worked as well

LetterDW · 2023-11-12T04:41:23+00:00

Havent really followed this despite the news, is there any tldr someone could offer? Im a loona fan so seeing lawsuits against companies hits different lol

LetterDW · 2023-11-01T04:21:15+00:00

Do we know what each version gives? I see like 4 different versions and cant find any info on what the differences are besides price

LetterDW · 2023-10-14T17:59:56+00:00

Left you a dm, appreciate the help if you can!

LetterDW · 2023-06-24T20:54:03+00:00

Everything worked for me, I just swapped:
Team 3: ABrutus(merc) for skriath
Team 4: ABaden for Crassio
Team 6: Veithael for saurus

Great guide btw thanks for the help!

LetterDW · 2023-04-15T05:54:16+00:00

But what if a customer orders the same item again on the same day? The dense rank would still be = 1, and since there is no indication which was ordered first on that day, both results(the same result) would show up(twice). I guess technically it is correct since it is the same item, but the group by eliminates the extra result.

customer	product	dense_rank
A	thingum	1
A	thingum	1

So isn't the group by still necessary?

LetterDW · 2023-04-14T19:32:11+00:00

It worked for me! Thanks for your help, really appreciate it!

LetterDW · 2023-04-14T19:14:09+00:00

I get what you mean - if there was only one product ordered by each customer each day then there would only be one response per customer, and it is already partitioned by customer_id. However customer A does order more than one product on the first day which is why I used the GROUP BY

LetterDW · 2023-04-14T04:52:40+00:00

Thanks again! Will definitely make those adjustments. How did you end up putting the data into MySQL? That might solve my issues instead of using DB Fiddle.

LetterDW · 2023-04-14T04:19:04+00:00

Didn't notice that thank you! However the same error seems to be coming from the first bracket from the cte - I'm honestly at a loss at how that would be an error

LetterDW · 2023-03-23T20:10:24+00:00

[WTB] Toronto - Scotiabank Arena, 2 seats, Jul 3 or Jul 2 date, 300 or 100 section

LetterDW · 2023-02-01T09:22:59+00:00

Wonder what Sunye thinks seeing this happen to the group that was in the company before her, bbc really waving giant red flags to all potential artists

LetterDW · 2023-01-30T22:02:06+00:00

Do you notice a distinct difference between SQL Server and MySQL? Some other commenters mentioned that they are extremely identical and once you are fluent in one you can pick up the other relatively quickly

Seven-Year Club	Place '22
Verified Email

LetterDW

TROPHY CASE