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-30 17:17:44')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND pc.classcategory_id1 IN( 14,61,35)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
68340 SLEEPING TABLET (スリーピングタブレット) Rx [ ALL OVER PRINTED INNER TEE SET ]
16037 Subciety PAISLEY TEE-Parantica sita- BLACK
70049 glamb (グラム) marquee club(R) Patch T-Shirts / マーキークラブパッチTシャツ Black
70639 glamb (グラム) marquee club(R) Collage T-shirts/マーキークラブコラージュTシャツ
17668 Subciety TIE DYE TEE-GLORIOUS- GREY
70745 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE WHITE
24775 NORTHLANE Yin Yang Heather Blue - Crewneck
68520 over print (オーバープリント) CAPTAIN Tee WHITE
20115 KILL STAR CLOTHING RA T-SHIRT [B]
58460 NARUTO-ナルト- 疾風伝 ×Subciety NARUTO S/S ORANGE
28055 SPITFIRE Bloodshot Premium T-Shirt - Rainbow Tie Dye
13399 ICECREAM FAST DOG TEE SU14 GRAY
22664 ICECREAM BOXED DOG.TEE WHT/PP
23467 ICECREAM ICJP16T001 WHT
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24768 NORTHLANE All-Over Print Black - T-Shirt
29589 ICECREAM ICJP16T034 T-SHIRT GRAY
68012 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ Tシャツ
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
20758 Subciety POCKET TEE S/S-GLORIOUS- GRAY
23090 Subciety(サブサエティ) THRON S/S BLACK
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
23125 Subciety COLLEGE S/S NAVY/WHITE
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
22541 SANTA CRUZ SIEBEN HAND S/S T SHIRT WHITE
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
17603 ICECREAM BALLERS T-SHIRT ROYAL
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
20065 ICECREAM VARSITY GREY
20067 ICECREAM ICEFA HEATHER GREY
28301 UPON A BURNING BODY Logo All Over T-Shirt
22098 FUZZ REZ ZWEEP MODULATION TEE BLK
22099 FUZZ REZ ZWEEP MODULATION TEE GRY
22103 FUZZ REZ ZWEEP BIT CRUSHER TEE WHT
18447 Subciety GLORIOUS S/S - BLACK/WHITE
20303 REBEL8 GR8FUL TEE
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
23111 Subciety SALOON S/S NAVY/YELLOW
42882 Subciety THE BASE S/S - ORANGE/WHITE
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
20169 FUZZ REZ ZWEEP DELAY TEE BLK
20170 FUZZ REZ ZWEEP DELAY TEE WHT
23685 SPITFIRE Malt Bighead Black
4599 NIRVANA MANY Happy Face T-Shirt
28810 RUDIE'S (ルーディーズ) PHAT-T BLK
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
35655 PANTERA Red Vulgar T-Shirts
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
9643 ICECREAM RACING DOG S/S T-SHIRT PURPLE
9644 SLIP&Co. BAMBINX TEE BLACK
25231 LIKE MOTHS TO FLAMES Devil Tie Dye
28047 SPITFIRE Bighead Fill T-Shirt - Black/Red
35489 RUDIE'S (ルーディーズ) SPARK-Tee BLK/WHT
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
35690 NIRVANA Bleach Cassette Photo T-shirt
36618 RIP DESIGN WORXX エレメントTシャツ GRAY
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
20337 AGAPE ATTIRE Militello Script Ringer Tee
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
12162 SPITFIRE MASSACRE S/S Tee BLACK
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
10261 RANCID MONSTER PRINT T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
15327 CHUNK!NO,CAPTAIN CHUNK! Open Your Ears Camo
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
28627 GUNS N' ROSES HEADS VINTAGE
35292 SLIPKNOT PAUL GRAY
35602 DISTURBED FIRE BEHIND T-SHIRTS
36668 IRON MAIDEN BOOK OF SOULS EDDIE
36670 IRON MAIDEN HIGHWAY
36673 JUDAS PRIEST PAINKILLER SOLO
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
35515 ALL OFF×LILWHITE. SEEKER T-shirt Black×Red
14988 Agape Attire SON OF THE MOST HIGH TEE
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
9428 THE WORD ALIVE Bullets Black T-Shirt
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
11283 CAPTURE THE CROWN Gargoyle Black
11432 WHITECHAPEL Priest Black T-Shirt
11454 THE WORD ALIVE I'd Rather Die Black
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
15582 TEXAS IN JULY Vice Black
15584 TEXAS IN JULY Ministry Maroon
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
19107 ATTILA SLUGGER BLACK
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19821 MAYDAY PARADE Label Crimson Tie Dye