SELECT post_where.post_id, MST_SYOHIN.*, MST_SHNKBN.ShnKbn1, MST_SHNKBN.ShnKbn4, MST_SHNKBN.ShnKbn5, MST_SHNKBN.ShnKbn8, MST_MK.ShnMkNm, MST_URIAGE.Count, PLOTNEWS.ShnCd as PICKUP, MST_MK.ShnMkANm, KBN.ShnFNm, KBN.ShnJMemo1, KBN.ShnJMemo1, KBN.ShnJMemo2, KBN.ShnJMemo3, KBN.ShnJMemo4, KBN.ShnJMemo5, KBN.ShnJMemo6, KBN.ShnJMemo7, KBN.ShnJMemo8, KBN.ShnJMemo9, KBN.ShnJMemo10, KBN.ShnJMemo11, KBN.ShnJMemo12, KBN.ShnJMemo13, KBN.ShnJMemo14, KBN.ShnJMemo15, KBN.ShnJMemo16, KBN.ShnJMemo17, KBN.ShnJMemo18, KBN.ShnJMemo19, KBN.ShnJMemo20, KBN.ShnJMemo21, KBN.ShnJMemo22, KBN.ShnJMemo23, KBN.ShnJMemo24, KBN.ShnJMemo25, KBN.ShnJMemo26, KBN.ShnJMemo27, KBN.ShnJMemo26, KBN.ShnJMemo27, KBN.ShnJMemo28, KBN.ShnJMemo29, KBN.ShnJMemo30, KBNNM.ShnJanRSu, KBNNM.ShnNmJMemo1, KBNNM.ShnNmJMemo1, KBNNM.ShnNmJMemo2, KBNNM.ShnNmJMemo3, KBNNM.ShnNmJMemo4, KBNNM.ShnNmJMemo5, KBNNM.ShnNmJMemo6, KBNNM.ShnNmJMemo7, KBNNM.ShnNmJMemo8, KBNNM.ShnNmJMemo9, KBNNM.ShnNmJMemo10, KBNNM.ShnNmJMemo11, KBNNM.ShnNmJMemo12, KBNNM.ShnNmJMemo13, KBNNM.ShnNmJMemo14, KBNNM.ShnNmJMemo15, KBNNM.ShnNmJMemo16, KBNNM.ShnNmJMemo17, KBNNM.ShnNmJMemo18, KBNNM.ShnNmJMemo19, KBNNM.ShnNmJMemo20, KBNNM.ShnNmJMemo21, KBNNM.ShnNmJMemo22, KBNNM.ShnNmJMemo23, KBNNM.ShnNmJMemo24, KBNNM.ShnNmJMemo25, KBNNM.ShnNmJMemo26, KBNNM.ShnNmJMemo27, KBNNM.ShnNmJMemo26, KBNNM.ShnNmJMemo27, KBNNM.ShnNmJMemo28, KBNNM.ShnNmJMemo29, KBNNM.ShnNmJMemo30, MST_JSHN.ShnJanRCd, MST_TENKAI.ShnKbn, MST_YZIK.ZikSu FROM post_where LEFT JOIN MST_SYOHIN ON MST_SYOHIN.ShnCD = post_where.ShnCD LEFT JOIN MST_SHNKBN ON MST_SYOHIN.ShnCD = MST_SHNKBN.ShnCD LEFT JOIN MST_SYOHIN_WebText on MST_SYOHIN.ShnCd = MST_SYOHIN_WebText.ShnCd LEFT JOIN MST_JSHN on MST_SHNKBN.ShnKbn2 = MST_JSHN.ShnJanRCd LEFT JOIN MST_TENKAI on MST_JSHN.ShnKbn = MST_TENKAI.ShnKbn LEFT JOIN MST_MK ON MST_SHNKBN.ShnKbn1 = MST_MK.ShnMkCd LEFT JOIN MST_YZIK on MST_SYOHIN.ShnCd = MST_YZIK.ShnCd LEFT JOIN MST_JSYOKBN as KBN on MST_SYOHIN.ShnCd = KBN.ShnCd LEFT JOIN MST_JSYOKBNNM as KBNNM on MST_JSHN.ShnJanRCd = KBNNM.ShnJanRCd LEFT JOIN MST_URIAGE on MST_SYOHIN.ShnCd = MST_URIAGE.ShnCd LEFT JOIN PLOTNEWS on MST_SYOHIN.ShnCd = PLOTNEWS.ShnCd WHERE MST_SYOHIN.OKFlg = '1' AND MST_SYOHIN.PreFlg = '1' AND (MST_SYOHIN.DLTFlg = '0' or MST_SYOHIN.DLTFlg = '1' )