{module TITLE}

SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created 

 , 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 io70j_jevents_repetition as rpt

 

  LEFT JOIN io70j_jevents_vevent as ev 

  ON rpt.eventid = ev.ev_id

 

  LEFT JOIN io70j_jevents_icsfile as icsf 

  ON icsf.ics_id=ev.icsid 

 

  LEFT JOIN io70j_jevents_vevdetail as det 

  ON det.evdet_id = rpt.eventdetail_id

 

  LEFT JOIN io70j_jevents_rrule as rr 

  ON rr.eventid = rpt.eventid

 

  WHERE ev.catid IN(-1,158)

 

  AND rpt.endrepeat >= '2016-02-18 09:18:10' 

  AND rpt.startrepeat <= '2017-02-12 23:59:59' 

  AND ev.state=1

 

  AND ev.access  IN (1,1,5)  

  AND icsf.state=1 

 

  AND icsf.access  IN (1,1,5)

 

  GROUP BY rpt.startrepeat , rpt.rp_id

						

  ORDER BY rpt.startrepeat ASC 

  LIMIT 10