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 =588
)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-01 18:09:23')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
66914 ハッピーハンバーグ ロックバンドロゴスウェットパーカー GRAY
66915 ハッピーハンバーグ ロックバンドロゴスウェットパーカー BLACK
56919 Half time Old×GEKIROCK CLOTHING 限定コラボ・パーカー
62570 Survive Said The Prophet REDEFINE TOUR HOODIE BLACK
62571 Survive Said The Prophet REDEFINE TOUR HOODIE WHITE
61155 AFFECTER (アフェクター) AFF TM HOODIE BLACK
57408 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE BLK/WHT
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
65873 GoneR(ゴナー) 3D One Point Parka Black
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
36789 SLIPKNOT Gray Chapter Skeleton Hooded Sweatshirt
51195 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
56758 GREEN DAY UNISEX HOODIE: AMERICAN IDIOT
56809 MY CHEMICAL ROMANCE UNISEX HOODIE: RACEWAY
66943 KORN UNISEX PULLOVER HOODIE: REQUIEM (BACK PRINT)
66947 MY CHEMICAL ROMANCE UNISEX PULLOVER HOODIE: THE BLACK PARADE COVER
66969 PANTERA UNISEX PULLOVER HOODIE: 101 PROOF
70344 NOTBADCAT (ノットバッドキャット) モニャリザ hoodie
65877 GoneR(ゴナー) Mexican Pattern Real Skull Parka Smokey Green
57815 四星球×ゲキクロ 限定コラボ・パーカー ブラック
61670 SLIPKNOT UNISEX PULLOVER HOODIE: MINNEAPOLIS '09 (BACK PRINT)
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
61825 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: SEMPITERNAL
66960 MEGADETH UNISEX PULLOVER HOODIE: COUNTDOWN TO EXTINCTION
67509 RED HOT CHILI PEPPERS UNISEX PULLOVER HOODIE: CLASSIC ASTERISK
68173 アマツカミ 雨薔薇/Rainrose Hoodie WHITE
68174 アマツカミ 遭逢/Encounter Hoodie WHITE
68177 アマツカミ 深紅/Crimson Hoodie WHITE
69360 MARILYN MANSON UNISEX PULLOVER HOODIE: CLASSIC LOGO
69365 NIRVANA UNISEX PULLOVER HOODIE: XEROX HAPPY FACE PINK GREY
69366 NIRVANA UNISEX PULLOVER HOODIE: YELLOW HAPPY FACE BLACK
69369 THE 1975 UNISEX PULLOVER HOODIE: NOACF
69370 THE 1975 UNISEX PULLOVER HOODIE: BLACK TOUR
69428 アマツカミ 蓮/bloom Hoodie BLACK
69432 アマツカミ 紫菊/mum Hoodie WHITE
70277 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: LOGO
70552 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: NEX GEN COVER
70553 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: BUG
70679 KORN UNISEX PULLOVER HOODIE: STILL A FREAK (BACK PRINT)
70683 LINKIN PARK UNISEX PULLOVER HOODIE: STREET SOLDIER
70684 LINKIN PARK UNISEX PULLOVER HOODIE: METEORA WALL ART
70933 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SKULL
70939 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
71248 MÅNESKIN UNISEX PULLOVER HOODIE: POCKET LOGO & MINI DOODLES (BACK PRINT)
60844 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカー WHITE
70204 GoneR(ゴナー) Eterno Pull Parka ASH
32031 RUDIE'S (ルーディーズ) SPARK HOOD SWEAT BLACK
58067 FOO FIGHTERS UNISEX PULLOVER HOODIE: MEDICINE AT MIDNIGHT TAPED
65633 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) x VANS “MAGICAL VANS MISFITS”HOODIE MINT
66711 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN RABBIT HOOD SWEAT SAND
66713 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN RABBIT HOOD SWEAT BLACK
65683 SABBAT13(サバトサーティーン) SCAPEGOAT HOODIE GREEN
68001 【BanG Dream! ×ゲキクロ 2023 ver.】マスキング×UNUSUAL コラボ プルオーバーパーカー
68007 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ プルオーバーパーカー
68013 【BanG Dream! ×ゲキクロ 2023 ver.】白金燐子×アマツカミ コラボ プルオーバーパーカー
68015 【BanG Dream! ×ゲキクロ 2023 ver.】宇田川あこ×SABBAT13 コラボ プルオーバーパーカー
68790 界川 深幸×CMP LABEL コラボ限定プルオーバーパーカー
66297 DI:VISION (ディヴィジョン) GRAFFITI HOODIE BLACK
67735 DI:VISION (ディヴィジョン) AXIS HOODIE GRAY
67774 空亜×RIPDW×GEKIROCK CLOTHINGスペシャル・コラボ・パーカー BLACK