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 =593
)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-19 07:48:46')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
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-
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
38989 ANIMALIA 2018 ANIMALIA LUCKY BAG
51694 ANIMALIA 2020 ANIMALIA LUCKY BAG
60561 Subciety 2022 福袋 -NEW YEAR BAG-
70864 glamb (グラム) Snap Lock Sacoche Bag/スナップロックサコッシュバッグ
70914 【予約商品】glamb (グラム) Synth Leather Sacoche Bag Black
33616 RUDIE'S SPARK SKATE BACKPACK BLACK/BLACK
33617 RUDIE'S SPARK SKATE BACKPACK BLACK/CAMO
33622 RUDIE'S SPARK SKATE BACKPACK BLACK/KHAOS
57232 ANIMALIA 2021 LUCKY BAG
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
40567 VIRGO VGW MILLSPEC TOTEBAG トートバッグ BLACK
40572 VIRGO VGW MILLSPEC TOTEBAG トートバッグ OLIVE
43953 VIRGO VG-GD-566 NEW MOON SHOULDER BAG BLACK
56912 RUDIE'S 2021 NEW YEAR PACK
69173 glamb (グラム) GB0323/AC03 : Leather Drawstring Bag / レザードローストリングバッグ Black
21223 RUDIE'S WLDFMS BOSTON BAG NAVY
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
48285 BLACK CRAFT Serpent Collection - Mini Backpack
70075 glamb (グラム) Synth Leather Sacoche / シンセレザーサコッシュ BLACK
64042 VIRGO(ヴァルゴ)PUFF DOWN SHOULDER BAG BLACK
64044 VIRGO(ヴァルゴ)PUFF DOWN SHOULDER BAG KHAKI
69655 VIRGOwearworks (ヴァルゴウェアワークス) TECHNICAL MINI SHOULDER BAG BLACK
56216 Anti Social Social Club Belong 2 You Black Sidebag
64923 ANIMALIA (アニマリア) TOTE BAG -goat skin-
7123 IRON FIST CLOTHING Sweets For My Sweets Purse
25027 REBEL8 GIANT FLASH DUFFLE BAG
38906 LILWHITE(dot) (リルホワイトドット) -BRAIN- WAIST BAG
38907 LILWHITE(dot) (リルホワイトドット) -PSYCHO- WAIST BAG
48538 Subciety (サブサエティ) LP BAG BLACK
52417 Zephyren 2020 NEW YEAR BAG
54692 MAGICAL MOSH MISFITS MAGICAL MOSH MESSENGER BAG BLACK
54693 MAGICAL MOSH MISFITS MAGICAL MOSH MESSENGER BAG DOKU
60135 SPRAY GROUND THE GODFATHER BACKPACK (DLXV)
60639 RIPNDIP Marker Backpack (Multi)
64979 over print(オーバープリント) Aurora BODY BAG (black)
59286 RIP DESIGN WORXX トライバルカモボディバッグ
52553 DISTURBIA CLOTHING Vandal Bag
56898 Anti Social Social Club ICRIGHTHRUYOU
41605 RIPNDIP Nermal 3M Shoulder Bag (Line Camo)
52520 RUDIE’S 2020 NEWYEAR PACK
52554 DISTURBIA CLOTHING Baal Bag
60638 RIPNDIP Marker Shoulder Bag (Multi)
68278 Subciety (サブサエティ) SLING BAG BLACK
68279 Subciety (サブサエティ) SLING BAG BROWN
34992 SABBAT13 DISPORT WAIST BAG (ブラック) BLACK
34993 SABBAT13 DISPORT WAIST BAG (カモ) CAMO
39419 ROLLING CRADLE RC CHECKER BANANA BAG RED
39420 ROLLING CRADLE RC CHECKER BANANA BAG BLACK
39421 ROLLING CRADLE RC CHECKER BANANA BAG NAVY
10049 RUDIE'S SPARK LIGHTLY BANANA BAG BLACK
70540 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) GOOD SIZE ショルダーBAG (A4すっぽり) DOKU
70541 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) GOOD SIZE ショルダーBAG (A4すっぽり) BLUE
64299 RIPNDIP (リップンディップ) Nikola Beach Bag (Blue)
71142 吉業重工 (ヨシワザジュウコウ) 【CYBORG】ワークウェアショルダーバック
31828 MISHKA (ミシカ) MSP15310499 BAG
36512 THE TEST×beruf baggage - SACOCHE (BLACK)
36513 THE TEST×beruf baggage - SACOCHE (WHITE)
36800 DISTURBIA CLOTHING VOID BAG
41923 MISHKA (ミシカ) MAW183109 BAG Black
62057 glamb (グラム) Riders Sacoche Bag - Black
71048 over print (オーバープリント) rock, paper, scissors Paperboy Bag white
71049 over print (オーバープリント) rock, paper, scissors Paperboy Bag black
62135 ROLLING CRADLE CIRCLE LOGO BAG BLACK
24207 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Orange
24209 ROLLING CRADLE SHOUT & SHOCKING SMILE LARGE BUCKET BAG / Blue
35213 VIRGO LANTANA ALOHA BAG WHITE
35214 VIRGO LANTANA ALOHA BAG RED
35215 VIRGO LANTANA ALOHA BAG BLACK
43092 NOT COMMON SENSE "NCS 2" SACOCHE BLACK
43093 NOT COMMON SENSE "NCS 2" SACOCHE PURPLE
53977 VIRGO VG-GD-619 VIRTALY MINI BAG BLACK
53978 VIRGO VG-GD-619 VIRTALY MINI BAG KHAKI
65695 glamb (グラム) GB0422/AC03 : Denim Sacoche Bag / デニムサコッシュバッグ - Light indigo
71026 【予約商品】PUNK DRUNKERS でっけぇウエストBAG - BLACK
31752 KILL STAR CLOTHING (キルスター・クロージング) Kimmi Kurses Coffin Handbag [B]
38908 LILWHITE(dot) (リルホワイトドット) -CHAOS- SHOULDER BAG
38909 LILWHITE(dot) (リルホワイトドット) -MIND- SHOULDER BAG
39022 DISTURBIA CLOTHING Pentagram Harness Bag
44867 ROB ZOMBIE×KILL STAR CLOTHING Monster Deluxe Messenger Bag
48383 LILWHITE(dot) LW-19SU-A01 “CLARITY” CLEAR BAG CLEAR
52736 MISHKA MSS203104F99 BAG BLACK
57374 MISHKA M21003104 BAG
57375 MISHKA M21003106 BAG
63879 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ドットショルダーBAG (便利サイズ) BLUE
63880 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ドットショルダーBAG (便利サイズ) DOKU
64460 PUNK DRUNKERS [ボンバーマンxPDS]ミニショルダーBAG - WHITE
37060 MARILYN MANSON×KILL STAR CLOTHING Anthem Messenger Bag
56962 MAGICAL MOSH MISFITS MAGICAL ANIMAL MISFITS 黄金比ショルダーBAG (A4すっぽり) HYOH
56963 MAGICAL MOSH MISFITS MAGICAL ANIMAL MISFITS 黄金比ショルダーBAG (A4すっぽり) DOKU
29543 Artemis Classic スタッズボディバッグ[ACBG0021]
37250 KILL STAR CLOTHING(キルスター・クロージング) BLITZ Backpack [B]
44864 ROB ZOMBIE×KILL STAR CLOTHING Mrs Zombie Tote Bag
45704 RUDIE'S PHAT WAISTBAG BLACK
45706 RUDIE'S PHAT WAISTBAG RED
58346 SILLENT FROM ME DRESS -Minimal Bag- WHITE
58347 SILLENT FROM ME DRESS -Minimal Bag- BLACK
65790 Subciety (サブサエティ) UTILITY SHOULDER BAG BLACK/GRAY
65791 Subciety (サブサエティ) UTILITY SHOULDER BAG BLACK/PAISLEY
66883 RIPNDIP (リップンディップ) Fuckin Fuck Crossbody Bag Black
40566 VIRGO VGW MILLSPEC TOTEBAG トートバッグ BEIGE
28157 KILL STAR CLOTHING (キルスター・クロージング) Ritual Ring Messenger Bag [C]
29942 VIRGO PROTECT CLUTCHBAG
30037 KILL STAR CLOTHING Allegra Handbag [B]
34439 VIRGO APRONBAG MINI BLACK
34440 VIRGO APRONBAG MIN KHAKI
41357 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Orange
41363 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Camo
41364 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Black
43485 KILL STAR CLOTHING Rana Handbag [B]
70247 PUNK DRUNKERS(パンクドランカーズ) PDSメッセンジャーBAG BLACK
21880 DROP DEAD CLOTHING Imagination Clutch Bag
36797 DISTURBIA CLOTHING HARNESS TOTE