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 About us Welcome to Naturemaniacs.com    Nature Maniacs goal is to provide high quality outdoor recreational 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 nature, adventure and cultural trips on 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 2009 TRIPS, EXPEDITIONS AND PRICES WILL BE UPLOADED AFTER THE NEW YEAR. WE WILL BE OFFERING NEW EXPEDITIONS, 7 DAY WESTERN CRETE, 7 DAY EASTERN CRETE  AND 5 DAYS GAVDOS ISLAND. PLEASE CHECK BACK FOR ALL THE DETAILS.  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... 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... 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... 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... Login Form Username Password Remember me Lost Password? No account yet? Register Subscribe to NewsLetter Name E-mail Subscribe Unsubscribe Syndicate Latest News Loutro Sfakia Loutro Sfakia Loutro 8 Day Kayaking 8 Day Trekking Popular Prices Sea Kayaking Oasis Hotel Our Programs Loutro Loutro Sfakia Ζήσε ! Χειμερινές εξορμήσεις στη φύση! Ζήσε ! ένα αλλιώτικο σαββατοκύριακο!     Δείτε το Λουτρό Σφακίων και τις άλλες εποχές του χρόνου διότι είναι ακόμα ποιο ωραία από το καλοκαίρι !   Κολυμπήστε και χαρείτε την θάλασσα όλο το χειμώνα σε θερμοκρασίες καλοκαιριού !   Επιλεγμένες διαδρομές σπάνιας φυσικής ομορφιάς μέσα από μονοπάτια με επισκέψεις σε εξωκλήσια και παραδοσιακά χώρια.  Επιλέξτε διακοπές χαμηλού κόστους αλλα πολύ υψηλής αξίας ! Το Λουτρό Σφακιών γνωστό σε όλους για το ζεστό καλοκαιρινό του κλίμα που παραμένει όλο το Χειμώνα όπως επίσης και η γύρω περιοχή (Φοίνιξ – Λύκος , φαράγγι Αράδενας , μάρμαρα, Ανώπολη, όλοι τους τόποι ζωντανής παράδοσης της Κρήτης, τόποι περισυλλογής και δράσης. Το μικρό ξενοδοχείο μας, που ονομάζεται Ξενοδοχείο Όαση, μπορεί να φιλοξενήσει 12-15 άτομα σε 5 δωμάτια με φανταστική θέα σε όλο το Λουτρό. Πρόκειται για ένα ζεστό και φιλόξενο χώρο στον οποίο μπορείτε να απολαύσετε ένα αλλιώτικο σαββατοκύριακο μακριά από άγχος και το στρες τις πολύβουης πόλης είτε ηρεμώντας αφημένοι στην θεά του Λυβικού πελάγους είτε κάνοντας διάφορες εκδρομές αναψυχής στην πανέμορφη γύρω περιοχή . Τα δωμάτια μας στο Λουτρό (Ξενοδοχείο «Όαση») μπορούν να χρησιμοποιηθούν σαν «βάση» για τις μικρές η μεγαλύτερες εξορμήσεις σας στη φύση.     |  ΧΑΡΤΗΣ ΔΙΑΔΡΟΜΩΝ Α   |  ΧΑΡΤΗΣ ΔΙΑΔΡΟΜΩΝ Β Οι διαδρομές που ανεπιφύλακτα σας προτείνουμε είναι οι εξής Λουτρό – Ανώπολη (Μέση διάρκεια 2 ώρες) Λουτρό –Γλυκά νερά – Χώρα Σφακίων (Μέση διάρκεια 1 ώρα και 40 λεπτά) Λουτρό – Φοίνιξ – Λύκος – μάρμαρα  (Μέση διάρκεια 1 ώρα) Λουτρό - Λιβανιανά – φαράγγι Αράδενας – μάρμαρα Και πολλές άλλες διαδρομές  όπως Ανώπολη – Αράδαινα (χωριό) – Αϊ Γιάννης (χωριό)   Next > [ Back ] 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 January 2009 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 11°C Platanias Chania 11°C Athens 9°C London -4°C New York 6°C [Details] Report Time 03:20 Condition --- Wind Chill 9°C Dew Point 9°C Wind Direction 320NW Variable Wind ---/--- Wind Speed 2.6mps Wind Gust --- Visibility 10 km Pressure 1008hpa Humidity 87.5% Hum. Index 11.8°C Heat Index --- Precipitation --- Snow --- Platanias Chania Athens London New York Who's Online

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1231204730' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1231204730' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
5
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
6
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
7
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
10
SELECT *
 FROM jos_menu
 WHERE id = 1
11
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 34 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-05 20:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-05 20:33' )
 AND a.access <= 0
12
SELECT a.id
 FROM jos_content AS a
 WHERE a.catid = 13
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-05 20:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-05 20:33' )
 ORDER BY a.ordering
13
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '34'
14
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT id FROM jos_mambots WHERE element = 'analytics' AND folder = 'content'
16
SELECT *
 FROM jos_mambots
 WHERE id = '21'
17
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'
18
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
19
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
20
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
21
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
22
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
23
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 <= '2009-01-05 20:33' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-05 20:33' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
24
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
25
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 <= '2009-01-05 17:33:51') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-05 17:33:51')
 AND catid='13' 
 ORDER BY RAND() LIMIT 6
26
SELECT *
 FROM jos_content
 WHERE id = '12'
27
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
28
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
29
SELECT *
 FROM jos_content
 WHERE id = '28'
30
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
31
SELECT *
 FROM jos_content
 WHERE id = '15'
32
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
33
SELECT *
 FROM jos_content
 WHERE id = '23'
34
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
35
SELECT *
 FROM jos_content
 WHERE id = '33'
36
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
37
SELECT *
 FROM jos_content
 WHERE id = '24'
38
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 24
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
39
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
40
SELECT *
 FROM jos_users
 WHERE id = '0'
41
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 <= '2009-01-05 20:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-05 20:33' )
 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
42
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
43
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 34
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
44
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
45
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 29
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
46
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 <= '2009-01-05 20:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-05 20:33' )
 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
47
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 18
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
48
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
49
SELECT m.* FROM jos_menu AS m
WHERE menutype='maniacs_menu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
50
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
51
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
52
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=13'
53
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=18'
54
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=24'
55
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=33'
56
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=0'
57
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
58
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=28'
59
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=23'
60
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=29'
61
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=30'
62
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=19'
63
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
64
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=21'
65
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=20'
66
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=27'
67
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=26'
68
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=25'
69
SELECT * FROM jos_rsgallery2_files ORDER BY Rand() DESC
LIMIT 5
70
SELECT * FROM jos_extcal_config
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') <= 20090101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090101 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090101 ) ) 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') <= 20090101) 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') <= 20090102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090102 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090102 ) ) 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') <= 20090102) 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') <= 20090103 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090103 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090103 ) ) 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') <= 20090103) 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') <= 20090104 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090104 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090104 ) ) 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') <= 20090104) 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') <= 20090105 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090105 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090105 ) ) 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') <= 20090105) 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') <= 20090106 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090106 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090106 ) ) 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') <= 20090106) 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') <= 20090107 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090107 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090107 ) ) 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') <= 20090107) 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') <= 20090108 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090108 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090108 ) ) 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') <= 20090108) 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') <= 20090109 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090109 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090109 ) ) 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') <= 20090109) 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') <= 20090110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090110 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090110 ) ) 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') <= 20090110) 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') <= 20090111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090111 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090111 ) ) 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') <= 20090111) 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') <= 20090112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090112 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090112 ) ) 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') <= 20090112) 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') <= 20090113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090113 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090113 ) ) 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') <= 20090113) 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') <= 20090114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090114 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090114 ) ) 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') <= 20090114) 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') <= 20090115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090115 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090115 ) ) 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') <= 20090115) 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') <= 20090116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090116 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090116 ) ) 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') <= 20090116) 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') <= 20090117 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090117 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090117 ) ) 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') <= 20090117) 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') <= 20090118 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090118 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090118 ) ) 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') <= 20090118) 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') <= 20090119 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090119 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090119 ) ) 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') <= 20090119) 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') <= 20090120 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090120 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090120 ) ) 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') <= 20090120) 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') <= 20090121 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090121 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090121 ) ) 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') <= 20090121) 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') <= 20090122 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090122 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090122 ) ) 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') <= 20090122) 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') <= 20090123 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090123 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090123 ) ) 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') <= 20090123) 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') <= 20090124 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090124 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090124 ) ) 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') <= 20090124) 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') <= 20090125 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090125 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090125 ) ) 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') <= 20090125) 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') <= 20090126 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090126 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090126 ) ) 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') <= 20090126) 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') <= 20090127 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090127 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090127 ) ) 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') <= 20090127) 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') <= 20090128 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090128 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090128 ) ) 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') <= 20090128) 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') <= 20090129 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090129 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090129 ) ) 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') <= 20090129) 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') <= 20090130 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090130 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090130 ) ) 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') <= 20090130) 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') <= 20090131 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090131 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090131 ) ) 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') <= 20090131) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
133
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
134
SELECT id
 FROM jos_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
135
SELECT id, text
 FROM jos_poll_data
 WHERE pollid = 14
 AND text != ''
 ORDER BY id
136
SELECT guest, usertype
 FROM jos_session
137
SELECT DISTINCT a.username
 FROM jos_session AS a
 WHERE a.guest = 0