select  re.syocd,  count(re.syocd) as ct_orders, re.syonm  From RE_T_KAGOMEI re   Where re.kago_cd > 2007110400000000000000 and   re.kago_cd < 2010072300000000000000 and   (re.syonm like '%SKY%' or re.syonm like '%RED%' )  GROUP BY re.syocd order by ct_orders desc<br />
<b>Warning</b>:  mysql_fetch_row(): supplied argument is not a valid MySQL result resource in <b>/home/galgal/public_html/pc/runking_k.php</b> on line <b>49</b><br />