As state workers face unprecedented attacks on our wages and benefits, Solidarity Forever is more important then ever. Take a minute and listen.. Solidarity Forever

 

Find Meetings and Events

November 2017 December 2017 January 2018
Su Mo Tu We Th Fr Sa
Week 48 1 2
Week 49 3 4 5 6 7 8 9
Week 50 10 11 12 13 14 15 16
Week 51 17 18 19 20 21 22 23
Week 52 24 25 26 27 28 29 30
Week 53 31

Who's Online

We have 1 guest online

UAW Local 6000 Login

             |  The “log-on” section of the website contains information that is only available to Local 6000 members and retirees.

You can now watch the House and Senate Sessions –Live
Just click on “Video” on the left.

Monthly View
Monthly View
Flat View
Flat View
Weekly View
Weekly View
Daily View
Daily View
Categories
Categories
Search
Search

Monthly View

Wednesday, December 13, 2017
    November 2017 November 2017 December 2017 January 2018 January 2018
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
48 November 2017 November 2017 November 2017 November 2017 November 2017
  1
  2
49
  3
  4
  5
  6
  7
  8
  9
50
  10
  11
  12
  13
  14
  15
  16
51
  17
  18
  19
  20
  21
  22
  23
52
  24
  25
  26
  27
  28
  29
  30
53
  31
January 2018 January 2018 January 2018 January 2018 January 2018 January 2018
Today   General   Special Days   State Employee Holidays  

Search Calendar

UAW Local 6000 Calendar

193 queries executed
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 = 1 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM jos_session WHERE ( ( time < '1513183324' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1513183324' ) AND guest = 1 AND userid = 0 )
5 SELECT id FROM jos_mambots WHERE element = 'bot_google_analytics' AND folder = 'system'
6 SELECT * FROM jos_mambots WHERE id = '25'
7 SELECT published FROM jos_mambots WHERE element = 'bot_google_analytics' AND folder = 'system'
8 SELECT * FROM jos_menu WHERE id = 1
9 SELECT * FROM jos_jcalpro_config
10 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
11 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
12 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
13 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.lft
14 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
15 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.lft
16 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
17 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.lft
18 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
19 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.lft
20 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
21 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.lft
22 SELECT cat_id, level FROM jos_jcalpro_categories
23 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
24 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.lft
25 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
26 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.lft
27 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
28 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.lft
29 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
30 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.lft
31 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
32 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.lft
33 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
34 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.lft
35 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
36 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.lft
37 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
38 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.lft
39 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
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 5 AND 10 GROUP BY g1.name ORDER BY g1.lft
41 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.lft
43 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
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 5 AND 10 GROUP BY g1.name ORDER BY g1.lft
45 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.lft
47 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.lft
49 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.lft
51 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') <= 20171201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171201 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
52 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') <= 20171201) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
53 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') <= 20171202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171202 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
54 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') <= 20171202) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
55 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') <= 20171203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171203 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
56 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') <= 20171203) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
57 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') <= 20171204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171204 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
58 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') <= 20171204) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
59 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') <= 20171205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171205 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
60 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') <= 20171205) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
61 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') <= 20171206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171206 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
62 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') <= 20171206) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
63 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') <= 20171207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171207 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
64 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') <= 20171207) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
65 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') <= 20171208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171208 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
66 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') <= 20171208) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
67 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') <= 20171209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171209 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
68 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') <= 20171209) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
69 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') <= 20171210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171210 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
70 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') <= 20171210) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
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') <= 20171211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171211 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
72 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') <= 20171211) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
73 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') <= 20171212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171212 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
74 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') <= 20171212) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
75 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') <= 20171213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171213 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
76 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') <= 20171213) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
77 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') <= 20171214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171214 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
78 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') <= 20171214) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
79 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') <= 20171215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171215 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
80 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') <= 20171215) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
81 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') <= 20171216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171216 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
82 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') <= 20171216) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
83 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') <= 20171217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171217 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
84 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') <= 20171217) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
85 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') <= 20171218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171218 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
86 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') <= 20171218) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
87 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') <= 20171219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171219 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
88 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') <= 20171219) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
89 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') <= 20171220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171220 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
90 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') <= 20171220) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
91 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') <= 20171221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171221 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
92 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') <= 20171221) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
93 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') <= 20171222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171222 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94 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') <= 20171222) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
95 SELECT e.*,cat_name, color, c.description AS cat_desc FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='1467'
96 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
97 SELECT e.*,cat_name, color, c.description AS cat_desc FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='1308'
98 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') <= 20171223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171223 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
99 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') <= 20171223) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
100 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') <= 20171224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171224 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
101 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') <= 20171224) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
102 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') <= 20171225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171225 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
103 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') <= 20171225) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
104 SELECT e.*,cat_name, color, c.description AS cat_desc FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='1309'
105 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') <= 20171226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171226 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106 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') <= 20171226) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
107 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') <= 20171227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171227 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108 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') <= 20171227) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
109 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') <= 20171228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171228 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110 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') <= 20171228) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
111 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') <= 20171229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171229 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
112 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') <= 20171229) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
113 SELECT e.*,cat_name, color, c.description AS cat_desc FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='1310'
114 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') <= 20171230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171230 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
115 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') <= 20171230) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
116 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') <= 20171231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171231 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
117 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') <= 20171231) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
118 SELECT cat_id, cat_name, description AS cat_desc, color FROM jos_jcalpro_categories WHERE published = 1 ORDER BY cat_name
119 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
120 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
121 SELECT m.* FROM jos_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
122 SELECT m.* FROM jos_menu AS m WHERE menutype = 'usermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
123 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 1 ) ORDER BY ordering
124 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'
125 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
126 SELECT p.id, p.title FROM jos_polls AS p INNER JOIN jos_poll_menu AS pm ON pm.pollid = p.id WHERE ( pm.menuid = 1 OR pm.menuid = 0 ) AND p.published = 1
127 SELECT id FROM jos_menu WHERE type = 'components' AND published = 1 AND link = 'index.php?option=com_poll'
128 SELECT params FROM jos_mambots WHERE element = 'jw_allvideos' AND folder = 'content'
129 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
130 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') <= 20171201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171201 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
131 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') <= 20171201) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
132 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') <= 20171202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171202 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
133 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') <= 20171202) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
134 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') <= 20171203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171203 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
135 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') <= 20171203) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
136 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') <= 20171204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171204 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
137 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') <= 20171204) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
138 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') <= 20171205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171205 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
139 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') <= 20171205) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
140 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') <= 20171206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171206 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
141 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') <= 20171206) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
142 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') <= 20171207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171207 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
143 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') <= 20171207) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
144 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') <= 20171208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171208 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
145 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') <= 20171208) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
146 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') <= 20171209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171209 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
147 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') <= 20171209) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
148 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') <= 20171210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171210 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
149 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') <= 20171210) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
150 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') <= 20171211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171211 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
151 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') <= 20171211) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
152 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') <= 20171212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171212 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
153 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') <= 20171212) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
154 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') <= 20171213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171213 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
155 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') <= 20171213) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
156 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') <= 20171214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171214 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
157 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') <= 20171214) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
158 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') <= 20171215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171215 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
159 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') <= 20171215) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
160 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') <= 20171216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171216 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
161 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') <= 20171216) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
162 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') <= 20171217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171217 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
163 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') <= 20171217) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
164 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') <= 20171218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171218 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
165 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') <= 20171218) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
166 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') <= 20171219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171219 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
167 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') <= 20171219) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
168 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') <= 20171220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171220 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
169 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') <= 20171220) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
170 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') <= 20171221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171221 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
171 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') <= 20171221) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
172 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') <= 20171222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171222 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
173 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') <= 20171222) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
174 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') <= 20171223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171223 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
175 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') <= 20171223) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
176 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') <= 20171224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171224 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
177 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') <= 20171224) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
178 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') <= 20171225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171225 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
179 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') <= 20171225) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
180 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') <= 20171226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171226 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
181 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') <= 20171226) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
182 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') <= 20171227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171227 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
183 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') <= 20171227) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
184 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') <= 20171228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171228 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
185 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') <= 20171228) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
186 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') <= 20171229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171229 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
187 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') <= 20171229) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
188 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') <= 20171230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171230 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
189 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') <= 20171230) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
190 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') <= 20171231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171231 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
191 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') <= 20171231) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
192 SELECT guest, usertype FROM jos_session
193 SELECT id, name, link, parent, type, menutype, access FROM jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering