0 - SQL=SELECT det.evdet_id, det.summary as title,
ev.created as created,
CONCAT(det.summary, ' ', det.description, ' ', det.location, ' ', det.contact, ' ', det.extra_info) as text,
CONCAT('Events Calendar','/',det.summary) AS section,
CONCAT('index.php?option=com_jevents&task=icalrepeat.detail&evid=',min(rpt.rp_id)) AS href,
'2' AS browsernav ,
rpt.startrepeat, rpt.rp_id
FROM (copa_jevents_vevent as ev)
INNER JOIN copa_categories AS b ON b.id = ev.catid
LEFT JOIN copa_jevents_repetition as rpt ON rpt.eventid = ev.ev_id
LEFT JOIN copa_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN copa_jevents_icsfile as icsf ON icsf.ics_id = ev.icsid
WHERE ((LOWER(det.summary) LIKE '%Ministério%') OR (LOWER(det.description) LIKE '%Ministério%') OR (LOWER(det.location) LIKE '%Ministério%') OR (LOWER(det.contact) LIKE '%Ministério%') OR (LOWER(det.extra_info) LIKE '%Ministério%'))
AND icsf.state = 1
AND icsf.access IN (1,1,5)
AND ev.state = 1
AND ev.access IN (1,1,5)
AND b.access IN (1,1,5)
AND b.published = '1' AND ev.state=1
GROUP BY det.evdet_id
ORDER BY det.created DESC
LIMIT 50

SQL=SELECT det.evdet_id, det.summary as title,
ev.created as created,
CONCAT(det.summary, ' ', det.description, ' ', det.location, ' ', det.contact, ' ', det.extra_info) as text,
CONCAT('Events Calendar','/',det.summary) AS section,
CONCAT('index.php?option=com_jevents&task=icalrepeat.detail&evid=',min(rpt.rp_id)) AS href,
'2' AS browsernav ,
rpt.startrepeat, rpt.rp_id
FROM (copa_jevents_vevent as ev)
INNER JOIN copa_categories AS b ON b.id = ev.catid
LEFT JOIN copa_jevents_repetition as rpt ON rpt.eventid = ev.ev_id
LEFT JOIN copa_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id
LEFT JOIN copa_jevents_icsfile as icsf ON icsf.ics_id = ev.icsid
WHERE ((LOWER(det.summary) LIKE '%Ministério%') OR (LOWER(det.description) LIKE '%Ministério%') OR (LOWER(det.location) LIKE '%Ministério%') OR (LOWER(det.contact) LIKE '%Ministério%') OR (LOWER(det.extra_info) LIKE '%Ministério%'))
AND icsf.state = 1
AND icsf.access IN (1,1,5)
AND ev.state = 1
AND ev.access IN (1,1,5)
AND b.access IN (1,1,5)
AND b.published = '1' AND ev.state=1
GROUP BY det.evdet_id
ORDER BY det.created DESC
LIMIT 50