mysql:12174
From: "¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥¤¥È" <"¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥¤¥È" <info@xxxxxxxxxx>>
Date: Sat, 24 Sep 2005 15:26:33 +0900
Subject: [mysql 12174] Re: £Ó£Ñ£Ìʸ¤Ë¤Ä¤¤¤Æ
¼«Í³ÀÊÆõÞÍÍ¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£ >SELECT > goodstb.id, goodstb.name, goodstb.exp, > goodstb.comment, goodstb.adtext, > goodstb.price2, goodstb.price3, > goodstb.note1, afftb.affst > FROM goodstb, afftb > LEFT JOIN afftb ON goodstb.id=afftb.goodsid > WHERE goodstb.note1=1 And afftb.affst > Is Null Or afftb.affst=1 And afftb.affid=11113 >¤³¤ì¤ÇÆ°¤¤Þ¤»¤ó¤Ç¤·¤¿¤Ç¤·¤ç¤¦¤«¡© Áᮡ¢¤¿¤á¤·¤Ë¥¢¥¯¥»¥¹¤Ç¼Â¹Ô¤·¤¿¤È¤³¤í¡¢¡Ö£Ê£Ï£É£ÎÁàºî¤Î¹½Ê¸¥¨¥é¡¼¤Ç¤¹¡£¡×¤È ¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤·¤¿¡£ ¥¢¥¯¥»¥¹¤Ç»î¤·¤¿¤«¤é¥À¥á¤Ê¤ó¤Ç¤·¤ç¤¦¤«¡© £Í£ù£Ó£ñ£ì¤Ç¤Ê¤é¤Ç¤¤ë¤Î¤Ç¤·¤ç¤¦¤«¡© ¼ÁÌä¤Ð¤«¤ê¤Ç¿½¤·Ìõ¤¢¤ê¤Þ¤»¤ó¡£
12172 2005-09-24 07:13 ["¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥] £Ó£Ñ£Ìʸ¤Ë¤Ä¤¤¤Æ 12173 2005-09-24 14:57 ¨±[¼«Í³ÀÊÆÃµÞ <kaisoku0] -> 12174 2005-09-24 15:26 ¡¡¨±["¥¹¡Ý¥Ñ¡¼¥¢¥Õ¥£¥ê¥¨¥]