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. Our 8 day trip is by request only for groups of 6 or more, please contact us for more information.

Details...

Our Programs

Programs

Sea Kayaking

Explore the gorgeous coastlines of Crete from a different angle, by Sea Kayak. We provide half-day, day, multi-day and customized trips along with lessons. No experience necessary to participate, we will provide you with all the needed skills. Details...

Prices

Prices

Day Trips 2008 May-October

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

All our programs

Programs

Sea Kayaking

Details...

Kayaking

Dates






Price per person		TBA

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

Sea Kayaking

Sea Kayaking

In our day trips we explore various areas on the South coast of Crete, starting from the seaside village of Loutro.

A typical trip consists of up to 1 hour of briefing and set up time, 3-4 hours of paddling and 2-3 Details...

Subscribe to NewsLetter
Name E-mail Subscribe Unsubscribe

Monthly View

Flat View

Weekly View

Daily View

Monthly View

Tuesday, January 06, 2009

January 2009

February 2009

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

December 2008

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

January 2009

Su	Mo	Tu	We	Th	Fr	Sa
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31

Translate

Live Weather

Warning: fopen(/home/russ/public_html/modules/MambWeather/LGSA_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/LGAV_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/EGKK_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/KNYC_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210

Warning: fopen(/home/russ/public_html/modules/MambWeather/LGSA_metar_cache.txt) [function.fopen]: failed to open stream: Permission denied in /home/russ/public_html/modules/MambWeather/metar.class.php on line 210


Platanias Chania 11°C
Platanias Chania 11°C Athens 8°C London -4°C New York 6°C

[Details]

1 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering

2 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 71 ) ORDER BY menuid DESC LIMIT 1

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

4 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 0

5 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 0

6 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 1

7 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 1

8 SELECT COUNT(*) FROM jos_stats_agents WHERE agent = 'Unknown' AND type = 2

9 UPDATE jos_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 2

10 SELECT * FROM jos_menu WHERE id = 71

11 SELECT * FROM jos_extcal_config

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

77 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

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

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

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

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

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

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

84 SELECT * FROM jos_mambots WHERE id = '21'

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

86 SELECT a.id FROM jos_content AS a INNER JOIN jos_categories AS b ON b.id = a.catid WHERE a.state = 1 AND a.access <= 0 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-05 17:17:46') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-05 17:17:46') AND catid='13' ORDER BY RAND() LIMIT 6

87 SELECT * FROM jos_content WHERE id = '30'

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

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

90 SELECT * FROM jos_content WHERE id = '24'

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

92 SELECT * FROM jos_content WHERE id = '18'

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

94 SELECT * FROM jos_content WHERE id = '28'

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

96 SELECT * FROM jos_content WHERE id = '15'

97 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

98 SELECT * FROM jos_content WHERE id = '23'

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

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

101 SELECT * FROM jos_users WHERE id = '0'

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

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

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

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

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

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

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

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

110 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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') <= 20090109) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY