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 =392
)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-22 22:52:31')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
47829 Survive Said The Prophet SSTP MODS COAT
55977 MISHKA(ミシカ) MAW200512 JACKET
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
58749 東京初期衝動×GEKIROCK CLOTHING コラボ・ジャージ・ジャケット NAVY
58750 東京初期衝動×GEKIROCK CLOTHING コラボ・ジャージ・ジャケット BLACK
58949 Subciety (サブサエティ) M-65 FIELD JKT - BLACK
65935 TOY MACHINE (トイマシーン) WINGED SECT ROCKET PADDING JACKET-BLACK
69436 SCENE TOKYO (シーントウキョウ) truck jacket NAVY
59458 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK
59461 Zephyren(ゼファレン) WIDE TAILORD JACKET FLOWER
59488 Zephyren(ゼファレン) LONG COAT BLACK
59490 Zephyren(ゼファレン) LONG COAT D.GREEN / CHECK
54982 Zephyren(ゼファレン)FUR JACKET WHITE
59439 Zephyren(ゼファレン) DENIM JKT - Victoria - BLACK / RED
61171 GALFY (ガルフィー) チャラ男 JKT GREEN/PINK
65742 GALFY (ガルフィー) ヘビ JKT BLACK
61300 MAGICAL MOSH MISFITS Mポケ モコモコ ボア JKT (裏地フリース) BEIGE
61480 glamb (グラム) Old School Jersey BLUE
61695 TOY MACHINE (トイマシーン) TM & EYE STADIUM JACKET NAVY
62966 NieR (ニーア) ブラックデニムジャケット
59179 VIRGO MIDDLE TAILORED JKT KHAKI
59431 Zephyren(ゼファレン) REVERSIBLE SKA JUMPER - MY FIRST STORY - KHAKI
60718 VIRGO NYLON RACER MOD HOODIE
66743 NieR (ニーア) フードレスBACK LOGO DOUBLE ZIP JACKET
61070 VIRGO VGW SWEAT RIDERS BLACK
62964 NieR (ニーア) HIGH-NECK ZIP OUTER【WING】
61167 GALFY (ガルフィー) 新 走り屋 JKT BLACK/RED
61169 GALFY 新 走り屋 JKT BLACK/SAX
65233 GALFY (ガルフィー) 犬暖嘘革 JKT-RED
65728 GALFY (ガルフィー) チェックのわんわん大学 JKT GREEN チェック
69962 gibous(ギボス) logo jersey scorpion black purple tops
70499 gibous(ギボス)×lhp logo track jersey white tops
54970 Zephyren(ゼファレン)SKA JUMPER - Kaleidoscope - BLACK
55979 MISHKA(ミシカ) MAW200507 JACKET SAFTY GREEN
58061 ANIMALIA AN21S-JK01 Canyoning Parka KHAKI
58062 ANIMALIA AN21S-JK01 Canyoning Parka BLACK
59456 Zephyren(ゼファレン) MA-1 BLACK
22240 Xmas Eileen コーチジャケット
70498 gibous(ギボス) lhp tie-dye cross half zip light
71427 gibous(ギボス) Wind hoodie black
54354 Nine Microphones SWING TOP-The bonds with family- KHAKI
57082 NieR (ニーア) SHINY NieR HIP ZIP OUTER
65818 NieR (ニーア) BLOUSON JACKET【BONDAGE】
66764 NieR (ニーア) BLOUSON JACKET 【28GRAY】
57796 METALLICA Met Glitch Duck Jacket Jacket
15524 WE CAME AS ROMANS Present, Future, And Past Black
61509 ANIMALIA AN22SP-JK01 ECWCS LEVEL-4 JACKET BLACK
57209 NieR (ニーア) DRAGON ZIP OUTER
58338 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- BLACK CHECK
59442 Zephyren(ゼファレン) MA-1 Type BLOUSON BROWN / PAISLEY
61467 Subciety (サブサエティ) SWING TOP KHAKI
65544 NieR (ニーア) LIGHTWEIGHT BLACK JUMPER6818
57017 VIRGO Big neck sell hoodie BLACK
62962 NieR (ニーア) 高品質DARK GRAY BLOUSON JACKET
65815 NieR (ニーア) BLOUSON JACKET【BLACK】
56542 NieR (ニーア) LIGHT BLACK BLOUSON JACKET【Skeleton NieR】
60782 RUDIE'S (ルーディーズ) PHAT MA-1 BLACK
61551 NieR (ニーア) LOGO WIND BREAKER
60506 Subciety (サブサエティ) NYLON JKT BLACK / WHITE