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 19:51:57')
AND pc.stock > 0
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
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
13900 NEW BREED The DIVIDE TEE
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15601 TEXAS IN JULY Draw The Line Black Tie Dye
15886 フクザワ 飼われ男 Tシャツ
18983 WE CAME AS ROMANS Wont Fade Away Navy
18987 WE CAME AS ROMANS Howl At The Moon White
19836 MAYDAY PARADE Upstage White Tank Top
19881 TEXAS IN JULY Brain Black
21083 フクザワ あの日のこと Tシャツ
21159 BLACK CRAFT Aquarius
21969 セプテンバーミー ユーレイTシャツ 白
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
22614 Bentham バットマンT ヘザーレッド
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
22719 ザ・チャレンジ カラフルBOXロゴ Tシャツ WHT
23747 9mm Parabellum Bullet Photo Tシャツ
23748 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) BLK
23749 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) NVY
23776 KILL STAR CLOTHING (キルスター・クロージング) Club 27 Sweatshirt [B}
23859 BACKDATE NOVEMBER タイダイ Tee
23928 a flood of circle AFOC LOGO TEE WHT
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
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
26399 【限定アイテム】モーモールルギャバン ロゴTシャツ(すしおデザイン)
26543 UROBOROS TシャツB
28020 MYKA RELOCATE MYK-T01 TEE
28026 ATTILA A T-Shirt
28113 Xmas Eileen ビーチサンダル&ビニールバッグSET BLK
28114 Xmas Eileen ビーチサンダル&ビニールバッグSET WHT
28155 KILL STAR CLOTHING (キルスター・クロージング) Poison Tank [B]
28295 THE BROWNING Skull Black
28546 【限定アイテム】ササノマリイ M(OTHER) Tシャツ
28569 EXODUS HORNED SKUL
28694 AUGUST BURNS RED DOVE
31953 Bentham ExPツアーTシャツ WHITE
32082 ライブキッズあるある フェス余韻パーカー
35602 DISTURBED FIRE BEHIND T-SHIRTS
36268 THRASHER THSR-SST01 BLK
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36662 GUNS N' ROSES BULLET CLASSIC GRAY
36695 SLAYER LARGE BLACK EAGLE
36825 DEFTONES California Rider-Black t-shirt
37032 PANTERA Reinventing Band
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
37836 Xmas Eileen DIS IS LOVE EYE Tシャツ(黒)
37839 Xmas Eileen DIS IS LOVEタンクトップ(白)
39093 BABYMETAL CROSSBONE EYE SKELETON MENS SOFT TEE
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
41074 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / PURPLE
41078 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / PINK
41079 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / BLACK
42595 Bentham Chicago Tシャツ ブラック
42596 Bentham Chicago Tシャツ バーガンディー
42597 Bentham ロゴTシャツ ネイビー
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
46263 SABBAT13 SBT-LT-022 D.D.T.W L/S T(ブラック)
46274 SABBAT13 SBT-LT-023 G.F.G L/S T(ゴールド)
46317 SANTA CRUZ CLASSIC DOT TANK WHITE
46882 mnml(ミニマル) DROP II TEE BLACK
47103 NOT COMMON SENSE FUXX THE POLICE SEAM TEE BLACK
48233 Zephyren(ゼファレン)PONCHO HOODY S/S WHITE / 如意宝珠
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
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50447 mnml HOODED DENIM JACKET BLACK
50453 SALUTE POCKET PANTS
50817 CHORD NUMBER EIGHT CH01-01K5-CL52 SIDE LACE UP SWEAT BLACK
51353 KILL STAR CLOTHING Juliet Ring
51363 KILL STAR CLOTHING Love Devil Distress Top
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
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
52607 GoneR -La Neta- Chemical Wash Denim Jacket INDIGO
52608 GoneR -La Neta- One Wash Denim Jacket 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
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53161 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE WHITE
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53928 KEYTALK 丁寧な刺繍パーカー ブラック
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
53958 KONUS Color Blocked Oversized Short Sleeve TEAL
54610 ANIMALIA AN20U-JK01 HUNTING VEST
54611 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG BLACK
54632 FILA FFM9841 ユニセックス クルーネックシャツ WHITE
54633 FILA FFM9841 ユニセックス クルーネックシャツ RED