SELECT SQL_CALC_FOUND_ROWS p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =6
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-03-28 19:47:10')
AND pc.stock > 0
AND FIND_IN_SET(14, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
14件見つかりました
1ページ中1ページ目
1
M 残り1点
¥26,400
glamb
L/S Shirt
¥25,300
glamb
L/S Shirt
¥25,300
glamb
L/S Shirt
¥24,600
SLEEPING TABLET
L/S Shirt
M 残り1点
¥24,200
glamb
L/S Shirt
¥22,000
Subciety
L/S Shirt
M 残り1点
¥20,800
ROLLING CRADLE
L/S Shirt
¥16,500
Subciety
L/S Shirt
¥15,799
ROLLING CRADLE
L/S Shirt
M 残り1点
¥13,200
TOY MACHINE
L/S Shirt
¥13,200
TOY MACHINE
L/S Shirt
フリー 残り1点
¥12,980
ZENON
L/S Shirt
¥12,100
over print×UMBRO
L/S T-Shirt
フリー 残り1点
¥5,990
DXMOUVE
L/S Shirt
14件見つかりました
1ページ中1ページ目
1
66801 glamb (グラム) GB0123/SH08 : Watercolor Marble SH / ウォーターカラーマーブルシャツ - Blue
67751 glamb (グラム) GB0123/SH10 : Light Oz 4XL SH/ライトオンス4XLシャツ Light indigo
67752 glamb (グラム) GB0123/SH10 : Light Oz 4XL SH/ライトオンス4XLシャツ Indigo
68337 SLEEPING TABLET (スリーピングタブレット) CRYPTO[PATERNED OPAL SHIRTS] BLUE
63594 glamb (グラム) Heavy Damaged SH - Blue
65783 Subciety (サブサエティ) GIANT CHECK SHIRT BLUE
62114 ROLLING CRADLE SKAJAN JERSEY / BLUE
58979 Subciety (サブサエティ) STRIPE OVER SHIRT - BLUE
63345 ROLLING CRADLE (ローリングクレイドル) BIG CHECK SHIRT / NAVY
66958 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLUE
70902 TOY MACHINE (トイマシーン) DOES'N LOVE YOU WORK SHIRTS L.BLUE
63423 ZENON(ゼノン) Front logo striped shirt BLUE
70886 over print(オーバープリント)UMBRO * OVER PRINT GAME SHIRTS SAX
65853 DXMOUVE(ドゥモーヴェ) ぼろぼろベアのtomy総柄長袖シャツBLUE