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 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-19 22:55:25')
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, 120
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
61712 HEDWiNG College logo C/C Longsleeve T-shirt Navy
67497 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Black
67498 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Wine red
67499 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Apple green
67500 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Gold
51419 HEDWiNG Line Logo Beanie BLACK
51420 HEDWiNG Line Logo Beanie LIME
42777 HEDWiNG Cursive Owl Hoodie Black
42778 HEDWiNG Cursive Owl Hoodie White
42781 HEDWiNG Fluffy Snood Beige
58438 HEDWiNG Neon Totalhandle Shirt Black
57305 HEDWiNG Pocket “MOJYAPON” T-shirt Navy
44224 HEDWiNG Light backpack Black
53155 HEDWiNG HD4-003 Jellyfish Climbing Shorts Beige
60579 HEDWiNG Unbreakable Arrow Sweat Blue
67422 竹下みいこ × HEDWiNG コラボ限定トートバッグ
48393 HEDWiNG Slimy Logo T-shirt Black
50296 HEDWiNG Line Logo Ballcap Charcoal
50297 HEDWiNG Line Logo Ballcap Light Blue
50298 HEDWiNG Line Logo Beret Black
53157 HEDWiNG HD8-006 Jellyfish Cap Black
53159 HEDWiNG HD8-006 Jellyfish Cap Khaki
55544 HEDWiNG Graffiti Logo Cap
57309 HEDWiNG Flamingo Skater Cap Black
68473 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLUExKHAKI
68474 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLACKxBURGUNDY
61719 HEDWiNG Half asleeper Bucket hat Black
42716 HEDWiNG Delta Flower Sweat White
42717 HEDWiNG Delta Flower Sweat Black
42770 HEDWiNG “Sacco” Sweat White
42772 HEDWiNG “Sacco” Sweat Mint Green
53152 HEDWiNG HD1-021 Waffle Long Tanktop Black
55786 【バンドリ!×ゲキクロ 第2弾復刻】HEDWiNG×山吹沙綾コラボ 限定 キャップ
63756 TEARS OF TRAGEDY×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・ショートスリーブTシャツ BLACK
63757 TEARS OF TRAGEDY×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・ショートスリーブTシャツ WHITE
68983 HEDWiNG (ヘドウィグ) Space Logo Bucket hat BLACK
55533 HEDWiNG Pierrot Mask Blackdenim Jacket
52491 【バンドリ!×ゲキクロ 第4弾復刻】HEDWiNG×白鷺 千聖 コラボ 限定 ポーチ
52886 【バンドリ!×ゲキクロ 第5弾復刻】HEDWiNG×奥沢 美咲コラボ 限定 キャップ
57969 【バンドリ!×ゲキクロ 第6弾】HEDWiNG×桐ヶ谷透子コラボ 限定 キャップ
65417 【バンドリ!×ゲキクロ 第6弾復刻】HEDWiNG×桐ヶ谷透子コラボ 限定 キャップ
68467 HEDWiNG (ヘドウィグ) Chaos Smile T-Shirt BLACK
68468 HEDWiNG (ヘドウィグ) Chaos Smile T-Shirt LAVENDER
68469 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt SLATE BLUE
68470 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt WHITE
68471 HEDWiNG (ヘドウィグ) Owl U.F.O. Pick-up T-Shirt WHITE
68472 HEDWiNG (ヘドウィグ) Owl U.F.O. Pick-up T-Shirt AQUA GREEN
57968 【バンドリ!×ゲキクロ 第6弾】HEDWiNG×桐ヶ谷透子コラボ 限定 Tシャツ
65418 【バンドリ!×ゲキクロ 第6弾復刻】HEDWiNG×桐ヶ谷透子コラボ 限定 Tシャツ
42776 HEDWiNG Pastel Ink Long Sleeve T-shirt Black
60031 HEDWiNG Game Maker Hoodie Red
60034 HEDWiNG Game Maker Hoodie Forest green
55787 【バンドリ!×ゲキクロ 第2弾復刻】HEDWiNG×山吹沙綾コラボ 限定 L/S Tシャツ
50289 HEDWiNG Chinese Zombie Longsleeve T-shirt Black
50290 HEDWiNG Chinese Zombie Longsleeve T-shirt Lime
63126 HEDWiNG (ヘドウィグ) Chrome logo T-shirt White
63127 HEDWiNG (ヘドウィグ) Chrome logo T-shirt Sand beige
63128 HEDWiNG (ヘドウィグ) Chrome logo T-shirt Black
52493 【バンドリ!×ゲキクロ 第4弾復刻】HEDWiNG×白鷺 千聖 コラボ 限定 L/S Tシャツ
52885 【バンドリ!×ゲキクロ 第5弾復刻】HEDWiNG×奥沢 美咲コラボ 限定 Tシャツ