Query using HAVING taking too long – Phpmyadmin
I have a query over two tables -- matchoverview id, home_id, away_id, date, season, result matchattributes id, game_id, attribute_id, attribute_value My query select m.id from matchOverview m join matchAttributes ma on ma.match_id=m.id and ma.attribute_id in (3,4,5,6) group by m.id having…