Все начинается с Домена

SELECT b1.* , b2.* FROM domains.`popular_domains` AS b1 INNER JOIN domains.`all_domains` AS b2 ON b1.d_id = b2.d_id;