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-26 00:23:38')
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 DESC
LIMIT 0, 75
68977 HEDWiNG (ヘドウィグ) Big Mods Coat BLACK
68978 HEDWiNG (ヘドウィグ) Big Mods Coat KHAKI
68986 HEDWiNG(ヘドウィグ) Split Zip Flannel Shirt RED
68988 HEDWiNG(ヘドウィグ) Split Zip Flannel Shirt ORANGE
68981 HEDWiNG(ヘドウィグ) Big Silhouette Logo Hoodie BLACK
68982 HEDWiNG(ヘドウィグ) Big Silhouette Logo Hoodie SMOKY GREEN
68984 HEDWiNG(ヘドウィグ) Big Silhouette Logo Hoodie SAND BEIGE
68990 HEDWiNG(ヘドウィグ) Damage Out stitch Sweat WASH GRAY
68989 HEDWiNG (ヘドウィグ) C/C Out stitch L/S T-shirt BLACK
68987 HEDWiNG (ヘドウィグ) C/C Out stitch L/S T-shirt SUMI
68985 HEDWiNG (ヘドウィグ) C/C Out stitch L/S T-shirt WHITE
68983 HEDWiNG (ヘドウィグ) Space Logo Bucket hat BLACK
67420 竹下みいこ × HEDWiNG コラボ限定アノラックパーカー
67421 竹下みいこ × HEDWiNG コラボ限定Tシャツ
67422 竹下みいこ × HEDWiNG コラボ限定トートバッグ
68771 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・Tシャツ WHITE
68770 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・Tシャツ PURPLE
68768 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・パーカー PINK
68769 やまもとひかる×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・パーカー CHARCOAL GRAY
68463 HEDWiNG (ヘドウィグ) Vacation Cat Big Silhouette T-Shirt WHITE
68462 HEDWiNG (ヘドウィグ) Vacation Cat Big Silhouette T-Shirt HEATHER BLACK
68461 HEDWiNG (ヘドウィグ) Vacation Cat Big Silhouette T-Shirt BLACK
68471 HEDWiNG (ヘドウィグ) Owl U.F.O. Pick-up T-Shirt WHITE
68472 HEDWiNG (ヘドウィグ) Owl U.F.O. Pick-up T-Shirt AQUA GREEN
68470 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt WHITE
68469 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt SLATE BLUE
68468 HEDWiNG (ヘドウィグ) Chaos Smile T-Shirt LAVENDER
68467 HEDWiNG (ヘドウィグ) Chaos Smile T-Shirt BLACK
68466 HEDWiNG (ヘドウィグ) C/C Pansy Big Silhouette T-Shirt type AP
68464 HEDWiNG (ヘドウィグ) C/C Pansy Big Silhouette T-Shirt type GA
68465 HEDWiNG (ヘドウィグ) C/C Pansy Big Silhouette T-Shirt type PG
68473 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLUExKHAKI
68474 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLACKxBURGUNDY
65306 白鳥 胡桃×HEDWiNG コラボ 限定 ジップパーカー
65307 白鳥 胡桃×HEDWiNG コラボ 限定 L/S Tシャツ
65308 白鳥 胡桃×HEDWiNG コラボ 限定 ウエストバッグ
67475 HEDWiNG (ヘドウィグ) Mimicry Cardigan / Black
67477 HEDWiNG (ヘドウィグ) Mimicry Cardigan / Royal blue
67481 HEDWiNG (ヘドウィグ) Big Silhouette Double Zip Shirt / Black
67485 HEDWiNG (ヘドウィグ) Big Silhouette Double Zip Shirt / Stone blue
67486 HEDWiNG (ヘドウィグ) Big Silhouette Double Zip Shirt / White
67487 HEDWiNG (ヘドウィグ) C/C Border L/S T-shirt / type-A
67488 HEDWiNG (ヘドウィグ) C/C Border L/S T-shirt / type-B
67493 HEDWiNG (ヘドウィグ) Big Silhouette Cargo Pants / Black
67499 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Apple green
67500 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Gold
67497 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Black
67498 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Wine red
65419 【バンドリ!×ゲキクロ 第6弾復刻】HEDWiNG×桐ヶ谷透子コラボ 限定 コーチジャケット
65418 【バンドリ!×ゲキクロ 第6弾復刻】HEDWiNG×桐ヶ谷透子コラボ 限定 Tシャツ
65417 【バンドリ!×ゲキクロ 第6弾復刻】HEDWiNG×桐ヶ谷透子コラボ 限定 キャップ
65676 HEDWiNG (ヘドウィグ) Circle maze Coach jacket
65677 HEDWiNG (ヘドウィグ) Padded jacket camel
65679 HEDWiNG (ヘドウィグ) Antonym Big Silhouette Hoodie Smoky green
65680 HEDWiNG (ヘドウィグ) Antonym Big Silhouette Hoodie Black
63757 TEARS OF TRAGEDY×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・ショートスリーブTシャツ WHITE
63756 TEARS OF TRAGEDY×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・ショートスリーブTシャツ BLACK
63755 TEARS OF TRAGEDY×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・ロングスリーブTシャツ WHITE
63754 TEARS OF TRAGEDY×HEDWiNG×GEKIROCK CLOTHING 限定コラボ・ロングスリーブTシャツ BLACK
63126 HEDWiNG (ヘドウィグ) Chrome logo T-shirt White
63127 HEDWiNG (ヘドウィグ) Chrome logo T-shirt Sand beige
63128 HEDWiNG (ヘドウィグ) Chrome logo T-shirt Black
63125 HEDWiNG (ヘドウィグ) Fall down Neon T-shirt Banana yellow
63124 HEDWiNG (ヘドウィグ) Fall down Neon T-shirt Lavender
63123 HEDWiNG (ヘドウィグ) Infection warning Tie-dye Big Silhouette T-shirt Surf blue
63122 HEDWiNG (ヘドウィグ) Infection warning Tie-dye Big Silhouette T-shirt Orange
63121 HEDWiNG (ヘドウィグ) Back to laughter Tie-dye T-shirt Navy
63120 HEDWiNG (ヘドウィグ) Back to laughter Tie-dye T-shirt Light green
63117 HEDWiNG (ヘドウィグ) Half asleeper Hemp Set up Black
61710 HEDWiNG Half asleeper Denim jacket Black denim
61711 HEDWiNG College logo C/C Longsleeve T-shirt White
61712 HEDWiNG College logo C/C Longsleeve T-shirt Navy
61713 HEDWiNG One stroke owl Longsleeve T-shirt Mustard
61714 HEDWiNG One stroke owl Longsleeve T-shirt Stone blue
61718 HEDWiNG Crayon Flower Pocket T-shirt Oatmeal