select  re.syocd,  count(re.syocd) as ct_orders, it.sy_name  From RE_T_KAGOMEI re , MST_ITEM it  Where re.kago_cd > 2010072300000000000000 and   re.kago_cd < 2010073000000000000000 and   it.sy_cd = re.syocd GROUP BY re.syocd order by ct_orders desc limit 0,10<hr><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=61067">小桜沙樹東熱流汁殺輪姦<br><img src="pr.php?width=45&src=../updata6/61067-01.jpg" border="0">
<img src="./img/r1.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=60988">好色妻降臨 Vol.9<br><img src="pr.php?width=45&src=../updata6/60988-01.jpg" border="0">
<img src="./img/r2.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=60989">SKY ANGEL 112<br><img src="pr.php?width=45&src=../updata6/60989-01.jpg" border="0">
<img src="./img/r3.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=61098">Red Hot Fetish Collection 95<br><img src="pr.php?width=45&src=../updata6/61098-01.jpg" border="0">
<img src="./img/r4.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=60829">Sky Angel 111<br><img src="pr.php?width=45&src=../updata6/60829-01.jpg" border="0">
<img src="./img/r5.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=60619">Sky Angel 108<br><img src="pr.php?width=45&src=../updata6/60619-01.jpg" border="0">
<img src="./img/r6.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=60958">美乳エロレロレディ<br><img src="pr.php?width=45&src=../updata6/60958-01.jpg" border="0">
<img src="./img/r7.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=60910">Desire 16<br><img src="pr.php?width=45&src=../updata6/60910-01.jpg" border="0">
<img src="./img/r8.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=61044">RED HOT JAM 148<br><img src="pr.php?width=45&src=../updata6/61044-01.jpg" border="0">
<img src="./img/r9.gif" width="100" border="0"></a></div><div style="border:1px solid;background:#EEE;width:195px;text-align:center;">
<a href="syousai.php?sy_cd=61018">Gカップ過剰輪姦過多孕汁<br><img src="pr.php?width=45&src=../updata6/61018-01.jpg" border="0">
<img src="./img/r10.gif" width="100" border="0"></a></div>