Remote mysql not executing query: how to make it simpler?

Vote count:

-1

The query listed below is running fine on localhost but it's somehow hanging when executed remotely targeting my service provider db (both the php script and the sql query in phpMyAdmin console hang), although every chunk is returning the promised table if run individually. Where am I wrong? Any suggestion on how to make it shorter or simpler and thus help the remote mysql? Thanks a lot.

$sql = "SELECT * FROM `Table1` WHERE `Tag1` IN (SELECT DISTINCT `Tag1` FROM `Table2` WHERE `Tag1` NOT IN (SELECT `Tag1` FROM `Table2` WHERE `Tag2` = '$keyWord'))";

edited 48 secs ago

Ghost

25.2k

asked 3 mins ago

SteveThePest

1

Remote mysql not executing query: how to make it simpler?