SELECT SQL_CALC_FOUND_ROWS 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-04-26 23:07:02')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 653)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
61648 PSYCHOLOGICAL METAMORPHOSIS PLMP WARM PARKA BLACK
55800 【バンドリ!×ゲキクロ 第2弾復刻】PSYCHOLOGICAL METAMORPHOSIS×戸山香澄コラボ 限定 コーチJKT
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
58414 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA SAX-ORG
41301 PSYCHOLOGICAL METAMORPHOSIS PLMP COACH JKT BLACK
41302 PSYCHOLOGICAL METAMORPHOSIS PLMP COACH JKT BEIGE
52485 【バンドリ!×ゲキクロ 第4弾復刻】PSYCHOLOGICAL METAMORPHOSIS×大和 麻弥 コラボ 限定 パーカー
53914 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA WHITE
53916 PSYCHOLOGICAL METAMORPHOSIS PLMP EXPANSION PARKA BLACK
53917 PSYCHOLOGICAL METAMORPHOSIS PLMP PILE WAPPEN PARKA GREEN
53918 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA RED
53919 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA BLACK
60877 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO PARKA BLACK
60878 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO PARKA BEIGE
54762 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS SAX
54763 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS BLACK
54764 PSYCHOLOGICAL METAMORPHOSIS PMLP STRIPE EAZY PANTS WHITE/NAVY
54765 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS RED
54766 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS SAX
54767 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS BLACK
59863 PSYCHOLOGICAL METAMORPHOSIS CHINO EASY SHORTS 2 OLIVE
59869 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 YELLOW
59870 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 ORIVE
59871 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 GRAY
62903 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. SWAET PARKA - BLACK
62904 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. SWAET PARKA - ORANGE
62908 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - BLACK
62909 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - BLUE
62910 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - GRAY
38727 PSYCHOLOGICAL METAMORPHOSIS PMLP PARKA LOGO / WHITE
38728 PSYCHOLOGICAL METAMORPHOSIS PMLP PARKA LOGO / BLACK
38729 PSYCHOLOGICAL METAMORPHOSIS PMLP PARKA LOGO / BLUE
62933 PSYCHOLOGICAL METAMORPHOSIS PLMP CIRCLE NECKLACE - GOLD
62935 PSYCHOLOGICAL METAMORPHOSIS PLMP CIRCLE NECKLACE - PURPLE
68929 PSYCHOLOGICAL METAMORPHOSIS RIPSTOP LOOSE TEE BLACK
68930 PSYCHOLOGICAL METAMORPHOSIS RIPSTOP LOOSE TEE KHAKI
41304 PSYCHOLOGICAL METAMORPHOSIS PLMP BACK PACK BLACK
41305 PSYCHOLOGICAL METAMORPHOSIS PLMP BACK PACK BROWN
61559 PSYCHOLOGICAL METAMORPHOSIS MOCK NECK HEAVY TEE BLACK
61560 PSYCHOLOGICAL METAMORPHOSIS MOCK NECK HEAVY TEE BEIGE
58634 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 01 BLACK
58635 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 01 WHITE
60054 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE BLU-BLK
60055 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE SS TEE ORG-BLK
55799 【バンドリ!×ゲキクロ 第2弾復刻】PSYCHOLOGICAL METAMORPHOSIS×戸山香澄コラボ 限定 L/S Tシャツ
38721 PSYCHOLOGICAL METAMORPHOSIS PLMP-17-06 PMLP L/S LOGO WHITE
38722 PSYCHOLOGICAL METAMORPHOSIS PLMP-17-06 PMLP L/S LOGO BLACK
38724 PSYCHOLOGICAL METAMORPHOSIS PMLP L/S CIRCLE BLACK
38725 PSYCHOLOGICAL METAMORPHOSIS PMLP L/S CIRCLE WHITE
38726 PSYCHOLOGICAL METAMORPHOSIS PMLP L/S CIRCLE BLUE
41296 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S MARK ORANGE
41297 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S MARK BLACK
41298 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S MARK SAX
41300 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2 BLACK
49876 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2(NEW COLOR) RED
49877 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2(NEW COLOR) YELLOW
49878 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2(NEW COLOR) BLACK
49879 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S BOX WHITE
49880 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S BOX SAX
49881 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S BOX PURPLE
52486 【バンドリ!×ゲキクロ 第4弾復刻】PSYCHOLOGICAL METAMORPHOSIS×大和 麻弥 コラボ 限定 L/S Tシャツ
54097 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE SAX
54098 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE RED
54099 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE WHITE
54100 PSYCHOLOGICAL METAMORPHOSIS EXPANTION L/S TEE BLACK
54101 PSYCHOLOGICAL METAMORPHOSIS EXPANTION L/S TEE WHITE/BLUE
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
62830 PSYCHOLOGICAL METAMORPHOSIS SWITCHING 7 SLEEVE - BLACK / WHITE
62831 PSYCHOLOGICAL METAMORPHOSIS SWITCHING 7 SLEEVE - BLUE / WHITE
62882 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 02 - BLACK
62883 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 02 - ORANGE
62884 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 02 - WHITE
62885 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 03 - BLACK
62886 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 03 - BLUE
52506 【限定コラボ・アイテム】Merm4id × PLMP Collaboration S/S TEE
55798 【バンドリ!×ゲキクロ 第2弾復刻】PSYCHOLOGICAL METAMORPHOSIS×戸山香澄コラボ 限定 キャップ
68969 PSYCHOLOGICAL METAMORPHOSIS PM BB CAP BLACK
69026 Gurin. ×PSYCHOLOGICAL METAMORPHOSIS EYES TEE WHITE
69027 Gurin. ×PSYCHOLOGICAL METAMORPHOSIS EYES TEE BLACK
41278 PSYCHOLOGICAL METAMORPHOSIS PLMP HEAVY CIRCLE BLACK
41279 PSYCHOLOGICAL METAMORPHOSIS PLMP HEAVY CIRCLE CAMEL
41280 PSYCHOLOGICAL METAMORPHOSIS PLMP HEAVY CIRCLE BURGUNDY
41284 PSYCHOLOGICAL METAMORPHOSIS PLMP POCKET WIDE TEE BLACK
41285 PSYCHOLOGICAL METAMORPHOSIS PLMP POCKET WIDE TEE WHITE
41286 PSYCHOLOGICAL METAMORPHOSIS PLMP POCKET WIDE TEE OLIVE
49873 PSYCHOLOGICAL METAMORPHOSIS PLMP FLOWER TEE WHITE
49874 PSYCHOLOGICAL METAMORPHOSIS PLMP FLOWER TEE BURGANDY
49875 PSYCHOLOGICAL METAMORPHOSIS PLMP FLOWER TEE BLACK
52487 【バンドリ!×ゲキクロ 第4弾復刻】PSYCHOLOGICAL METAMORPHOSIS×大和 麻弥 コラボ 限定 キャップ
54761 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS RED
58569 PSYCHOLOGICAL METAMORPHOSIS LOGO KNIT CAP BLACK
58570 PSYCHOLOGICAL METAMORPHOSIS LOGO KNIT CAP NAVY
60180 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin.SS TEE 03 WHITE
60181 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin.SS TEE 03 BLACK
60182 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. SS TEE 02 WHITE
60183 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. SS TEE 02 BLACK
61631 PSYCHOLOGICAL METAMORPHOSIS OLD FUTERE CAP BLACK
61632 PSYCHOLOGICAL METAMORPHOSIS OLD FUTERE CAP GREEN
62839 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 04 - BLACK
62841 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 04 - WHITE
62849 PSYCHOLOGICAL METAMORPHOSIS COLLEGE WIDE TEE - BLACK
62863 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 06 - BLACK
62864 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 06 - E.GREEN
62865 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 06 - WHITE
62930 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO KNIT CAP - BLACK
62931 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO KNIT CAP - BROWN
38730 PSYCHOLOGICAL METAMORPHOSIS PMLP LOGO WHITE
38731 PSYCHOLOGICAL METAMORPHOSIS PMLP LOGO BLACK
38732 PSYCHOLOGICAL METAMORPHOSIS PMLP CIRCLE BLACK
38733 PSYCHOLOGICAL METAMORPHOSIS PMLP CIRCLE WHITE
41281 PSYCHOLOGICAL METAMORPHOSIS PLMP WORD TEE MT GREEN
41282 PSYCHOLOGICAL METAMORPHOSIS PLMP WORD TEE BLACK
41283 PSYCHOLOGICAL METAMORPHOSIS PLMP WORD TEE ORANGE
41287 PSYCHOLOGICAL METAMORPHOSIS PLMP TEE RED
41288 PSYCHOLOGICAL METAMORPHOSIS PLMP TEE BLACK
41289 PSYCHOLOGICAL METAMORPHOSIS PLMP TEE GREEN
41290 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO 2 BURGUNDY
41292 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO 2 BLACK
41293 PSYCHOLOGICAL METAMORPHOSIS PLMP MARK TEE BLACK
41294 PSYCHOLOGICAL METAMORPHOSIS PLMP MARK TEE WHITE