SQL
AخA
select * from page
where page_namespace = 0
and page_title in ("Reiwa_era","Heisei_era","Shōwa_era","Taishō_era","Meiji_era","Keiō","Genji_era","Bunkyū","Man'en","Ansei","Kaei","Kōka","Tenpō","Bunsei","Bunka","Kyōwa","Kansei","Tenmei","An'ei","Meiwa","Hōreki","Kan'en","Enkyō_(Edo_period)","Kanpō","Genbun","Kyōhō","Shōtoku_(era)","Hōei","Genroku","Jōkyō","Tenna","Enpō","Kanbun_(era)","Manji_(era)","Meireki","Jōō_(Edo_period)","Keian","Shōhō","Kan'ei","Genna","Keichō","Bunroku","Tenshō_(Momoyama_period)","Genki_(era)","Eiroku","Kōji_(Muromachi_period)","Tenbun","Kyōroku","Daiei_(era)","Eishō_(Muromachi_period)","Bunki","Meiō","Entoku","Chōkyō","Bunmei","Ōnin","Bunshō","Kanshō","Chōroku","Kōshō","Kyōtoku","Hōtoku","Bun'an","Kakitsu","Eikyō","Shōchō","Ōei","Meitoku","Kōō","Kakei","Shitoku","Eitoku","Kōryaku","Eiwa","Ōan","Jōji","Kōan_(Muromachi_period)","Enbun","Bunna","Kannō","Jōwa_(Muromachi_period)","Kōei","Ryakuō","Shōkyō","Kenmu","Genkō_(1331–34)","Gentoku","Karyaku","Shōchū_(era)","Genkō_(1321–24)","Gen'ō","Bunpō","Shōwa_(1312–1317)","Ōchō","Enkyō_(Kamakura_period)","Tokuji","Kagen","Kengen","Shōan","Einin","Shōō_(Kamakura_period)","Kōan_(Kamakura_period)","Kenji_(era)","Bun'ei","Kōchō","Bun'ō","Shōgen","Shōka_(era)","Kōgen","Kenchō","Hōji_(era)","Kangen","Ninji","En'ō","Ryakunin","Katei","Bunryaku","Tenpuku","Jōei","Kangi","Antei","Karoku","Gennin","Jōō_(Kamakura_period)","Jōkyū","Kempo_(era)","Kenryaku","Jōgen_(Kamakura_period)","Ken'ei","Genkyū","Kennin","Shōji_(era)","Kenkyū","Bunji_(era)","Genryaku","Juei","Yōwa","Jishō","Angen","Jōan_(era)","Kaō_(era)","Nin'an","Eiman","Chōkan","Ōhō","Eiryaku","Heiji","Hōgen_(era)","Kyūju","Ninpei","Kyūan","Ten'yō","Kōji_(Heian_period)","Eiji_(era)","Hōen","Chōshō","Tenshō_(Heian_period)","Daiji_(era)","Tenji_(era)","Hōan","Gen'ei","Eikyū","Ten'ei","Tennin_(era)","Kajō","Chōji","Kōwa_(Heian_period)","Jōtoku","Eichō","Kahō","Kanji_(era)","Ōtoku","Eihō","Jōryaku","Jōhō","Enkyū","Jiryaku","Kōhei","Tengi","Eishō_(Heian_period)","Kantoku","Chōkyū","Chōryaku","Chōgen","Manju_(era)","Jian_(era)","Kannin","Chōwa","Kankō","Chōhō_(era)","Chōtoku","Shōryaku","Eiso_(era)","Eien","Kanna_(era)","Eikan","Tengen_(era)","Jōgen_(Heian_period)","Ten'en","Tenroku","Anna_(era)","Kōhō","Ōwa","Tentoku","Tenryaku","Tengyō","Jōhei","Enchō","Engi_(era)","Shōtai","Kanpyō_(era)","Ninna","Gangyō","Jōgan","Ten'an","Saikō","Ninju","Kashō","Jōwa_(Heian_period)","Tenchō","Kōnin_(era)","Daidō","Enryaku","Ten'ō","Hōki","Jingo-keiun","Tenpyō-jingo","Tenpyō-hōji","Tenpyō-shōhō","Tenpyō-kanpō","Tenpyō","Jinki_(era)","Yōrō","Reiki_(era)","Wadō_(era)","Keiun","Taihō_(era)","Shuchō","Hakuchi_(era)","Taika_(era)")
-- and page_id not in (select cl_from from categorylinks where cl_to = "Japanese_eras")
and page_id not in (select tl_from from templatelinks where tl_target_id = 3036 and tl_from_namespace = 0)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.