Home arrow Blog arrow Sea Kayak and Loutro area photosarrow Sleeping under stars Ag. Pavlos
Newsflash

Sea Kayak Crete is the Outdoor Activities program of Itanos Tours based in Sitia, combining the best of East and West Crete. Itanostours.gr
Itanos Tours

 
Main Menu
Home
News
Blog
Links
Contact Us
Search
Naturemaniacs maps
Naturemaniacs Forum
News Feeds
FAQs
Sign our Book!
Send a postcard!
Our Newsletters
Trip Calendar
Book your trip now!
Info
About us

Welcome To Sea Kayak Crete

 

 Sea Kayak Crete's goal is to provide high quality sea kayaking activities for our guests that empower individuals to grow physically, mentally and spiritually, enhancing quality of life and fostering passion for the outdoors. 

    The object of our company is to organize and carry out multi-day sea kayaking  expeditions on east and west Crete. We believe that the unique nature, the impressive ancient sites, the indescribable beaches under the sun of Crete and last but not least the warm-hearted locals will make your stay unforgettable.

   Sea Kayak Crete guides are at your service throughout your stay with us ,
introducing you to the island’s flora and fauna, to the history and geology, they will also choose for you the best accommodation and locations with the most authentic Cretan food.
 


 Details...

8 Day Western Crete Seakayak Expedition

Western Crete expedition - 8 days paddling, 7 nights wild camping

Dominated by the Lefka Ori (the white mountains), the western part of Crete is the most spectacular and inaccessible part of the island. Highlights include crossing the “horns” of Crete; Elafonisi beach and inlet; the picturesque villages of Paleohora, Sougio, Loutro and Sfakion; and the Samaria gorge and national park.

  • Some sea kayaking experience required. You must have enough stamina to paddle up to 30km per day and be confident paddling in strong wind and waves.
  • Total distance = 160km, 20km/day
  • Dates  October,  Dates flexable
  • Price 600 euro (self catering)

    •     Places Remaining   -   6

 

Included in price

  • All kayaking equipment for 8-day expedition.
  • ACA certified sea kayak guide
  • Expedition plan and logistics.
  • Laminated maps
  • Return transport to Hania
 

Not included in price

  • Camping equipment, food and food preparation
  • Occasional night in hotel, campground and restaurant meals (optional)
 Expedition plan The aim of the expedition is to circumnavigate western Crete, from Hania on the north coast to Sfakion on the south coast, via the Rodopos and Gramvousa peninsulas. The total distance is about 160km. This equates to about 20km/day in 8 days, however bad weather days will make it necessary to increase the daily mileage.

Required paddling experience

This expedition is for competent paddlers who would like to enjoy the experience of an extended sea trip. Experience of specialist sea kayaks is essential.  To join us you should be:

  • Fit enough to paddle up to 30km/day on the expedition
  • Have effective support strokes and be able to cope with moderate seas
  • Have some experience of rough water
  • Able to control the boat down wind and across the wind
  Logistics We will meet in Hania , at 10am on Saturday October 17th. After we meet we will decide a plan of action. Plan A is to offload the boats into the Harbour, stock up on supplies and begin paddling. If strong northerly winds make this plan unfeasible then we will travel by car to an alternative location. Plan B would be to start at Sfakion, and attempt the expedition in reverse.  Plan C, if strong northerly winds are likely to persist, could be to start at Falisarna on the west coast and continue south, thereby missing the Rodopos and Gramvousa peninsulas. The expedition will end on the Saturday afternoon. On Sunday morning the 18th we will return to Hania by mid-day. Your arrival and departure dates to/from Hania The advertised dates include 8 full paddling days. We will meet at the Western end of the Hania Harbour, at the Hand Monument behind the Naval Museum at 10am on Saturday October 17.  We will return to Hania, by car on the morning of the 25th. You can book your departure anytime after mid-day on Sunday the 25th. It is recommend that you spend a day or more in Hania, either before or after the expedition, as it is quite a nice place! Camping Camping will be wild, on or near beaches. Most are remote and there will be no facilities, not even water. Tents are recommended as there is a possibility of rain and there will be a heavy due most nights. Most nights we will have a campfire. There is the possibility we we spend the final night (Saturday 24th) in a hotel, allow 25 euro pp.

Food The expedition is (self catering) You must buy and prepare your own meals. You are welcome to bring some food from home if you wish, however I suggest we buy most of the food, and especially water, after we meet in Hania and have decided on a plan. If we need to relocate to an alternative location, then the less we have to carry the better. We will buy 2-3 days worth of supplies at a time as we will be able to restock. Meals in seaside towns or beachside Tavernas are a possibility. Stoves and fuel Mentholated spirits, white gas (Kerosene) and camping gaz fuel are readily available. Coleman type screw on gas canisters, are not. I use a Primus with a mentholated spirit burner. What to wear For paddling, shorts and a shirt will be sufficient on most days. A cagoule (waterproof jacket may be required if it’s windy or overcast. Cold weather paddling gear, (wetsuits, etc) are not required.
 Details...

All our programs

Programs 

Sea Kayaking

 

Explore the gorgeous coastlines of Crete from a different angle, by Sea Kayak. We provide half-day, day, multi-day and customized trips along with lessons. No experience necessary to participate, we will provide you with all the needed skills. We also combine trekking/gorges with our sea kayaking programs on our multi-day trips.

   Details...

Sea Kayaking

Sea Kayaking

 

In our day trips we explore various areas on the South coast of Crete, starting from the seaside village of Loutro.

A typical trip consists of up to 1 hour of briefing and set up time, 3-4 hours of paddling and 2-3  Details...

Kayaking in Loutro Itanos Tours Outdoor Activities Branch Nature Maniacs now has a new location for our Sea Kayaking adventures in the beautiful seaside village of Loutro, located on the south side of Crete near Hora Sfakion which is only accessible by foot or by sea via ferry boat (time tables on our link page). The majestic scenery, beautiful crystal clear waters, friendly people and peacefulness make this an ideal location for your sea kayaking holidays.Magical is the first word that enters the mind when one sees the village of Loutro. The small semi circular bay, crystal clear water, pebble beach with hotels and tavernas at it's edge, the steep ragged rock mountain sides stretching high above, it's an impressive sight to behold. There are no roads that lead here so there is no traffic pollution, no discos or loud clubs to disturb one's peace. It truly is a hidden gem of the med. We offer full day and multi day guided trips in English and German with certified experienced professional guides. Pre-booking is not necessary if kayaks are available for passing customers, Nature Maniacs thrive on spontaneity.  We can also assist you with accommodation or you can make your own arrangements if you have a preferred hotel. If you wish to book in advance please send us an e-mail with the dates you will be in Loutro. Sit on top kayaks are also available for rental by the hour or day. Please contact us for more information.The season runs from May until October in Loutro.   Details...

Prices

Prices


Day Trips 2010 May-October


- Price € 60.00
- No experience necessary
- Duration: 6 to 8 hours
- Departs: Everyday
- Included in price: All sea kayaking equipment, guiding, tuition, a dry bag and snorkelling equipment.  Lunch is self-catering. Trip consists of 3-4   hours paddling and 2-3 hours out of kayak time for relaxing, swimming, snorkeling, walking and exploring.
 Details...

Subscribe to NewsLetter






 
 
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
 
 

Loutro

  
   
 
 

Description

 Hits: 62536
No Description

Voting

Votes: 2
Average Vote:    
Vote:  Very Bad 
 Bad 
 Ok 
 Good 
 Very Good 
 
NatureManiacs Menu
Random image





































Trip Calendar
September 2010 October 2010
Su Mo Tu We Th Fr Sa
Week 35 1 2 3 4
Week 36 5 6 7 8 9 10 11
Week 37 12 13 14 15 16 17 18
Week 38 19 20 21 22 23 24 25
Week 39 26 27 28 29 30
Translate
Live Weather

Warning: fopen(/home/russ/public_html/modules/MambWeather/LGSA_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/LGAV_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/EGKK_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/KNYC_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/LGSA_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210
Platanias Chania
23°C
Platanias Chania 23°C Athens 20°C London 15°C New York 21°C
© 2010 NatureManiacs.com Active Holidays
Joomla! is Free Software released under the GNU/GPL License.
133 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 9 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1284063657' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1284063657' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = 'bd5c8ca1980147d443ce46159e83f51d'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = '6c6846231c5d4b4e107e2ba7fb602ade'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '6c6846231c5d4b4e107e2ba7fb602ade','1284064557','','0','1' )
8
SELECT *
 FROM jos_menu
 WHERE id = 9
9
SELECT * FROM jos_rsgallery2_config
10
SELECT * FROM jos_rsgallery2_galleries WHERE id = '4' ORDER BY ordering ASC
11
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
12
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (4)
13
SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '4'
14
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
15
SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (4) ORDER BY rand() LIMIT 1
16
SELECT * FROM jos_rsgallery2_galleries WHERE id = '4' LIMIT 1
17
SELECT * FROM jos_rsgallery2_galleries WHERE id = "4"
18
SELECT title FROM jos_rsgallery2_files WHERE id = "97"
19
SELECT name FROM jos_rsgallery2_galleries WHERE id = '4'
20
SELECT COUNT(*) FROM jos_rsgallery2_files WHERE gallery_id = '4'
21
SELECT * FROM jos_rsgallery2_files WHERE gallery_id = 4 ORDER BY ordering ASC LIMIT 0, 1
22
SELECT hits FROM jos_rsgallery2_files WHERE id = '30'
23
UPDATE jos_rsgallery2_files SET hits = '62536' WHERE id = '30'
24
SELECT * FROM jos_rsgallery2_files WHERE id = '30'
25
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
26
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
27
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 9 )
 ORDER BY ordering
28
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
29
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
30
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
31
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-09 16:35' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 16:35' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
32
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
33
SELECT id FROM jos_mambots WHERE element = 'analytics' AND folder = 'content'
34
SELECT *
 FROM jos_mambots
 WHERE id = '21'
35
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
36
SELECT a.id
 FROM jos_content AS a
 INNER JOIN jos_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access  <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-09 13:35:57') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 13:35:57')
 AND catid='13' 
 ORDER BY RAND() LIMIT 6
37
SELECT *
 FROM jos_content
 WHERE id = '12'
38
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 12
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
39
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
40
SELECT *
 FROM jos_content
 WHERE id = '29'
41
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 29
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
42
SELECT *
 FROM jos_content
 WHERE id = '28'
43
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 28
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
44
SELECT *
 FROM jos_content
 WHERE id = '23'
45
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 23
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
46
SELECT *
 FROM jos_content
 WHERE id = '33'
47
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 33
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
48
SELECT *
 FROM jos_content
 WHERE id = '18'
49
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 18
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
50
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
51
SELECT *
 FROM jos_users
 WHERE id = '0'
52
SELECT m.* FROM jos_menu AS m
WHERE menutype='maniacs_menu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
53
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
54
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
55
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
56
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
57
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=24'
58
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=33'
59
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=0'
60
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 0
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
61
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=28'
62
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
63
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=29'
64
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=30'
65
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=19'
66
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
67
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
68
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
69
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=27'
70
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
71
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
72
SELECT * FROM jos_rsgallery2_files ORDER BY Rand() DESC
LIMIT 5
73
SELECT * FROM jos_extcal_config
74
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100901 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100901 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100901 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
75
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100901) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
76
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100902 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100902 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100902 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
77
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100902) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
78
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100903 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100903 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100903 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
79
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100903) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
80
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100904 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100904 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100904 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
81
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100904) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
82
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100905 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100905 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100905 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
83
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100905) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
84
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100906 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100906 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100906 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
85
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100906) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
86
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100907 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100907 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100907 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
87
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100907) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
88
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100908 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100908 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100908 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
89
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100908) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
90
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100909 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100909 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100909 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
91
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100909) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
92
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100910 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100910 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100910 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
93
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100910) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
94
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100911 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100911 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100911 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
95
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100911) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
96
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100912 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100912 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100912 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
97
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100912) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
98
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100913 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100913 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100913 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
99
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100913) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
100
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100914 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100914 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100914 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
101
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100914) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
102
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100915 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100915 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100915 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
103
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100915) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
104
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100916 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100916 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100916 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
105
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100916) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
106
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100917 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100917 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100917 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
107
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100917) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
108
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100918 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100918 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100918 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
109
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100918) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
110
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100919 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100919 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100919 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
111
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100919) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
112
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100920 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100920 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100920 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
113
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100920) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
114
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100921 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100921 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100921 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
115
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100921) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
116
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100922 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100922 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100922 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
117
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100922) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
118
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100923 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100923 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100923 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
119
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100923) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
120
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100924 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100924 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100924 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
121
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100924) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
122
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100925 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100925 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100925 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
123
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100925) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
124
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100926 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100926 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100926 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
125
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100926) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
126
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100927 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100927 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100927 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
127
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100927) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
128
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100928 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100928 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100928 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
129
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100928) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
130
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100929 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100929 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100929 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
131
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100929) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
132
SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100930 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100930 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100930 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
133
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100930) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC