Newsflash

Naturemaniacs 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
Oasis Hotel Oasis Hotel is located in the old part of Loutro Village right next to the E-4 trail as you come from Hora Sfakion / Sweetwater Beach.Sitting high on the mountain side it offers beautiful views of sparkling Loutro bay and the ocean, away from the noise of the water front Taverns and Cafes.Rooms consist of dorm style accommodation, two bunk beds per room with on suite and air conditioning. From our large communal terrace you have a 360 view ofh the area and loads of room to stretch out, have a frappe, read a book or just soak up the sun and enjoy the renowned peace and quiet of Loutro.Breakfast is also available upon request.Check out our Image Gallery for hotel photos. Oasis Hotel Contact: 0030-28240-91017 / 0030-6937940511 / 0030-6949447206 www.oasishotelloutro.com    

  Details...

Loutro Sfakia

Ζήσε ! Χειμερινές εξορμήσεις στη φύση!

Ζήσε ! ένα αλλιώτικο σαββατοκύριακο!

 
Sample Image
 
Δείτε το Λουτρό Σφακίων και τις άλλες εποχές του χρόνου διότι είναι ακόμα ποιο ωραία από το καλοκαίρι !
 
Κολυμπήστε και χαρείτε την θάλασσα όλο το χειμώνα σε θερμοκρασίες καλοκαιριού !
 
Επιλεγμένες διαδρομές σπάνιας φυσικής ομορφιάς μέσα από μονοπάτια με επισκέψεις σε εξωκλήσια και παραδοσιακά χώρια. 

Επιλέξτε διακοπές χαμηλού κόστους αλλα πολύ υψηλής αξίας ! Details...

Kayaking

Dates
   
   
 
 
 
 
Price per person TBA
Price includes all sea kayaking equipment, transportation, guiding, accommodation with breakfast or camping equipment where appropriate, welcoming/departure meal, some lunches (box lunch) with a drink. Other meals and drinks are self-catering Details...

Prices

Prices


Day Trips 2009 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...

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...

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.  Details...

Subscribe to NewsLetter






Lost your Password?
Please enter your Username and e-mail address then click on the Send Password button.
You will receive a new password shortly. Use this new password to access the site.
Username:
E-mail Address:
NatureManiacs Menu
Random image





































Trip Calendar
March 2010 April 2010
Su Mo Tu We Th Fr Sa
Week 9 1 2 3 4 5 6
Week 10 7 8 9 10 11 12 13
Week 11 14 15 16 17 18 19 20
Week 12 21 22 23 24 25 26 27
Week 13 28 29 30 31
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
12°C
Platanias Chania 12°C Athens 10°C London 4°C New York 9°C
© 2010 NatureManiacs.com Active Holidays
Joomla! is Free Software released under the GNU/GPL License.
126 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 = 99999999 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1268341240' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268341240' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = 'b8f57679e5b8c098fc0f956eb38a2841'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = 'aa53ec0049648354645087c70f74db16'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'aa53ec0049648354645087c70f74db16','1268342140','','0','1' )
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
12
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
13
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
14
SELECT *
 FROM jos_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com\_registration&task=lostPassword%'
15
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'
16
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
17
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 = 99999999 )
 ORDER BY ordering
18
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
20
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
21
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-03-11 16:15' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 16:15' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
22
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
23
SELECT id FROM jos_mambots WHERE element = 'analytics' AND folder = 'content'
24
SELECT *
 FROM jos_mambots
 WHERE id = '21'
25
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
26
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-03-11 13:15:40') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 13:15:40')
 AND catid='13' 
 ORDER BY RAND() LIMIT 6
27
SELECT *
 FROM jos_content
 WHERE id = '13'
28
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 = 13
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
29
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
30
SELECT *
 FROM jos_content
 WHERE id = '34'
31
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 = 34
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
SELECT *
 FROM jos_content
 WHERE id = '15'
33
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 = 15
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
34
SELECT *
 FROM jos_content
 WHERE id = '18'
35
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
36
SELECT *
 FROM jos_content
 WHERE id = '33'
37
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
38
SELECT *
 FROM jos_content
 WHERE id = '24'
39
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 = 24
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
40
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
41
SELECT *
 FROM jos_users
 WHERE id = '0'
42
SELECT m.* FROM jos_menu AS m
WHERE menutype='maniacs_menu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
43
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
44
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
45
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
47
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=24'
48
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=33'
49
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=0'
50
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
51
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=28'
52
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
53
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=29'
54
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=30'
55
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=19'
56
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
57
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
58
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
59
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=27'
60
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
61
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
62
SELECT * FROM jos_rsgallery2_files ORDER BY Rand() DESC
LIMIT 5
63
SELECT id
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 AND link = 'index.php?option=com_registration'
 ORDER BY link
64
SELECT * FROM jos_extcal_config
65
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') <= 20100301 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100301 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100301 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
66
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') <= 20100301) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
67
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') <= 20100302 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100302 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100302 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
68
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') <= 20100302) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
69
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') <= 20100303 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100303 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100303 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
70
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') <= 20100303) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
71
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') <= 20100304 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100304 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100304 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
72
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') <= 20100304) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
73
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') <= 20100305 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100305 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100305 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
74
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') <= 20100305) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
75
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') <= 20100306 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100306 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100306 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
76
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') <= 20100306) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
77
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') <= 20100307 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100307 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100307 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
78
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') <= 20100307) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
79
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') <= 20100308 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100308 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100308 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
80
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') <= 20100308) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
81
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') <= 20100309 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100309 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100309 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
82
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') <= 20100309) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
83
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') <= 20100310 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100310 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100310 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
84
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') <= 20100310) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
85
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') <= 20100311 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100311 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100311 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
86
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') <= 20100311) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
87
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') <= 20100312 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100312 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100312 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
88
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') <= 20100312) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
89
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') <= 20100313 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100313 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100313 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
90
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') <= 20100313) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
91
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') <= 20100314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100314 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100314 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
92
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') <= 20100314) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
93
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') <= 20100315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100315 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100315 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94
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') <= 20100315) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
95
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') <= 20100316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100316 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100316 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
96
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') <= 20100316) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
97
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') <= 20100317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100317 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100317 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
98
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') <= 20100317) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
99
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') <= 20100318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100318 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100318 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
100
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') <= 20100318) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
101
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') <= 20100319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100319 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100319 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
102
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') <= 20100319) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
103
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') <= 20100320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100320 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100320 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
104
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') <= 20100320) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
105
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') <= 20100321 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100321 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100321 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106
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') <= 20100321) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
107
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') <= 20100322 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100322 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100322 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108
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') <= 20100322) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
109
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') <= 20100323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100323 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100323 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110
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') <= 20100323) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
111
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') <= 20100324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100324 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100324 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
112
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') <= 20100324) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
113
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') <= 20100325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100325 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100325 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
114
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') <= 20100325) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
115
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') <= 20100326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100326 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100326 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
116
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') <= 20100326) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
117
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') <= 20100327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100327 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100327 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
118
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') <= 20100327) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
119
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') <= 20100328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100328 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100328 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
120
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') <= 20100328) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
121
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') <= 20100329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100329 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100329 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
122
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') <= 20100329) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
123
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') <= 20100330 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100330 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100330 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
124
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') <= 20100330) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
125
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') <= 20100331 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100331 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100331 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
126
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') <= 20100331) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC