I've never heard of an "innodb version 5.2.7". Since 5.1.68, InnoDB version numbers have matched MySQL version numbers; 5.1, 5.5, 5.6, 5.7, 6.0, now 8.0. Let's see the result of ...
select version();
As Jean points out, table126 has no PK, indeed no keys at all, so joins on it will perform poorly, semi-joins more so, indeed without a PK it's not a real table at all.
To preserve text formatting, enclose text in
BBCode code tags
MySQL can usually use one index per table reference in a query, so youmay want to ocmbine some of the indexes on my_list_subscriber according to what Explain reports about queries referencing that table.
Edited 1 time(s). Last edit at 02/03/2018 10:56AM by Peter Brawley.