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 =1
)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-28 01:28:52')
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
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
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
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
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
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
28295 THE BROWNING Skull Black
28546 【限定アイテム】ササノマリイ M(OTHER) Tシャツ
28569 EXODUS HORNED SKUL
28694 AUGUST BURNS RED DOVE
31953 Bentham ExPツアーTシャツ WHITE
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シャツ(黒)
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
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
46882 mnml(ミニマル) DROP II TEE BLACK
47103 NOT COMMON SENSE FUXX THE POLICE SEAM TEE BLACK
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
51363 KILL STAR CLOTHING Love Devil Distress Top
51445 JILUKA×DI:VISION ゲキクロ・コラボ・Tシャツ WHITE
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
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)
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
53958 KONUS Color Blocked Oversized Short Sleeve TEAL
54632 FILA FFM9841 ユニセックス クルーネックシャツ WHITE
54633 FILA FFM9841 ユニセックス クルーネックシャツ RED
54634 FILA FFM9841 ユニセックス クルーネックシャツ BLACK
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
11984 ANTHRAX WORSHIP MUSIC T-Shirt
12020 EVANESCENCE SHINE T-Shirt
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
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
54046 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 03
56213 Anti Social Social Club Headrush All Over White Tee
55732 SLAYER UNISEX TEE: REPENTLESS
56810 AC/DC UNISEX TEE: ANGUS STATUE
56811 AC/DC UNISEX FASHION TEE: BLACK ICE (BURN OUT)
57385 FILA FS3028 T-Shirt NAVY
57390 FILA FS3008 T-Shirt WHITE
58095 WASTED PARIS T-shirt Marble Dye Nebula Green
57322 Subciety×仮面ライダードライブ DRIVE S/S WHITE
57324 Subciety×仮面ライダードライブ DRIVE S/S BLACK
58287 ANIMALIA AN21S-CS06 Wild Bill S/S
58509 THRASHER (スラッシャー) TH8101 MAG LOGO S/S TEE KHARKI/BLACK
57885 Subciety (サブサエティ) WEEKENDER S/S- RED
57913 Subciety (サブサエティ) DRUNKER S/S- BLACK
59235 LONELY論理 LONELY UNIV TEE black
58513 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・Tシャツ
59405 SUPPLIER (サプライヤー) SPIDER WEB TEE
45953 Crossfaith ORNAMENT TEE BLACK
59278 BABYMETAL PENTAGRAM TEE
52713 BABYMETAL UNISEX TEE: LOGO
60030 SUPPLIER (サプライヤー) ANGEL TEE PINK
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK