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

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

About us

Welcome To Sea Kayak Crete

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

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

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

Details...

Loutro Sfakia

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

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

Δείτε το Λουτρό Σφακίων και τις άλλες εποχές του χρόνου διότι είναι ακόμα ποιο ωραία από το καλοκαίρι !

Κολυμπήστε και χαρείτε την θάλασσα όλο το χειμώνα σε θερμοκρασίες καλοκαιριού !

Επιλεγμένες διαδρομές σπάνιας φυσικής ομορφιάς μέσα από μονοπάτια με επισκέψεις σε εξωκλήσια και παραδοσιακά χώρια.

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

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

8 Day Western Crete Seakayak Expedition

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

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

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

Places Remaining - 6

Included in price

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

Not included in price

Camping equipment, food and food preparation
Occasional night in hotel, campground and restaurant meals (optional)

Expedition plan The aim of the expedition is to circumnavigate western Crete, from Hania on the north coast to Sfakion on the south coast, via the Rodopos and Gramvousa peninsulas. The total distance is about 160km. This equates to about 20km/day in 8 days, however bad weather days will make it necessary to increase the daily mileage.

Required paddling experience

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

Fit enough to paddle up to 30km/day on the expedition
Have effective support strokes and be able to cope with moderate seas
Have some experience of rough water
Able to control the boat down wind and across the wind

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

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

Subscribe to NewsLetter
Name E-mail Subscribe Unsubscribe

Monthly View

Flat View

Weekly View

Daily View

Weekly View

Sun. 05 Sep, 2010 - Sat. 11 Sep, 2010

Previous Week

Week 36

Next Week

There are no events on this week

One Day Trips

8 Day Kayak trips

Half Day Trips

Search Calendar

NatureManiacs Menu

Transmenu powered by JoomlArt.com - Mambo Joomla Professional Templates Club

Random image

Trip Calendar

July 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

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 27°C
Platanias Chania 27°C Athens 27°C London 18°C New York 23°C

[Details]

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 = 71 ) ORDER BY menuid DESC LIMIT 1

4 DELETE FROM jos_session WHERE ( ( time < '1283866942' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1283866942' ) AND guest = 1 AND userid = 0 )

5 SELECT * FROM jos_session WHERE session_id = 'f66d266823d6693184b03f46cb287ac4'

6 SELECT session_id FROM jos_session WHERE session_id = '7f5ba31f5db169474c933b203c9e3b26'

7 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '7f5ba31f5db169474c933b203c9e3b26','1283867842','','0','1' )

8 SELECT * FROM jos_menu WHERE id = 71

9 SELECT * FROM jos_extcal_config

10 SELECT extid FROM jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100905 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100905) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC

11 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100905 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100905 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100905 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

12 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100905) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

13 SELECT extid FROM jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100906 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100906) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC

14 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100906 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100906 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100906 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

15 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100906) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

16 SELECT extid FROM jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100907 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100907) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC

17 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100907 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100907 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100907 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

18 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100907) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

19 SELECT extid FROM jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100908 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100908) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC

20 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100908 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100908 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100908 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

21 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100908) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

22 SELECT extid FROM jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100909 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100909) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC

23 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100909 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100909 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100909 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

24 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100909) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

25 SELECT extid FROM jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100910 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100910) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC

26 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100910 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100910 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100910 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

27 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100910) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

28 SELECT extid FROM jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100911 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100911) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC

29 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100911 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100911 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100911 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

30 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100911) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

31 SELECT cat_id, cat_name, description AS cat_desc, color FROM jos_extcal_categories WHERE published = 1

32 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'

33 SELECT m.id FROM jos_modules AS m WHERE m.module = 'mod_rssfeed' AND m.published = 1

34 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 = 71 ) ORDER BY ordering

35 SELECT id, name, link, parent, type, menutype, access FROM jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering

36 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering

37 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1

38 SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-07 09:57' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-07 09:57' ) AND a.catid = 3 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering

39 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering

40 SELECT id FROM jos_mambots WHERE element = 'analytics' AND folder = 'content'

41 SELECT * FROM jos_mambots WHERE id = '21'

42 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering

43 SELECT a.id FROM jos_content AS a INNER JOIN jos_categories AS b ON b.id = a.catid WHERE a.state = 1 AND a.access <= 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-07 06:57:22') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-07 06:57:22') AND catid='13' ORDER BY RAND() LIMIT 6

44 SELECT * FROM jos_content WHERE id = '15'

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 = 15 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

46 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0

47 SELECT * FROM jos_content WHERE id = '33'

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 = 33 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

49 SELECT * FROM jos_content WHERE id = '12'

50 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 12 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id

51 SELECT * FROM jos_content WHERE id = '34'

52 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

53 SELECT * FROM jos_content WHERE id = '13'

54 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

55 SELECT * FROM jos_content WHERE id = '29'

56 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

57 SELECT m.* FROM jos_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering

58 SELECT * FROM jos_users WHERE id = '0'

59 SELECT m.* FROM jos_menu AS m WHERE menutype='maniacs_menu' AND published='1' AND access <= '0' ORDER BY parent,ordering

60 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1

61 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1

62 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=13'

63 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=18'

64 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=24'

65 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=33'

66 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=0'

67 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

68 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=28'

69 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=23'

70 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=29'

71 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=30'

72 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=19'

73 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=22'

74 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=21'

75 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=20'

76 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=27'

77 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=26'

78 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=25'

79 SELECT * FROM jos_rsgallery2_files ORDER BY Rand() DESC LIMIT 5

80 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100701 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100701 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100701 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

81 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100701) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

82 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100702 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100702 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100702 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

83 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100702) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

84 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100703 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100703 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100703 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

85 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100703) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

86 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100704 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100704 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100704 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

87 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100704) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

88 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100705 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100705 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100705 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

89 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100705) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

90 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100706 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100706 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100706 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

91 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100706) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

92 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100707 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100707 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100707 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

93 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100707) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

94 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100708 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100708 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100708 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

95 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100708) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

96 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100709 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100709 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100709 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

97 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100709) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

98 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100710 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100710 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100710 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

99 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100710) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

100 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100711 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100711 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100711 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

101 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100711) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

102 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100712 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100712 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100712 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

103 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100712) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

104 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100713 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100713 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100713 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

105 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100713) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

106 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100714 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100714 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100714 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

107 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100714) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

108 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100715 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100715 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100715 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

109 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100715) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

110 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100716 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100716 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100716 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

111 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100716) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

112 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100717 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100717 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100717 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

113 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100717) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

114 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100718 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100718 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100718 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

115 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100718) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

116 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100719 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100719 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100719 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

117 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100719) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

118 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100720 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100720 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100720 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

119 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100720) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

120 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100721 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100721 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100721 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

121 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100721) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

122 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100722 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100722 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100722 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

123 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100722) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

124 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100723 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100723 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100723 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

125 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100723) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

126 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100724 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100724 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100724 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

127 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100724) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

128 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100725 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100725 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100725 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

129 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100725) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

130 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100726 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100726 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100726 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

131 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100726) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

132 SELECT e.extid, start_date, end_date from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100727 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100727 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100727 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

133 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_extcal_events AS e LEFT JOIN jos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100727) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

134 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') <= 20100728 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100728 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100728 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

135 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') <= 20100728) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

136 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') <= 20100729 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100729 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100729 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

137 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') <= 20100729) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

138 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') <= 20100730 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100730 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100730 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

139 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') <= 20100730) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

140 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') <= 20100731 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100731 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100731 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC

141 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') <= 20100731) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC