SELECT * FROM `embassy` INNER JOIN `countries` ON embassy.country = countries.countries_id WHERE embassy.country IN (227)

Jl. Taman Ketampon (Permata Bintoro No. 50-51)
Phone: +62 31 5688896
Fax: +62 31 5613777
Surabaya 60264 - Indonesia