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 07:04:10')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
52942 Survive Said The Prophet MIA TOUR TEE
52946 Survive Said The Prophet CONCRETE COACH JKT WHITE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
53239 【予約商品】Zephyren(ゼファレン)SWITCHING SHIRT S/S WHITE / RED
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
17973 UNEARTH SKATE RAGE
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
23747 9mm Parabellum Bullet Photo Tシャツ
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
23749 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) NVY
26399 【限定アイテム】モーモールルギャバン ロゴTシャツ(すしおデザイン)
28694 AUGUST BURNS RED DOVE
35602 DISTURBED FIRE BEHIND T-SHIRTS
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
37839 Xmas Eileen DIS IS LOVEタンクトップ(白)
39163 BLACK SABBATH LOTW white Tee
39905 SANTA CRUZ Classic Dot S/S T-Shirt White
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
41078 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / PINK
41079 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / BLACK
42629 KEYTALK シンプルロゴ刺繍Tシャツ バナナ
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
44826 KILL STAR CLOTHING Spook N Destroy Knit Sweater [B]
46250 SABBAT13 SBT-LT-020 13X-BONE L/S T (ブラック)
46263 SABBAT13 SBT-LT-022 D.D.T.W L/S T(ブラック)
46274 SABBAT13 SBT-LT-023 G.F.G L/S T(ゴールド)
49759 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW GREEN
49763 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Sweat Designed by RIPDW GREEN
49765 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW BLUE
49766 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW YELLOW
49767 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW GREEN
49846 DISTURBED LOST SOULS
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
50445 LIGHTWEIGHT FLY HOODIE BOLT
51362 KILL STAR CLOTHING Diablerie T-Shirt
51376 極東ロマンス×acOlaSia ゲキクロ限定コラボ L/S T-Shirt
51444 JILUKA×DI:VISION ゲキクロ・コラボ・Tシャツ BLACK
51445 JILUKA×DI:VISION ゲキクロ・コラボ・Tシャツ WHITE
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52511 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) LIME GREEN
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52864 BILLIE EILISH UNISEX LONG SLEEVED TEE: SMILE (BACK & ARM PRINT) BLUE
52865 BILLIE EILISH UNISEX LONG SLEEVED TEE: MANINMAN BLUE
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53927 KEYTALK 丁寧な刺繍パーカー パープル
53930 KEYTALK 繋がるKEYTALKロゴTシャツ WHITE
53957 KONUS Color Blocked Oversized Short Sleeve BLACK
53959 KONUS Color Blocked Cotton Twill Oversized Shirt BLACK
54632 FILA FFM9841 ユニセックス クルーネックシャツ WHITE
54633 FILA FFM9841 ユニセックス クルーネックシャツ RED
54634 FILA FFM9841 ユニセックス クルーネックシャツ BLACK
52606 GoneR -La Neta- Agave Pocket T-Shirts BLACK
52604 GoneR -La Neta- Agave Pocket T-Shirts MAROON
55629 Anti Social Social Club SAMSIES PINK HOODIE
55628 Anti Social Social Club SAMSIES BLUE HOODIE
12020 EVANESCENCE SHINE T-Shirt
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
55130 Zephyren(ゼファレン)PARKA - variat omnia tempus - WHITE
55876 GoneR GR26ZP001 Rose Photo Zip Parka Heather gray
56210 Anti Social Social Club Enrique White Vneck Tee
56213 Anti Social Social Club Headrush All Over White Tee
56214 Anti Social Social Club Goodbye Summer Black Tank
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
56760 AC/DC LADIES ZIPPED HOODIE: LOGO (BACK PRINT)
56810 AC/DC UNISEX TEE: ANGUS STATUE
56047 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Blk)
56049 【ゲキクロ限定】KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(ゲキクロ限定カラー)
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
56517 水野ギイ×RIPDW×GEKIROCK CLOTHINGコラボ・ロンT PURPLE
56757 エルフリーデ×ゲキクロ×DI:VISION限定ロング・スリーブTシャツBLACK/RED
57389 FILA FS3027 L/S T-Shirt NAVY
57391 FILA FS3008 T-Shirt BLACK
57414 THRASHER (スラッシャー) TH8528PLGONZ HOODIE WHITE
57419 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT RED
57797 FALLING IN REVERSE Knit Sweater Sweatshirt
39639 Subciety (サブサエティ) WORK PANTS-PAISLEY- BEIGE
57034 VIRGO Upright zip swt BLACK
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
57012 VIRGO Middle Cuban shirt NAVY
58285 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW BLACK
58286 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW WHITE
58287 ANIMALIA AN21S-CS06 Wild Bill S/S
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
57817 四星球×ゲキクロ 限定コラボ・パーカー ピンク
57815 四星球×ゲキクロ 限定コラボ・パーカー ブラック
58198 PUNK DRUNKERS [PDSxBLACK PEARLS]PDSロードTEE - BLACK
59117 ANIMALIA AN21U-TE11 FALLING WHITE
59233 LONELY論理 LONELY UNIV TEE white
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58456 Subciety×NARUTO-ナルト- 疾風伝 KAKASHI&GUY L/S BLACK
57597 Zephyren(ゼファレン) DOUBLE POCKET SHORTS BLACK
55636 Anti Social Social Club Kkoch Black Tee
59274 IRON MAIDEN Unisex Tee: Duality