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-05-19 21:32:42')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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, 240
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
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
24329 RUDIE'S DRAWING-T BLACK
24330 RUDIE'S DRAWING-T WHITE
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
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
59255 NIRVANA Unisex Tee:White Happy Face
59257 NINE INCH NAILS Unisex Tee: Classic Logo
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
59265 Ed Sheeran Unisex Tee: Chords
59266 Ed Sheeran Unisex Tee: Divide
59273 IRON MAIDEN Unisex Tee: Eddie Chained Legacy
59274 IRON MAIDEN Unisex Tee: Duality
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
59278 BABYMETAL PENTAGRAM TEE
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
66944 KORN UNISEX T-SHIRT: BLOCKS
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
67958 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY WHITE
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK
68576 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO WHITE
68577 LINKIN PARK UNISEX T-SHIRT: LIVING THINGS ALBUM
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
68580 SLIPKNOT UNISEX T-SHIRT: ALIEN (BACK PRINT)
68581 SLIPKNOT UNISEX T-SHIRT: SKELETON & PENTAGRAM (BACK PRINT)
68582 SLIPKNOT UNISEX T-SHIRT: ADDERALL FACEBACK (BACK PRINT)
68583 SLIPKNOT UNISEX T-SHIRT: THE END (BACK PRINT)
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68585 SYSTEM OF A DOWN UNISEX T-SHIRT: TRIPLE STACK BOX
68833 SLIPKNOT UNISEX T-SHIRT: ZOMBIE (BACK PRINT)
68835 SLIPKNOT UNISEX T-SHIRT: DEVIL SINGLE - LOGO BLUR (BACK PRINT)
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69161 DEF LEPPARD UNISEX T-SHIRT: HYSTERIA WORLD TOUR (BACK PRINT)
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
69446 BRING ME THE HORIZON UNISEX T-SHIRT: IMPRINT NEX GEN
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
70557 SUM41 UNISEX T-SHIRT: REAPER
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
70821 POLYPHIA UNISEX T-SHIRT: SPEAR ANGEL
70935 BLINK-182 UNISEX T-SHIRT: OVERBOARD EVENT
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
70945 SLEEP TOKEN UNISEX T-SHIRT: TAKE ME BACK TO EDEN
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
71249 MÅNESKIN UNISEX T-SHIRT: TEATRO D'IRA DOODLES (BACK PRINT & EX-TOUR)
71250 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 POSTER (EX-TOUR)
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
71430 SKINDRED UNISEX T-SHIRT: LOUD MUSIC
71431 SKINDRED UNISEX T-SHIRT: RASTA LOGO
71494 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX (BACK PRINT)
71495 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: WOLFMAN
71496 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: DETROIT (BACK PRINT)
71497 BAD OMENS UNISEX T-SHIRT: SUNFLOWER
71498 DEFTONES UNISEX T-SHIRT: SPHYNX
71499 DEFTONES UNISEX T-SHIRT: STATIC SKULL (BACK PRINT)
71500 DEFTONES UNISEX T-SHIRT: STAR & PONY
71502 MOTIONLESS IN WHITE UNISEX T-SHIRT: GRAVEYARD SHIFT
71504 NINE INCH NAILS UNISEX T-SHIRT: HEAD LIKE A HOLE
68744 Gluttonous Slaughter(グラトナススローター) Feast of the Unbirthed T-shirt BLACK
69064 Dogmatic Gourmet x over print x RIP DESIGN WORXX ラーメンガールTシャツ WHITE
69065 Dogmatic Gourmet x over print x RIP DESIGN WORXX ラーメンガールTシャツ BLACK
68741 Gluttonous Slaughter(グラトナススローター) The Monster Slayer Cat T-shirt BLACK
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
69113 PUNK DRUNKERS(パンクドランカーズ)ABCDTEE'23 / REVIVAL BLACK
69890 PUNK DRUNKERS(パンクドランカーズ) 超丸尾兄弟TEE - WHITE
68078 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / SAX
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
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
58064 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TILT
64916 ANIMALIA (アニマリア) TITLE WHITE
71411 GoneR (ゴナー) Graffiti Logo T-Shirts White
71413 GoneR (ゴナー) Graffiti Logo T-Shirts Black
49739 NineMicrophones Pray with the microphone S/S WHITE
49740 NineMicrophones Pray with the microphone S/S BLACK
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
57798 CRADLE OF FILTH Krampus T-shirt + ornament
64193 Subciety (サブサエティ) THE BASE S/S NAVY
68230 TheBackOfBoys(ザバックオブボーイズ) CITY GRAFFITI TEE HEATHER BLACK
68235 TheBackOfBoys(ザバックオブボーイズ) CITY GRAFFITI TEE WHITE
68294 RUDIE'S (ルーディーズ) EXTRA DRAWING-T BLACK
68341 CMP LABEL (シーエムピーレーベル) CHAOTIC oversized T-shirt
68342 CMP LABEL (シーエムピーレーベル) Antinomie oversized T-shirt
68384 SABBAT13(サバトサーティーン) PLAY SONG T (BLACK)
68387 SABBAT13(サバトサーティーン) FATE T (SMOKE BLACK)
68388 SABBAT13(サバトサーティーン) FATE T (ASH)
68439 SABBAT13(サバトサーティーン) SCAPEGOAT T (WHITE)
68440 SABBAT13(サバトサーティーン) SCAPEGOAT T (BLACK)
68458 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T BLACK
68459 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T WHITE
68904 TheBackOfBoys(ザバックオブボーイズ) SORE LOSER TEE WHITE
68905 TheBackOfBoys(ザバックオブボーイズ) SORE LOSER TEE BLACK
68909 TheBackOfBoys(ザバックオブボーイズ) PREMONITION OF SUMMER TEE BLACK
68911 TheBackOfBoys(ザバックオブボーイズ) CHEESE&MOUSE TEE WHITE
68912 TheBackOfBoys(ザバックオブボーイズ) CHEESE&MOUSE TEE NAVY
68913 TheBackOfBoys(ザバックオブボーイズ) TEAM TEE WHITE
69026 Gurin. ×PSYCHOLOGICAL METAMORPHOSIS EYES TEE WHITE
69027 Gurin. ×PSYCHOLOGICAL METAMORPHOSIS EYES TEE BLACK
69211 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Red
69213 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt White
69215 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Purple
69270 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE ASH
69271 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE MINT
69272 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE BLACK
69869 PUNK DRUNKERS(パンクドランカーズ) [PDSxたまごっち]世話しなすぎTEE - WHITE
69873 PUNK DRUNKERS(パンクドランカーズ) [PDSxチャーミーちゃん]遊泳禁止TEE - BLACK
69874 PUNK DRUNKERS(パンクドランカーズ) [PDSxチャーミーちゃん]遊泳禁止TEE - PURPLE
71727 SABBAT13(サバトサーティーン) SMOKY GIRL Tee BLACK
71729 SABBAT13(サバトサーティーン) SMOKY GIRL Tee SMOKY PINK
71730 SABBAT13(サバトサーティーン) SPOOK LOGO Tee BLACK
71731 SABBAT13(サバトサーティーン) SPOOK LOGO Tee WHITE
71732 SABBAT13(サバトサーティーン) SPOOK LOGO Tee GREEN
64257 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Natural)
64267 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Gray)
68870 DI:VISION (ディヴィジョン) TRAPPED Tee BLACK
68871 DI:VISION (ディヴィジョン) TRAPPED Tee WHITE
68875 DI:VISION (ディヴィジョン) BURNED LOGO Tee BLACK
68876 DI:VISION (ディヴィジョン) BURNED LOGO Tee WHITE
43487 KILL STAR CLOTHING Delish Relaxed Top [B]
64187 over print(オーバープリント) back pennant Tee (light coral pink)
68420 SCENE TOKYO (シーントウキョウ) Grafitie S/S WHITE
69090 SCENE TOKYO (シーントウキョウ) Skate girl Tee WHITE
69091 SCENE TOKYO (シーントウキョウ) Skate girl Tee NAVY
69092 SCENE TOKYO (シーントウキョウ) Retro girl Tee WHITE
69093 SCENE TOKYO (シーントウキョウ) Retro girl Tee NAVY
69877 PUNK DRUNKERS(パンクドランカーズ) マイレコメンドポケTEE - BLACK
69878 PUNK DRUNKERS(パンクドランカーズ) マイレコメンドポケTEE - S.BLUE
69879 PUNK DRUNKERS(パンクドランカーズ) ピン抜くゲームTEE - WHITE
64306 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Black)
67922 【BanG Dream! ×ゲキクロ 2023 ver.】氷川紗夜×Subciety コラボ Tシャツ
68004 【BanG Dream! ×ゲキクロ 2023 ver.】パレオ×DI:VISION コラボ Tシャツ
68008 【BanG Dream! ×ゲキクロ 2023 ver.】湊友希那×ZEPHYREN コラボ Tシャツ
64309 Subciety (サブサエティ) LEAGUE TEE WHITE/BLUE
64312 Subciety (サブサエティ) Monogram TEE WHITE
64314 Subciety (サブサエティ) SUPPORTER TEE WHITE
65688 Lonesome_Blue×KAVANE Clothing×GEKIROCK CLOTHINGコラボ・Tシャツ
67412 福島ノア × DI:VISION コラボ限定Tシャツ
68115 Subciety (サブサエティ) CREST TEE BLACK
68181 アマツカミ 雨薔薇/Rainrose T-shirt WHITE
68182 アマツカミ 雄弁/Eloquencee T-shirt WHITE
68184 アマツカミ 遭逢/Encounter T-shirt BLACK
68185 アマツカミ 彼岸花/Lycoris radiata T-shirt WHITE
68194 アマツカミ 雨薔薇/Rainrose T-shirt BLACK
68195 アマツカミ 雄弁/Eloquencee T-shirt BLACK
68196 アマツカミ 彼岸花/Lycoris radiata T-shirt BLACK
68197 アマツカミ 遭逢/Encounter T-shirt WHITE
68548 東京13零式(トウキョウイチサンゼロシキ) 滅滅 Light Purple
68549 東京13零式(トウキョウイチサンゼロシキ) 滅滅 White
68836 over print (オーバープリント) SIDE LINE Nylon Pullover LAVENDER
70059 Risky Melody×RIP DESIGN WORXX×GEKIROCK CLOTHING コラボ・Tシャツ
70441 明石真秀×RUDIE'S コラボ限定Tシャツ
70455 月見山 渚×アマツカミ コラボ限定Tシャツ
70723 Subciety (サブサエティ) Hard Days TEE BLACK
70724 Subciety (サブサエティ) Hard Days TEE BURGUNDY
70725 Subciety (サブサエティ) Hard Days WHITE