No valid database connection Table 'strideg_jo151.jos_jevents_vevent' doesn't exist SQL=SELECT ev.*, rpt.*, rr.*, det.*
, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
, YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn
, HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
, HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn
FROM (jos_jevents_vevent as ev, jos_jevents_icsfile as icsf )
LEFT JOIN jos_jevents_repetition as rpt ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule as rr ON rr.eventid = ev.ev_id
WHERE ev.catid IN(-1,61,50,60)
AND ev.access <= 0
AND ev.state=1
AND icsf.ics_id=ev.icsid AND icsf.state=1 AND icsf.access <= 0
AND ((rpt.startrepeat >= '2010-09-01 00:00:00%' AND rpt.startrepeat <= '2010-09-30 23:59:59%')
OR (rpt.endrepeat >= '2010-09-01 00:00:00%' AND rpt.endrepeat <= '2010-09-30 23:59:59%')
OR (rpt.startrepeat >= '2010-09-01 00:00:00%' AND rpt.endrepeat <= '2010-09-30 23:59:59%')
OR (rpt.startrepeat <= '2010-09-01 00:00:00%' AND rpt.endrepeat >= '2010-09-30 23:59:59%'))
September 06 2010
JEvents v1.5.0 alpha
Copyright © 2006-2008
|
