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-04-27 23:11:46')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
26230 OPETH Morningrise Hoodie
32082 ライブキッズあるある フェス余韻パーカー
40491 THRASHER TH8501 MAG LOGO HOODIE NAVY/WHITE
45577 TOY MACHINE TMP19SW16 FIST EMBRO SWEAT PARKA BLACK
47643 SANTA CRUZ CLASSIC DOT HEAVYWEIGHT P/O HOODED SWEATSHIRT BLACK
49756 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW ORANGE
49758 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW YELLOW
49759 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW GREEN
51240 SAMURAI CORE SR-PK-07-B PUNK侍 pk black
51475 ANIMALIA AN19W-SW02 P/O HOODIE - CONVERT BLACK
52285 あゆみくりかまき×ゲキクロ×ripdw AKM STAR HOODIE
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
52915 FILA × STAPLE FM9880 WHITE
53074 SAMURAI CORE 釈迦 HOODIE BLACK
53075 SAMURAI CORE 釈迦 HOODIE WHITE
53076 SAMURAI CORE 釈迦 HOODIE RED
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
53917 PSYCHOLOGICAL METAMORPHOSIS PLMP PILE WAPPEN PARKA GREEN
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
54221 ANIMALIA S/S SIDE ZIP HOODIE GRAY
54222 ANIMALIA S/S SIDE ZIP HOODIE RED
55635 Anti Social Social Club MIND GAMES BLACK HOODIE
56026 RUDIE'S (ルーディーズ) PHAT HIGHNECK HOOD SWEAT BLACK
56027 RUDIE'S (ルーディーズ) PHAT HIGHNECK HOOD SWEAT GRAY
56067 NineMicrophones PARKA-Power of will-BLACK
28428 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
56206 Anti Social Social Club Don’t Red Hoodie
56759 AC/DC UNISEX PULLOVER HOODIE: CANNON SWIG
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
56836 Subcietyx攻殻機動隊 SECTION9 PULLOVER PARKA KHAKI
56455 Subciety (サブサエティ) BREAK PARKA- YELLOW
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
57295 IRON MAIDEN UNISEX PULLOVER HOODIE: LOTB LIVE ALBUM (ARM & BACK PRINT)
56451 Subciety (サブサエティ) VANDALIZE PARKA- KHAKI
57397 FILA FS3025 HOODIE NAVY
57414 THRASHER (スラッシャー) TH8528PLGONZ HOODIE WHITE
56458 Subciety (サブサエティ) SOUVENIR PARKA- KHAKI
58003 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT PINK
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58100 WASTED PARIS Hoodie Columbia Bridge Black
58099 WASTED PARIS Hoodie Columbia Bridge Lilac
58101 WASTED PARIS Hoodie Columbia Bridge Pink
58109 MISHKA M21000404 Pullover WHITE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58451 Subciety ×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA GRAY
58512 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・パーカー
59312 Anti Social Social Club A Fire Inside Black Hoodie - Flame
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
58414 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA SAX-ORG
27139 Zephyren (ゼファレン) PARKA -BEYOND- BLACK
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
60433 ANIMALIA AN21A-SW03 AA FLAG HEAVY Oz HOODIE BLACK
60507 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE GRAY
60766 ROLLING CRADLE LOGO ROSE HOODIE / RED
60814 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / PINK
60846 エルフリーデ×ゲキクロ×DI:VISIONスペシャル・コラボ・パーカーBLACK×RED
60161 Anti Social Social Club I SEE BLUE SPLASH BLACK HOODIE
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
60813 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / BLACK
57408 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE BLK/WHT
61568 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE CREAM
61569 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE BLACK
61671 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) BLACK
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
61440 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie White
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
61845 A FEW GOOD KIDS EARTH ON THE HOODIE ORANGE
63000 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BLACK
63001 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BROWN
62773 ROLLING CRADLE CNS HOODIE / BLACK
62774 ROLLING CRADLE CNS HOODIE / YELLOW
63376 Anti Social Social Club Passing Fad Pink Hoodie
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
64274 RIPNDIP (リップンディップ) Summer Revenge Rhinestone Hoodie (Black)
65427 RIPNDIP (リップンディップ) Ripndip Rubber Logo Hoodie (Sage/Slate Tie Dye)
64124 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ PULLOVER ] BLACK
64125 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ PULLOVER ] BLUE
64126 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ PULLOVER ] CHOCOLATE
66305 幽遊白書×ROLLING CRADLE 集合 HOODIE / BLACK
61401 NineMicrophones PIGMENT PARKA BLACK
65464 Subciety (サブサエティ) RAGLAN PARKA-BLACK
25685 Subciety (サブサエティ) PARKA-THE BASE- GRAY
14639 Subciety PARKA-GLORIOUS- BLACK/WHITE
66713 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN RABBIT HOOD SWEAT BLACK
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
60561 Subciety 2022 福袋 -NEW YEAR BAG-
66269 夜道雪×GEKIROCK CLOTHING "Guilty &Apple" Hoodie
66950 TOY MACHINE (トイマシーン) PEPPER SECT SWEAT PARKA YELLOW
65930 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・パーカー The Scream BLACK
65929 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・パーカー The Scream WHITE
66969 PANTERA UNISEX PULLOVER HOODIE: 101 PROOF
66960 MEGADETH UNISEX PULLOVER HOODIE: COUNTDOWN TO EXTINCTION
66473 10-FEET×Zephyren(ゼファレン) BIG PARKA BLACK
66235 glamb(グラム) Himiko Toga Hoodie White
66246 glamb(グラム) Himiko Toga Hoodie Black
32031 RUDIE'S (ルーディーズ) SPARK HOOD SWEAT BLACK
67875 白石万浬 × DI:VISION コラボ限定プルオーバーパーカー
67880 RIPNDIP (リップンディップ) Heaven On Earth Hoodie Black
68011 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ プルオーバーパーカー
68001 【BanG Dream! ×ゲキクロ 2023 ver.】マスキング×UNUSUAL コラボ プルオーバーパーカー
69238 THRASHER (スラッシャー) Inferno Hoodie NAVY BLUE
69240 THRASHER (スラッシャー) Outlined Chest Logo Hoodie GRAY
67395 TheBackOfBoys(ザバックオブボーイズ) Arm Logo Pullover Hoodie ORANGE
67396 TheBackOfBoys(ザバックオブボーイズ) Arm Logo Pullover Hoodie BLUE
67397 TheBackOfBoys(ザバックオブボーイズ) Arm Logo Pullover Hoodie BLACK
67400 TheBackOfBoys(ザバックオブボーイズ) TBOB Logo Pullover Hoodie ASH
67399 TheBackOfBoys(ザバックオブボーイズ) TBOB Logo Pullover Hoodie GREEN
67398 TheBackOfBoys(ザバックオブボーイズ) TBOB Logo Pullover Hoodie SUMI
68526 RIPNDIP (リップンディップ) Shock Hoodie BLACK
56761 AVENGED SEVENFOLD UNISEX PULLOVER HOODIE: SEIZE THE DAY
69364 NINE INCH NAILS UNISEX PULLOVER HOODIE: CLASSIC LOGO
69359 DEFTONES UNISEX PULLOVER HOODIE: AROUND THE FUR NAVY BLUE