Obviously, this new job you started isn't keeping you as busy as you thought! Seriously, good luck with the challenge. I'm sure you'll have some interesting tales to tell, over the coming months.
Obviously, this new job you started isn't keeping you as busy as you thought! Seriously, good luck with the challenge. I'm sure you'll have some interesting tales to tell, over the coming months.
'And where he supped the past lived still. And where he sipped the glass brimmed full' John Barleycorn, Carol Ann Duffy.
Another few SQL / general rule tweaks -
- Singular & plurals eg Hop Pole and Hop Poles, Compass/Compasses, I'd say they need to be amalgamated, if possible.
- Also there are Old Red Lions and Olde Red Lions - same thing, in my book.
- Issues with words that can be separated in pub names - Horse Shoes/Horsehoes, Holly Bush/Hollybush, Odd Fellow/Oddfellows, Wool Pack/Woolpack etc
- Finally, do apostrophes interfere with the results? Nags/Nag's/Nags' etc
Also, what do we reckon about 'Brewery Tap'? There are a few standalones though there are also loads with "(brewery name) Brewery Tap". Include and amlagamate?
Last edited by Quinno; 16-12-2015 at 14:54.
Surely "Lounge" needs a tweak as I suspect it'll be referring to nearly all the "loungers bars" which are on here which is actually equivalent to bar, Inn, Tavern etc in the naming of their brand which are now being dropped to accommodate this challenge....
On data in Spain so haven't/can't afford to check this theory fully.
Also removing/bunching things together like Hart/Harte is wrong but his challenge his rules.
Last edited by bcfczuluarmy; 16-12-2015 at 17:03.
I will never manage the complete 250 pubs with a different name that you have not been in before challenge like Quinno will do.
But i would be interested if there is a way we can see how many other members do on the list over a year,i hope to do 400 plus new pubs in 2016 and hopefully a few will be on that list.
I dont have a printer,but it would be nice to have a tick box of some sorts to keep track of what pubs we do on the list.
Just a thought,dont want to complicate things to much though.
We are all equal,but some are more equal than others
Still thinking about how to do this. I suspect that when it comes to applying the extra rules there is going to have to be a part automatic and part manual process that I'm starting to visualise in my head.
I assume that 'Old Red Lion', 'New Red Lion' and 'Red Lion' are all different names as far as you're concerned?
I think I have apostrophes covered already.
Makes sense just saw lounge and thought given I have one at the bottom of my road it was likely to be them accounting for the addition to the top 250.
Last edited by bcfczuluarmy; 16-12-2015 at 17:46.