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 >= '2023-02-05 17:20:41')
AND pc.stock > 0
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 120, 120
57069 SALUTE CACTUS PRINTER JEANS
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
50360 ANIMALIA AN19M-PT01 JEANS BRONCO No.7 L.BLUE
51400 KILL STAR CLOTHING Lita Hooded Coat
60726 MISHKA M61000452 HOODIE
60729 MISHKA M61000841 PANTS
61275 LONELY論理 3EMBROIDERY HOODIE BLACK
61276 LONELY論理 3EMBROIDERY HOODIE GRAY
61617 HYPER CORE GRUDGEモッズコート
61706 SUPPLIER (サプライヤー) LOONEY CREW SWEAT BURGUNDY
61707 SUPPLIER (サプライヤー) LOONEY CREW SWEAT LIGHT GRAY
61808 CIVARIZE【シヴァーライズ】 オーバーミリタリーシャツ B
62605 HYPER CORE SICKS MUTE BEARスタジャン
65231 GALFY (ガルフィー) 犬暖 JKT-GREEN
37759 REBEL8 Foretold Jacket
51303 DOPE Sideline Reversible Satin Bomber Black
56797 ROLLING CRADLE SUEDE TRACK JACKET BLACK
57116 SABBAT13 VEIL SHOP COAT BLACK
57117 SABBAT13 VEIL SHOP COAT BEIGE
61509 ANIMALIA AN22SP-JK01 ECWCS LEVEL-4 JACKET BLACK
61510 ANIMALIA AN22SP-JK01 ECWCS LEVEL-4 JACKET OLIVE
61507 CIVARIZE【シヴァーライズ】フラワードルマンジャガードシャツ Purple
61708 SUPPLIER (サプライヤー) LAYER LOGO SWEAT PANTS BURGUNDY
61709 SUPPLIER (サプライヤー) LAYER LOGO SWEAT PANTS LIGHT GRAY
61807 CIVARIZE【シヴァーライズ】 オーバーミリタリーシャツ A
56564 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON PARKA BLACK
59312 Anti Social Social Club A Fire Inside Black Hoodie - Flame
59313 Anti Social Social Club Nowadays Grey Hoodie
60160 Anti Social Social Club THE REAL ME BLACK HOODIE
60161 Anti Social Social Club I SEE BLUE SPLASH BLACK HOODIE
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
60199 Anti Social Social Club Fuzzy Connection Black Hoodie
60556 MISHKA M61000519 JACKET BLACK
61306 MAGICAL MOSH MISFITS モコモコボアパンツ (裏地フリース) BEIGE
61307 MAGICAL MOSH MISFITS モコモコボアパンツ (裏地フリース) DOKU
44195 NOT COMMON SENSE NS NYLON PANTS BLACK / RED
56895 SALUTE CACTUS PRINTER HOODIE
37192 VIRGO CAT HAND MOHAIR CARDIGAN BLACK
38778 VIRGO Gradation check middle shirts BLACK
44325 VIRGO OREO SWITCH KNIT VG-KNIT-74 BLACK
61274 LONELY論理 3EMBROIDERY CREWNECK GRAY
56896 Anti Social Social Club FOOD COURT BLACK HOODIE
49473 CRIMIE CR01-01K3-SH71 PLAYBOY SHIRT BLACK
52647 MISHKA MSS200814M BOTTOMS CAMO
56321 NineMicrophones WIDE SHIRT L/S NAVY
56457 Subciety (サブサエティ) SOUVENIR PARKA- BLACK
56458 Subciety (サブサエティ) SOUVENIR PARKA- KHAKI
58108 MISHKA M21000251 SHIRT
58114 MISHKA M21000509 Jacket
58166 NOT COMMON SENSE PALM HOODIE
60288 MISHKA M61000526 JACKET
61281 TRAVAS TOKYO【トラバストーキョー】Jelly fish zip hoodie Black/Red
61598 HYPER CORE BOOSTジップフーディー
40007 VIRGO GUITARIST DOLMAN SHIRTS RED
43944 VIRGO VG-SH-191 VA-1 SHIRTS KHAKI
56977 VIRGO CREST PANTS 21 BEIGE
56978 VIRGO CREST PANTS 21 NAVY
57004 VIRGO Relaxed uniform shirts BEIGE
57005 VIRGO Relaxed uniform shirts CHARCOAL
57006 VIRGO Relaxed uniform shirts BLACK
58043 ROLLING CRADLE RIP-STOP JACKET BLACK
58044 ROLLING CRADLE RIP-STOP JACKET BLUE
51646 ANIMALIA AN19W-JK04 JOGGING JACKET : MISFIT BLACK
51647 ANIMALIA AN19W-JK04 JOGGING JACKET : MISFIT NAVY
50446 mnml HOODED DENIM JACKET BLUE
50447 mnml HOODED DENIM JACKET BLACK
56460 Subciety (サブサエティ) FACTORY JKT- BLACK
56566 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT BLACK
57355 SUPPLIER (サプライヤー) TINPLATE ZIP HOODIE BLUE
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
60281 MISHKA M61000421 HOODIE
46753 FILA FM9546 Jacket Flame red
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
56800 ROLLING CRADLE SUEDE TRACK PANTS BLACK
56801 ROLLING CRADLE SUEDE TRACK PANTS BEIGE
56893 SALUTE CARGO PANTS
57317 TOY MACHINE LOYAL PAWN BOMBER JACKET(OLIVE)
57382 FILA FS3000 JACKET
60541 TOY MACHINE (トイマシーン) PEPPER SECT COTTON DUCK JACKET - BLACK
61392 ANIMALIA ANKN-SW03 Buffalo Clan BLACK
61393 ANIMALIA ANKN-SW04 10M Powers BLACK
61227 TRAVAS TOKYO【トラバストーキョー】サッドネスバニープルオーバーパーカー White
61727 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー マルチカラー
61728 TRAVAS TOKYO【トラバストーキョー】切り替え総柄バイカラーパーカー Pulple
50702 RIPNDIP MBN STRIPE HOODIE NEON
37514 RUDIE'S (ルーディーズ) DRAWING LONG SHIRTS NATIVE BLACK
38443 Zephyren (ゼファレン) BANDANA SHORTS CAMO
42994 NineMicrophones CHECK SHIRT RED
56403 Subciety (サブサエティ) PAISLEY SLACKS- BLACK
57246 mnml(ミニマル) CROPPED PUFFER JACKET BLACK
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
58109 MISHKA M21000404 Pullover WHITE
58110 MISHKA M21000404 Pullover BLACK
58113 MISHKA M21000414M WHITE
60156 Anti Social Social Club WOODY WHITE BUTTON UP
60273 MISHKA M61000301 KNIT BLACK
60274 MISHKA M61000301 KNIT PINK
60275 MISHKA M61000301 KNIT BLUE
60560 MISHKA M61000251 CHECK SHIRT
60648 RUDIE'S (ルーディーズ) PHAT EXTREME JACKET BLACK
60649 RUDIE'S (ルーディーズ) PHAT EXTREME JACKET WHITE
60660 MISHKA M61000253 SHIRT L.BLUE
38767 SQUARE DAMAGE DENIM SHIRTS
43087 NOT COMMON SENSE "FLAME" CUT OFF HOODIE BLACK
50556 ROLLING CRADLE LOOSE HOODIE / Crazy
55735 Anti Social Social Club ASHTON BLACK TEE
57011 VIRGO Middle Cuban shirt WHITE
57012 VIRGO Middle Cuban shirt NAVY
57013 VIRGO Middle Cuban shirt BLACK
57032 VIRGO Upright zip swt WHITE
57033 VIRGO Upright zip swt NAVY
57034 VIRGO Upright zip swt BLACK
57794 CIVARIZE【シヴァーライズ】半分プリーツワイドスラックスパンツ
43055 ANIMALIA AN18A-SW05 SIDE ZIP HOODIE L/S BLACK
49053 VIRGO VG-SH-202 PULLOVER MILY ZIP SHIRTS BLACK
56980 VIRGO Relaxed uniform jogger pants BEIGE
61224 TRAVAS TOKYO【トラバストーキョー】FURRY BEARセーラーカラーニット Purple
39020 DISTURBIA CLOTHING All-Seeing Hi-Tops Silver