Ads not shown when logged in
Former Pubs Galore Coder
Well taken from yesterdays backup, hopefully I got the query right
Bedfordshire, England
551 Pubs
477 Open pubs
233 Reviews
180 Pubs with reviews
1081 Photos
260 Pubs with photo
Berkshire, England
777 Pubs
678 Open pubs
511 Reviews
351 Pubs with reviews
1609 Photos
390 Pubs with photo
Buckinghamshire, England
586 Pubs
527 Open pubs
211 Reviews
163 Pubs with reviews
1101 Photos
509 Pubs with photo
Cambridgeshire, England
757 Pubs
679 Open pubs
261 Reviews
192 Pubs with reviews
1758 Photos
392 Pubs with photo
Central London, England
2802 Pubs
2045 Open pubs
3827 Reviews
1644 Pubs with reviews
24062 Photos
2729 Pubs with photo
Cheshire, England
1059 Pubs
981 Open pubs
603 Reviews
409 Pubs with reviews
1610 Photos
812 Pubs with photo
Cornwall, England
677 Pubs
661 Open pubs
422 Reviews
266 Pubs with reviews
912 Photos
394 Pubs with photo
County Durham, England
883 Pubs
816 Open pubs
263 Reviews
190 Pubs with reviews
482 Photos
296 Pubs with photo
Cumbria, England
874 Pubs
830 Open pubs
256 Reviews
189 Pubs with reviews
933 Photos
468 Pubs with photo
Derbyshire, England
1280 Pubs
1207 Open pubs
596 Reviews
447 Pubs with reviews
1183 Photos
728 Pubs with photo
Devon, England
1360 Pubs
1313 Open pubs
463 Reviews
343 Pubs with reviews
3085 Photos
793 Pubs with photo
Dorset, England
648 Pubs
607 Open pubs
428 Reviews
284 Pubs with reviews
611 Photos
277 Pubs with photo
East Riding of Yorkshire, England
527 Pubs
507 Open pubs
470 Reviews
320 Pubs with reviews
507 Photos
351 Pubs with photo
East Sussex, England
790 Pubs
737 Open pubs
515 Reviews
331 Pubs with reviews
2906 Photos
680 Pubs with photo
Essex, England
1519 Pubs
1151 Open pubs
653 Reviews
473 Pubs with reviews
9944 Photos
1496 Pubs with photo
Gloucestershire, England
654 Pubs
626 Open pubs
138 Reviews
112 Pubs with reviews
250 Photos
167 Pubs with photo
Greater Bristol, England
731 Pubs
642 Open pubs
588 Reviews
360 Pubs with reviews
733 Photos
426 Pubs with photo
Greater London, England
3122 Pubs
2503 Open pubs
3114 Reviews
1878 Pubs with reviews
12742 Photos
2851 Pubs with photo
Greater Manchester, England
2879 Pubs
2424 Open pubs
1514 Reviews
1097 Pubs with reviews
5733 Photos
2414 Pubs with photo
Hampshire, England
1451 Pubs
1274 Open pubs
846 Reviews
575 Pubs with reviews
2688 Photos
898 Pubs with photo
Herefordshire, England
262 Pubs
251 Open pubs
94 Reviews
72 Pubs with reviews
157 Photos
98 Pubs with photo
Hertfordshire, England
1017 Pubs
851 Open pubs
657 Reviews
412 Pubs with reviews
4092 Photos
824 Pubs with photo
Isle Of Wight, England
168 Pubs
161 Open pubs
88 Reviews
63 Pubs with reviews
272 Photos
111 Pubs with photo
Kent, England
1787 Pubs
1465 Open pubs
1116 Reviews
829 Pubs with reviews
10571 Photos
1645 Pubs with photo
Lancashire, England
1789 Pubs
1470 Open pubs
780 Reviews
622 Pubs with reviews
3934 Photos
1620 Pubs with photo
Leicestershire, England
814 Pubs
766 Open pubs
294 Reviews
225 Pubs with reviews
732 Photos
246 Pubs with photo
Lincolnshire, England
1053 Pubs
1017 Open pubs
272 Reviews
215 Pubs with reviews
701 Photos
304 Pubs with photo
Merseyside, England
1202 Pubs
1066 Open pubs
392 Reviews
262 Pubs with reviews
1200 Photos
787 Pubs with photo
Norfolk, England
1169 Pubs
906 Open pubs
332 Reviews
249 Pubs with reviews
4648 Photos
685 Pubs with photo
North Yorkshire, England
1457 Pubs
1377 Open pubs
1390 Reviews
756 Pubs with reviews
2634 Photos
1045 Pubs with photo
Northamptonshire, England
494 Pubs
480 Open pubs
149 Reviews
119 Pubs with reviews
422 Photos
144 Pubs with photo
Northumberland, England
344 Pubs
337 Open pubs
138 Reviews
96 Pubs with reviews
228 Photos
141 Pubs with photo
Nottinghamshire, England
1075 Pubs
956 Open pubs
511 Reviews
400 Pubs with reviews
805 Photos
526 Pubs with photo
Oxfordshire, England
788 Pubs
747 Open pubs
236 Reviews
193 Pubs with reviews
545 Photos
245 Pubs with photo
Rutland, England
56 Pubs
54 Open pubs
10 Reviews
10 Pubs with reviews
24 Photos
17 Pubs with photo
Shropshire, England
709 Pubs
631 Open pubs
662 Reviews
346 Pubs with reviews
883 Photos
538 Pubs with photo
Somerset, England
957 Pubs
880 Open pubs
499 Reviews
327 Pubs with reviews
1117 Photos
422 Pubs with photo
South Yorkshire, England
1294 Pubs
1120 Open pubs
510 Reviews
353 Pubs with reviews
1442 Photos
822 Pubs with photo
Staffordshire, England
1179 Pubs
1045 Open pubs
877 Reviews
539 Pubs with reviews
1087 Photos
586 Pubs with photo
Suffolk, England
1173 Pubs
804 Open pubs
228 Reviews
179 Pubs with reviews
6066 Photos
916 Pubs with photo
Surrey, England
856 Pubs
764 Open pubs
775 Reviews
513 Pubs with reviews
1612 Photos
528 Pubs with photo
Tyne & Wear, England
870 Pubs
831 Open pubs
242 Reviews
154 Pubs with reviews
366 Photos
253 Pubs with photo
Warwickshire, England
555 Pubs
526 Open pubs
284 Reviews
192 Pubs with reviews
431 Photos
254 Pubs with photo
West Midlands, England
2327 Pubs
1816 Open pubs
2299 Reviews
1366 Pubs with reviews
3595 Photos
1914 Pubs with photo
West Sussex, England
602 Pubs
564 Open pubs
274 Reviews
196 Pubs with reviews
1086 Photos
377 Pubs with photo
West Yorkshire, England
2538 Pubs
2137 Open pubs
1244 Reviews
838 Pubs with reviews
3966 Photos
2102 Pubs with photo
Wiltshire, England
747 Pubs
683 Open pubs
392 Reviews
271 Pubs with reviews
748 Photos
317 Pubs with photo
Worcestershire, England
608 Pubs
579 Open pubs
224 Reviews
177 Pubs with reviews
540 Photos
314 Pubs with photo
Isle of Man, Isle of Man
96 Pubs
89 Open pubs
45 Reviews
36 Pubs with reviews
197 Photos
95 Pubs with photo
Antrim, Northern Ireland
355 Pubs
354 Open pubs
75 Reviews
55 Pubs with reviews
84 Photos
53 Pubs with photo
Armagh, Northern Ireland
82 Pubs
82 Open pubs
1 Reviews
1 Pubs with reviews
0 Photos
0 Pubs with photo
Down, Northern Ireland
228 Pubs
223 Open pubs
13 Reviews
12 Pubs with reviews
10 Photos
5 Pubs with photo
Fermanagh, Northern Ireland
56 Pubs
56 Open pubs
1 Reviews
1 Pubs with reviews
3 Photos
3 Pubs with photo
Londonderry, Northern Ireland
153 Pubs
152 Open pubs
3 Reviews
3 Pubs with reviews
5 Photos
4 Pubs with photo
Tyrone, Northern Ireland
130 Pubs
130 Open pubs
4 Reviews
4 Pubs with reviews
2 Photos
2 Pubs with photo
Borders, Scotland
155 Pubs
148 Open pubs
28 Reviews
27 Pubs with reviews
73 Photos
54 Pubs with photo
Central, Scotland
297 Pubs
283 Open pubs
67 Reviews
57 Pubs with reviews
319 Photos
244 Pubs with photo
Dumfries and Galloway, Scotland
213 Pubs
209 Open pubs
67 Reviews
47 Pubs with reviews
162 Photos
92 Pubs with photo
Fife, Scotland
316 Pubs
310 Open pubs
44 Reviews
34 Pubs with reviews
140 Photos
86 Pubs with photo
Grampian, Scotland
461 Pubs
447 Open pubs
111 Reviews
81 Pubs with reviews
416 Photos
172 Pubs with photo
Highland, Scotland
385 Pubs
382 Open pubs
77 Reviews
59 Pubs with reviews
188 Photos
126 Pubs with photo
Lothian, Scotland
837 Pubs
746 Open pubs
376 Reviews
265 Pubs with reviews
1032 Photos
669 Pubs with photo
Orkney, Scotland
24 Pubs
24 Open pubs
1 Reviews
1 Pubs with reviews
0 Photos
0 Pubs with photo
Shetland Islands, Scotland
19 Pubs
19 Open pubs
0 Reviews
0 Pubs with reviews
0 Photos
0 Pubs with photo
Strathclyde, Scotland
1615 Pubs
1577 Open pubs
339 Reviews
279 Pubs with reviews
562 Photos
392 Pubs with photo
Tayside, Scotland
492 Pubs
484 Open pubs
71 Reviews
59 Pubs with reviews
92 Photos
54 Pubs with photo
Western Isles, Scotland
10 Pubs
10 Open pubs
6 Reviews
6 Pubs with reviews
7 Photos
5 Pubs with photo
Clwyd, Wales
543 Pubs
511 Open pubs
127 Reviews
98 Pubs with reviews
477 Photos
260 Pubs with photo
Dyfed, Wales
543 Pubs
518 Open pubs
196 Reviews
162 Pubs with reviews
451 Photos
234 Pubs with photo
Gwent, Wales
446 Pubs
440 Open pubs
50 Reviews
40 Pubs with reviews
105 Photos
84 Pubs with photo
Gwynedd, Wales
341 Pubs
329 Open pubs
149 Reviews
102 Pubs with reviews
275 Photos
133 Pubs with photo
Mid Glamorgan, Wales
439 Pubs
409 Open pubs
103 Reviews
87 Pubs with reviews
146 Photos
124 Pubs with photo
Powys, Wales
203 Pubs
196 Open pubs
51 Reviews
47 Pubs with reviews
114 Photos
82 Pubs with photo
South Glamorgan, Wales
306 Pubs
301 Open pubs
61 Reviews
41 Pubs with reviews
168 Photos
84 Pubs with photo
West Glamorgan, Wales
382 Pubs
374 Open pubs
83 Reviews
61 Pubs with reviews
166 Photos
112 Pubs with photo
Attached Files
Anyone fancy a holiday in Orkney to review and photograph the 24 pubs there.
Or any of the Islands off Scotland.
Londonderry is a bit thin as well, or is "Pub photography" and note taking a very risky business in Nor'n Ireland?
Originally Posted by
Farway
Londonderry is a bit thin as well, or is "Pub photography" and note taking a very risky business in Nor'n Ireland?
Well we're off to Belfast for a few days soon which might help Antrim a little. Armagh is even worse with only 1 pub with a review!!
A pub is for life not just for Christmas
I'll stay on me own
What becomes apparent from this data is that the largest conurbations in England are well covered but pubs in Northern Ireland, Wales and the top half of Scotland are short on reviews and photographs. According to the CAMRA website, there are just 10 Scottish CAMRA branches, 1 Northern Ireland branch, and 17 Welsh Branches. That's not too many to e-mail to ask them to post a PG link to their website (quid pro quo)!
In England, Gloucestershire, Lincolnshire and Tyne and Wear need a boost
Last edited by Andy Ven; 23-03-2011 at 20:04 .
Waes hael!
Originally Posted by
Andy Ven
Conrad / Dave - is it still possible to add a web link to the page for each postal town? I started with Cardiff
http://www.cardiffcamra.co.uk/ but couldn't see a button to suggest a link
.
At the moment it is not possible.
The town link functionality needs rewriting to work with the new pages. As we don't exactly have that many of them we decided it wasn't as high priority as actually getting the new areas changes out.
To be fair though some this stuff was covered last year and we came up with a much better offering to CAMRA branches . So far Forth Valley are still the only branch to get all the extra promotion.
I'll stay on me own
I remember the thread. I tried a few local branches to no avail but I thought I'd have a go at the areas on PG where there isn't much coverage, such as the Welsh CAMRA branches.
Waes hael!
Similar Threads
By Conrad in forum Chit Chat
Replies: 26
Last Post: 21-11-2009, 09:05
By hopwas in forum Chit Chat
Replies: 28
Last Post: 06-11-2009, 11:04
By Jonathan David in forum Requests
Replies: 0
Last Post: 01-08-2007, 07:52
Posting Permissions
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Rules