SELECTd0_.idASid_0,d0_.page_nameASpage_name_1,d0_.urlASurl_2,d0_.file_nameASfile_name_3,d0_.edit_typeASedit_type_4,d0_.authorASauthor_5,d0_.descriptionASdescription_6,d0_.keywordASkeyword_7,d0_.create_dateAScreate_date_8,d0_.update_dateASupdate_date_9,d0_.meta_robotsASmeta_robots_10,d0_.meta_tagsASmeta_tags_11,d1_.page_idASpage_id_12,d1_.layout_idASlayout_id_13,d1_.sort_noASsort_no_14,d2_.idASid_15,d2_.layout_nameASlayout_name_16,d2_.create_dateAScreate_date_17,d2_.update_dateASupdate_date_18,d0_.discriminator_typeASdiscriminator_type_19,d0_.master_page_idASmaster_page_id_20,d1_.discriminator_typeASdiscriminator_type_21,d1_.page_idASpage_id_22,d1_.layout_idASlayout_id_23,d2_.discriminator_typeASdiscriminator_type_24,d2_.device_type_idASdevice_type_id_25FROMdtb_paged0_LEFT JOINdtb_page_layoutd1_ONd0_.id=d1_.page_idANDd1_.discriminator_typeIN ('pagelayout') LEFT JOINdtb_layoutd2_ONd1_.layout_id=d2_.idANDd2_.discriminator_typeIN ('layout') WHERE (d0_.url=?) ANDd0_.discriminator_typeIN ('page')
SELECTd0_.idASid_0,d0_.page_nameASpage_name_1,d0_.urlASurl_2,d0_.file_nameASfile_name_3,d0_.edit_typeASedit_type_4,d0_.authorASauthor_5,d0_.descriptionASdescription_6,d0_.keywordASkeyword_7,d0_.create_dateAScreate_date_8,d0_.update_dateASupdate_date_9,d0_.meta_robotsASmeta_robots_10,d0_.meta_tagsASmeta_tags_11,d1_.page_idASpage_id_12,d1_.layout_idASlayout_id_13,d1_.sort_noASsort_no_14,d2_.idASid_15,d2_.layout_nameASlayout_name_16,d2_.create_dateAScreate_date_17,d2_.update_dateASupdate_date_18,d0_.discriminator_typeASdiscriminator_type_19,d0_.master_page_idASmaster_page_id_20,d1_.discriminator_typeASdiscriminator_type_21,d1_.page_idASpage_id_22,d1_.layout_idASlayout_id_23,d2_.discriminator_typeASdiscriminator_type_24,d2_.device_type_idASdevice_type_id_25FROMdtb_paged0_LEFT JOINdtb_page_layoutd1_ONd0_.id=d1_.page_idANDd1_.discriminator_typeIN ('pagelayout')
LEFT JOINdtb_layoutd2_ONd1_.layout_id=d2_.idANDd2_.discriminator_typeIN ('layout')
WHERE
(d0_.url=?)
ANDd0_.discriminator_typeIN ('page')
SELECTd0_.idASid_0,d0_.page_nameASpage_name_1,d0_.urlASurl_2,d0_.file_nameASfile_name_3,d0_.edit_typeASedit_type_4,d0_.authorASauthor_5,d0_.descriptionASdescription_6,d0_.keywordASkeyword_7,d0_.create_dateAScreate_date_8,d0_.update_dateASupdate_date_9,d0_.meta_robotsASmeta_robots_10,d0_.meta_tagsASmeta_tags_11,d1_.page_idASpage_id_12,d1_.layout_idASlayout_id_13,d1_.sort_noASsort_no_14,d2_.idASid_15,d2_.layout_nameASlayout_name_16,d2_.create_dateAScreate_date_17,d2_.update_dateASupdate_date_18,d0_.discriminator_typeASdiscriminator_type_19,d0_.master_page_idASmaster_page_id_20,d1_.discriminator_typeASdiscriminator_type_21,d1_.page_idASpage_id_22,d1_.layout_idASlayout_id_23,d2_.discriminator_typeASdiscriminator_type_24,d2_.device_type_idASdevice_type_id_25FROMdtb_paged0_LEFT JOINdtb_page_layoutd1_ONd0_.id=d1_.page_idANDd1_.discriminator_typeIN ('pagelayout') LEFT JOINdtb_layoutd2_ONd1_.layout_id=d2_.idANDd2_.discriminator_typeIN ('layout') WHERE (d0_.url='nekoposu') ANDd0_.discriminator_typeIN ('page');
SELECTt0.idASid_1,t0.category_nameAScategory_name_2,t0.hierarchyAShierarchy_3,t0.sort_noASsort_no_4,t0.create_dateAScreate_date_5,t0.update_dateASupdate_date_6,t0.urlASurl_7,t0.title_image_pathAStitle_image_path_8,t0.teikikoudoku1ASteikikoudoku1_9,t0.teikikoudoku2ASteikikoudoku2_10,t0.menunoASmenuno_11,t0.kankouASkankou_12,t0.hatsubaibiAShatsubaibi_13,t0.newnoASnewno_14,t0.linkimage01ASlinkimage01_15,t0.linkimage02ASlinkimage02_16,t0.linkimage03ASlinkimage03_17,t0.linkimage04ASlinkimage04_18,t0.linkimage05ASlinkimage05_19,t0.linkimage06ASlinkimage06_20,t0.linkimage07ASlinkimage07_21,t0.linkimage08ASlinkimage08_22,t0.linkimage09ASlinkimage09_23,t0.linkimage10ASlinkimage10_24,t0.linkimage11ASlinkimage11_25,t0.linkimage12ASlinkimage12_26,t0.linkimage13ASlinkimage13_27,t0.linkimage14ASlinkimage14_28,t0.linkimage15ASlinkimage15_29,t0.linkimage16ASlinkimage16_30,t0.linkimage17ASlinkimage17_31,t0.linkimage18ASlinkimage18_32,t0.linkimage19ASlinkimage19_33,t0.linkimage20ASlinkimage20_34,t0.linkimage21ASlinkimage21_35,t0.linkimage22ASlinkimage22_36,t0.linkimage23ASlinkimage23_37,t0.linkimage24ASlinkimage24_38,t0.linkimage25ASlinkimage25_39,t0.linkimage26ASlinkimage26_40,t0.linkimage27ASlinkimage27_41,t0.linkimage28ASlinkimage28_42,t0.linkimage29ASlinkimage29_43,t0.linkimage30ASlinkimage30_44,t0.link01ASlink01_45,t0.link02ASlink02_46,t0.link03ASlink03_47,t0.link04ASlink04_48,t0.link05ASlink05_49,t0.link06ASlink06_50,t0.link07ASlink07_51,t0.link08ASlink08_52,t0.link09ASlink09_53,t0.link10ASlink10_54,t0.link11ASlink11_55,t0.link12ASlink12_56,t0.link13ASlink13_57,t0.link14ASlink14_58,t0.link15ASlink15_59,t0.link16ASlink16_60,t0.link17ASlink17_61,t0.link18ASlink18_62,t0.link19ASlink19_63,t0.link20ASlink20_64,t0.link21ASlink21_65,t0.link22ASlink22_66,t0.link23ASlink23_67,t0.link24ASlink24_68,t0.link25ASlink25_69,t0.link26ASlink26_70,t0.link27ASlink27_71,t0.link28ASlink28_72,t0.link29ASlink29_73,t0.link30ASlink30_74,t0.blank01ASblank01_75,t0.blank02ASblank02_76,t0.blank03ASblank03_77,t0.blank04ASblank04_78,t0.blank05ASblank05_79,t0.blank06ASblank06_80,t0.blank07ASblank07_81,t0.blank08ASblank08_82,t0.blank09ASblank09_83,t0.blank10ASblank10_84,t0.blank11ASblank11_85,t0.blank12ASblank12_86,t0.blank13ASblank13_87,t0.blank14ASblank14_88,t0.blank15ASblank15_89,t0.blank16ASblank16_90,t0.blank17ASblank17_91,t0.blank18ASblank18_92,t0.blank19ASblank19_93,t0.blank20ASblank20_94,t0.blank21ASblank21_95,t0.blank22ASblank22_96,t0.blank23ASblank23_97,t0.blank24ASblank24_98,t0.blank25ASblank25_99,t0.blank26ASblank26_100,t0.blank27ASblank27_101,t0.blank28ASblank28_102,t0.blank29ASblank29_103,t0.blank30ASblank30_104,t0.newcateASnewcate_105,t0.dspflASdspfl_106,t0.parent_category_idASparent_category_id_107,t0.creator_idAScreator_id_108,t0.discriminator_typeFROMdtb_categoryt0WHEREt0.parent_category_id=?ANDt0.discriminator_typeIN ('category') ORDER BYt0.sort_noDESC
SELECTt0.idASid_1,t0.category_nameAScategory_name_2,t0.hierarchyAShierarchy_3,t0.sort_noASsort_no_4,t0.create_dateAScreate_date_5,t0.update_dateASupdate_date_6,t0.urlASurl_7,t0.title_image_pathAStitle_image_path_8,t0.teikikoudoku1ASteikikoudoku1_9,t0.teikikoudoku2ASteikikoudoku2_10,t0.menunoASmenuno_11,t0.kankouASkankou_12,t0.hatsubaibiAShatsubaibi_13,t0.newnoASnewno_14,t0.linkimage01ASlinkimage01_15,t0.linkimage02ASlinkimage02_16,t0.linkimage03ASlinkimage03_17,t0.linkimage04ASlinkimage04_18,t0.linkimage05ASlinkimage05_19,t0.linkimage06ASlinkimage06_20,t0.linkimage07ASlinkimage07_21,t0.linkimage08ASlinkimage08_22,t0.linkimage09ASlinkimage09_23,t0.linkimage10ASlinkimage10_24,t0.linkimage11ASlinkimage11_25,t0.linkimage12ASlinkimage12_26,t0.linkimage13ASlinkimage13_27,t0.linkimage14ASlinkimage14_28,t0.linkimage15ASlinkimage15_29,t0.linkimage16ASlinkimage16_30,t0.linkimage17ASlinkimage17_31,t0.linkimage18ASlinkimage18_32,t0.linkimage19ASlinkimage19_33,t0.linkimage20ASlinkimage20_34,t0.linkimage21ASlinkimage21_35,t0.linkimage22ASlinkimage22_36,t0.linkimage23ASlinkimage23_37,t0.linkimage24ASlinkimage24_38,t0.linkimage25ASlinkimage25_39,t0.linkimage26ASlinkimage26_40,t0.linkimage27ASlinkimage27_41,t0.linkimage28ASlinkimage28_42,t0.linkimage29ASlinkimage29_43,t0.linkimage30ASlinkimage30_44,t0.link01ASlink01_45,t0.link02ASlink02_46,t0.link03ASlink03_47,t0.link04ASlink04_48,t0.link05ASlink05_49,t0.link06ASlink06_50,t0.link07ASlink07_51,t0.link08ASlink08_52,t0.link09ASlink09_53,t0.link10ASlink10_54,t0.link11ASlink11_55,t0.link12ASlink12_56,t0.link13ASlink13_57,t0.link14ASlink14_58,t0.link15ASlink15_59,t0.link16ASlink16_60,t0.link17ASlink17_61,t0.link18ASlink18_62,t0.link19ASlink19_63,t0.link20ASlink20_64,t0.link21ASlink21_65,t0.link22ASlink22_66,t0.link23ASlink23_67,t0.link24ASlink24_68,t0.link25ASlink25_69,t0.link26ASlink26_70,t0.link27ASlink27_71,t0.link28ASlink28_72,t0.link29ASlink29_73,t0.link30ASlink30_74,t0.blank01ASblank01_75,t0.blank02ASblank02_76,t0.blank03ASblank03_77,t0.blank04ASblank04_78,t0.blank05ASblank05_79,t0.blank06ASblank06_80,t0.blank07ASblank07_81,t0.blank08ASblank08_82,t0.blank09ASblank09_83,t0.blank10ASblank10_84,t0.blank11ASblank11_85,t0.blank12ASblank12_86,t0.blank13ASblank13_87,t0.blank14ASblank14_88,t0.blank15ASblank15_89,t0.blank16ASblank16_90,t0.blank17ASblank17_91,t0.blank18ASblank18_92,t0.blank19ASblank19_93,t0.blank20ASblank20_94,t0.blank21ASblank21_95,t0.blank22ASblank22_96,t0.blank23ASblank23_97,t0.blank24ASblank24_98,t0.blank25ASblank25_99,t0.blank26ASblank26_100,t0.blank27ASblank27_101,t0.blank28ASblank28_102,t0.blank29ASblank29_103,t0.blank30ASblank30_104,t0.newcateASnewcate_105,t0.dspflASdspfl_106,t0.parent_category_idASparent_category_id_107,t0.creator_idAScreator_id_108,t0.discriminator_typeFROMdtb_categoryt0WHEREt0.parent_category_id=?ANDt0.discriminator_typeIN ('category')
ORDER BYt0.sort_noDESC
SELECTt0.idASid_1,t0.category_nameAScategory_name_2,t0.hierarchyAShierarchy_3,t0.sort_noASsort_no_4,t0.create_dateAScreate_date_5,t0.update_dateASupdate_date_6,t0.urlASurl_7,t0.title_image_pathAStitle_image_path_8,t0.teikikoudoku1ASteikikoudoku1_9,t0.teikikoudoku2ASteikikoudoku2_10,t0.menunoASmenuno_11,t0.kankouASkankou_12,t0.hatsubaibiAShatsubaibi_13,t0.newnoASnewno_14,t0.linkimage01ASlinkimage01_15,t0.linkimage02ASlinkimage02_16,t0.linkimage03ASlinkimage03_17,t0.linkimage04ASlinkimage04_18,t0.linkimage05ASlinkimage05_19,t0.linkimage06ASlinkimage06_20,t0.linkimage07ASlinkimage07_21,t0.linkimage08ASlinkimage08_22,t0.linkimage09ASlinkimage09_23,t0.linkimage10ASlinkimage10_24,t0.linkimage11ASlinkimage11_25,t0.linkimage12ASlinkimage12_26,t0.linkimage13ASlinkimage13_27,t0.linkimage14ASlinkimage14_28,t0.linkimage15ASlinkimage15_29,t0.linkimage16ASlinkimage16_30,t0.linkimage17ASlinkimage17_31,t0.linkimage18ASlinkimage18_32,t0.linkimage19ASlinkimage19_33,t0.linkimage20ASlinkimage20_34,t0.linkimage21ASlinkimage21_35,t0.linkimage22ASlinkimage22_36,t0.linkimage23ASlinkimage23_37,t0.linkimage24ASlinkimage24_38,t0.linkimage25ASlinkimage25_39,t0.linkimage26ASlinkimage26_40,t0.linkimage27ASlinkimage27_41,t0.linkimage28ASlinkimage28_42,t0.linkimage29ASlinkimage29_43,t0.linkimage30ASlinkimage30_44,t0.link01ASlink01_45,t0.link02ASlink02_46,t0.link03ASlink03_47,t0.link04ASlink04_48,t0.link05ASlink05_49,t0.link06ASlink06_50,t0.link07ASlink07_51,t0.link08ASlink08_52,t0.link09ASlink09_53,t0.link10ASlink10_54,t0.link11ASlink11_55,t0.link12ASlink12_56,t0.link13ASlink13_57,t0.link14ASlink14_58,t0.link15ASlink15_59,t0.link16ASlink16_60,t0.link17ASlink17_61,t0.link18ASlink18_62,t0.link19ASlink19_63,t0.link20ASlink20_64,t0.link21ASlink21_65,t0.link22ASlink22_66,t0.link23ASlink23_67,t0.link24ASlink24_68,t0.link25ASlink25_69,t0.link26ASlink26_70,t0.link27ASlink27_71,t0.link28ASlink28_72,t0.link29ASlink29_73,t0.link30ASlink30_74,t0.blank01ASblank01_75,t0.blank02ASblank02_76,t0.blank03ASblank03_77,t0.blank04ASblank04_78,t0.blank05ASblank05_79,t0.blank06ASblank06_80,t0.blank07ASblank07_81,t0.blank08ASblank08_82,t0.blank09ASblank09_83,t0.blank10ASblank10_84,t0.blank11ASblank11_85,t0.blank12ASblank12_86,t0.blank13ASblank13_87,t0.blank14ASblank14_88,t0.blank15ASblank15_89,t0.blank16ASblank16_90,t0.blank17ASblank17_91,t0.blank18ASblank18_92,t0.blank19ASblank19_93,t0.blank20ASblank20_94,t0.blank21ASblank21_95,t0.blank22ASblank22_96,t0.blank23ASblank23_97,t0.blank24ASblank24_98,t0.blank25ASblank25_99,t0.blank26ASblank26_100,t0.blank27ASblank27_101,t0.blank28ASblank28_102,t0.blank29ASblank29_103,t0.blank30ASblank30_104,t0.newcateASnewcate_105,t0.dspflASdspfl_106,t0.parent_category_idASparent_category_id_107,t0.creator_idAScreator_id_108,t0.discriminator_typeFROMdtb_categoryt0WHEREt0.parent_category_id=1ANDt0.discriminator_typeIN ('category') ORDER BYt0.sort_noDESC;