ook... mi rimetto a lavoro e vi tengo aggiornati
intanto vi posto la query che ho generato:
SELECT e.id, e.title, e.params, e.catid, e.image, e.file, e.dates, e.time, e.desc, e.next,
l.address as address, l.name as location_name, l.city as city, l.coordinate as coordinate, l.desc as location_desc,
c.title as cat_title, c.color as cat_color, c.desc as cat_desc,
r.id as regisId
FROM `#__xcal_events` AS e
LEFT JOIN `#__xcal_category` AS c ON c.id = e.catid
LEFT JOIN `#__xcal_location` AS l ON l.id = e.location
LEFT JOIN `#__xcal_registration` AS r ON r.eventid = e.id
WHERE e.state =1 AND e.next >= (CURDATE())
ORDER BY e.next
LIMIT 0, 5
Il problema è che nonostante ci sia un evento che soddisfa i requisiti... questo non viene trovato
se vi viene in mente qualcosa ditemelo ok?
