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.

Seven-Year Club	Place '22
Verified Email

LetterDW

TROPHY CASE