|
|
|
|
|
|
|
|
|
|
|
Еллап карау |
Айлап карау |
Атналап карау |
Бүген |
Эзләү |
Сайланган айга күчү |
|
|
|
No valid database connection Got error 28 from storage engine SQL=SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published
, 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_repetition as rpt
LEFT JOIN jos_jevents_vevent as ev ON rpt.eventid = ev.ev_id
LEFT JOIN jos_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid
LEFT JOIN jos_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN jos_jevents_rrule as rr ON rr.eventid = rpt.eventid
WHERE ev.catid IN(-1,35,36,37,38)
AND rpt.endrepeat >= '2019-01-01 00:00:00' AND rpt.startrepeat <= '2019-12-31 23:59:59' AND ev.state=1
AND ev.access <= 0 AND icsf.state=1 AND icsf.access <= 0 ORDER BY rpt.startrepeat asc LIMIT 20
Вакыйгалар
|
