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 =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-05-24 08:12:20')
AND pc.price02 > 4545
AND price02 <= 9090
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
71142 吉業重工 (ヨシワザジュウコウ) 【CYBORG】ワークウェアショルダーバック
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
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
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
56962 MAGICAL MOSH MISFITS MAGICAL ANIMAL MISFITS 黄金比ショルダーBAG (A4すっぽり) HYOH
56963 MAGICAL MOSH MISFITS MAGICAL ANIMAL MISFITS 黄金比ショルダーBAG (A4すっぽり) DOKU
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
70247 PUNK DRUNKERS(パンクドランカーズ) PDSメッセンジャーBAG BLACK
50242 MISHKA MAW193106 BAG BLACK
52976 acOlaSia ボディバッグ
52994 Subciety PAISLEY WAIST BAG
53132 RUDIE'S TUSK WAISTBAG BLACK
55838 RUDIE'S BANDANA WAISTBAG
61638 STAPLE×Sesame Street Tote Bag
62638 LONELY論理 NEW LOGO TOTE BAG BLACK
62639 LONELY論理 NEW LOGO TOTE BAG GRAY
62642 LONELY論理 NEW LOGO TOTE BAG WOODLAND
70442 明石真秀×RUDIE'S コラボ限定ウエストバッグ
70774 Subciety (サブサエティ) FLOWER PAISLEY BODY BAG BLACK
70775 Subciety (サブサエティ) FLOWER PAISLEY BODY BAG ORANGE
70776 Subciety (サブサエティ) FLOWER PAISLEY BODY BAG YELLOW
70777 Subciety (サブサエティ) FLOWER PAISLEY BODY BAG GREEN
61268 TRAVAS TOKYO【トラヴァストーキョー】くま総柄のミニショルダーバッグ BLACK/BLUE
58055 XrossOver XOver logoBug
52874 【バンドリ!×ゲキクロ 第5弾復刻】RUDIE’S×弦巻 こころコラボ 限定 ポーチ
56107 SABBAT13 SCARER BODY BAG
58797 HYPER CORE THE BLACK HISTORY ボディバッグ
50243 MISHKA MAW193108 BAG BLACK
55927 MISHKA MAW203112 BAG
55928 MISHKA MAW203111 BAG
56883 MISHKA(ミシカ) MAW203117 WHITE
56884 MISHKA(ミシカ) MAW203118 WHITE
58142 MISHKA M21003101 Bag
65308 白鳥 胡桃×HEDWiNG コラボ 限定 ウエストバッグ
69959 gibous(ギボス) fake leather square bag
56746 TOY MACHINE BOA FLEECE TOTE BAG - WHITE
57855 Subciety SHOULDER BAG - BLACK
63373 Subciety (サブサエティ) MULTI STORAGE BELT BAG BLACK
63374 Subciety (サブサエティ) MULTI STORAGE BELT BAG KHAKI
61033 FILA MINI SHOULDER BAG EVANGELION LIMITED RED
53921 KILL STAR CLOTHING Pentagram Handbag
58379 WASTED PARIS Sport Belt Bag Black
60136 SPRAY GROUND THE GODFATHER SAVVY CROSSBODY
60144 Anti Social Social Club FRACTURE BLACK
60145 Anti Social Social Club FRACTURE PINK
67410 清水絵空 × RIPDW コラボ限定トートバッグ