An Error Was Encountered

Error Number: 1052

Column 'display' in where clause is ambiguous

SELECT e.*, CASE WHEN v.city IS NOT NULL THEN v.city ELSE CASE WHEN tv.city IS NOT NULL THEN tv.city END END AS city FROM (`event` e) LEFT JOIN `venue` v ON e.venueID = v.venueID LEFT JOIN `temp_venue` tv ON e.eventID = tv.eventID WHERE e.eventID IN ('440119857', '440188733', '440120025', '440153991', '440160917', '440145560', '440120068', '440145517', '440126120', '86537', '123071', '43319', '440187861', '440083264', '440083257', '440083255', '440083254', '72978', '72983', '75667', '80674', '85300', '85669', '87552', '87553', '87555', '440087064', '440095388', '440095391', '440095397', '440095437', '440095440', '440095452', '440095473', '440095487', '440095491', '440095500', '440103785', '440103808', '440104685', '440119625', '440119643', '440119660', '440119691', '440119701', '440119706', '440119775', '440119799', '440119867', '440119880', '440119896', '440119902', '440119918', '440119929', '440119937', '440119949', '440119980', '440119992', '440120084', '440120097', '440120107', '440120117', '440120129', '440120141', '440120149', '440120176', '440120180', '440120188', '440120201', '440120205', '440120217', '440124492', '440124493', '440124494', '440124495', '440124496', '440126136', '440126142', '440126158', '440126703', '440126707', '440126710', '440126713', '440126717', '440126761', '440126885', '440127563', '440127580', '440127668', '440141533', '440141534', '440141537', '440141600', '440141618', '440141933', '440142269', '440145454', '440145463', '440145477', '440145508', '440145513', '440145528', '440145563', '440146031', '440146051', '440146058', '440146062', '440146908', '440151963', '440153852', '440156842', '440157237', '440148289', '440151454', '440151493', '440151630', '440151974', '440151977', '440151978', '440153549', '440153628', '440156717', '440156730', '440156819', '440157202', '440157211', '440160697', '440160710', '440161659', '440162425', '440163483', '440151628', '440165812', '440166678', '440166742', '440167605', '440167612', '440167631', '440167639', '440168388', '440168434', '440168635', '440168720', '440169248', '440171285', '440171646', '440171801', '440171806', '440151512', '440173577', '440175522', '440175547', '440176274', '440177130', '440178492', '440178553', '440178558', '440178561', '440178564', '440178567', '440178570', '440178572', '440178575', '440178581', '440180181', '440180242', '440180691', '440180698', '440180710', '440180890', '440180901', '440180923', '440180952', '440180966', '440182068', '440182085', '440183244', '440183261', '440183288', '440184065', '440188814', '440188839', '440191777', '440191872', '440191895', '440191899', '440191908', '440192443', '440192451', '440193306', '440193339', '440193477', '440194879', '440194887', '440194893', '440194900', '440194989', '440195239', '440195484', '630', '440198454', '440199237', '440199511', '440199600', '440199610', '440199619', '440199639', '440199655', '440199763', '440201215', '440201863', '440202080', '440202115', '440202458', '440202744', '440202827', '440203274', '440203452', '440203959', '639') AND e.dateEnd >= CURDATE() AND display > 0 ORDER BY dateEnd,dateBegin asc