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 ('86827', '440115223', '440141746', '440126873', '440104576', '440141741', '440115196', '440136836', '440115203', '440104603', '440104583', '440104608', '440104599', '440104594', '440115213', '440159946', '609', '440131078', '440131069', '78807', '440131036', '440104588', '440098274', '560', '90531', '440156597', '81216', '440177852', '440146590', '440188609', '440115227', '440146584', '440160104', '440176241', '440162261', '40996', '90525', '90526', '90527', '90529', '90530', '90532', '440115233', '440115239', '440115248', '440115252', '440115255', '440115259', '440115263', '440115266', '440115273', '440115277', '440115282', '440115286', '440126141', '440127607', '440127613', '440127644', '440131074', '440139426', '440139452', '440141535', '440139463', '440141295', '440146449', '440156487', '440156508', '440156617', '440156620', '440156670', '440156828', '440156847', '440158379', '440160110', '440160334', '440160357', '440160362', '440160367', '440160372', '440160385', '440160389', '440162284', '440162559', '440152667', '440156434', '440156462', '440156568', '440156724', '440159964', '440159967', '440159968', '440160122', '440160129', '440160330', '440162270', '624', '440166662', '440171662', '440171795', '440177234', '440179636', '440179650', '440179701', '440179717', '440179740', '440180189', '440180719', '440181129', '440181140', '440181144', '440182261', '440182304', '440185303', '440186480', '440187640', '440191659', '440192534', '440192692', '440193220', '440194856', '440194865', '440194869', '440194872', '440194875', '440195086', '440195162', '440195279', '640', '440201272', '440201801', '440201886', '440202039', '440202251', '440203859', '440204072', '440204075') AND e.dateEnd >= CURDATE() AND display > 0 ORDER BY dateEnd,dateBegin asc