Cinemas

The cinemas within 15 miles from central Maidstone are:

Failed to find events: Got error 28 from storage engine SELECT DISTINCT e.st_date, e.tag, FROM_UNIXTIME( e.st_date, GET_FORMAT(DATETIME,'ISO')) AS dtstart, FROM_UNIXTIME( e.end_date, GET_FORMAT(DATETIME,'ISO')) AS dtend, DATE_FORMAT(FROM_UNIXTIME(e.st_date), '%D %M %Y') AS StartDate, DATE_FORMAT(FROM_UNIXTIME(e.st_date), '%k:%i') AS StartTime, DATE_FORMAT(FROM_UNIXTIME(e.end_date), '%D %M %Y') AS EndDate, DATE_FORMAT(FROM_UNIXTIME(e.end_date), '%k:%i') AS EndTime, e.eventname, e.locname, e.locpostcode, e.description, e.ticketurl, CASE WHEN e.town_id != t.id THEN '' WHEN e.town_id != tt.id THEN CASE WHEN l.id = 0 THEN CONCAT( s.Name, ', ', t.Name ) ELSE CASE WHEN s.id = 0 THEN l.Name ELSE CONCAT( s.Name, ', ', l.Name, ', ', t.Name ) END END ELSE CASE WHEN l.id = 0 THEN s.Name ELSE CASE WHEN s.id = 0 THEN l.Name ELSE CONCAT( s.Name, ', ', l.Name ) END END END AS Address, g.northing AS Latitude, g.easting AS Longitude, ( COALESCE( acos( g.xaxis * tg.xaxis + g.yaxis * tg.yaxis + g.zaxis * tg.zaxis), 0 ) * 6367.0 / 1.852 ) AS Distance, e.status FROM angle_events.events AS e LEFT JOIN paf.geocode g ON e.locpostcode = g.postcode LEFT JOIN paf.streets s ON g.street_id = s.id LEFT JOIN paf.localities l ON g.locality_id = l.id LEFT JOIN paf.towns t ON g.town_id = t.id INNER JOIN paf.towns tt ON tt.id = 898 INNER JOIN paf.geocode tg ON tt.mappoint = tg.postcode WHERE (e.town_id = 898 OR ( acos( g.xaxis * tg.xaxis + g.yaxis * tg.yaxis + g.zaxis * tg.zaxis ) * 6367.0 / 1.852 ) < 25) AND e.end_date > UNIX_TIMESTAMP() AND e.st_date < (UNIX_TIMESTAMP() + (182 * 86400) ) AND e.status > 0 AND e.tag LIKE '%cinema%' ORDER BY e.st_date ASC limit 100