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-01 12:55:31')
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 p.update_date
LIMIT 0, 120
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
51444 JILUKA×DI:VISION ゲキクロ・コラボ・Tシャツ BLACK
52286 あゆみくりかまき×ゲキクロ×ripdw AKM TIMES T-SHIRT
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
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
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
11984 ANTHRAX WORSHIP MUSIC T-Shirt
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
53189 BLACK VEIL BRIDES UNISEX TEE: INFERNO
55734 SLAYER UNISEX TEE: SILVER EAGLE
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
59274 IRON MAIDEN Unisex Tee: Duality
59273 IRON MAIDEN Unisex Tee: Eddie Chained Legacy
45953 Crossfaith ORNAMENT TEE BLACK
41960 BABYMETAL Unisex Tee: Skull Sword
59278 BABYMETAL PENTAGRAM TEE
52713 BABYMETAL UNISEX TEE: LOGO
65293 ハッピーハンバーグ ステーキハウス刺繍Tシャツ WHITE
65312 ZERO EVOKE Spider Tee 【PINK】
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
68159 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH CAMOFITS TEE YELLOW
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
68078 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / SAX
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68585 SYSTEM OF A DOWN UNISEX T-SHIRT: TRIPLE STACK BOX
68586 SYSTEM OF A DOWN UNISEX T-SHIRT: BANNER MARCHES
37811 ALL TIME LOW UNISEX TEE: SCRATCH
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
68744 Gluttonous Slaughter(グラトナススローター) Feast of the Unbirthed T-shirt BLACK
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68544 THRASHER (スラッシャー) Devils Music S/S T-SHIRTS WHITE
68545 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS BLACK
68546 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS WHITE
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
28395 THRASHER (スラッシャー) TH8101 MAG LOGO TEE BURGUNDY
28396 THRASHER (スラッシャー) TH8101 MAG LOGO TEE NAV/WHT
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
58321 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT WHITE
69086 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / RED
69087 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / WHITE
69088 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / MELON
69089 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / WHITE
68741 Gluttonous Slaughter(グラトナススローター) The Monster Slayer Cat T-shirt BLACK
69113 PUNK DRUNKERS(パンクドランカーズ)ABCDTEE'23 / REVIVAL BLACK
69112 PUNK DRUNKERS(パンクドランカーズ)ABCDTEE'23 / REVIVAL WHITE
69065 Dogmatic Gourmet x over print x RIP DESIGN WORXX ラーメンガールTシャツ BLACK
69064 Dogmatic Gourmet x over print x RIP DESIGN WORXX ラーメンガールTシャツ WHITE
69161 DEF LEPPARD UNISEX T-SHIRT: HYSTERIA WORLD TOUR (BACK PRINT)
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
69895 PUNK DRUNKERS(パンクドランカーズ) ですメタルTEE - SUMI
71011 【予約商品】PUNK DRUNKERS ロマンチーストTEE - BLACK
71003 【予約商品】PUNK DRUNKERS 大きな小人TEE - BLACK
70995 【予約商品】PUNK DRUNKERS スペコンライダーTEE - NAVY
70994 【予約商品】PUNK DRUNKERS スペコンライダーTEE - BLACK
70945 SLEEP TOKEN UNISEX T-SHIRT: TAKE ME BACK TO EDEN
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
69890 PUNK DRUNKERS(パンクドランカーズ) 超丸尾兄弟TEE - WHITE
71303 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE WH/DOKU
71304 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE BK/BLU
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
59266 Ed Sheeran Unisex Tee: Divide
59265 Ed Sheeran Unisex Tee: Chords
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
4598 NIRVANA Happy Face T-Shirt
59255 NIRVANA Unisex Tee:White Happy Face
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
51426 GREEN DAY Unisex Tee: Hypno 4
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
70935 BLINK-182 UNISEX T-SHIRT: OVERBOARD EVENT
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
70557 SUM41 UNISEX T-SHIRT: REAPER
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
60192 RED HOT CHILI PEPPERS UNISEX T-SHIRT: GETAWAY ALBUM ASTERISK
585 RED HOT CHILI PEPPERS Asterisk Logo Black
1097 RED HOT CHILI PEPPERS Asterisk Logo White
10235 METALLICA VINTAGE METAL UP T-Shirt
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
10233 METALLICA DORIS T-Shirt
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
59257 NINE INCH NAILS Unisex Tee: Classic Logo
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
70279 BULLET FOR MY VALENTINE UNISEX T-SHIRT: FLORAL OMEN
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
35642 MARILYN MANSON RED LIPS T-SHIRTS
28592 MARILYN MANSON CROWN T-Shirts
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)