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

Details...

Kayaking

Dates






Price per person		TBA

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

Prices

Prices

Day Trips 2010 May-October

- Price € 60.00
- No experience necessary
- Duration: 6 to 8 hours
- Departs: Everyday
- Included in price: All sea kayaking equipment, guiding, tuition, a dry bag and snorkelling equipment. Lunch is self-catering. Trip consists of 3-4 hours paddling and 2-3 hours out of kayak time for relaxing, swimming, snorkeling, walking and exploring.
Details...

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

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

Subscribe to NewsLetter
Name E-mail Subscribe Unsubscribe

Monthly View

Flat View

Weekly View

Daily View

Monthly View

Friday, September 03, 2010

September 2010

October 2010

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

August 2010

October 2010

Today

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

August 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

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 21°C
Platanias Chania 21°C Athens 19°C London 7°C New York 27°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 < '1283489032' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1283489032' ) AND guest = 1 AND userid = 0 )

5 SELECT * FROM jos_session WHERE session_id = '8ab9b4982ecbcb4dc39982d7e6644fa5'

6 SELECT session_id FROM jos_session WHERE session_id = '98b1c5cc7aa885307c77f0972627510d'

7 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '98b1c5cc7aa885307c77f0972627510d','1283489932','','0','1' )

8 SELECT * FROM jos_menu WHERE id = 71

9 SELECT * FROM jos_extcal_config

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

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

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

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

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

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

18 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

19 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

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') <= 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

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

22 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

23 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

24 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

25 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

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') <= 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

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

28 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

29 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

30 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

31 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

73 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

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

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

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

77 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-03 00:58' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-03 00:58' ) AND a.catid = 3 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering

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

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

80 SELECT * FROM jos_mambots WHERE id = '21'

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

82 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-02 21:58:52') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-02 21:58:52') AND catid='13' ORDER BY RAND() LIMIT 6

83 SELECT * FROM jos_content WHERE id = '30'

84 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

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

86 SELECT * FROM jos_content WHERE id = '15'

87 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

88 SELECT * FROM jos_content WHERE id = '18'

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

90 SELECT * FROM jos_content WHERE id = '34'

91 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

92 SELECT * FROM jos_content WHERE id = '13'

93 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

94 SELECT * FROM jos_content WHERE id = '23'

95 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

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

97 SELECT * FROM jos_users WHERE id = '0'

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

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

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

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

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

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

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

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

106 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

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

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

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

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

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

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

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

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

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

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

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

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

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') <= 20090801 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090801 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090801 ) ) 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') <= 20090801) 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') <= 20090802 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090802 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090802 ) ) 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') <= 20090802) 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') <= 20090803 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090803 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090803 ) ) 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') <= 20090803) 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') <= 20090804 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090804 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090804 ) ) 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') <= 20090804) 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') <= 20090805 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090805 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090805 ) ) 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') <= 20090805) 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') <= 20090806 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090806 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090806 ) ) 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') <= 20090806) 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') <= 20090807 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090807 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090807 ) ) 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') <= 20090807) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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