Post meta data was never designed to be used efficiently in queries. Using it with LIKE
based matching will only make it more horrible.
You need to rethink your DB. For example use taxonomy terms to indicate which social network is associated with a post.