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 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-05-01 17:46:16')
AND pc.stock > 0
AND pc.point_rate >1
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
61832 A FEW GOOD KIDS AFGK BOWLING STADIUM JACKET PINK
64129 SLEEPING TABLET(スリーピング・タブレット) METEOR [ PUFF JACKET ] BLACK
63903 VIRGO(ヴァルゴ)LAYERED MID VA-1 BLACK
61567 SUPPLIER (サプライヤー) 1st ANV. LEATHER VARSITY JACKET
61856 A FEW GOOD KIDS BADGE PUFFER JACKET BLACK
65078 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Black×Navy
65079 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Khaki×White
63384 Anti Social Social Club Dialtone Olive Tie Dye Flannel
63926 VIRGO(ヴァルゴ)NATIVE KNIT SNAP SWT BLACK
55628 Anti Social Social Club SAMSIES BLUE HOODIE
55629 Anti Social Social Club SAMSIES PINK HOODIE
56202 Anti Social Social Club True Colors Purple Camo
50817 CHORD NUMBER EIGHT CH01-01K5-CL52 SIDE LACE UP SWEAT BLACK
56468 Subciety (サブサエティ) CPO COACH JKT- YELLOW
56849 MUSIC SAVED MY LIFE (MSML) MOHAIR BORDER KNIT PINK
60736 ANIMALIA AN21A-PT03 APACHE-Stretch Cotton Sarrouel Pants BLACK
63378 Anti Social Social Club Self Conclusion Black Hoodie
63593 glamb (グラム) Heavy Damaged SH - Black
61441 glamb (グラム)×攻殻機動隊 SAC_2045 SAC_2045 hoodie Black
61777 MISHKA (ミシカ) M21100512 JACKET
61988 glamb (グラム) Classic Jersey Pants - Black
61989 glamb (グラム) Classic Jersey Pants - Wine
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
63000 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BLACK
63001 SUPPLIER (サプライヤー) PLAYBOY ALL OVER EMBROIDERY PULLOVER BROWN
63504 glamb (グラム) Fuzzy Leopard Cardigan - Wine
63517 glamb (グラム) Lips and Song Turtle Knit - Black
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
64096 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] WHITE
58343 SILLENT FROM ME OBSCURE -Mesh Knit Sweater- MIXED
61277 LONELY論理 CHRYSANTHEMUM HOODIE BLACK
61278 LONELY論理 CHRYSANTHEMUM HOODIE WHITE
61285 LONELY論理 KAMIKAZE HOODIE WHITE
56977 VIRGO CREST PANTS 21 BEIGE
58044 ROLLING CRADLE RIP-STOP JACKET BLUE
50447 mnml HOODED DENIM JACKET BLACK
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58510 ANIMALIA AN21S-KN01 TEANA KNIT OLIVE
61287 LONELY論理 KAMIKAZE CREWNECK BURGUNDY
61442 glamb (グラム)×攻殻機動隊 SAC_2045 sweat Blue
61443 glamb (グラム)×攻殻機動隊 SAC_2045 sweat Black
63812 Subciety(サブサエティ) PAISLEY COACH SHIRT BLACK
63813 Subciety(サブサエティ) PAISLEY COACH SHIRT BLUE
54610 ANIMALIA AN20U-JK01 HUNTING VEST
54611 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG BLACK
61092 VIRGO CLOTH CARRYING SHIRTS WHITE
61568 SUPPLIER (サプライヤー) COLLEGE LOGO KNIT HOODIE CREAM
63003 SUPPLIER (サプライヤー) PLAYBOY COLLEGE LOGO KNIT
64002 VIRGOwearworks (ヴァルゴウェアワークス)BAMBI CHECK PANTS BLACK-BLACK
64003 VIRGOwearworks (ヴァルゴウェアワークス)BAMBI CHECK PANTS BLACK-BROWN
64004 VIRGOwearworks (ヴァルゴウェアワークス)BAMBI CHECK PANTS BLACK-KHAKI
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
60814 ROLLING CRADLE COSPLAY GIRL-THUNDER- HOODIE / PINK
62773 ROLLING CRADLE CNS HOODIE / BLACK
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
58110 MISHKA M21000404 Pullover BLACK
58595 SLEEPING TABLET REVERIE [ PATTERNED PAJAMA PANTS ] NAVY
60412 MUSIC SAVED MY LIFE (MSML) OVERSIZED BATTERFLY GRAPHIC HOODIE BLACK
62342 Zephyren(ゼファレン) EASY PANTS 8/S BLACK / DRAGONFLY
63002 SUPPLIER (サプライヤー) PLAYBOY QUARTER ZIP SWEAT BEIGE
63510 glamb (グラム) Anarchist Knit - Black
57032 VIRGO Upright zip swt WHITE
58374 WASTED PARIS Worker Pants Houdstooth Brown
61570 SUPPLIER (サプライヤー) PANELLED COLLEGE LOGO KNIT PURPLE
62129 SUPPLIER (サプライヤー) FIRE PATTERN HALF ZIP KNIT BLACK
59334 SLEEPING TABLET GENE [ RAW DENIM PANTS ] MUSTARD
62566 NineMicrophones CRAZY SHIRT BLACK/WHITE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
58328 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO L.BLUE
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58451 Subciety ×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA GRAY
58600 SLEEPING TABLET NOBLE [ SILKY PAJAMA PANTS ] BLACK
58979 Subciety (サブサエティ) STRIPE OVER SHIRT - BLUE
59014 Subciety (サブサエティ) PIGMENT PARKA - RED
60507 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE GRAY
60508 ANIMALIA AN21A-SW04 CROSS-NECK HEAVY OZ HOODIE NAVY
61276 LONELY論理 3EMBROIDERY HOODIE GRAY
63580 glamb (グラム) Pullover Line Jersey - Red
63581 glamb (グラム) Pullover Line Jersey - Blue
61706 SUPPLIER (サプライヤー) LOONEY CREW SWEAT BURGUNDY
61707 SUPPLIER (サプライヤー) LOONEY CREW SWEAT LIGHT GRAY
61401 NineMicrophones PIGMENT PARKA BLACK
61403 NineMicrophones PIGMENT PARKA GREEN
63345 ROLLING CRADLE (ローリングクレイドル) BIG CHECK SHIRT / NAVY
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
57279 Subciety (サブサエティ) PARKA-PROVIDENCE- NAVY
57594 Zephyren(ゼファレン) SHORTS BROWN CHECK
58099 WASTED PARIS Hoodie Columbia Bridge Lilac
58100 WASTED PARIS Hoodie Columbia Bridge Black
61489 glamb (グラム) Openwork Cardgian GREEN
61490 glamb (グラム) Semi Flare Slacks BLACK
61837 Subciety (サブサエティ) EMBROIDERY PARKA BLACK
61867 glamb (グラム) Military Remake CS - White×Khaki
62019 glamb (グラム) Old School Pile Shorts - Black
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK
63103 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT WHITE
64522 Zephyren(ゼファレン)COACH JACKET - FEAR NO ONE - BLACK
50453 SALUTE POCKET PANTS
57351 SUPPLIER (サプライヤー) LOGO HOODIE RED
61709 SUPPLIER (サプライヤー) LAYER LOGO SWEAT PANTS LIGHT GRAY
61844 A FEW GOOD KIDS EARTH ON THE HOODIE LIGHT PURPLE
61846 A FEW GOOD KIDS EARTH ON THE HOODIE BLACK
63066 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo BLUE
63067 ANIMALIA AN22SP-SW07 DOUBLE KNIT HOODIE-Overlap Logo BLACK
54361 Nine Microphones PARKA-Sunforever2020aw- BLACK
56067 NineMicrophones PARKA-Power of will-BLACK
56122 N.B.O. BLUE FLARED DENIM PANTS
60433 ANIMALIA AN21A-SW03 AA FLAG HEAVY Oz HOODIE BLACK
61405 NineMicrophones SWEAT-Wanderer- BLACK
64941 A FEW GOOD KIDS (アフューグッドキッズ) DATING CLUB LONG SLEEVE WHITE
64942 A FEW GOOD KIDS (アフューグッドキッズ) DATING CLUB LONG SLEEVE BLACK
56113 N.B.O. STITCHING EMBROIDERED SWEATPANTS
64246 SABBAT13(サバトサーティーン) SPOOK SAFARI SHIRTS BLACK
63068 ANIMALIA AN22SP-SW08 DOUBLE KNIT CREW-Overlap Logo KHAKI
63381 Anti Social Social Club The Notebook Orange Tee
63952 VIRGO(ヴァルゴ)PERFECTION L/S SPECIAL BLACK
63955 VIRGO(ヴァルゴ)PERFECTION L/S SPECIAL WHITE
65102 【glamb (グラム)GB0422/CS11 : Fake Layered Wide CS / フェイクレイヤードワイドカットソー - Gray
56213 Anti Social Social Club Headrush All Over White Tee