SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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 dtb_products AS p
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-05-27 10:03:44')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 804)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 240
14件見つかりました
1ページ中1ページ目
1
¥11,000
BRATS×GEKIROCK CLOTHING×AFFECTER
Pullover
L 残り1点
¥4,180
AFFECTER
L/S T-Shirt
¥4,180
AFFECTER
Hat
XL 残り1点
¥4,950
AFFECTER
T-Shirt
XL 残り1点
¥4,620
AFFECTER
T-Shirt
¥4,620
AFFECTER
T-Shirt
フリー 残り1点
¥3,080
AFFECTER
Cap
¥3,080
AFFECTER
Cap
¥3,080
AFFECTER
Cap
XL 残り1点
¥7,480
AFFECTER
Pullover
¥7,480
AFFECTER
Pullover
L 残り1点
¥8,030
AFFECTER
Pullover
L 残り1点
¥8,030
AFFECTER
Pullover
L 残り1点
¥7,480
AFFECTER
Pullover
14件見つかりました
1ページ中1ページ目
1
65772 BRATS×GEKIROCK CLOTHING×AFFECTER コラボ・パーカー
63699 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Black
63703 AFFECTER (アフェクター) TM BUCKET HAT CAMO
64072 AFFECTER (アフェクター) HEAVEN Tee WHITE
64074 AFFECTER (アフェクター) TAG Tee BLUE
64075 AFFECTER (アフェクター) TAG Tee BLACK
64076 AFFECTER (アフェクター) COLLEGE LOGO CAP ORANGE
64077 AFFECTER (アフェクター) COLLEGE LOGO CAP GRAY
64078 AFFECTER (アフェクター) COLLEGE LOGO CAP BLACK
61153 AFFECTER (アフェクター) LIGHTNING HOODIE BLACK
61155 AFFECTER (アフェクター) AFF TM HOODIE BLACK
61149 AFFECTER (アフェクター) NESS HOODIE BLACK
61150 AFFECTER (アフェクター) NESS HOODIE GREEN
61151 AFFECTER (アフェクター) TAG HOODIE BLACK