Sans Frontiers Europe is an independent private organization which provides professional consultancy and assistance to Maltese, European and international private or public companies, enterprises and institutions wishing to participate in EU or Euro-Mediterranean Projects.
Sans Frontiers Europe was founded in February 2007 as a limited liability company though its members already worked together prior to that date under a partnership agreement as a team and in fact have been participating and helping organizations to benefit from EU funded projects since 2002. We are a success-oriented consulting company which specializes in EU funds acquisition. We offer comprehensive and professional consultancy starting from project idea to actual implementation and our services are meticulously designed to meet the specific requirements of our clients.
Sans Frontiers Europe offers a full service including:
1. Researching for EU Funding Opportunities; including open calls, events, partners, technology offers and tenders; 2. Personalized Grants and Funds Report for your organisation; 3. Proposal Writing and Collation; 4. Partner Searches and Consortium Management; 5. Consultancy, training and workshop animation; 6. Project Management and assistance in reporting during project execution.
Sans Frontiers Europe also provides specialized training courses geared towards bridging the gap between Europe and its citizens. Malta is rich in cultural heritage. It is a well known fact that Cultural Heritage is widely recognised across Europe as a vehicle of cultural identity. In fact, how much people know about cultural heritage depends both on what is done to promote it and also on the capacity of Europeans to become familiar with and appreciate their own culture and those of the other EU Member States
1
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering2
SELECT id, link
FROM jos_menu
WHERE menutype = 'mainmenu'
AND published = 1
ORDER BY parent, ordering
LIMIT 13
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 14
DELETE FROM jos_session
WHERE (
( time < '1265698837' )
AND guest = 0
AND gid > 0
) OR (
( time < '1265698837' )
AND guest = 1
AND userid = 0
)5
SELECT *
FROM jos_menu
WHERE id = 16
SELECT COUNT(a.id)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-09 00:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 00:15' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 07
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-09 00:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 00:15' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0
ORDER BY f.ordering
LIMIT 48
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering9
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 1 )
ORDER BY ordering10
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'11
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0'
GROUP BY m.id ORDER BY m.parent, m.ordering12
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'13
SELECT id, name, link, parent, type, menutype, access
FROM jos_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering14
SELECT a.id, a.title, a.sectionid, a.catid, cc.access AS cat_access, s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
LEFT JOIN jos_categories AS cc ON cc.id = a.catid
LEFT JOIN jos_sections AS s ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-09 00:15' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 00:15' )
AND a.access <= 0
ORDER BY a.created DESC
LIMIT 515
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 = 38
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id16
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 017
SELECT id
FROM jos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 018
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 = 37
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id19
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 = 36
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id20
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 35
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id21
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.id22
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering23
SELECT *
FROM jos_banner
WHERE showBanner=124
SELECT id
FROM jos_menu
WHERE link = 'index.php?option=com_search'
AND published = 125
SELECT * FROM jos_jcalpro_config26
SELECT name FROM jos_jcalpro_themes WHERE published= '1'27
SELECT name FROM jos_jcalpro_themes WHERE published= '1'28
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'29
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 5 AND 10
GROUP BY g1.name
ORDER BY g1.lft30
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'31
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft32
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'33
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft34
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'35
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft36
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'37
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft38
SELECT
cat_id, level
FROM
jos_jcalpro_categories39
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'40
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft41
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'42
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft43
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'44
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft45
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'46
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft47
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'48
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft49
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'50
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft51
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'52
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft53
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'54
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft55
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'56
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft57
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'58
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft59
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'60
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft61
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'62
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft63
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'64
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft65
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'66
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft67
SELECT MAX(id) FROM jos_menu WHERE link LIKE '%index.php?option=com_jcalpro%' AND published = '1' AND componentid > 068
SELECT e.*,cat,cat_name from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id
WHERE ( ( ( UNIX_TIMESTAMP(e.end_date) >= UNIX_TIMESTAMP('2010-02-09 08:15:38') ) OR ( UNIX_TIMESTAMP(e.start_date) >= UNIX_TIMESTAMP('2010-02-09 08:15:38') ) )
OR ( e.end_date = '0000-00-00 00:00:01' ) )
AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''
ORDER BY e.start_date,e.title ASC69
SELECT e.*,cat,cat_name from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id
WHERE c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''
ORDER BY e.start_date,e.title ASC70
SELECT name FROM jos_jcalpro_themes WHERE published= '1'71
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100201 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC72
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100201) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC73
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100202 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC74
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100202) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC75
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100203 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC76
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100203) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC77
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100204 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC78
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100204) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC79
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100205 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC80
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100205) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC81
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100206 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC82
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100206) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC83
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100207 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC84
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100207) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC85
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100208 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC86
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100208) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC87
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100209 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC88
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100209) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC89
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100210 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC90
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100210) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC91
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100211 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC92
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100211) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC93
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100212 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC94
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100212) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC95
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100213 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC96
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100213) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC97
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100214 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC98
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100214) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC99
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100215 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC100
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100215) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC101
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100216 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC102
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100216) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC103
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100217 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC104
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100217) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC105
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100218 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC106
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100218) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC107
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100219 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC108
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100219) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC109
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100220 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC110
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100220) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC111
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100221 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC112
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100221) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC113
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100222 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC114
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100222) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC115
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100223 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC116
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100223) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC117
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100224 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC118
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100224) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC119
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100225 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC120
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100225) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC121
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100226 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC122
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100226) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC123
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100227 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC124
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100227) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC125
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100228 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC126
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100228) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC127
SELECT guest, usertype
FROM jos_session
