Home   Newsflash Naturemaniacs is the Outdoor Activities program of Itanos Tours based in Sitia, combining the best of East and West Crete. Itanostours.gr   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... 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... Loutro Sfakia Ζήσε ! Χειμερινές εξορμήσεις στη φύση! Ζήσε ! ένα αλλιώτικο σαββατοκύριακο!     Δείτε το Λουτρό Σφακίων και τις άλλες εποχές του χρόνου διότι είναι ακόμα ποιο ωραία από το καλοκαίρι !   Κολυμπήστε και χαρείτε την θάλασσα όλο το χειμώνα σε θερμοκρασίες καλοκαιριού !   Επιλεγμένες διαδρομές σπάνιας φυσικής ομορφιάς μέσα από μονοπάτια με επισκέψεις σε εξωκλήσια και παραδοσιακά χώρια.  Επιλέξτε διακοπές χαμηλού κόστους αλλα πολύ υψηλής αξίας ! 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 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... About us Welcome to Naturemaniacs.com    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... Login Form Username Password Remember me Lost Password? No account yet? Register Subscribe to NewsLetter Name E-mail Subscribe Unsubscribe Syndicate Latest News Latest Review Loutro Sfakia Kayaking in Loutro 8 Day South Coast Kayak/Hiking Trip 8 Day Western Crete Seakayak Expedtion Popular Prices Sea Kayaking Oasis Hotel Our Programs Kayaking in Loutro Main gallery page Nature Maniacs Image Gallery Sea Kayak and Loutro area photos 24 Images   Oasis Hotel 5 Images   Beaches and Coastlines of Crete 3 Images   Trekking photos 8 Images     Random images     Latest images     RSGallery2 1.12.2 Alpha - SVN: 587 © 2005 - 2007 RSGallery2. All rights reserved.   NatureManiacs Menu Transmenu powered by JoomlArt.com - Mambo Joomla Professional Templates Club Oasis Hotel Our Prices Our Programs FAQs Image Gallery Loutro Random image Trip Calendar March 2010 Su Mo Tu We Th Fr Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Translate Polls What do you prefer on your nature-active holidays? Kayaking ! Trekking ! Sailing ! Ski ! other!   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 15°C Platanias Chania 15°C Athens 16°C London 8°C New York 6°C [Details] Report Time 16:50 Condition --- Wind Chill 12°C Dew Point 5°C Wind Direction 270WWW Variable Wind ---/--- Wind Speed 7.2mps Wind Gust 24k Visibility 10 km Pressure 1015hpa Humidity 51.2% Hum. Index 14.3°C Heat Index --- Precipitation --- Snow --- Platanias Chania Athens London New York Who's Online We have 21 guests online

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 = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1268405910' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268405910' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '771de26e6f68a316fb9297dbde4a0d4d'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = '2af436082d79b4388c9fffd0d278d71d'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '2af436082d79b4388c9fffd0d278d71d','1268406810','','0','1' )
8
SELECT *
 FROM jos_menu
 WHERE id = 1
9
SELECT * FROM jos_rsgallery2_config
10
SELECT * FROM jos_rsgallery2_galleries WHERE id = '0' ORDER BY ordering ASC
11
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '0'
12
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
13
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
14
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
15
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
16
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (0,2,3,4,6)
17
SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '0'
18
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '0'
19
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
20
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
21
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
22
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
23
SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (0,2,3,4,6) ORDER BY rand() LIMIT 1
24
SELECT * FROM jos_rsgallery2_galleries WHERE id = '0' LIMIT 1
25
SELECT name FROM jos_rsgallery2_galleries WHERE id = '0'
26
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '0' ORDER BY ordering ASC
27
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
28
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (4)
29
SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '4'
30
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
31
SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (4) ORDER BY rand() LIMIT 1
32
SELECT * FROM jos_rsgallery2_galleries WHERE id = '4' LIMIT 1
33
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
34
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (6)
35
SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '6'
36
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
37
SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (6) ORDER BY rand() LIMIT 1
38
SELECT * FROM jos_rsgallery2_galleries WHERE id = '6' LIMIT 1
39
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
40
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (2)
41
SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '2'
42
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
43
SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (2) ORDER BY rand() LIMIT 1
44
SELECT * FROM jos_rsgallery2_galleries WHERE id = '2' LIMIT 1
45
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
46
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (3)
47
SELECT thumb_id FROM jos_rsgallery2_galleries WHERE id = '3'
48
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
49
SELECT name FROM jos_rsgallery2_files WHERE gallery_id IN (3) ORDER BY rand() LIMIT 1
50
SELECT * FROM jos_rsgallery2_galleries WHERE id = '3' LIMIT 1
51
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '4'
52
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (4)
53
SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-03-05 00:03:00' AND gallery_id = '4'
54
SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '4' ORDER BY ordering ASC
55
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '6'
56
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (6)
57
SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-03-05 00:03:00' AND gallery_id = '6'
58
SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '6' ORDER BY ordering ASC
59
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '2'
60
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (2)
61
SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-03-05 00:03:00' AND gallery_id = '2'
62
SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '2' ORDER BY ordering ASC
63
SELECT * FROM jos_rsgallery2_galleries WHERE parent = '3'
64
SELECT count(*) FROM jos_rsgallery2_files WHERE gallery_id IN (3)
65
SELECT * FROM jos_rsgallery2_files WHERE date >= '2010-03-05 00:03:00' AND gallery_id = '3'
66
SELECT * FROM jos_rsgallery2_galleries WHERE published = 1 and parent = '3' ORDER BY ordering ASC
67
SELECT COUNT(*) FROM jos_rsgallery2_files WHERE gallery_id='0'
68
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
69
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
70
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'
71
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
72
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 = 1 )
 ORDER BY ordering
73
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
74
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
75
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
76
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-12 10:13' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-12 10:13' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
77
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
78
SELECT id FROM jos_mambots WHERE element = 'analytics' AND folder = 'content'
79
SELECT *
 FROM jos_mambots
 WHERE id = '21'
80
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
81
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-12 07:13:30') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-12 07:13:30')
 AND catid='13' 
 ORDER BY RAND() LIMIT 6
82
SELECT *
 FROM jos_content
 WHERE id = '13'
83
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
84
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
85
SELECT *
 FROM jos_content
 WHERE id = '28'
86
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
87
SELECT *
 FROM jos_content
 WHERE id = '34'
88
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
89
SELECT *
 FROM jos_content
 WHERE id = '23'
90
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
91
SELECT *
 FROM jos_content
 WHERE id = '15'
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 = 15
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
93
SELECT *
 FROM jos_content
 WHERE id = '12'
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 = 12
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
95
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
96
SELECT *
 FROM jos_users
 WHERE id = '0'
97
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 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.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-12 10:13' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-12 10:13' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 5
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 = 35
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
99
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
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 = 30
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
101
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
102
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 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.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-12 10:13' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-12 10:13' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.hits DESC
LIMIT 5
103
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
104
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
105
SELECT m.* FROM jos_menu AS m
WHERE menutype='maniacs_menu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
106
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
107
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
108
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
109
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
110
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=24'
111
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=33'
112
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=0'
113
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
114
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=28'
115
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
116
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=29'
117
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=30'
118
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=19'
119
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
120
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
121
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
122
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=27'
123
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
124
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
125
SELECT * FROM jos_rsgallery2_files ORDER BY Rand() DESC
LIMIT 5
126
SELECT * FROM jos_extcal_config
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') <= 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
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') <= 20100301) 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') <= 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
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') <= 20100302) 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') <= 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
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') <= 20100303) 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') <= 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
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') <= 20100304) 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') <= 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
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') <= 20100305) 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') <= 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
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') <= 20100306) 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') <= 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
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') <= 20100307) 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') <= 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
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') <= 20100308) 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') <= 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
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') <= 20100309) 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') <= 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
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') <= 20100310) 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') <= 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
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') <= 20100311) 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') <= 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
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') <= 20100312) 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') <= 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
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') <= 20100313) 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') <= 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
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') <= 20100314) 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') <= 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
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') <= 20100315) 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') <= 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
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') <= 20100316) 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') <= 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
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') <= 20100317) 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') <= 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
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') <= 20100318) 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') <= 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
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') <= 20100319) 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') <= 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
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') <= 20100320) 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') <= 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
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') <= 20100321) 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') <= 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
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') <= 20100322) 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') <= 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
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') <= 20100323) 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') <= 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
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') <= 20100324) 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') <= 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
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') <= 20100325) 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') <= 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
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') <= 20100326) 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') <= 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
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') <= 20100327) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
181
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
182
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
183
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
184
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
185
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
186
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
187
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
188
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
189
SELECT p.id, p.title
 FROM jos_polls AS p
 INNER JOIN jos_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1
190
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
191
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 14
 AND text != ''
 ORDER BY id
192
SELECT guest, usertype
 FROM jos_session
193
SELECT DISTINCT a.username
 FROM jos_session AS a
 WHERE a.guest = 0