[Ameiseuk]

I opened the sunroof and carefully poured water into the black surround, water drained quickly front and back out where they should have gone. If you're going to poke wire or similar up the drain hoses make sure the end is folded over so it's not sharp and likely to poke holes in it.

Your door looks similar to my issue - I ran a dull screwdriver down between the two 'lips' of the seal, dug out a load of caked crud then gave it a genlter clean with an old toothbrush and some soapy water. At least if it gets past the outer seal it can now run down the outside of the 'A' pillar