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-28 22:43:48')
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 MAX(price02)
LIMIT 0, 60
53158 HEDWiNG HD8-006 Jellyfish Cap Orange
53153 HEDWiNG HD1-021 Waffle Long Tanktop Lime
44222 HEDWiNG Knit Gloves Heather Gray
44223 HEDWiNG Knit Gloves Black
58440 HEDWiNG Stripe Box T-shirt Black
63125 HEDWiNG (ヘドウィグ) Fall down Neon T-shirt Banana yellow
61718 HEDWiNG Crayon Flower Pocket T-shirt Oatmeal
44218 HEDWiNG Cable knit Beanie Mustard
44219 HEDWiNG Cable knit Beanie Black
48399 HEDWiNG Lemonade Sacoche Yellow
57301 HEDWiNG “W”ave Longsleeve T-shit Black
57302 HEDWiNG “W”ave Longsleeve T-shit White
47464 HEDWiNG AFF x HDW BIG Tee White
52382 HEDWiNG Geometric Wave T-shirt Lime
42779 HEDWiNG Fluffy Snood Black
42780 HEDWiNG Fluffy Snood Off White
44220 HEDWiNG Gradation Muffler Purple
44221 HEDWiNG Gradation Muffler Black
46807 HEDWiNG Hashtag〝#〟 Totebag Black
46804 HEDWiNG Dripping Logo Cap Black/White
46805 HEDWiNG Dripping Logo Cap Black/Green
46806 HEDWiNG Dripping Logo Cap Black/Yellow
48390 HEDWiNG "Hyokkori" Owl T-shirt White
48391 HEDWiNG "Hyokkori" Owl T-shirt Black
48392 HEDWiNG Slimy Logo T-shirt White
48394 HEDWiNG Stardust T-shirt White
48395 HEDWiNG Stardust T-shirt Black
48396 HEDWiNG Stardust T-shirt Red
57310 HEDWiNG Flamingo Skater Cap Off pink
57311 【ゲキクロ限定】 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt Black
61720 HEDWiNG Back to laughter Socks White
46798 HEDWiNG Drawstring T-shirt White
46799 HEDWiNG Drawstring T-shirt Black
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
48388 HEDWiNG Crazy-Monna-Crazy T-shirt White
48389 HEDWiNG Crazy-Monna-Crazy T-shirt Black
48397 HEDWiNG Crosscut Onepiece White
48398 HEDWiNG Crosscut Onepiece Black
63124 HEDWiNG (ヘドウィグ) Fall down Neon T-shirt Lavender
46794 HEDWiNG 〝Kaminari〟 Longsleeve T-shirt White
46800 HEDWiNG Crosscut Longsleeve T-shirt Black
46801 HEDWiNG Crosscut 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
56171 HEDWiNG HD-012 Pierrot Mask Longsleeve T-shirt Purple
61714 HEDWiNG One stroke owl Longsleeve T-shirt Stone blue
48386 HEDWiNG Crosscut Missing "Syrup" T-shirt type A
48387 HEDWiNG Crosscut Missing "Syrup" T-shirt type B
60036 HEDWiNG Reflector Sweat White
60040 HEDWiNG Right or wrong Longsleeve T-shirt White
60044 HEDWiNG Arch Logo Bucket Hat Black
63123 HEDWiNG (ヘドウィグ) Infection warning Tie-dye Big Silhouette T-shirt Surf blue
46796 HEDWiNG Warning Tape T-shirt White
46797 HEDWiNG Warning Tape T-shirt Black
46802 HEDWiNG Big Hashtag〝#〟 T-shirt White
46803 HEDWiNG Big Hashtag〝#〟 T-shirt Black
51421 HEDWiNG Warning Tape Belt