Home
Welcome to Hambledon
10The Cradle of Cricket and the rebirth place of English commercial wine production. The Memorial shown on the right is on Broadhalfpenny Down opposite the Bat & Ball pub. The village nestles along a valley and ancient riverbed running from the South Downs in East Hampshire. For 3000 years there has been a settlement in Hambledon and the human footprint of history can still be discerned; a Roman villa, a Saxon church and significant Norman and Medieval buildings. Hambledon is set in a typical southern English countryside in the South Downs National Park, surrounded by sweeping farmland and splendid woods.

We are an active, vibrant, proud community with every age group and skill represented across a whole spectrum of activities 


The Parish Council is no longer responsible for this Hambledon website. They have their own site which can be reached from the Menu Link.
 
The webmaster  owns and administers this site for the benefit of the community. The website aims to enable you to learn more about our community, what is going on, what we have to offer, where you can stay and some notable places to visit.

 View from Speltham DownThe Main Menu lists those pages of immediate interest to the website visitor:


 Village Noticeboard highlights village notable events of immediate interest and longer term programmes of the principal organisations, clubs and societies.

 

Parish Council Website lists its objectives and responsibilities, when it meets, how Parish Councillors can be contacted and provides the latest agenda and minutes.

 

Events provide detailed day-to-day information on planned village activities for two months ahead and further ahead when known.

 

Directory lists the details of local Shops, Services and Businesses, including where to eat, drink & stay. The Hambledon community is very active with many Societies, Clubs and Groups involving arts, drama, and horticulture. Also to be found on this page are details of medical, educational and transport facilities.

 

Church lists details of the Church of England Services, the Parochial Church Council and the many church activities.  There is an outline history of the Church of St Peter and St Paul from its foundation in Saxon times up to today.


School page has direct link to the Hambledon School's own website.

 

 

Village Maps on two scales showing the location of landmarks and points of special interest in and around the village.

 

Links to local useful websites in Hampshire,  places, people and organisations if interest - is under development.

 

Contact Us enables visitors to contact the Webmaster and Content Administrator.

 

Under the Village Life Menu can be found useful information relating to:

 

Family History of people and families who live in the village over the years.

 

Hambledon Past and Present is a short history of the village.

 

Village Walks around Hambledon to help see the varied attractions of the village.

 

Vineyard and the replanting of the south-facing slope with new vines.

 

 

What to Visit guidance on houses of interest, the beautiful gardens open to the public and the viewpoints to enable you make the most of your visit.

 

The Cricket Menu concentrates on why Hambledon is the "Cradle of Cricket" and shows that the national game is alive and well in Hambledon. There are links to the Hambledon Cricket Club giving the fixture list and an overview of Hambledon in the history of cricket.

 

The User Access Menu is for those contributing to the management and content of the website.

 

Brief History of Hambledon

 

The Parish of Hambledon originally comprised several manors and tithings, including Ervill's Exton, Burwell, Glidden, Chidden, Rushmere, Putte and Denmead. The Manor of Hambledon was granted to the Bishop of Winchester by King John in 1199 and remained with the bishopric until the English Civil War in 1650.

 

In 1651 King Charles II spent the night of 13th October at Hambledon on his way to exile in France after the Battle of Worcester. The king was travelling from Somerset to the port of Shoreham, and lodged at his guide's house now known as "Kings Rest". At the restoration of Charles II the Parish of Hambledon reverted to the bishopric of Winchester.


Hambledon is the "Cradle of Cricket" where the laws of the present-day game were formalised in 1770 and the early notable matches were played on Broadhalfpenny Down in the eighteenth century. John Nyren, the famous cricket writer, was born here in 1764, the son of Richard Nyren who founded the Hambledon Cricket Club.

 

King George VI reviewed the British and Canadian troops encamped in Hambledon in May 1944 just before D-Day on the 6th June 1944 in the field opposite Bury Lodge. More recently a retired Major General started the rebirth of English vine growing and the making of English white wine which had died out in the time of King Henry VIII some 400 years earlier.

 

Welcome to Hambledon - The Cradle of Cricket

 

 

 
Last Updated ( Wednesday, 16 April 2014 )
106 queries executed
1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1685756683)
5
SELECT * FROM mos_session WHERE session_id='69b461f7d9d20b302ef253235c249125'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('4ad9541044a47027633e4bbd74531fb5')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e0be151891a2b064f11f4a346c329046','1685757583','','0','1' )
8
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
10
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
11
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
12
SELECT count(*) FROM mos_stats_agents WHERE agent='ec2-3-230-152-133.compute-1.amazonaws.com' AND type='2'
13
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='ec2-3-230-152-133.compute-1.amazonaws.com' AND type='2'
14
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
15
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
16
SELECT access FROM mos_menu WHERE id='1'
17
SELECT * FROM mos_menu WHERE id='1'
18
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 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.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-06-03 01:59:43'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-06-03 01:59:43' )
 ORDER BY f.ordering
19
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
20
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
21
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
22
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
23
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=19
24
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=19
25
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_categories AS c ON i.catid=c.id
LEFT JOIN mos_menu AS m ON m.componentid=c.id 
WHERE m.type='content_blog_category' AND m.published='1' AND i.id=19
26
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 = '1' OR mm.menuid = '0')
ORDER BY ordering
27
SELECT id, link
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
28
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
29
SELECT m.* FROM mos_menu AS m
WHERE menutype='moduleclass_sfx' AND published='1' AND access <= '0'
ORDER BY parent,ordering
30
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
31
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
32
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
33
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
34
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
35
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
36
SELECT m.* FROM mos_menu AS m
WHERE menutype='Village Life' AND published='1' AND access <= '0'
ORDER BY parent,ordering
37
SELECT m.* FROM mos_menu AS m
WHERE menutype='cricket' AND published='1' AND access <= '0'
ORDER BY parent,ordering
38
SELECT id FROM mos_menu WHERE link = 'index.php?option=com_events'
39
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-01 00:00:00' AND publish_up <= '2023-06-01 23:59:59')
	OR (publish_down >= '2023-06-01 00:00:00' AND publish_down <= '2023-06-01 23:59:59')
	OR (publish_up <= '2023-06-01 00:00:00' AND publish_down >= '2023-06-01 23:59:59')) AND state='1'
ORDER BY publish_up ASC
40
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-02 00:00:00' AND publish_up <= '2023-06-02 23:59:59')
	OR (publish_down >= '2023-06-02 00:00:00' AND publish_down <= '2023-06-02 23:59:59')
	OR (publish_up <= '2023-06-02 00:00:00' AND publish_down >= '2023-06-02 23:59:59')) AND state='1'
ORDER BY publish_up ASC
41
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-03 00:00:00' AND publish_up <= '2023-06-03 23:59:59')
	OR (publish_down >= '2023-06-03 00:00:00' AND publish_down <= '2023-06-03 23:59:59')
	OR (publish_up <= '2023-06-03 00:00:00' AND publish_down >= '2023-06-03 23:59:59')) AND state='1'
ORDER BY publish_up ASC
42
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-04 00:00:00' AND publish_up <= '2023-06-04 23:59:59')
	OR (publish_down >= '2023-06-04 00:00:00' AND publish_down <= '2023-06-04 23:59:59')
	OR (publish_up <= '2023-06-04 00:00:00' AND publish_down >= '2023-06-04 23:59:59')) AND state='1'
ORDER BY publish_up ASC
43
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-05 00:00:00' AND publish_up <= '2023-06-05 23:59:59')
	OR (publish_down >= '2023-06-05 00:00:00' AND publish_down <= '2023-06-05 23:59:59')
	OR (publish_up <= '2023-06-05 00:00:00' AND publish_down >= '2023-06-05 23:59:59')) AND state='1'
ORDER BY publish_up ASC
44
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-06 00:00:00' AND publish_up <= '2023-06-06 23:59:59')
	OR (publish_down >= '2023-06-06 00:00:00' AND publish_down <= '2023-06-06 23:59:59')
	OR (publish_up <= '2023-06-06 00:00:00' AND publish_down >= '2023-06-06 23:59:59')) AND state='1'
ORDER BY publish_up ASC
45
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-07 00:00:00' AND publish_up <= '2023-06-07 23:59:59')
	OR (publish_down >= '2023-06-07 00:00:00' AND publish_down <= '2023-06-07 23:59:59')
	OR (publish_up <= '2023-06-07 00:00:00' AND publish_down >= '2023-06-07 23:59:59')) AND state='1'
ORDER BY publish_up ASC
46
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-08 00:00:00' AND publish_up <= '2023-06-08 23:59:59')
	OR (publish_down >= '2023-06-08 00:00:00' AND publish_down <= '2023-06-08 23:59:59')
	OR (publish_up <= '2023-06-08 00:00:00' AND publish_down >= '2023-06-08 23:59:59')) AND state='1'
ORDER BY publish_up ASC
47
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-09 00:00:00' AND publish_up <= '2023-06-09 23:59:59')
	OR (publish_down >= '2023-06-09 00:00:00' AND publish_down <= '2023-06-09 23:59:59')
	OR (publish_up <= '2023-06-09 00:00:00' AND publish_down >= '2023-06-09 23:59:59')) AND state='1'
ORDER BY publish_up ASC
48
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-10 00:00:00' AND publish_up <= '2023-06-10 23:59:59')
	OR (publish_down >= '2023-06-10 00:00:00' AND publish_down <= '2023-06-10 23:59:59')
	OR (publish_up <= '2023-06-10 00:00:00' AND publish_down >= '2023-06-10 23:59:59')) AND state='1'
ORDER BY publish_up ASC
49
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-11 00:00:00' AND publish_up <= '2023-06-11 23:59:59')
	OR (publish_down >= '2023-06-11 00:00:00' AND publish_down <= '2023-06-11 23:59:59')
	OR (publish_up <= '2023-06-11 00:00:00' AND publish_down >= '2023-06-11 23:59:59')) AND state='1'
ORDER BY publish_up ASC
50
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-12 00:00:00' AND publish_up <= '2023-06-12 23:59:59')
	OR (publish_down >= '2023-06-12 00:00:00' AND publish_down <= '2023-06-12 23:59:59')
	OR (publish_up <= '2023-06-12 00:00:00' AND publish_down >= '2023-06-12 23:59:59')) AND state='1'
ORDER BY publish_up ASC
51
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-13 00:00:00' AND publish_up <= '2023-06-13 23:59:59')
	OR (publish_down >= '2023-06-13 00:00:00' AND publish_down <= '2023-06-13 23:59:59')
	OR (publish_up <= '2023-06-13 00:00:00' AND publish_down >= '2023-06-13 23:59:59')) AND state='1'
ORDER BY publish_up ASC
52
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-14 00:00:00' AND publish_up <= '2023-06-14 23:59:59')
	OR (publish_down >= '2023-06-14 00:00:00' AND publish_down <= '2023-06-14 23:59:59')
	OR (publish_up <= '2023-06-14 00:00:00' AND publish_down >= '2023-06-14 23:59:59')) AND state='1'
ORDER BY publish_up ASC
53
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-15 00:00:00' AND publish_up <= '2023-06-15 23:59:59')
	OR (publish_down >= '2023-06-15 00:00:00' AND publish_down <= '2023-06-15 23:59:59')
	OR (publish_up <= '2023-06-15 00:00:00' AND publish_down >= '2023-06-15 23:59:59')) AND state='1'
ORDER BY publish_up ASC
54
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-16 00:00:00' AND publish_up <= '2023-06-16 23:59:59')
	OR (publish_down >= '2023-06-16 00:00:00' AND publish_down <= '2023-06-16 23:59:59')
	OR (publish_up <= '2023-06-16 00:00:00' AND publish_down >= '2023-06-16 23:59:59')) AND state='1'
ORDER BY publish_up ASC
55
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-17 00:00:00' AND publish_up <= '2023-06-17 23:59:59')
	OR (publish_down >= '2023-06-17 00:00:00' AND publish_down <= '2023-06-17 23:59:59')
	OR (publish_up <= '2023-06-17 00:00:00' AND publish_down >= '2023-06-17 23:59:59')) AND state='1'
ORDER BY publish_up ASC
56
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-18 00:00:00' AND publish_up <= '2023-06-18 23:59:59')
	OR (publish_down >= '2023-06-18 00:00:00' AND publish_down <= '2023-06-18 23:59:59')
	OR (publish_up <= '2023-06-18 00:00:00' AND publish_down >= '2023-06-18 23:59:59')) AND state='1'
ORDER BY publish_up ASC
57
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-19 00:00:00' AND publish_up <= '2023-06-19 23:59:59')
	OR (publish_down >= '2023-06-19 00:00:00' AND publish_down <= '2023-06-19 23:59:59')
	OR (publish_up <= '2023-06-19 00:00:00' AND publish_down >= '2023-06-19 23:59:59')) AND state='1'
ORDER BY publish_up ASC
58
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-20 00:00:00' AND publish_up <= '2023-06-20 23:59:59')
	OR (publish_down >= '2023-06-20 00:00:00' AND publish_down <= '2023-06-20 23:59:59')
	OR (publish_up <= '2023-06-20 00:00:00' AND publish_down >= '2023-06-20 23:59:59')) AND state='1'
ORDER BY publish_up ASC
59
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-21 00:00:00' AND publish_up <= '2023-06-21 23:59:59')
	OR (publish_down >= '2023-06-21 00:00:00' AND publish_down <= '2023-06-21 23:59:59')
	OR (publish_up <= '2023-06-21 00:00:00' AND publish_down >= '2023-06-21 23:59:59')) AND state='1'
ORDER BY publish_up ASC
60
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-22 00:00:00' AND publish_up <= '2023-06-22 23:59:59')
	OR (publish_down >= '2023-06-22 00:00:00' AND publish_down <= '2023-06-22 23:59:59')
	OR (publish_up <= '2023-06-22 00:00:00' AND publish_down >= '2023-06-22 23:59:59')) AND state='1'
ORDER BY publish_up ASC
61
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-23 00:00:00' AND publish_up <= '2023-06-23 23:59:59')
	OR (publish_down >= '2023-06-23 00:00:00' AND publish_down <= '2023-06-23 23:59:59')
	OR (publish_up <= '2023-06-23 00:00:00' AND publish_down >= '2023-06-23 23:59:59')) AND state='1'
ORDER BY publish_up ASC
62
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-24 00:00:00' AND publish_up <= '2023-06-24 23:59:59')
	OR (publish_down >= '2023-06-24 00:00:00' AND publish_down <= '2023-06-24 23:59:59')
	OR (publish_up <= '2023-06-24 00:00:00' AND publish_down >= '2023-06-24 23:59:59')) AND state='1'
ORDER BY publish_up ASC
63
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-25 00:00:00' AND publish_up <= '2023-06-25 23:59:59')
	OR (publish_down >= '2023-06-25 00:00:00' AND publish_down <= '2023-06-25 23:59:59')
	OR (publish_up <= '2023-06-25 00:00:00' AND publish_down >= '2023-06-25 23:59:59')) AND state='1'
ORDER BY publish_up ASC
64
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-26 00:00:00' AND publish_up <= '2023-06-26 23:59:59')
	OR (publish_down >= '2023-06-26 00:00:00' AND publish_down <= '2023-06-26 23:59:59')
	OR (publish_up <= '2023-06-26 00:00:00' AND publish_down >= '2023-06-26 23:59:59')) AND state='1'
ORDER BY publish_up ASC
65
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-27 00:00:00' AND publish_up <= '2023-06-27 23:59:59')
	OR (publish_down >= '2023-06-27 00:00:00' AND publish_down <= '2023-06-27 23:59:59')
	OR (publish_up <= '2023-06-27 00:00:00' AND publish_down >= '2023-06-27 23:59:59')) AND state='1'
ORDER BY publish_up ASC
66
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-28 00:00:00' AND publish_up <= '2023-06-28 23:59:59')
	OR (publish_down >= '2023-06-28 00:00:00' AND publish_down <= '2023-06-28 23:59:59')
	OR (publish_up <= '2023-06-28 00:00:00' AND publish_down >= '2023-06-28 23:59:59')) AND state='1'
ORDER BY publish_up ASC
67
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-29 00:00:00' AND publish_up <= '2023-06-29 23:59:59')
	OR (publish_down >= '2023-06-29 00:00:00' AND publish_down <= '2023-06-29 23:59:59')
	OR (publish_up <= '2023-06-29 00:00:00' AND publish_down >= '2023-06-29 23:59:59')) AND state='1'
ORDER BY publish_up ASC
68
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-06-30 00:00:00' AND publish_up <= '2023-06-30 23:59:59')
	OR (publish_down >= '2023-06-30 00:00:00' AND publish_down <= '2023-06-30 23:59:59')
	OR (publish_up <= '2023-06-30 00:00:00' AND publish_down >= '2023-06-30 23:59:59')) AND state='1'
ORDER BY publish_up ASC
69
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-01 00:00:00' AND publish_up <= '2023-07-01 23:59:59')
	OR (publish_down >= '2023-07-01 00:00:00' AND publish_down <= '2023-07-01 23:59:59')
	OR (publish_up <= '2023-07-01 00:00:00' AND publish_down >= '2023-07-01 23:59:59')) AND state='1'
ORDER BY publish_up ASC
70
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-02 00:00:00' AND publish_up <= '2023-07-02 23:59:59')
	OR (publish_down >= '2023-07-02 00:00:00' AND publish_down <= '2023-07-02 23:59:59')
	OR (publish_up <= '2023-07-02 00:00:00' AND publish_down >= '2023-07-02 23:59:59')) AND state='1'
ORDER BY publish_up ASC
71
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-03 00:00:00' AND publish_up <= '2023-07-03 23:59:59')
	OR (publish_down >= '2023-07-03 00:00:00' AND publish_down <= '2023-07-03 23:59:59')
	OR (publish_up <= '2023-07-03 00:00:00' AND publish_down >= '2023-07-03 23:59:59')) AND state='1'
ORDER BY publish_up ASC
72
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-04 00:00:00' AND publish_up <= '2023-07-04 23:59:59')
	OR (publish_down >= '2023-07-04 00:00:00' AND publish_down <= '2023-07-04 23:59:59')
	OR (publish_up <= '2023-07-04 00:00:00' AND publish_down >= '2023-07-04 23:59:59')) AND state='1'
ORDER BY publish_up ASC
73
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-05 00:00:00' AND publish_up <= '2023-07-05 23:59:59')
	OR (publish_down >= '2023-07-05 00:00:00' AND publish_down <= '2023-07-05 23:59:59')
	OR (publish_up <= '2023-07-05 00:00:00' AND publish_down >= '2023-07-05 23:59:59')) AND state='1'
ORDER BY publish_up ASC
74
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-06 00:00:00' AND publish_up <= '2023-07-06 23:59:59')
	OR (publish_down >= '2023-07-06 00:00:00' AND publish_down <= '2023-07-06 23:59:59')
	OR (publish_up <= '2023-07-06 00:00:00' AND publish_down >= '2023-07-06 23:59:59')) AND state='1'
ORDER BY publish_up ASC
75
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-07 00:00:00' AND publish_up <= '2023-07-07 23:59:59')
	OR (publish_down >= '2023-07-07 00:00:00' AND publish_down <= '2023-07-07 23:59:59')
	OR (publish_up <= '2023-07-07 00:00:00' AND publish_down >= '2023-07-07 23:59:59')) AND state='1'
ORDER BY publish_up ASC
76
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-08 00:00:00' AND publish_up <= '2023-07-08 23:59:59')
	OR (publish_down >= '2023-07-08 00:00:00' AND publish_down <= '2023-07-08 23:59:59')
	OR (publish_up <= '2023-07-08 00:00:00' AND publish_down >= '2023-07-08 23:59:59')) AND state='1'
ORDER BY publish_up ASC
77
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-09 00:00:00' AND publish_up <= '2023-07-09 23:59:59')
	OR (publish_down >= '2023-07-09 00:00:00' AND publish_down <= '2023-07-09 23:59:59')
	OR (publish_up <= '2023-07-09 00:00:00' AND publish_down >= '2023-07-09 23:59:59')) AND state='1'
ORDER BY publish_up ASC
78
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-10 00:00:00' AND publish_up <= '2023-07-10 23:59:59')
	OR (publish_down >= '2023-07-10 00:00:00' AND publish_down <= '2023-07-10 23:59:59')
	OR (publish_up <= '2023-07-10 00:00:00' AND publish_down >= '2023-07-10 23:59:59')) AND state='1'
ORDER BY publish_up ASC
79
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-11 00:00:00' AND publish_up <= '2023-07-11 23:59:59')
	OR (publish_down >= '2023-07-11 00:00:00' AND publish_down <= '2023-07-11 23:59:59')
	OR (publish_up <= '2023-07-11 00:00:00' AND publish_down >= '2023-07-11 23:59:59')) AND state='1'
ORDER BY publish_up ASC
80
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-12 00:00:00' AND publish_up <= '2023-07-12 23:59:59')
	OR (publish_down >= '2023-07-12 00:00:00' AND publish_down <= '2023-07-12 23:59:59')
	OR (publish_up <= '2023-07-12 00:00:00' AND publish_down >= '2023-07-12 23:59:59')) AND state='1'
ORDER BY publish_up ASC
81
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-13 00:00:00' AND publish_up <= '2023-07-13 23:59:59')
	OR (publish_down >= '2023-07-13 00:00:00' AND publish_down <= '2023-07-13 23:59:59')
	OR (publish_up <= '2023-07-13 00:00:00' AND publish_down >= '2023-07-13 23:59:59')) AND state='1'
ORDER BY publish_up ASC
82
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-14 00:00:00' AND publish_up <= '2023-07-14 23:59:59')
	OR (publish_down >= '2023-07-14 00:00:00' AND publish_down <= '2023-07-14 23:59:59')
	OR (publish_up <= '2023-07-14 00:00:00' AND publish_down >= '2023-07-14 23:59:59')) AND state='1'
ORDER BY publish_up ASC
83
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-15 00:00:00' AND publish_up <= '2023-07-15 23:59:59')
	OR (publish_down >= '2023-07-15 00:00:00' AND publish_down <= '2023-07-15 23:59:59')
	OR (publish_up <= '2023-07-15 00:00:00' AND publish_down >= '2023-07-15 23:59:59')) AND state='1'
ORDER BY publish_up ASC
84
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-16 00:00:00' AND publish_up <= '2023-07-16 23:59:59')
	OR (publish_down >= '2023-07-16 00:00:00' AND publish_down <= '2023-07-16 23:59:59')
	OR (publish_up <= '2023-07-16 00:00:00' AND publish_down >= '2023-07-16 23:59:59')) AND state='1'
ORDER BY publish_up ASC
85
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-17 00:00:00' AND publish_up <= '2023-07-17 23:59:59')
	OR (publish_down >= '2023-07-17 00:00:00' AND publish_down <= '2023-07-17 23:59:59')
	OR (publish_up <= '2023-07-17 00:00:00' AND publish_down >= '2023-07-17 23:59:59')) AND state='1'
ORDER BY publish_up ASC
86
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-18 00:00:00' AND publish_up <= '2023-07-18 23:59:59')
	OR (publish_down >= '2023-07-18 00:00:00' AND publish_down <= '2023-07-18 23:59:59')
	OR (publish_up <= '2023-07-18 00:00:00' AND publish_down >= '2023-07-18 23:59:59')) AND state='1'
ORDER BY publish_up ASC
87
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-19 00:00:00' AND publish_up <= '2023-07-19 23:59:59')
	OR (publish_down >= '2023-07-19 00:00:00' AND publish_down <= '2023-07-19 23:59:59')
	OR (publish_up <= '2023-07-19 00:00:00' AND publish_down >= '2023-07-19 23:59:59')) AND state='1'
ORDER BY publish_up ASC
88
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-20 00:00:00' AND publish_up <= '2023-07-20 23:59:59')
	OR (publish_down >= '2023-07-20 00:00:00' AND publish_down <= '2023-07-20 23:59:59')
	OR (publish_up <= '2023-07-20 00:00:00' AND publish_down >= '2023-07-20 23:59:59')) AND state='1'
ORDER BY publish_up ASC
89
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-21 00:00:00' AND publish_up <= '2023-07-21 23:59:59')
	OR (publish_down >= '2023-07-21 00:00:00' AND publish_down <= '2023-07-21 23:59:59')
	OR (publish_up <= '2023-07-21 00:00:00' AND publish_down >= '2023-07-21 23:59:59')) AND state='1'
ORDER BY publish_up ASC
90
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-22 00:00:00' AND publish_up <= '2023-07-22 23:59:59')
	OR (publish_down >= '2023-07-22 00:00:00' AND publish_down <= '2023-07-22 23:59:59')
	OR (publish_up <= '2023-07-22 00:00:00' AND publish_down >= '2023-07-22 23:59:59')) AND state='1'
ORDER BY publish_up ASC
91
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-23 00:00:00' AND publish_up <= '2023-07-23 23:59:59')
	OR (publish_down >= '2023-07-23 00:00:00' AND publish_down <= '2023-07-23 23:59:59')
	OR (publish_up <= '2023-07-23 00:00:00' AND publish_down >= '2023-07-23 23:59:59')) AND state='1'
ORDER BY publish_up ASC
92
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-24 00:00:00' AND publish_up <= '2023-07-24 23:59:59')
	OR (publish_down >= '2023-07-24 00:00:00' AND publish_down <= '2023-07-24 23:59:59')
	OR (publish_up <= '2023-07-24 00:00:00' AND publish_down >= '2023-07-24 23:59:59')) AND state='1'
ORDER BY publish_up ASC
93
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-25 00:00:00' AND publish_up <= '2023-07-25 23:59:59')
	OR (publish_down >= '2023-07-25 00:00:00' AND publish_down <= '2023-07-25 23:59:59')
	OR (publish_up <= '2023-07-25 00:00:00' AND publish_down >= '2023-07-25 23:59:59')) AND state='1'
ORDER BY publish_up ASC
94
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-26 00:00:00' AND publish_up <= '2023-07-26 23:59:59')
	OR (publish_down >= '2023-07-26 00:00:00' AND publish_down <= '2023-07-26 23:59:59')
	OR (publish_up <= '2023-07-26 00:00:00' AND publish_down >= '2023-07-26 23:59:59')) AND state='1'
ORDER BY publish_up ASC
95
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-27 00:00:00' AND publish_up <= '2023-07-27 23:59:59')
	OR (publish_down >= '2023-07-27 00:00:00' AND publish_down <= '2023-07-27 23:59:59')
	OR (publish_up <= '2023-07-27 00:00:00' AND publish_down >= '2023-07-27 23:59:59')) AND state='1'
ORDER BY publish_up ASC
96
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-28 00:00:00' AND publish_up <= '2023-07-28 23:59:59')
	OR (publish_down >= '2023-07-28 00:00:00' AND publish_down <= '2023-07-28 23:59:59')
	OR (publish_up <= '2023-07-28 00:00:00' AND publish_down >= '2023-07-28 23:59:59')) AND state='1'
ORDER BY publish_up ASC
97
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-29 00:00:00' AND publish_up <= '2023-07-29 23:59:59')
	OR (publish_down >= '2023-07-29 00:00:00' AND publish_down <= '2023-07-29 23:59:59')
	OR (publish_up <= '2023-07-29 00:00:00' AND publish_down >= '2023-07-29 23:59:59')) AND state='1'
ORDER BY publish_up ASC
98
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-30 00:00:00' AND publish_up <= '2023-07-30 23:59:59')
	OR (publish_down >= '2023-07-30 00:00:00' AND publish_down <= '2023-07-30 23:59:59')
	OR (publish_up <= '2023-07-30 00:00:00' AND publish_down >= '2023-07-30 23:59:59')) AND state='1'
ORDER BY publish_up ASC
99
SELECT mos_events.* FROM mos_events, mos_categories as b
WHERE mos_events.catid = b.id AND b.access <= 0 AND mos_events.access <= 0
AND ((publish_up >= '2023-07-31 00:00:00' AND publish_up <= '2023-07-31 23:59:59')
	OR (publish_down >= '2023-07-31 00:00:00' AND publish_down <= '2023-07-31 23:59:59')
	OR (publish_up <= '2023-07-31 00:00:00' AND publish_down >= '2023-07-31 23:59:59')) AND state='1'
ORDER BY publish_up ASC
100
SELECT m.* FROM mos_menu AS m
WHERE menutype='moduleclass_sfx' AND published='1' AND access <= '0'
ORDER BY parent,ordering
101
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
102
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=274'
103
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
104
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=113'
105
SELECT id 
FROM mos_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=332'
106
SELECT id 
FROM mos_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=332'