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-19 11:07:24')
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
60771 MUSIC SAVED MY LIFE (MSML) OVERSIZED BOA RIDERS JACKET BLACK
56984 VIRGO Special Petaurista cargo pants NAVY
65968 PUNK DRUNKERS (パンクドランカーズ) ヤンキーJKT - BLACK
55401 VIRGO ROCKET LONG SHIRTS - BLACK
57292 SALUTExEVAE bomber jacket
61351 SLEEPING TABLET X [ DOCTOR COAT ] BLACK
60661 MISHKA M61000729 JACKET BLACK
57345 SUPPLIER (サプライヤー) WHITE TYVEK PUFFER
57293 SALUTExEVAE shears jacket
54988 Zephyren(ゼファレン)STUDIUM JACKET - As above,So below - BLACK / WHITE
51869 Zephyren(ゼファレン) SWITCHING PARKA NAVY / RED
59874 PUNK DRUNKERS [PDSxSONIC]ソニックスタジャン - BLACK
59875 PUNK DRUNKERS [PDSxSONIC]ソニックスタジャン - D.PURPLE
66848 RIPNDIP (リップンディップ) Neon Cat Puffer Jacket Black
59876 PUNK DRUNKERS [PDSxGreatMUTA]グレート・ムタ スカジャン / BLUE - BLUE/BLACK
66625 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ビチャビチャスライム JKT BLUE
65957 VIRGO(ヴァルゴ) GLADIATORS [VG-SWT-147]-BLUE
47024 NOVE NV-001N D060 DENIM IND
54983 Zephyren(ゼファレン)FUR JACKET BLACK
59441 Zephyren(ゼファレン) DENIM JKT - Victoria - INDIGO/RED
43410 NOVE NV-001D 048 DENIM INDIGO
65595 GALFY (ガルフィー)×東京リベンジャーズ 東京卍會 構成員 SET UP
59191 VIRGO STRUMMER CHESTER COAT BEIGE
59192 VIRGO STRUMMER CHESTER COAT AQUA
65718 GALFY (ガルフィー) クレイジーわんわん大学 SET UP BLACK×RED
62113 ROLLING CRADLE SKAJAN JERSEY / RED
61414 VIRGO BAGGY-D CARGO 22[CLASSIC LINE] CHARCOAL
56522 SILLENT FROM ME VEIN -Cable Knit Sweater- WHITE
58958 Subciety (サブサエティ) SOUVENIR JKT - BLACK
43409 NOVE NV-001D 045 DENIM INDIGO
58342 SILLENT FROM ME OBSCURE -Mesh Knit Sweater- WHITE
60728 LONELY論理 バキ×LONELY論理 "FIGHTING POSE" PO HOODIE GREEN
60883 PUNK DRUNKERS Mt.FUJIナイロンJKT - BLACK
56767 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts BLACK
56768 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts WHITE
65084 glamb (グラム)GB0422/CS02 : Big Drape Hoodie / ビッグドレープフーディ - Black
61087 VIRGO MIXTURE LONG SHIRTS KHAKI
61125 VIRGO CREST PANTS(CLASSIC LINE) NAVY
54228 Subciety LEOPARD SWING TOP BEIGE
59446 Zephyren(ゼファレン) TRENCH COAT BLACK
63474 glamb (グラム) Snow Mountain JKT - Multi
63475 glamb (グラム) Snow Mountain JKT - Black
63885 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / BLACK
61372 SLEEPING TABLET (スリーピングタブレット) PYLON [ 6 POCKETS CARGO PANTS ] BLACK
50650 CHORD NUMBER EIGHT CH01-01K5-PL07 SIDE LINE CHECK CROPPED PANTS BLACK&RED
58483 SILLENT FROM ME LAWYER -Oversized Tailored Jacket- GRAY CHECK
59445 Zephyren(ゼファレン) MA-1 Type BLOUSON TIEDYE
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
60668 MISHKA M61000730 JACKET BLACK
56204 Anti Social Social Club Headrush All Over White Hoodie
59335 SLEEPING TABLET GENE [ RAW DENIM TRUCKER JACKET ] BLACK
60545 ROLLING CRADLE HOOD CHECK SHIRT / YELLOW
62208 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK / PAISLEY
59839 Evae mob *EVAE+Tyga Collaboration Necklace
51478 KONUS K-400490 Fully Fashioned Oversize Sweater with Pocket GREEN
56286 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT ORANGE
56848 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT BLACK
63529 glamb (グラム) Glen Check Balloon Pants - Gray
66707 ROLLING CRADLE(ローリングクレイドル) 2023 NEW YEAR LOGO HOODIE BLACK
29939 PUNK DRUNKERS ロング丈でかPスタジャン BLUE
47022 NOVE NV-009S110 DENIM IND
57922 Subciety (サブサエティ) HALF ZIP CUBA SHIRT- BLACK
58952 Subciety (サブサエティ) EXTREME JKT - GRAY
61892 glamb (グラム) Old School Pile Jersey - Black
61893 glamb (グラム) Old School Pile Jersey - Green
64102 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] BLACK
64103 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] GRAY
64104 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] GREEN
55379 VIRGO VINTAGE RATS LONG COAT - WHITE
56971 NOT COMMON SENSE CIRCLELOGO C/N RIPSTOP OZONE WASHINGJACKET BLACK
56109 N.B.O. CONTRAST EMBROIDERY T KHAKI
56116 SILLENT FROM ME CULTISM Long Length Shirts WHT
63600 glamb (グラム) 4XL Denim SH - Indigo
64281 RIPNDIP (リップンディップ) Nerm Doodle Work Jacket (Chocolate)
60665 MISHKA M61000712 JACKET BEIGE
61264 MISHKA M61000735 JACKET SAFETY GREEN
44192 NOT COMMON SENSE VELCRO NYLON JKT BLACK / BROWN
58031 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - TAN
63028 GALFY (ガルフィー) 色激渋SETUP WHITE/G.BLUE
63029 GALFY (ガルフィー) 色激渋SETUP WHITE/L.GREEN
63030 GALFY (ガルフィー) 色激渋SETUP GREIGE/GRAY
63033 GALFY (ガルフィー) 炎上大学SETUP 夏 NAVY
41375 Subciety (サブサエティ) CHECK BDU JKT RED
60289 MISHKA M61000518 JACKET
60551 MUSIC SAVED MY LIFE (MSML) NYLON SAROUEL PANTS BLACK
60567 HEDWiNG R.A.M Leopard Fur Jacket
65747 GALFY (ガルフィー) ピカピカ注射器 SET UP EMERALD
62115 ROLLING CRADLE SKAJAN JERSEY / GREEN
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
60295 MISHKA M61000014 L/S T-SHIRT
56203 Anti Social Social Club Birdbath Black Hoodie
56207 Anti Social Social Club Sweeter Then You Think Black Hoodie
64095 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] GRAY
51613 MUSIC SAVED MY LIFE M101-02L1-PL01 2LINE JERSEY PANTS BLACK×GREEN
51712 MUSIC SAVED MY LIFE M101-01K5-FW01 ZIP SNEAKER RED
55403 VIRGO ROCKET LONG SHIRTS - WHITE
55977 MISHKA(ミシカ) MAW200512 JACKET
58949 Subciety (サブサエティ) M-65 FIELD JKT - BLACK
62632 LONELY論理 MEID NAGISA ASSASIN HALF ZIP BLACK
63819 Subciety(サブサエティ) MILITARY OVER SHIRT BLACK
65935 TOY MACHINE (トイマシーン) WINGED SECT ROCKET PADDING JACKET-BLACK
65612 TRAVAS TOKYO【トラバストーキョー】 Myriad of bears zip hoodie Black
56985 VIRGO Special Petaurista cargo pants BLACK
62131 SUPPLIER (サプライヤー) FIRE PATTERN STITCH LOGO DENIM LIGHT BLUE
65532 VIRGO(ヴァルゴ) SPLASH VGW SHIRTS BLUE
65734 GALFY (ガルフィー) 久々賛否両論 SET UP オーロラ BLACK
65735 GALFY (ガルフィー) 久々賛否両論 SET UP SAX
63574 glamb (グラム) Damaged Layered CS - Black
66004 PUNK DRUNKERS (パンクドランカーズ) タイダイきのこトレーナー - BLUE/PURPLE
59458 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK
59461 Zephyren(ゼファレン) WIDE TAILORD JACKET FLOWER
59488 Zephyren(ゼファレン) LONG COAT BLACK
59490 Zephyren(ゼファレン) LONG COAT D.GREEN / CHECK
67516 SLEEPING TABLET(スリーピング・タブレット) FORMULA [ NYLON COACH JACKET ]COYOTE
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
64970 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / COLOR
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
54170 SILLENT FROM ME VICTOR -Slim Slacks- GRAY CHECK
57354 SUPPLIER (サプライヤー) TINPLATE ZIP HOODIE PURPLE