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-23 17:50:40')
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
71563 【数量限定予約商品】ゲキクロX5万フォロワー達成記念HAPPY BAG 50000
71633 【数量限定予約商品】ゲキクロX5万フォロワー達成記念HAPPY BAG 25000
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
55736 Anti Social Social Club ASHTON WHITE TEE
55636 Anti Social Social Club Kkoch Black Tee
63379 Anti Social Social Club Self Conclusion Sand Tee
63380 Anti Social Social Club Self Conclusion Black Tee
63383 Anti Social Social Club Out Of Time Blue Tee
56213 Anti Social Social Club Headrush All Over White Tee
55631 Anti Social Social Club BAT EMOJI WHITE TEE
55634 Anti Social Social Club MIND GAMES BLACK TEE
60165 Anti Social Social Club THE REAL ME WHITE TEE
52520 RUDIE’S 2020 NEWYEAR PACK
56210 Anti Social Social Club Enrique White Vneck Tee
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
71356 over print (オーバープリント) CHUCKY Tee 1
71357 over print (オーバープリント) CHUCKY Tee 2
64863 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE WHITE
64864 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE LIGHT BLUE
64865 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE GRAY
65008 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/BLACK
65009 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/GREEN
65349 SUPPLIER (サプライヤー) VENOM REFLECTOR TEE
66900 PLEASURES(プレジャーズ)REALITY T-SHIRTWHITE
66964 PLEASURES(プレジャーズ) NO SMOKING T-SHIRT BROWN
53186 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SMILEY
71758 VIRGOwearworks (ヴァルゴウェアワークス)Ultimate [C] BLACK
71759 VIRGOwearworks (ヴァルゴウェアワークス)Ultimate [C] RED
60103 LONELY論理 ASKA FUTATABI T-SHIRTS BLACK
60722 LONELY論理 バキ×LONELY論理 "OYAKO KENKA" T-SHIRTS
68168 Subciety (サブサエティ) Cereal TEE BLACK
68169 Subciety (サブサエティ) Cereal TEE WHITE
68170 Subciety (サブサエティ) Cereal TEE GREEN
68915 EMPATHY×over print Tシャツ YELLOW
68916 EMPATHY×over print Tシャツ WHITE
68917 EMPATHY×over print Tシャツ PURPLE
68918 EMPATHY×over print Tシャツ ORANGE
68919 【通販限定】EMPATHY×over print Tシャツ VIOLET PINK
68920 EMPATHY×over print Tシャツ MINT
68921 EMPATHY×over printコラボ・Tシャツ BLUE
68970 EMPATHY×over print Tシャツ L.BLUE
70749 攻殻機動隊 STAND ALONE COMPLEX x Subciety episodes TEE BLACK
70750 攻殻機動隊 STAND ALONE COMPLEX x Subciety episodes TEE WHITE/PURPLE
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
56039 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE BLACK
56040 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE YELLOW
69508 AILE VIVANTES(エイルヴィヴァンテス) Masonry t-shirt Tie Dye
69509 AILE VIVANTES(エイルヴィヴァンテス) 4th dimension tie dye t-shirt
56653 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズTEE - BLACK
56654 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズTEE - ASH
56655 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズTEE - LT.GREEN
70741 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY TEE BLACK
70742 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE BLACK
70743 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY TEE WHITE
70745 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE WHITE
70751 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident TEE WHITE