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 ('440127448', '440113919', '440134681', '440136884', '440105063', '440167047', '89025', '440183663', '440165969', '440126122', '440193138', '440167556', '440184158', '440184150', '440146997', '627', '125479', '440141533', '440186471', '440188887', '440185847', '440193506', '440193880', '440193900', '440193850', '440095866', '122621', '122730', '124976', '124978', '123859', '124751', '40064', '40065', '40067', '42929', '42974', '43315', '44641', '44044', '44473', '44892', '44893', '47197', '47603', '440187808', '52356', '440083283', '59032', '60888', '60918', '60921', '60931', '60932', '60933', '63155', '65787', '78567', '80755', '80757', '84438', '84439', '86251', '87142', '88430', '89026', '89027', '89029', '90342', '90691', '90692', '91222', '91224', '125483', '125912', '440090938', '440090959', '440090962', '440090966', '440091759', '440095840', '440095846', '440095855', '440103912', '440103918', '440103926', '440103930', '440103938', '440105059', '440111114', '440111566', '440111569', '440111572', '440113932', '440113941', '440113946', '440113949', '440113952', '440115166', '440115174', '440115177', '440115181', '440117310', '440117328', '440118198', '440119306', '440119446', '440119466', '440119764', '440119792', '440120044', '440119818', '440126127', '440126128', '440126135', '440126137', '440126139', '440126143', '440126146', '440126149', '440126150', '440126157', '440126164', '440126170', '440126177', '440126831', '440127338', '440127342', '440127349', '440127409', '440127421', '440127434', '440127440', '440127467', '440127485', '440127497', '440127524', '440129621', '440129627', '440129630', '440129637', '440129692', '440129707', '440134389', '440134664', '440134666', '440134670', '440134672', '440134676', '440134684', '440135858', '440136893', '440137066', '440138883', '40872', '440141722', '440141803', '440148267', '440141879', '440141883', '440141889', '440141895', '440141897', '440141898', '440141946', '440141949', '440142247', '440142254', '440142256', '440142259', '440142261', '440142284', '440142286', '440142287', '440142288', '440142289', '440142292', '40254', '440146050', '440146056', '440146060', '440146443', '440146683', '440146776', '440146780', '440146793', '440146938', '440146992', '440147001', '440148160', '440148161', '440150966', '440156836', '440157172', '440157774', '440160073', '440160075', '440160079', '440163039', '440163044', '440119381', '440148143', '440148154', '440148158', '440150958', '440150963', '440156708', '440156727', '440156773', '440156805', '440157170', '440158423', '440158437', '440159011', '440160058', '440160060', '440160065', '440160241', '440160520', '440162438', '440163029', '440163031', '440163034', '440188071', '440152746', '440166845', '440166850', '440167059', '440167063', '440167072', '440167101', '440167104', '440167106', '440167109', '440167137', '440167139', '440167145', '440167149', '440167154', '440167198', '440167203', '440168395', '440169227', '440169279', '440169297', '440169565', '440170246', '440170268', '440171774', '440171780', '440171786', '440171788', '440169755', '440169765', '440169775', '440169784', '440173787', '440173796', '440173811', '440173816', '440175643', '440176666', '440176672', '440176822', '440177895', '440178132', '440178482', '440149952', '440179855', '440179873', '440179883', '440179914', '440179937', '440180535', '440181263', '440184064', '440184122', '440184168', '440184171', '440184180', '440185744', '440185754', '440185775', '440185779', '440186670', '440188774', '440189379', '440189626', '440189642', '440189853', '440192321', '440193151', '440193155', '440193320', '440193452', '440193500', '440193871', '440194802', '440194811', '440194826', '440194833', '440194838', '440194843', '440194848', '440194970', '440195074', '440195105', '440195119', '440195248', '631', '632', '633', '641', '636', '440198432', '440198444', '440199248', '440201177', '440201186', '440201208', '440201224', '440201229', '440201240', '440201258', '440201509', '440201831', '440202155', '440202217', '440202276', '440202698', '440202799', '440203074', '440203795', '440203887', '440204299') AND e.dateEnd >= CURDATE() AND display > 0 ORDER BY dateEnd,dateBegin asc