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

the query listed below running fine on localhost it's somehow hanging when executed remotely targeting service provider database (both php script , sql query in phpmyadmin console hang), although every chunk returning expected table when run individually.

what's wrong? suggestions on how make shorter or simpler , remote mysql?

select * `table1`  `tag1` in (     select distinct `tag1` `table2`      `tag1` not in (         select `tag1` `table2` `tag2` = '$keyword'     ) )