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-28 20:29:25')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
14469 Subciety 2015 福袋 25,000
52538 RIP DESIGN WORXX ripdw HAPPY BAG2020
71563 【数量限定予約商品】ゲキクロX5万フォロワー達成記念HAPPY BAG
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
45546 RIP DESIGN WORXX HAPPY BAG 2019 Bタイプ
45603 RIP DESIGN WORXX HAPPY BAG 2019 Aタイプ
57102 Zephyren 2021 NEW YEAR BAG
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
66301 Subciety 2023 福袋 -NEW YEAR BAG-
38989 ANIMALIA 2018 ANIMALIA LUCKY BAG
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
56066 Subciety 2021 福袋 -NEW YEAR BAG-
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
55801 FOG ESSENTIALS "LA"Limit Tee White
55802 FOG ESSENTIALS "LA"Limit Tee Black
39135 Subciety 2018 福袋 -NEW YEAR BAG-
69179 glamb (グラム) GB0323/CS09 : Flower Combination CS / フラワーコンビネーションカットソー White
65533 VIRGO(ヴァルゴ) SPLASH VGW SHIRTS BLACK
71523 【予約商品】GALFY(ガルフィー) 先輩セットアップ OFF WHITE
71524 【予約商品】GALFY(ガルフィー) 先輩セットアップ BEIGE
71526 【予約商品】GALFY(ガルフィー) パチンコセットアップ WHITE
71527 【予約商品】GALFY(ガルフィー) パチンコセットアップ BLACK
39098 RIPDW 2018 HAPPY BAG with MA-1-BLKxBLK BAG-WHT
39107 RIPDW 2018 HAPPY BAG with MA-1-KHAxBLK BAG-WHT
25389 BLACK SCALE SEVERSON T-SHIRT BLK
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
71528 glamb (グラム) Crossing Heart T-shirts / クロッシングハートTシャツ BLACK
55736 Anti Social Social Club ASHTON WHITE TEE
41252 VIRGO VG-CUT-360 Rover poncho hoodie ポンチョカットソー BLACK
68340 SLEEPING TABLET (スリーピングタブレット) Rx [ ALL OVER PRINTED INNER TEE SET ]
54608 FOG ESSENTIALS Essentials Boxy Photo Series T-Shirt White
54609 FOG ESSENTIALS Essentials Boxy Photo Series T-Shirt Black
63117 HEDWiNG (ヘドウィグ) Half asleeper Hemp Set up Black
42884 NOT COMMON SENSE ReMAKE TEE
42885 NOT COMMON SENSE "NCS"ReMAKE TEE
42886 NOT COMMON SENSE "NCS"ReMAKE TEE 3
47108 NOT COMMON SENSE "NCS"Remake TEE MULTI 1
47109 NOT COMMON SENSE NCS REMAKE SEAM TEE BLACK
47218 NOT COMMON SENSE "NCS"Remake TEE MULTI 2
47219 NOT COMMON SENSE "NCS"Remake TEE MULTI 3
47220 NOT COMMON SENSE "NCS"Remake TEE MULTI 4
47221 NOT COMMON SENSE "NCS"Remake TEE MULTI 5
50151 NOT COMMON SENSE "BREAK OUT" ZIP L/S TEE PURPLE
54744 Dezzn Oversized Hooded T-Shirt Black
61416 VIRGO KITE ZIPPER CUTSHIRTS WHITE
61417 VIRGO KITE ZIPPER CUTSHIRTS KHAKI
61418 VIRGO KITE ZIPPER CUTSHIRTS BLACK
61383 SLEEPING TABLET ASTHENIA [ EXTRA WIDE TEE ] BLACK
61384 SLEEPING TABLET ASTHENIA [ EXTRA WIDE TEE ] WHITE
61867 glamb (グラム) Military Remake CS - White×Khaki
66160 glamb (グラム) GB0123/CS12 : Grunge Stream CS / グランジストリームカットソー - Black
66908 glamb (グラム) GB0123/CS12 : Grunge Stream CS / グランジストリームカットソー - White
67075 glamb (グラム) GB0223/CS09 : Fake Layered Wide CS / フェイクレイヤードワイドカットソー - White
67076 glamb (グラム) GB0223/CS09 : Fake Layered Wide CS / フェイクレイヤードワイドカットソー - Black
70865 glamb (グラム) Needlework Oversize T-shirts/ニードルワークオーバーサイズTシャツ White
70866 glamb (グラム) Needlework Oversize T-shirts/ニードルワークオーバーサイズTシャツ Black
48259 VIRGO VG-CUT-390 HIDDEN VG PONCHO BLACK
48260 VIRGO VG-CUT-390 HIDDEN VG PONCHO CHARCOAL
49284 Dezzn IN91103S-1 Messenger Bag T-Shirt WHT
49285 Dezzn IN91103S-1 Messenger Bag T-Shirt BLK
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
58050 XrossOverBig SilhouetteT (Black)
58051 XrossOverBig SilhouetteT (White)
6521 Subciety EMBROIDERY POLO S/S BLACKII Riot ANGELS
25345 PARADOX SOUVENIR PULLOVER PINK
29983 BLACK SCALE HARA-KIRI TEE BLACK
29984 BLACK SCALE HARA-KIRI TEE WHITE
29985 BLACK SCALE STOMACH PAIN TEE WHITE
29986 BLACK SCALE STOMACH PAIN TEE BLACK
29987 BLACK SCALE TREATED WORLD TOUR TEE BLACK
29988 BLACK SCALE TREATED WORLD TOUR TEE WHITE
29989 BLACK SCALE WING TEE WHITE
29990 BLACK SCALE WING TEE BLACK
29991 BLACK SCALE ENDOPLASMATIC TEE WHITE
29992 BLACK SCALE ENDOPLASMATIC TEE BLACK
40500 PARADOX ALL GRAPHIC TEE HOLY GROUND
47380 PARADOX PX15-CS04 LONG T-SHIRTS(ORANGE)
47381 PARADOX PX15-CS04 LONG T-SHIRTS(GRAY)
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
33428 VIRGO Airship dolmania BURGANDY
47524 VIRGO VG-CUT-381 VINTAGE RAGLAN CUTSEW 染めカットソー BLACK
47765 VIRGO VG-CUT-385 MECHANICAL ARMOR TEE BLACK
47766 VIRGO VG-CUT-385 MECHANICAL ARMOR TEE CHARCOAL
54074 VIRGO VG-CUT-405 CLOWN NOMAD BLACK
54075 VIRGO VG-CUT-405 CLOWN NOMAD WHITE
63262 GALFY (ガルフィー) わんわん大学 SETUP あの夏 WHITE
63263 GALFY (ガルフィー) わんわん大学 SETUP あの夏 BLACK
63264 GALFY (ガルフィー) わんわん大学 SETUP あの夏 GREEN
63265 GALFY (ガルフィー) わんわん大学 SETUP あの夏 杢 GRAY
55636 Anti Social Social Club Kkoch Black Tee
63377 Anti Social Social Club Passing Fad Mint Tee
63379 Anti Social Social Club Self Conclusion Sand Tee
63380 Anti Social Social Club Self Conclusion Black Tee
63381 Anti Social Social Club The Notebook Orange Tee
63383 Anti Social Social Club Out Of Time Blue Tee
56213 Anti Social Social Club Headrush All Over White Tee
29197 Subciety (サブサエティ) PAISLEY JACQUARD P/O S/S OFF_WHITE
29198 Subciety (サブサエティ) PAISLEY JACQUARD P/O S/S BLACK
39725 NineMicrophones FAINT WHITE
39726 NineMicrophones FAINT BLACK
45068 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW BLACK
45069 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW KHAKI
45070 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW RED
45071 MUSIC SAVED MY LIFE (MSML) M1H5T-CS01 SMOOTH FOOTBALL CUTSEW WHITE
49896 FOG ESSENTIALS Boxy T-Shirt LIGHT HEATHER
49910 UNUSUAL REMAKE BAND T-SHIRTS (BRING ME THE HORIZON)
49911 UNUSUAL REMAKE BAND T-SHIRTS (SLIPKNOT)1
52417 Zephyren 2020 NEW YEAR BAG
61476 glamb (グラム) Fake Layered Wide CS BLACK
61477 glamb (グラム) Fake Layered Wide CS BROWN
66159 glamb (グラム) GB0123/CS11 : Lips and Candy CS / リップスアンドキャンディカットソー - White
67529 glamb (グラム) GB0123/CS11 : Lips and Candy CS / リップスアンドキャンディカットソー - Black
68410 LOVE KILLER(ラブキラー) Killer cat Graffiti Logo T-shit BLACK