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-02 02:48:05')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 14,61,35)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
70639 glamb (グラム) marquee club(R) Collage T-shirts/マーキークラブコラージュTシャツ
70049 glamb (グラム) marquee club(R) Patch T-Shirts / マーキークラブパッチTシャツ Black
70844 【予約商品】glamb (グラム)Punk Bouquet T-Shirt / パンクブーケTシャツ - Black
4599 NIRVANA MANY Happy Face T-Shirt
70745 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE WHITE
68520 over print (オーバープリント) CAPTAIN Tee WHITE
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
68012 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ Tシャツ
35655 PANTERA Red Vulgar T-Shirts
37586 MEGADETH -Dystopia-Black t-shirt
68340 SLEEPING TABLET (スリーピングタブレット) Rx [ ALL OVER PRINTED INNER TEE SET ]
35292 SLIPKNOT PAUL GRAY
58460 NARUTO-ナルト- 疾風伝 ×Subciety NARUTO S/S ORANGE
9313 MEMPHIS MAY FIRE Identity Navy Blue
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9322 CAPTURE THE CROWN Walking Dead Black
9369 ATTILA Sugar Skull Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9424 WHITECHAPEL Riot Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
9433 OH SLEEPER Endseekers T-Shirt
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
10261 RANCID MONSTER PRINT T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
11261 CHUNK!NO,CAPTAIN CHUNK! Bats Navy
11283 CAPTURE THE CROWN Gargoyle Black
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11311 ENTER SHIKARI Return To Black
11419 CAPTURE THE CROWN Doggie Black
11432 WHITECHAPEL Priest Black T-Shirt
11454 THE WORD ALIVE I'd Rather Die Black
11932 AC/DC THUNDER LOGO T-Shirt
11939 AMON AMARTH LOGO RUNE T-Shirt
12026 MEGADETH EXPLODING VIC T-Shirt
13900 NEW BREED The DIVIDE TEE
15327 CHUNK!NO,CAPTAIN CHUNK! Open Your Ears Camo
15351 WHITECHAPEL Backfire Black
15378 THE SUMMER SET Logo Camo
15386 NORTHLANE Snakes Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15427 THE WORD ALIVE Lighthouse Black
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15430 THE WORD ALIVE Press Photo White T-Shirt
15471 CROWN THE EMPIRE Axe Navy
15496 ALL THAT REMAINS A War You Cannot Win Black
15508 WE CAME AS ROMANS Dave & Kyle Live Black T-Shirt
15510 WE CAME AS ROMANS Hope Crest Black
15513 WE CAME AS ROMANS My Home Your Heart White
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
15537 MAYDAY PARADE Chain Gang Black
15549 NEW BREED SKULL TEE
15582 TEXAS IN JULY Vice Black
15584 TEXAS IN JULY Ministry Maroon
15886 フクザワ 飼われ男 Tシャツ
15983 PAN マスコロ'14オフィシャルTシャツ×HABIT DESIGN PINK
16616 this is not a business カタカナTシャツ
17973 UNEARTH SKATE RAGE
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
18979 MEMPHIS MAY FIRE Nautical Black
18980 MEMPHIS MAY FIRE Eagle Dagger Red
18981 MEMPHIS MAY FIRE Cartoon Matty Black
18988 WE CAME AS ROMANS Floral Script HeatherMountain
19001 WHITECHAPEL Pocket Blade Black
19004 WHITECHAPEL Simple Flag Black
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19096 ATTILA Bad Reputation Black
19107 ATTILA SLUGGER BLACK
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19821 MAYDAY PARADE Label Crimson Tie Dye
19844 FOR TODAY IMMORTAL RED
19884 WITHIN THE RUINS Agent Of Chaos Black
19894 FINCH Hand Heather RED T-Shirt
20126 激ロック×サボパン【激サボパンTシャツ】 BLACK
20193 KEYTALK ボーダーTシャツ赤
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
20337 AGAPE ATTIRE Militello Script Ringer Tee
21083 フクザワ あの日のこと Tシャツ
21086 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT BLK
21087 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT WHT
21125 BEARTOOTH Generation Of Disorder Black
21130 BEFORE MY LIFE FAILS BMLFCULT Color Tee NVY/PUR
21139 BEFORE MY LIFE FAILS Bucket Hat BlackLogo Tee NAVY
21140 BEFORE MY LIFE FAILS NEW LOGO TEE WHITE
21141 BEFORE MY LIFE FAILS NEW LOGO TEE BLACK
21220 ATTILA RageAholics Red - T-Shirt
21968 セプテンバーミー ユーレイTシャツ 黒
21969 セプテンバーミー ユーレイTシャツ 白
21990 THREE LIGHTS DOWN KINGS FIRE T-Shirts WHITE
21991 THREE LIGHTS DOWN KINGS FIRE T-Shirts BLACK
22377 小南泰葉 「EMETH」 Tシャツ
22508 ドラマチックアラスカ 人間ロックTシャツ ゲキクロ限定カラー
22586 I THE BREATHER SERCH FOR A BETTER LIFE
22611 Bentham cokeTシャツ WHT
22613 Bentham cokeTシャツ BLK
22703 5 SECONDS OF SUMMER Jet Black Heart Tee
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
22719 ザ・チャレンジ カラフルBOXロゴ Tシャツ WHT
23454 HER NAME IN BLOOD BEAST MODE TOUR T-Shirts
23847 BACK LIFT タイダイTシャツ TROPICAL
23928 a flood of circle AFOC LOGO TEE WHT
23944 amazarashi higashizm tour T-shirts【ピンク】
24258 UNDEAD CORPORATION 朱美デザインTシャツ BLACK
24260 UNDEAD CORPORATION LOGO Tshirt BLK×GOLD
24434 【限定カラー】あゆみくりかまき MATAGI IN DA HOUSE Tシャツ
24541 ATTILA Fuck Your Shit Camo Black - T-Shirt
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
24679 SLEEPING WITH SIRENS Sealed Lips Black - T-Shirt
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt