Home arrow Image Gallery
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
Loutro Sfakia

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

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

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

Επιλέξτε διακοπές χαμηλού κόστους αλλα πολύ υψηλής αξίας ! 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...

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

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

8 Day South Coast Kayak/Hiking Trip

8 Day Kayak/Hiking Trip

 

We will spend 8 days and 7 nights touring the south west coast. This area is known for its varied scenery and high rugged cliffs contrasting beautifully with the blue sky and sea. What a better way to discover the land than from a sea kayak, we can visit places nearly inaccessible via land. Remote villages, ruins and antiquities will leave an experience not quickly forgotten. 


 Details...

About us

Welcome to Naturemaniacs.com

 Sample Image

 Nature Maniacs 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 sea kayaking trips and 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.

   Nature Maniacs 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.
 
OUR 2010 TRIPS, EXPEDITIONS, PRICES AND OUR NEW WEB SITE WILL BE UPLOADED BY CHRISTMAS. OUR NAME WILL BE CHANGING AS WELL TO SEAKAYAKCRETE.COM, PLEASE COME BACK AND SEE THE GREAT OFFERS WE WILL HAVE FOR YOU NEXT YEAR. 

 Details...

Subscribe to NewsLetter






Nature Maniacs Image Gallery
 

Random images
 
 
Latest images
 
 
 
NatureManiacs Menu
Random image
Trip Calendar
February 2010 March 2010
Su Mo Tu We Th Fr Sa
Week 5 1 2 3 4 5 6
Week 6 7 8 9 10 11 12 13
Week 7 14 15 16 17 18 19 20
Week 8 21 22 23 24 25 26 27
Week 9 28
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
14°C
Platanias Chania 14°C Athens 12°C London 4°C New York -2°C
© 2010 NatureManiacs.com Active Holidays
Joomla! is Free Software released under the GNU/GPL License.
180 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 = 81 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1265716603' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1265716603' ) AND guest = 1 AND userid = 0 )
5 SELECT * FROM jos_session WHERE session_id = '464921a01330aecbcc22230c5be26d0f'
6 SELECT session_id FROM jos_session WHERE session_id = '4aa685177445b94aa91e516aca232af0'
7 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '4aa685177445b94aa91e516aca232af0','1265717503','','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 id = 81
15 SELECT * FROM jos_rsgallery2_config
16 SELECT * FROM jos_rsgallery2_galleries WHERE id = '0' ORDER BY ordering ASC
17 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '0'
18 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
19 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
20 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
21 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
22 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (0,2,3,4,6)
23 SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '0'
24 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '0'
25 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
26 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
27 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
28 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
29 SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (0,2,3,4,6) ORDER BY rand() LIMIT 1
30 SELECT * FROM jos_rsgallery2_galleries WHERE id = '0' LIMIT 1
31 SELECT name FROM jos_rsgallery2_galleries WHERE id = '0'
32 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '0' ORDER BY ordering ASC
33 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
34 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (4)
35 SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '4'
36 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
37 SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (4) ORDER BY rand() LIMIT 1
38 SELECT * FROM jos_rsgallery2_galleries WHERE id = '4' LIMIT 1
39 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
40 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (6)
41 SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '6'
42 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
43 SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (6) ORDER BY rand() LIMIT 1
44 SELECT * FROM jos_rsgallery2_galleries WHERE id = '6' LIMIT 1
45 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
46 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (2)
47 SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '2'
48 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
49 SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (2) ORDER BY rand() LIMIT 1
50 SELECT * FROM jos_rsgallery2_galleries WHERE id = '2' LIMIT 1
51 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
52 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (3)
53 SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '3'
54 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
55 SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (3) ORDER BY rand() LIMIT 1
56 SELECT * FROM jos_rsgallery2_galleries WHERE id = '3' LIMIT 1
57 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
58 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (4)
59 SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-02-02 00:02:00' AND gallery_id = '4'
60 SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '4' ORDER BY ordering ASC
61 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
62 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (6)
63 SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-02-02 00:02:00' AND gallery_id = '6'
64 SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '6' ORDER BY ordering ASC
65 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
66 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (2)
67 SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-02-02 00:02:00' AND gallery_id = '2'
68 SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '2' ORDER BY ordering ASC
69 SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
70 SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (3)
71 SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-02-02 00:02:00' AND gallery_id = '3'
72 SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '3' ORDER BY ordering ASC
73 SELECT COUNT(*) FROM jos_rsgallery2_files WHERE gallery_id='0'
74 SELECT file.gallery_id, file.ordering, file.id, file.name, file.descr FROM jos_rsgallery2_files file, jos_rsgallery2_galleries gal WHERE file.gallery_id=gal.id and gal.published=1 ORDER BY rand() limit 3
75 SELECT file.gallery_id, file.ordering, file.id, file.name, file.descr FROM jos_rsgallery2_files file, jos_rsgallery2_galleries gal WHERE file.gallery_id=gal.id and gal.published=1 ORDER BY file.date DESC limit 3
76 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'
77 SELECT m.id FROM jos_modules AS m WHERE m.module = 'mod_rssfeed' AND m.published = 1
78 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 = 81 ) ORDER BY ordering
79 SELECT id, name, link, parent, type, menutype, access FROM jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
80 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
81 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
82 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-02-09 07:11' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 07:11' ) AND a.catid = 3 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering
83 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
84 SELECT id FROM jos_mambots WHERE element = 'analytics' AND folder = 'content'
85 SELECT * FROM jos_mambots WHERE id = '21'
86 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
87 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-02-09 04:11:43') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 04:11:43') AND catid='13' ORDER BY RAND() LIMIT 6
88 SELECT * FROM jos_content WHERE id = '34'
89 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
90 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
91 SELECT * FROM jos_content WHERE id = '28'
92 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
93 SELECT * FROM jos_content WHERE id = '24'
94 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
95 SELECT * FROM jos_content WHERE id = '33'
96 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
97 SELECT * FROM jos_content WHERE id = '30'
98 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 = 30 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
99 SELECT * FROM jos_content WHERE id = '12'
100 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
101 SELECT m.* FROM jos_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
102 SELECT * FROM jos_users WHERE id = '0'
103 SELECT m.* FROM jos_menu AS m WHERE menutype='maniacs_menu' AND published='1' AND access <= '0' ORDER BY parent,ordering
104 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
105 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
106 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=13'
107 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=18'
108 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=24'
109 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=33'
110 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=0'
111 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
112 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=28'
113 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=23'
114 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=29'
115 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=30'
116 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=19'
117 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=22'
118 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=21'
119 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=20'
120 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=27'
121 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=26'
122 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=25'
123 SELECT * FROM jos_rsgallery2_files ORDER BY Rand() DESC LIMIT 5
124 SELECT * FROM jos_extcal_config
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') <= 20100201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100201 ) ) 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') <= 20100201) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
127 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') <= 20100202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100202 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
128 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') <= 20100202) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
129 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') <= 20100203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100203 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
130 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') <= 20100203) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
131 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') <= 20100204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100204 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
132 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') <= 20100204) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
133 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') <= 20100205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100205 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
134 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') <= 20100205) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
135 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') <= 20100206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100206 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
136 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') <= 20100206) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
137 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') <= 20100207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100207 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
138 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') <= 20100207) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
139 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') <= 20100208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100208 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
140 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') <= 20100208) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
141 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') <= 20100209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100209 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
142 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') <= 20100209) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
143 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') <= 20100210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100210 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
144 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') <= 20100210) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
145 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') <= 20100211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100211 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
146 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') <= 20100211) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
147 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') <= 20100212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100212 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
148 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') <= 20100212) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
149 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') <= 20100213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100213 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
150 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') <= 20100213) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
151 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') <= 20100214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100214 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
152 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') <= 20100214) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
153 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') <= 20100215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100215 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
154 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') <= 20100215) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
155 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') <= 20100216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100216 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
156 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') <= 20100216) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
157 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') <= 20100217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100217 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
158 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') <= 20100217) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
159 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') <= 20100218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100218 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
160 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') <= 20100218) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
161 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') <= 20100219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100219 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
162 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') <= 20100219) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
163 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') <= 20100220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100220 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
164 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') <= 20100220) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
165 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') <= 20100221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100221 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
166 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') <= 20100221) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
167 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') <= 20100222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100222 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
168 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') <= 20100222) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
169 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') <= 20100223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100223 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
170 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') <= 20100223) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
171 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') <= 20100224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100224 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
172 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') <= 20100224) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
173 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') <= 20100225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100225 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
174 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') <= 20100225) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
175 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') <= 20100226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100226 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
176 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') <= 20100226) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
177 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') <= 20100227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100227 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
178 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') <= 20100227) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
179 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') <= 20100228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100228 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
180 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') <= 20100228) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC