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-05-22 06:58:15')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.stock > 0
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
10236 METALLICA JUSTICE FOR ALL T-Shirt
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
28396 THRASHER (スラッシャー) TH8101 MAG LOGO TEE NAV/WHT
58321 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT WHITE
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
65293 ハッピーハンバーグ ステーキハウス刺繍Tシャツ WHITE
68159 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE YELLOW
65312 ZERO EVOKE Spider Tee 【PINK】
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
71422 Subciety (サブサエティ) CREST TANK TOP WHITE
71303 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE WH/DOKU
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
585 RED HOT CHILI PEPPERS Asterisk Logo Black
1097 RED HOT CHILI PEPPERS Asterisk Logo White
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
4598 NIRVANA Happy Face T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
10233 METALLICA DORIS T-Shirt
10235 METALLICA VINTAGE METAL UP T-Shirt
11984 ANTHRAX WORSHIP MUSIC T-Shirt
17951 AVENGED SEVENFOLD STELLAR
24329 RUDIE'S DRAWING-T BLACK
24330 RUDIE'S DRAWING-T WHITE
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
28592 MARILYN MANSON CROWN T-Shirts
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
35642 MARILYN MANSON RED LIPS T-SHIRTS
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
36830 GREEN DAY American Idiot Black T-shirt
41960 BABYMETAL Unisex Tee: Skull Sword
43345 BRING ME THE HORIZON Sempiternal TEE
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
45953 Crossfaith ORNAMENT TEE BLACK
49512 SLIPKNOT .5 THE GRAY CHAPTER
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
51425 GREEN DAY Unisex Tee: Drips
51426 GREEN DAY Unisex Tee: Hypno 4
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52713 BABYMETAL UNISEX TEE: LOGO
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
52907 KORN UNISEX TEE: DEATH DREAM
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
53189 BLACK VEIL BRIDES UNISEX TEE: INFERNO
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
55734 SLAYER UNISEX TEE: SILVER EAGLE
56820 THE 1975 UNISEX TEE: BLACK TOUR
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)