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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =97
)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-23 23:34:23')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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
14469 Subciety 2015 福袋 25,000
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
45546 RIP DESIGN WORXX HAPPY BAG 2019 Bタイプ
66149 glamb (グラム) GB0123/CS05 : Crazy Pullover Jersey / クレイジープルオーバージャージ - Red
66150 glamb (グラム) GB0123/CS05 : Crazy Pullover Jersey / クレイジープルオーバージャージ - Black
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
38989 ANIMALIA 2018 ANIMALIA LUCKY BAG
45379 Subciety 2019 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
66247 RUDIE'S (ルーディーズ) 2023 福袋 NEWYEAR PACK
63575 glamb (グラム) Damaged Layered CS - White
63585 glamb (グラム) Crazy Textiles CS - Black
43267 SILLENT FROM ME VEXED -Nylon Pullover- BLACK
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
54137 SILLENT FROM ME R.I.P -Long Length Cutsew- BLACK
54138 SILLENT FROM ME R.I.P -Long Length Cutsew- WHITE
23646 DROP DEAD CLOTHING (ドロップデッド・クロージング) Sastrugi Longsleeve
29023 BLACK SCALE WI16LK089 BLACK
30090 MUSIC SAVED MY LIFE (MSML) L/S LONG CUTSEW BLACK
30091 MUSIC SAVED MY LIFE (MSML) L/S LONG CUTSEW WHITE
52417 Zephyren 2020 NEW YEAR BAG
66236 glamb(グラム) Izuku Midoriya Long Sleeves T Black
66243 glamb(グラム) Endeavor Long Sleeves T Black
66245 glamb(グラム) Tomura Shigaraki Long Sleeves T Black
25378 BLACK SCALE ALL CITY LONGSLEEVE T-SHIRT BLK
51501 MISHKA MSS200057F99 L/S TEE BLACK
39099 RIPDW 2018 HAPPY BAG WHT
39100 RIPDW 2018 HAPPY BAG PUR
37642 MUSIC SAVED MY LIFE (MSML) CUT OFF LONG THERMAL BLACK
50647 CHORD NUMBER EIGHT CH01-01K5-CL03 LONG CUTSEW WHITE
61482 glamb (グラム) Cactus Print Raglan CS BLACK
61483 glamb (グラム) Cactus Print Raglan CS GREEN
5070 Subciety PRAYING HANDS R-L/S BK/WH
34534 MUSIC SAVED MY LIFE (MSML) LONG SLEEVE BORDER CUTSEW KHAKI
34535 MUSIC SAVED MY LIFE (MSML) LONG SLEEVE BORDER CUTSEW BLACK&WHITE
37645 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE PINK
37646 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE MINT BLUE
37647 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE LEAF GREEN
37648 MUSIC SAVED MY LIFE (MSML) FLAMINGO EMBROIDERY LONG SLEEVE TEE BLACK
42798 SLEEPING TABLET SORBET MOCK NECK CUTSEW BLACK
42799 SLEEPING TABLET SORBET MOCK NECK CUTSEW PINK
51988 Zephyren(ゼファレン) L/S TEE -Gott lst Todi- WHITE
51989 Zephyren(ゼファレン) L/S TEE -Gott lst Todi- BLACK
55023 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - BLACK
34956 SABBAT13 GLORY BORDER L/S T (ブラック) BLACK
34957 SABBAT13 GLORY BORDER L/S T (ホワイト) WHITE
63574 glamb (グラム) Damaged Layered CS - Black
63667 【ゲキクロ限定カラー】NOTBADCAT (ノットバッドキャット) Lift cat LS Tee BLACK
63669 【ゲキクロ限定カラー】NOTBADCAT (ノットバッドキャット) Glasses cat LS Tee WHITE
63671 【予約商品】ゲキクロ限定カラー NOTBADCAT (ノットバッドキャット) Glasses cat LS Tee BLACK
63705 【予約商品】ゲキクロ限定カラー NOTBADCAT (ノットバッドキャット) Lift cat LS Tee WHITE
61242 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション EUREKA L/S WHITE
63606 glamb (グラム) Belivers Long Sleeve T - White
9353 LUCKY13 MOTOR SKULL MENS LONG SLEEVE TEE
58317 SLEEPING TABLET GRRL [ MULTI BORDER LONG SLEEVE ] BLACK
37052 MARILYN MANSON×KILL STAR CLOTHING When I'm God Sweatshirt
20596 FAMOUS STARS AND STRAPS WHIP LS RAGLAN TOP
22465 DROP DEAD CLOTHING (ドロップデッド・クロージング) Offroad Longsleeve
42787 SLEEPING TABLET NOTICE LOOSE BORDER CUTSEW BLACK
42788 SLEEPING TABLET NOTICE LOOSE BORDER CUTSEW GREEN
42789 SLEEPING TABLET NOTICE LOOSE BORDER CUTSEW YELLOW
42790 SLEEPING TABLET NOTICE LOOSE BORDER CUTSEW PINK
63672 【ゲキクロ限定カラー】NOTBADCAT (ノットバッドキャット) Girl LS Tee WHITE
63673 【ゲキクロ限定カラー】NOTBADCAT (ノットバッドキャット) Girl LS Tee BLACK
65932 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -100g- BLACK
65933 神尾晋一郎×acOlaSia×GEKIROCK CLOTHINGコラボ・ロンT KAMMY BEAR -12g- BLACK
69373 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・ロンT BLUE
69374 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・ロンT RED
68125 SLEEPING TABLET(スリーピング・タブレット) MADOROMI [ HEAVY WAIGHT LONG SLEEVE ] BLACK
68126 SLEEPING TABLET(スリーピング・タブレット) MADOROMI [ HEAVY WAIGHT LONG SLEEVE ] FROST GRAY
68127 SLEEPING TABLET(スリーピング・タブレット) MADOROMI [ HEAVY WAIGHT LONG SLEEVE ] ACID BLUE
29240 Subciety (サブサエティ) GLORIOUS L/S WHITE
29241 Subciety (サブサエティ) GLORIOUS L/S BLACK
29242 Subciety (サブサエティ) GLORIOUS L/S NAVY-RED
34958 SABBAT13 CAMO POCKET L/S T (ブラック) BLACK
34959 SABBAT13 CAMO POCKET L/S T WHITE
39702 ROLLING CRADLE RCxEVANGELION LONG T-SHIRT "Shikinami Asuka Langley" / White
39705 ROLLING CRADLE RCxEVANGELION LONG T-SHIRT "Shikinami Asuka Langley" / Black
18492 Subciety LARGE GLORIOUS L/S - BLACK
18493 Subciety LARGE GLORIOUS L/S - RED
22198 SABBAT13 IGOR BICOLOR L/S T WHT
22199 SABBAT13 IGOR BICOLOR L/S T GRY
41513 NineMicrophones Sing L/S WHITE
41514 NineMicrophones Sing L/S BLACK
45498 RIP DESIGN WORXX HAPPY BAG 2019 プチ袋
56556 Nine Microphones BORDER TEE L/S -9MC Vrew- WHITE
20389 DROP DEAD CLOTHING Outer Circle Longsleeve
21841 FAMOUS STARS AND STRAPS Goon LS Knit Graphic Shirt
43220 RIPNDIP Hell Pit L/S (Black)
43221 RIPNDIP Ross L/S (Black)
43222 RIPNDIP Nerm Gearhead L/S (Black)
43225 RIPNDIP Hang In There L/S (Black)
43226 RIPNDIP Lord Nermal Pocket L/S (Black)
47332 RIPNDIP Nermamaniac L/S (Black)
47333 RIPNDIP Lord Nermal Pocket L/S (Hunter Mineral Wash)
47334 RIPNDIP Lord Nermal Pocket L/S (Light Pink Mineral Wash)
66730 NOTBADCAT (ノットバッドキャット) ラッキーストニャイク LS Tee WHITE
66732 NOTBADCAT (ノットバッドキャット) ラッキーストニャイク LS Tee BLACK
66734 NOTBADCAT (ノットバッドキャット)ハイニャイトメンソール LS Tee WHITE
66735 NOTBADCAT (ノットバッドキャット)ハイニャイトメンソール LS Tee BLACK
10098 Subciety TRIBE CROSS L/S BLACK/WHITE
10099 Subciety Guadalupe L/S 2014 SP BLACK/WHITE
10100 Subciety Guadalupe L/S 2014 SP NAVY
10627 Nine Microphones The angel soare L/S WHT/COLOR
13708 NineMicrophones Power of will R-L/S GRAY/NAVY
15794 NineMicrophones King Of The Road L/S BLK/RED
15795 NineMicrophones King Of The Road L/S BLK/WHI
15907 NineMicrophones King Of The Road R-7/S WHI/BLK
18495 Subciety SALOON L/S-CAMOUFLAGE- - BLACK
18498 Subciety New Jack L/S - WHITE/BLACK
18499 Subciety New Jack L/S - BLACK/WHITE
18501 Subciety New Jack L/S - NAVY/RED
20732 Subciety SALOON L/S-CAMOUFLAGE- WHITE
20734 Subciety GLORIOUS L/S-PAISLEY- WHITE
22156 FAMOUS STARS AND STRAPS RAISED ON RAP LS MESH JERS
22457 DROP DEAD CLOTHING (ドロップデッド・クロージング) Peaks 3/4 Sleeve
26057 NineMicrophones 9MICS Crew L/S BLK-BGN
30031 Subciety GLORIOUS L/S-PAISLEY- BLACK
34871 NineMicrophones howhigh L/S BLACK
37057 MARILYN MANSON×KILL STAR CLOTHING This Is Your World Long Sleeve