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 (
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-05-27 17:08:52')
AND FIND_IN_SET(14, p.color)
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
27件見つかりました
1ページ中1ページ目
1
¥5,500
Anti Social Social Club
Socks
完売
¥2,750
RIPNDIP
Socks
¥2,500
ROLLING CRADLE
Socks
完売
¥2,420
RIPNDIP
Socks
完売
¥2,420
RIPNDIP
Socks
完売
¥2,420
PUNK DRUNKERS
Socks
完売
¥2,420
RIPNDIP
Socks
完売
¥2,420
RIPNDIP
Socks
完売
¥2,420
RIPNDIP
Socks
完売
¥2,420
RIPNDIP
Socks
完売
¥2,420
PUNK DRUNKERS
Socks
完売
¥2,200
PUNK DRUNKERS
Socks
完売
¥2,200
ROLLING CRADLE
Socks
完売
¥2,200
ROLLING CRADLE
Socks
完売
¥2,035
PUNK DRUNKERS
Socks
完売
¥2,035
PUNK DRUNKERS
Socks
¥1,870
東京13零式
Socks
完売
¥1,850
MAGICAL MOSH MISFITS
Socks
フリー 残り1点
¥1,850
MAGICAL MOSH MISFITS
Socks
¥1,760
over print
Socks
¥1,760
over print
Socks
完売
¥2,420 → 1,694
PUNK DRUNKERS
Socks
完売
¥1,650
VIRGOwearworks
Socks
完売
¥1,650
VIRGOwearworks
Socks
完売
¥1,650
over print
Socks
完売
¥1,430
THRASHER
Socks
完売
¥2,420 → 1,210
PUNK DRUNKERS
Socks
27件見つかりました
1ページ中1ページ目
1
63388 Anti Social Social Club Down The Tube Blue/White Socks
67895 RIPNDIP (リップンディップ) Lord Nermal Socks (Light Slate)
64975 ROLLING CRADLE RC x KUDAN LOGO SOX / BLUE
52964 RIPNDIP Lord Nermal Socks (Baby Blue Tie Dye)
52969 RIPNDIP Lord Nermal Socks (Navy Speckle)
56704 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズ SOCKS - BLUE/ORANGE
60643 RIPNDIP Welcome To Heck Socks (Electric Blue)
64294 RIPNDIP (リップンディップ) Lord Nermal Socks (Cornflower)
65456 RIPNDIP (リップンディップ) Lord Nermal Socks (Cobalt Blue)
66877 RIPNDIP (リップンディップ) Jolly Holiday Socks Navy
67695 PUNK DRUNKERS (パンクドランカーズ)あいつライン靴下 - TURQUOISE
59969 PUNK DRUNKERS ギザロゴカラフルソックス - MINT
60712 ROLLING CRADLE LMS SOX / BLUE
63888 ROLLING CRADLE (ローリングクレイドル) RC STAR SOX / ICEBLUE
54726 PUNK DRUNKERS レントゲン靴下 BLUE
62753 PUNK DRUNKERS 三つ目ちゃんソックス - BLUE
71289 東京13零式(トウキョウイチサンゼロシキ) Socks 炎 Indigo
70544 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM どろどろ HIGHSOX WH/BLU (LONG)
70547 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM どろどろ HIGHSOX BK/BL (MID)
71184 over print (オーバープリント) OVER DYE sox blue
71185 over print (オーバープリント) OVER DYE sox black
59966 PUNK DRUNKERS [PDSxSONIC]ソニックツシタ(靴下) - WHITE
55516 VIRGO RISE SOCKS - EMERALD
57047 VIRGO VG LOGO SOCKS GREEN
69394 over print (オーバープリント) SOX (BLUE)
60629 THRASHER TH-SX217 3Pack MIX
62748 PUNK DRUNKERS (パンクドランカーズ) タイダイクソックス - BLUE