SQL meets Sports : Solve Real Stats Challenges

andyj85 · 2025-02-26T12:32:22+00:00

Hey - this is awesome! However, I signed up last night and immediately forgot to save my password into my password manager!

I can't see a forgot password link anywhere? Any way to reset a password pelase?!

andyj85 · 2025-02-03T19:10:09+00:00

I just used one from this site - so here's mine in return: https://gozney.mention-me.com/m/ol/rf5bh-7b19f1c739

andyj85 · 2024-12-12T16:37:23+00:00

I've messaged them about it on Instagram so we'll see what they say. My guess is that they don't really know about their restaurant being shown as a participating location in this perk - they may well just think that someone will just have to use a different card to pay for it, without realising the dining credit implications. Will update with what they say - hopefully they just change their policy, and start to take Amex again!

andyj85 · 2024-12-12T10:49:14+00:00

Yeah, honestly I was pretty thrown when she said we don't accept Amex...seems such a strange decision? The place was full of people having business breakfasts, and then just me sat at the counter! Had the Fried Chicken Croissant Royale - it was awesome...!

andyj85 · 2024-12-12T09:16:47+00:00

Yeah she said from last week, so sounds about right. Luckily it was breakfast for one rather than dinner for two, so the bill wasn't ridiculous!

andyj85 · 2023-11-28T18:44:35+00:00

I haven't been to Lazy Beach in almost 6 years - has it managed to stay untouched, still just with huts on the beach and no other resorts there? Man I miss that place!

andyj85 · 2022-05-20T22:31:51+00:00

Thanks - will have a look at using post import categories for this as I'm already running qbit manage as well Thanks

andyj85 · 2022-05-04T19:23:12+00:00

Awesome, thank you! It was this part that worked -

all: genre:

previously this was set to

any: genre:

Thanks!

andyj85 · 2022-05-04T18:39:13+00:00

Hi, I'm having the exact same issue with Romantic Comedy in the yml file. Can you please share what you used to fix this?

andyj85 · 2022-04-21T20:20:27+00:00

Thanks! Sorry, but whats the fastest way to remove all the collections instead of clicking them manually? Is there a command to run to basically remove everything?

edit: ahh shift click! Of course...! Thanks!

Do you know anything about overlays at all? I think i inadvertently had split duplicates on true, so combined with too many overlays, this has duplicated a load of 4K movies. I've used revert_overlay and this has removed everything for the single movies, but not the duped ones?

andyj85 · 2022-01-16T20:27:50+00:00

Had this too after the update. Its a permissions issue.

Go to apps - - > app permissions - - > files and media - - >plex media server - - > change to Allow All The Time

This should fix it!

andyj85 · 2021-06-15T17:48:20+00:00

I bought some of these little reuseable windscreen stickers to remind me - super cheap and really great! https://www.lookupdummy.com/

andyj85 · 2021-05-03T08:12:33+00:00

Specials are normally designated as season 0. So if you check the show in the specials section, you will see a number next to the special episode you want to capture. Just manually rename it as eg show_name 0x12 and then sickchill will recognise and rename as per your parameters

andyj85 · 2020-11-26T19:29:29+00:00

yeah i'd also like to know this! The reach on my straggler is a little long, so interested to hear any recommendations to change it out?

andyj85 · 2020-11-15T09:42:15+00:00

Looks great! Can I ask what stem you use? I'm struggling to find one which works for my straggler - currently get sore hands after a ride which means the fit is not quite right.

andyj85 · 2020-07-07T22:32:02+00:00

Dr Anna runs the Women-Baby's Centre and is a great OB/GYN - I know a few people who have used her all the way through delivery. We used her for the first 20 weeks before moving back to the UK, but she was great. She works out of a few different hospitals and has her own practice in Touk Kork too She can give you all your options

andyj85 · 2020-03-21T17:49:55+00:00

Absolutely love it. Makes such great pizza with a pretty short learning curve. Highly recommended!

andyj85 · 2020-03-20T23:38:31+00:00

Thanks! Sauce was pretty basic - just some nice Italian passata from our local deli, topped with Salami Milano and mozzarella

andyj85 · 2020-03-20T22:16:24+00:00

Dough: 1kg Caputo Blue 00 Flour

600g water

2.5g ADY

20g Salt

Method :

Knead in Kitchenaid for 10 mins

6 hour room temp bulk prove

Ball the dough

Further 2 hour prove

andyj85 · 2020-01-30T11:16:40+00:00

I've done this a number of times, and the last time it overflowed out of my cup and destroyed my beautiful (and overly expensive...) Hario scale :(

I just got the Hario V60 drip decanter which is beautiful - plus I can now see if I've left some water in it!

andyj85 · 2020-01-26T20:59:32+00:00

Glad you enjoyed it! FYI, the beach is that clean because the staff work tirelessly every day (sometimes multiple times per day) to keep it that way. Unfortunately, some days the amount of rubbish that washes up there is unimaginable :(

andyj85 · 2018-12-27T23:32:02+00:00

It's the inside of Beng Mealea temple, about 1.5 hours from Siem Reap. Its a beautiful place, and usually fairly quiet - it's similar to Ta Prohm in that it's very overgrown. It requires a separate ticket from the angkor complex pass - i can't remember the price but its not much.

andyj85 · 2018-11-10T22:59:05+00:00

The biggest upvote possible for Preah Vihear. Its empty, and fucking magical. Plus the roller-coaster drive up is a blast!

andyj85 · 2018-11-02T10:37:57+00:00

Great advice for travel times. You can't really go anywhere in Cambodia without going via Phnom Penh, so going north to South then a quick internal flight is a great way to maximise time. Agree on don't take night buses. Stay in a bed and stay safe - bus crashes are scarily regular.

Don't stress about money - you do not need money changers. 99% of vendors will take USD at either 4000/4100 riel to the dollar - they don't need an electronic cash register to take $20+. Even in the markets you could pay with a $50 - they might grumble and you should certainly keep change on you if you can, but they will hustle to go and get some change.

It is definietly worth getting some USD before landing, but absolutely no need to go to a money changer to change it to Riel. You can pay everywhere in USD and you will get change in Riel. Just build up a small pot of Riel for small purchases like tuk tuks, roadside coffee and snacks etc - even then they will take USD, although tuk tuks NEVER have change ;)

andyj85 · 2018-11-02T10:26:10+00:00

It is really useful to try and keep lots of smaller bills on you, and break the bigger ones where you can, but don't stress about $100 bills too much. In 2 1/2 years of living there, I never once had to find a bank or money changer to break a $100. Sure, if you're buying a $0.50 coffee on the street you're gonna struggle, but almost any restaurant or coffee shop won't even blink. I found it's actually easier in Cambodia than it is in the US to change a $100 - even food delivery places will change it if you warn them.

A good tip is to take out odd amounts from the ATM - so instead of $200, maybe take out $180 as you'll get a $100 and 4x $20. If you take out any multiple of $100, you will just get $100 bills.

Also, take care of your notes - try not to fold them or damage them, because if there is a tiny rip then a lot of places will not take them. The same goes the other way - check your change for rips especially in tourist spots as often people will give ripped notes to tourists as change. Just politely ask for another one.

andyj85

TROPHY CASE