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
ショッピングカート
