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 =328
)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-04-19 11:29:11')
AND pc.stock > 0
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
20件見つかりました
1ページ中1ページ目
1
フリー 残り1点
¥7,700
Anti Social Social Club × Playboy
Socks
フリー 残り1点
¥5,500
Anti Social Social Club
Socks
¥5,500
Anti Social Social Club
Socks
¥5,500
Anti Social Social Club
Socks
¥5,500
Anti Social Social Club
Socks
¥3,850
HYPER CORE
Socks
¥2,970
RIPNDIP
Socks
フリー 残り1点
¥2,970
RIPNDIP
Socks
¥2,970
RIPNDIP
Socks
¥2,970
RIPNDIP
Socks
¥2,970
RIPNDIP
Socks
¥2,800
AIKA ELECTRONICS
Socks
¥2,750
SUPPLIER
Socks
¥2,420
RIPNDIP
Socks
¥2,200
VIRGO
Socks
¥2,090
ANIMALIA
¥2,090
ANIMALIA
Socks
¥1,760
over print
Socks
¥1,430
THRASHER
Socks
¥1,430
THRASHER
Socks
20件見つかりました
1ページ中1ページ目
1
63296 Anti Social Social Club Playboy x ASSC Bunny White Socks
63300 Anti Social Social Club Down The Tube Black/White Socks
63302 Anti Social Social Club Collapse White Socks
63387 Anti Social Social Club Down The Tube Pink/White Socks
63388 Anti Social Social Club Down The Tube Blue/White Socks
61607 HYPER CORE MUMMYディザイアニーハイ
68540 RIPNDIP (リップンディップ) Nermal Loves Socks WHITE
69583 RIPNDIP (リップンディップ) PEEKING NERMAL SOCKS (PURPLE & GOLD)
70615 RIPNDIP (リップンディップ)PEEKING NERMAL SOCKS (WHITE/LILAC)
71300 RIPNDIP (リップンディップ) PEEKING NERMAL SOCKS (WHITE)
71302 RIPNDIP (リップンディップ) LOVE YOU MID SOCKS (WHITE)
70809 AIKA ELECTRONICS(アイカエレクトロニクス) Classic Leg Warmers【WHITE】
65391 SUPPLIER (サプライヤー) SNAKE SKATE SOCKS WHITE
64297 RIPNDIP (リップンディップ) Lord Nermal Socks (White)
70266 VIRGO(ヴァルゴ) KANJI SOX WHITE
68080 ANIMALIA (アニマリア) SOX - Panther -
69614 ANIMALIA (アニマリア) SOX - A sign WHITE
71184 over print (オーバープリント) OVER DYE sox blue
60437 THRASHER (スラッシャー) TH-SX206 3Pack WHITE
61031 THRASHER TH-SX203 3Pack WHITE