The event you are looking for is not on this web siteSELECT e.ID AS 'e.ID', e.UserID AS 'e.UserID', e.Title AS 'e.Title', e.Description AS 'e.Description', e.CreationDate AS 'e.CreationDate', e.ModificationDate AS 'e.ModificationDate', COUNT(ee.ID) AS 'totEventsByUser',
e.KindID AS 'e.KindID', e.GenreID AS 'e.GenreID', e.KnowMoreURL AS 'e.KnowMoreURL', e.VideoURL AS 'e.VideoURL', e.Views AS 'e.Views', e.Status AS 'e.Status', v.PlaceID AS 'v.PlaceID', p.Name AS 'p.Name', p.Address AS 'p.Address', p.ZIP AS 'p.ZIP', p.Latitude AS 'p.Latitude', p.Longitude AS 'p.Longitude', p.Web AS 'p.Web', p.Email AS 'p.Email',
p.Phone AS 'p.Phone', p.Fax AS 'p.Fax', p.CityID AS 'p.CityID', c.City AS 'c.City', c.Region AS 'c.Region', c.CountryCode AS 'c.CountryCode', k.Title AS 'k.Title', g.Title AS 'g.Title', k.Color AS 'k.Color', t.Name AS 't.Name', t.Code AS 't.Code', u.ID AS 'u.ID', u.Username AS 'u.Username', u.Status AS 'u.Status', u.Role AS 'u.Role', u.Votes AS 'u.Votes', u.Trust AS 'u.Trust', u.Organization AS 'u.Organization', a.VoterID AS 'a.VoterID', a.AssetID AS 'a.AssetID', a.Kind AS 'a.Kind', d.StartDate AS 'd.StartDate', dm.Price AS 'dm.Price', dm.PriceMax AS 'dm.PriceMax', dm.Currency AS 'dm.Currency', dm.Info AS 'dm.Info', dm.Hall AS 'dm.Hall', n.Symbol AS 'n.Symbol', GROUP_CONCAT(DISTINCT v.PlaceID SEPARATOR ',') AS 'PLACES_IDS', SUM(aa.Kind) AS 'aa.AlertsSum' FROM events AS e INNER JOIN venues as v on e.ID = v.EventID LEFT JOIN places AS p on v.PlaceID = p.ID LEFT JOIN cities AS c on p.CityID = c.ID LEFT JOIN countries AS t on c.CountryCode = t.Code LEFT JOIN dates AS d on e.ID = d.EventID LEFT JOIN datesM AS dm on (v.ID = dm.VenueID AND d.StartDate >= dm.StartDate AND d.StartDate <= dm.EndDate) LEFT JOIN currencies AS n on dm.Currency = n.Code LEFT JOIN kinds AS k on e.KindID = k.ID LEFT JOIN genres AS g on e.GenreID = g.ID LEFT JOIN users AS u on e.UserID = u.ID LEFT JOIN events AS ee on u.ID = ee.UserID LEFT JOIN alerts AS a on (a.Asset = 'e' AND e.ID = a.AssetID AND a.VoterID = '') LEFT JOIN alerts AS aa on (a.Asset = 'e' AND e.ID = aa.AssetID) WHERE e.ID = '1833' AND ((u.Status = '0' AND e.Status = '0') OR (u.Status >= '-10' AND e.UserID = '' AND e.Status >= '-10')) GROUP BY d.StartDate LIMIT 1