SELECT * FROM shopadminmst WHERE shopid = '#sid#' SELECT * FROM #sdb#kubun1list ORDER BY number ASC SELECT kubun2 FROM #sdb#itemmst WHERE kubun1 = '#a_kubun1#' GROUP BY kubun2 ORDER BY kubun2 ASC SELECT * FROM #sdb#itemmst LEFT JOIN #sdb#fullcomment ON #sdb#itemmst.number = #sdb#fullcomment.number WHERE (dispflag = 1 AND selectflag = 0) AND (goods LIKE ('%#a_goods#%') OR comment LIKE ('%#a_goods#%')) OR fullcomment LIKE ('%#a_goods#%') AND kubun1 = '#a_kubun1#' AND kubun2 = '#a_kubun2#' AND makercode = #mkcode# ORDER BY #sdb#itemmst.id ASC ORDER BY #sdb#itemmst.number ASC ORDER BY #sdb#itemmst.id DESC SELECT * FROM #sdb#itemmst WHERE dispflag = 1 AND selectflag = 0 AND #sdb#itemmst.kubun1 = '#a_kubun1#' AND #sdb#itemmst.kubun2 = '#a_kubun2#' AND makercode = #mkcode# ORDER BY id ASC ORDER BY number ASC ORDER BY id DESC SELECT * FROM #sdb#makermst ORDER BY makercode ASC SELECT * FROM #sdb#basicinimst WHERE id = 1 SELECT * FROM #sdb#designmst SELECT officename,url FROM #sdb#officemst ショッピングカート
#Getoffice.officename#

#ReplaceList("#Getdesign.auto_msg#","#chr(13)##chr(10)#,#chr(13)#","
,
")#
カテゴリ検索
商品検索 メーカー検索
並び替え

検索結果:#Getitem.RecordCount# #startrow#件から #GetItem.RecordCount# #maxrow#件まで     
商品カテゴリ:#kubn1name#>#kubn2name#
#Getitem.goods#   メーカー: #NumberFormat("#a_unit#")#円
#Getitem.goods#
商品番号:#Getitem.number#      #Getitem.makername#
価格: #NumberFormat("#a_unit#")# #a_offrate#%OFF→ #NumberFormat("#b_unit#")#円   在庫:#zaikoResult# #zaikoResult# 
商品説明: #ReplaceList("#Getitem.comment#","#chr(13)##chr(10)#,#chr(13)#","
,
")#
数量:  詳細を見る  詳細を見る

検索結果:#Getitem.RecordCount# #startrow#件から #GetItem.RecordCount# #maxrow#件まで