Home

Main Menu
Home Photo Gallery Hambledonian Hambledonians down under Village Noticeboard Parish Council Parish Plan Events Directory Accommodation Church and Chapel Clubs and Groups Education Places to Visit Services Shops and Pubs Transport Chapel Church Churchyard School Village Maps Links Whats New Contact Us

Village Life
Village Hall Website Family History Past and Present Vineyard Village Walks What to Visit

Cricket
Hambledon CC Cricket History

Login Form
Username Password Remember me Forgotten your password? No account yet? Create one

User Menu
Home Photo Gallery Hambledonian Hambledonians down under Village Noticeboard Parish Council Parish Plan Events Directory Accommodation Church and Chapel Clubs and Groups Education Places to Visit Services Shops and Pubs Transport Chapel Church Churchyard School Village Maps Links Whats New Contact Us

The Bat and Ball Inn

This newly restored late 17th century Inn was used to house the clubroom for members of Hambledon Cricket Club, in the great days of Hambledon cricket from around 1750. It is still noted for its cricket memorabilia including a new collection specifically relating to Richard Nyren landlord from 1760 to 1771 and one of the great men of English cricket. There is a large restaurant to the rear of the building, with a wide and comprehensive menu.  It is now a Fuller Smith & Turner House, offering bar food at lunchtimes and evenings. Location: Next to Broadhalfpenny Down about 2 miles on the Clanfield Road from Hambledon village centre. Proprietors: Jason Eastlake and His Team   Telephone: 023 9263 2692 Email: batandball@fullers.co.uk Address: The Bat & Ball, Hyden Farm Lane, Clanfield, Hants PO8 0UB

Last Updated ( Tuesday, 02 December 2008 )

1
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='144' LIMIT 1
3
DELETE FROM mos_session
WHERE (time < 1685754896)
4
SELECT * FROM mos_session WHERE session_id='69b461f7d9d20b302ef253235c249125'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('8b907bbee7c1553d08f19411b7d1418e')
6
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '682b4b7e7a8a5bf2feb7d22ea731da3c','1685755796','','0','1' )
7
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
8
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
9
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
10
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
11
SELECT count(*) FROM mos_stats_agents WHERE agent='ec2-3-230-152-133.compute-1.amazonaws.com' AND type='2'
12
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='ec2-3-230-152-133.compute-1.amazonaws.com' AND type='2'
13
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
14
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
15
SELECT access FROM mos_menu WHERE id='144'
16
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.id='28' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-06-03 01:29:56')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-03 01:29:56')
 AND a.access <= 0
17
UPDATE mos_content SET hits=(hits+1) WHERE id='28'
18
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2023-06-03' AND item_table='#__content' AND item_id='28'
19
INSERT INTO mos_core_log_items VALUES
('2023-06-03','#__content','28','1')
20
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
21
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '144' OR mm.menuid = '0')
ORDER BY ordering
22
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
23
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
24
SELECT title, catid FROM mos_content WHERE id=28
25
SELECT c.title AS title, s.id AS sectionid FROM mos_categories AS c LEFT JOIN mos_sections AS s ON c.section=s.id WHERE c.id=75
26
SELECT m.* FROM mos_menu AS m
WHERE menutype='moduleclass_sfx' AND published='1' AND access <= '0'
ORDER BY parent,ordering
27
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
28
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
29
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
30
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
31
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
32
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
33
SELECT m.* FROM mos_menu AS m
WHERE menutype='Village Life' AND published='1' AND access <= '0'
ORDER BY parent,ordering
34
SELECT m.* FROM mos_menu AS m
WHERE menutype='cricket' AND published='1' AND access <= '0'
ORDER BY parent,ordering
35
SELECT m.* FROM mos_menu AS m
WHERE menutype='moduleclass_sfx' AND published='1' AND access <= '0'
ORDER BY parent,ordering
36
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
37
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
38
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
39
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
40
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
41
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=332'