SELECT * FROM games WHERE permalink='takeda-shingen-japan-japanese' LIMIT 1





 TAKEDA SHINGEN (JAPAN, JAPANESE)