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-04-30 19:02:16')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 671)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
42715 HEDWiNG Peep Logo Hoodie Black
42716 HEDWiNG Delta Flower Sweat White
42717 HEDWiNG Delta Flower Sweat Black
42768 HEDWiNG Cross Cut Hoodie typeA
42770 HEDWiNG “Sacco” Sweat White
42772 HEDWiNG “Sacco” Sweat Mint Green
42773 HEDWiNG Bad Owl Long Sleeve T-shirt White
42774 HEDWiNG Bad Owl Long Sleeve T-shirt Black
42775 HEDWiNG Pastel Ink Long Sleeve T-shirt White
42776 HEDWiNG Pastel Ink Long Sleeve T-shirt Black
42777 HEDWiNG Cursive Owl Hoodie Black
42778 HEDWiNG Cursive Owl Hoodie White
42779 HEDWiNG Fluffy Snood Black
42780 HEDWiNG Fluffy Snood Off White
42781 HEDWiNG Fluffy Snood Beige
44215 HEDWiNG Peep logo Mods coat Black
44216 HEDWiNG Light knit chester Coat Glen Check
44217 HEDWiNG Light knit chester Coat Heather Black
44218 HEDWiNG Cable knit Beanie Mustard
44219 HEDWiNG Cable knit Beanie Black
44220 HEDWiNG Gradation Muffler Purple
44221 HEDWiNG Gradation Muffler Black
44222 HEDWiNG Knit Gloves Heather Gray
44223 HEDWiNG Knit Gloves Black
44224 HEDWiNG Light backpack Black
46794 HEDWiNG 〝Kaminari〟 Longsleeve T-shirt White
46796 HEDWiNG Warning Tape T-shirt White
46797 HEDWiNG Warning Tape T-shirt Black
46798 HEDWiNG Drawstring T-shirt White
46799 HEDWiNG Drawstring T-shirt Black
46800 HEDWiNG Crosscut Longsleeve T-shirt Black
46801 HEDWiNG Crosscut Longsleeve T-shirt White
46802 HEDWiNG Big Hashtag〝#〟 T-shirt White
46803 HEDWiNG Big Hashtag〝#〟 T-shirt Black
46804 HEDWiNG Dripping Logo Cap Black/White
46805 HEDWiNG Dripping Logo Cap Black/Green
46806 HEDWiNG Dripping Logo Cap Black/Yellow
46807 HEDWiNG Hashtag〝#〟 Totebag Black
47464 HEDWiNG AFF x HDW BIG Tee White
48384 HEDWiNG Owl Totalhandle Shirt White
48385 HEDWiNG Owl Totalhandle Shirt Black
48386 HEDWiNG Crosscut Missing "Syrup" T-shirt type A
48387 HEDWiNG Crosscut Missing "Syrup" T-shirt type B
48388 HEDWiNG Crazy-Monna-Crazy T-shirt White
48389 HEDWiNG Crazy-Monna-Crazy T-shirt Black
48390 HEDWiNG "Hyokkori" Owl T-shirt White
48391 HEDWiNG "Hyokkori" Owl T-shirt Black
48392 HEDWiNG Slimy Logo T-shirt White
48393 HEDWiNG Slimy Logo T-shirt Black
48394 HEDWiNG Stardust T-shirt White
48395 HEDWiNG Stardust T-shirt Black
48396 HEDWiNG Stardust T-shirt Red
48397 HEDWiNG Crosscut Onepiece White
48398 HEDWiNG Crosscut Onepiece Black
48399 HEDWiNG Lemonade Sacoche Yellow
50286 HEDWiNG Cross Cut Hoodie type C
50287 HEDWiNG Cross Cut Hoodie type D
50289 HEDWiNG Chinese Zombie Longsleeve T-shirt Black
50290 HEDWiNG Chinese Zombie Longsleeve T-shirt Lime
50291 HEDWiNG ”Shide” Longsleeve T-shirt Black
50292 HEDWiNG Dropingtag Sweat Black
50293 HEDWiNG Dropingtag Sweat White
50294 HEDWiNG Line Logo Jogger Pants Black
50296 HEDWiNG Line Logo Ballcap Charcoal
50297 HEDWiNG Line Logo Ballcap Light Blue
50298 HEDWiNG Line Logo Beret Black
50299 HEDWiNG Slidebar Longsleeve T-shirt Black
50300 HEDWiNG Slidebar Longsleeve T-shirt White
50853 NAGAHAMA(世田谷店)×HEDWiNG コラボ T-shirt Kids(140サイズ) White
50854 NAGAHAMA(世田谷店)×HEDWiNG コラボ T-shirt Kids(140サイズ) Black
50855 NAGAHAMA(世田谷店)×HEDWiNG コラボ T-shirt Kids(140サイズ) Light Blue
50856 NAGAHAMA(世田谷店)×HEDWiNG コラボLong sleeve T-shirt Light Blue
50857 NAGAHAMA(世田谷店)×HEDWiNG コラボLong sleeve T-shirt Black
50858 NAGAHAMA(世田谷店)×HEDWiNG コラボLong sleeve T-shirt White
51415 HEDWiNG Sheep Bore Jacket BEIGE
51416 HEDWiNG Sheep Bore Jacket Black
51417 HEDWiNG Work Logo MA-1 BLACK
51418 HEDWiNG Work Logo MA-1 KHAKI
51419 HEDWiNG Line Logo Beanie BLACK
51420 HEDWiNG Line Logo Beanie LIME
51421 HEDWiNG Warning Tape Belt
52381 HEDWiNG Geometric Wave T-shirt Black
52382 HEDWiNG Geometric Wave T-shirt Lime
52383 HEDWiNG Geometric Wave T-shirt White
52388 HEDWiNG Big Shilhouette “罠” T-shirt Black
52389 HEDWiNG Big Shilhouette “罠” T-shirt Purple
52390 HEDWiNG Big Shilhouette “Stick Out” T-shirt
52391 HEDWiNG “W” Cross Longsleeve T-shirt Black
52392 HEDWiNG “W” Cross Longsleeve T-shirt White
52393 HEDWiNG Divided Logo Overall
52394 HEDWiNG Divided Logo Spring Coat Beige
52395 HEDWiNG CylinderPVC Backpack
52397 HEDWiNG Divided Logo Spring Coat Black
52566 AFFECTER × HEDWiNG Nylon Zip Jacket
53137 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type A
53138 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type B
53139 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type A
53140 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type B
53141 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Black
53142 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Navy
53144 HEDWiNG HD1-019 80’s Tropical T-shirt White
53146 HEDWiNG HD1-020 Drawstring 2020 T-shirt Black
53148 HEDWiNG HD1-020 Drawstring 2020 T-shirt White
53152 HEDWiNG HD1-021 Waffle Long Tanktop Black
53153 HEDWiNG HD1-021 Waffle Long Tanktop Lime
53157 HEDWiNG HD8-006 Jellyfish Cap Black
53158 HEDWiNG HD8-006 Jellyfish Cap Orange
53159 HEDWiNG HD8-006 Jellyfish Cap Khaki
53910 【ゲキクロ限定】HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirtBLK×WHT type A
53911 【ゲキクロ限定】HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirtBLK×WHT type B
53156 HEDWiNG HD4-003 Jellyfish Climbing Shorts Blue
53155 HEDWiNG HD4-003 Jellyfish Climbing Shorts Beige
53154 HEDWiNG HD4-003 Jellyfish Climbing Shorts Black
55544 HEDWiNG Graffiti Logo Cap
55543 HEDWiNG Corduroy Pants
55542 HEDWiNG Garment Dyed Longsleeve T-shirt Aquagreen
55541 HEDWiNG Garment Dyed Longsleeve T-shirt White
55540 HEDWiNG Garment Dyed Longsleeve T-shirt Sumi
55539 HEDWiNG “JYOCHO” Crosscut Longsleeve T-shirt White
55538 HEDWiNG “JYOCHO” Crosscut Longsleeve T-shirt Black