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 22:09:33')
AND pc.price02 > 4545
AND price02 <= 9090
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
20293 REBEL8 WOMENS MARLED KNIT PANT
21843 PARADOX - GRAPHIC MA1 MAGIC
21844 PARADOX - GRAPHIC MA1 NIGHTMARE
22228 REBEL8 Standard Issue Logo Crewneck
22935 PARADOX - HOODY PONCHO (BLACK)
23405 PARADOX - NO COLLAR BLOUSON (BLACK)
28218 REBEL8 WOMENS CONSPIRACY PANT
28219 REBEL8 WOMENS CONSPIRACY SHORT SLEEVE CREWNECK
34469 REBEL8 WORK SHORTS BLACK
34470 REBEL8 WORK SHORTS KHAKI
36730 REBEL8 Floret Embroidered Crewneck
37755 REBEL8 Slashed Pullover
50197 REBEL8 DIE BY THE SWORD LS TEE
50643 CHORD NUMBER EIGHT CHA1-01K5-AC01 CROSS NECKLACE
50644 CHORD NUMBER EIGHT CHA1-01K5-AC02 PLATE NECKLACE
50818 CHORD NUMBER EIGHT CH01-01K5-AC07 JACQUARD TAPE NECKLACE BLACK&BLACK
50819 CHORD NUMBER EIGHT CH01-01K5-AC07 JACQUARD TAPE NECKLACE ORANGE&BLACK
52669 REBEL8×Slayer Slayer Army Longsleeve Tee
52670 REBEL8×SLAYER South Of Heaven Longsleeve Tee
54594 PARADOX PX17-CS03 BIG WIDE TEE BLACK
54596 PARADOX PX17-CS03 BIG WIDE TEE PURPLE
55527 PARADOX PX17-HST01 HALF SLEEVE T-SHIRTS LOST WEEKEND BLACK
55528 PARADOX PX17-HST01 HALF SLEEVE T-SHIRTS LOST WEEKEND WHITE
55898 PARADOX HALF SLEEVE T-SHIRTS-FARCE WHITE
49231 MAISON EMERALD STITCHED PRINTED WIDE LEG JEANS
49236 MAISON EMERALD WASHED SPRAY PAINTED SHORTS
49238 SALUTE REMADE DYE TEE
49239 SALUTE REMADE DOUBLE WASHED TEE
52560 Evae mob *EVAE+ Smiley Necklace Green
55895 SALUTE WASHED FLOWER VINTAGE TEE BLACK
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
42828 BLACK CRAFT Believe In Yourself Bleach Wash Hooded Pullover
20447 PARADOX × LYSERG - COCOON BACKPACK
21297 PARADOX × LYSERG - COCOON BACKPACK WHT
22083 REBEL8 WOMENS SHORT SLEEVE SWEATER LOGO TEE
29877 REBEL8 WOMENS TWO FACED CREWNECK
29878 REBEL8 WOMENS ORNATE BADGE FLANNEL DRESS
31790 REBEL8 ORNATE BADGE CREW GRAY
32325 REBEL8 WORLDWIDE DOMINATION CREW BURGUNDY
40726 REBEL8 118010001 CEREMONY SWIM SHORTS BLACK
41229 REBEL8 Integrity Champion Mesh Shorts
47873 VISION STREET WEAR VSW-9157 VISION CANVAS HI RHCP WHITE
50201 REBEL8 SLAYER SNAPBACK CAP
52673 REBEL8×SLAYER God Hates Us All Snapback
52674 REBEL8×Slayer Slayer LP Snapback
56485 SALUTE Flower Anarchy Hoodie BLACK
11268 BLACK CRAFT Lone Wolf Hooded Pullover Sweater
15812 BLACK CRAFT Lucipurr - Hooded Pullover Sweater
42834 BLACK CRAFT In Reason Unisex Lightweight Hoodie
56765 FOG ESSENTIALS Solid Hoodie L/H.GRY
56766 FOG ESSENTIALS Solid Hoodie TAN
13732 REBEL8 STANDARD ISSUE LEATHER WALLET
15284 REBEL8 WOMENS LOGO LOCK UP CREWNECK
16367 BLACK CRAFT Baphomet 666 - Hooded Pullover Sweater
21163 BLACK CRAFT Planchette - White Hooded Pullover
21278 BLACK CRAFT Sinners Are Winners White Hooded Pull
29868 REBEL8 WOMENS OWL MOCK NECK
35162 REBEL8 Enduring Track Short Black
35163 REBEL8 Enduring Track Short Grey
42835 BLACK CRAFT Leviathan
42836 BLACK CRAFT Hell Cat
45167 FAR★STAR 門番モンキーカラー ロンT
49232 MAISON EMERALD STITCHING CASHEW FLOWER SWEATPANTS
15292 REBEL8 WOMENS WATCH YOUR STEP BUTTON-UP
42838 BLACK CRAFT Dagger Sheath
42839 BLACK CRAFT Nocturnal
45591 FAR★STAR ピンスト BIG T BLACK/COLOR
52671 REBEL8×SLAYER Black Magic Tee
55893 SALUTE FLOWER ANARCHY BRACELET
22936 PARADOX - GRAPHIC LONG PARKA SUBSPACE
23410 PARADOX - GRAPHIC LONG PARKA (SPIKE)
23411 PARADOX - GRAPHIC LONG PARKA (DARK WATER)
11110 REBEL8 STANDARD ISSUE LOGO NEW ERA
11267 BLACK CRAFT Tarot Zip Up Hoodie
11317 BLACK CRAFT Wolf Howl Crewneck Sweater
21414 PARADOX GRAPHIC PARKA MAGIC
21703 PARADOX GRAPHIC LONG PARKA XTAL
22933 PARADOX - DENIM JOGGER PANTS ICE
22934 PARADOX - DENIM JOGGER PANTS BLACK
25339 PARADOX SKINNY PANTS BLACK
31785 REBEL8 STANDARD ISSUE BELT
42819 BLACK CRAFT Alchemy Priest Long Sleeve
42820 BLACK CRAFT Command Spirits Long Sleeve
42821 BLACK CRAFT Baphomet Long Sleeve
42823 BLACK CRAFT Disembodied Long Sleeve
44098 REBEL8 Standard Issue Logo Script Snapback Dark Cardinal
47874 VISION STREET WEAR VSW-9158 VISION SLIP ON RHCP WHITE
47875 VISION STREET WEAR VSW-9158 VISION SLIP ON RHCP BLACK
47876 VISION STREET WEAR VSW-9158 VISION SLIP ON RHCP RED
54946 PARADOX PX17-BT01 GRAPHIC BIG T-SHIRTS(NEVER SATISFIED) WHITE
54948 PARADOX PX17-BT02 GRAPHIC BIG T-SHIRTS(STAY DIFFERENT) WHITE
54950 PARADOX PX17-BT02 GRAPHIC BIG T-SHIRTS(STAY DIFFERENT) GLAY
55531 PARADOX PX17-BT01 GRAPHIC BIG T-SHIRTS(NEVER SATISFIED) LIGHT PURPLE
55627 Anti Social Social Club THE GROVE BLACK HOODIE
55630 Anti Social Social Club BAT EMOJI WHITE HOODIE
56769 FOG ESSENTIALS Solid Crew Sweat Shirts TAN
62118 STAPLE×Hello Kitty Friends Hoodie BLACK
63294 Anti Social Social Club Playboy x ASSC Bunny Logo Black Hoodie
28139 REBEL8 BOVVER BLACK POLO
54745 Dezzn Oversized Hooded T-Shirt Beige
56892 SALUTE DESERT SHIRT
56894 SALUTE RACING PRINTER SHIRT
11320 BLACK CRAFT Death Card Crewneck Sweater
15558 FAR★STAR BLOOD目苺
15572 FAR★STAR 百目 BIG WHT
15574 FAR★STAR 百目 BIG BLK
15816 BLACK CRAFT Hail Satan And Drink Coffee Crewneck
20290 REBEL8 GR8FUL REVERSIBLE BUCKET HAT
20482 FAR★STAR 練乳 目苺 BIG T オーバーサイズ
20484 FAR★STAR Sperm BIG T
20490 FAR★STAR 目苺トートバック
20504 FAR★STAR Octopus Eddy TAIDAI BIG T ブルーオーシャン
20506 FAR★STAR Octopus Eddy TAIDAI BIG T SANレインボー
20507 FAR★STAR Octopus Eddy TAIDAI BIG T サターン
20509 FAR★STAR Octopus Eddy TAIDAI BIG T ピンクイエロー
20511 FAR★STAR Octopus Eddy TAIDAI BIG T リアクティブレインボー
20512 FAR★STAR Octopus Eddy TAIDAI BIG T Vレインボー
20513 FAR★STAR Octopus Eddy TAIDAI BIG T スパイダー
23293 PARADOX LONG PARKA WHT