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 15:10:35')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
11582 KILL STAR CLOTHING LUCIFER TANK [B]
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
52942 Survive Said The Prophet MIA TOUR TEE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
52941 Survive Said The Prophet VERTICAL LOGO TEE
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
13900 NEW BREED The DIVIDE TEE
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15601 TEXAS IN JULY Draw The Line Black Tie Dye
19881 TEXAS IN JULY Brain Black
21159 BLACK CRAFT Aquarius
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
23776 KILL STAR CLOTHING (キルスター・クロージング) Club 27 Sweatshirt [B}
24261 UNDEAD CORPORATION LOGO Tshirt BLK×RED
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25144 CITY LIGHTS Arrows Black - Crewneck Sweatshirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
26543 UROBOROS TシャツB
28020 MYKA RELOCATE MYK-T01 TEE
28026 ATTILA A T-Shirt
28113 Xmas Eileen ビーチサンダル&ビニールバッグSET BLK
28155 KILL STAR CLOTHING (キルスター・クロージング) Poison Tank [B]
28295 THE BROWNING Skull Black
28569 EXODUS HORNED SKUL
28694 AUGUST BURNS RED DOVE
32082 ライブキッズあるある フェス余韻パーカー
35602 DISTURBED FIRE BEHIND T-SHIRTS
36268 THRASHER THSR-SST01 BLK
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36695 SLAYER LARGE BLACK EAGLE
36825 DEFTONES California Rider-Black t-shirt
37032 PANTERA Reinventing Band
37836 Xmas Eileen DIS IS LOVE EYE Tシャツ(黒)
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
41079 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / BLACK
42595 Bentham Chicago Tシャツ ブラック
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
46263 SABBAT13 SBT-LT-022 D.D.T.W L/S T(ブラック)
47103 NOT COMMON SENSE FUXX THE POLICE SEAM TEE BLACK
49213 KILL STAR CLOTHING Omen Kimono Dress [B]
49758 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW YELLOW
49759 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW GREEN
49765 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW BLUE
49767 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW GREEN
50447 mnml HOODED DENIM JACKET BLACK
50453 SALUTE POCKET PANTS
50817 CHORD NUMBER EIGHT CH01-01K5-CL52 SIDE LACE UP SWEAT BLACK
51363 KILL STAR CLOTHING Love Devil Distress Top
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52608 GoneR -La Neta- One Wash Denim Jacket BLACK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53928 KEYTALK 丁寧な刺繍パーカー ブラック
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
54610 ANIMALIA AN20U-JK01 HUNTING VEST
54611 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG BLACK
54634 FILA FFM9841 ユニセックス クルーネックシャツ BLACK
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
54046 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 03
54361 Nine Microphones PARKA-Sunforever2020aw- BLACK
56067 NineMicrophones PARKA-Power of will-BLACK
55107 Zephyren(ゼファレン)ZIP PARKA - POWER OF WILL - BLACK
28428 RUDIE'S (ルーディーズ) PHAT HOOD SWEAT BLACK
56214 Anti Social Social Club Goodbye Summer Black Tank
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
55732 SLAYER UNISEX TEE: REPENTLESS
56759 AC/DC UNISEX PULLOVER HOODIE: CANNON SWIG
56760 AC/DC LADIES ZIPPED HOODIE: LOGO (BACK PRINT)
56810 AC/DC UNISEX TEE: ANGUS STATUE
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
55792 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 コーチJKT
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
57295 IRON MAIDEN UNISEX PULLOVER HOODIE: LOTB LIVE ALBUM (ARM & BACK PRINT)
56919 Half time Old×GEKIROCK CLOTHING 限定コラボ・パーカー
56806 SILENT SIREN×ゲキクロ コラボコーチジャケット
28846 THRASHER (スラッシャー) TH8901C MAG LOGO COACH JKT BLK
57421 THRASHER (スラッシャー) TH8428PLGONZ SWEAT BLACK
57797 FALLING IN REVERSE Knit Sweater Sweatshirt
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58100 WASTED PARIS Hoodie Columbia Bridge Black
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
57324 Subciety×仮面ライダードライブ DRIVE S/S BLACK
58110 MISHKA M21000404 Pullover BLACK
58160 NOT COMMON SENSE FLAME L/S TEE BLACK
58285 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW BLACK
58287 ANIMALIA AN21S-CS06 Wild Bill S/S
57939 Subciety (サブサエティ) WORK SHORTS-WORKER- BLACK
57815 四星球×ゲキクロ 限定コラボ・パーカー ブラック
58600 SLEEPING TABLET NOBLE [ SILKY PAJAMA PANTS ] BLACK
57913 Subciety (サブサエティ) DRUNKER S/S- BLACK
59235 LONELY論理 LONELY UNIV TEE black
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58512 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・パーカー
58513 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・Tシャツ
45953 Crossfaith ORNAMENT TEE BLACK
59278 BABYMETAL PENTAGRAM TEE
52713 BABYMETAL UNISEX TEE: LOGO
60028 SUPPLIER (サプライヤー) ANGEL SWEAT SHORTS BLACK
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK