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 =96
)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-04-28 13:49:38')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
59670 Zephyren(ゼファレン) EASY PANTS FLOWER
59672 Zephyren(ゼファレン) EASY PANTS 8/S GREEN CHECK
59674 Zephyren(ゼファレン) EASY PANTS 8/S FLOWER
60332 LONELY論理 LONELY OVER ROCK OVERALL BLACK
60262 RUDIE'S (ルーディーズ) PHAT OVERALL BLACK
60263 RUDIE'S (ルーディーズ) PHAT OVERALL BLUEGRAY
60211 NieR (ニーア) LACE UP PANTS
60228 NieR (ニーア) フラップ付きSARROUEL PANTS【NieR RED LOGO】
60229 NieR (ニーア) BLACK SARROUEL PANTS【FACE LOGO】
59424 SUPPLIER (サプライヤー) SPLIT CORDUROY DENIM LIGHT BLUE
60099 NieR (ニーア) ORIGINAL BLACK オールインワン
59953 CIVARIZE【シヴァーライズ】 デザインワイドパンツ BLACK/RED
58773 CIVARIZE【シヴァーライズ】アシンメトリーレイヤードサルエルパンツ
57794 CIVARIZE【シヴァーライズ】半分プリーツワイドスラックスパンツ
57155 SABBAT13 GHOST CHECK SLACKS GRAY
58835 GALFY (ガルフィー) 炎上大学フレアジャージ 濃紺
58836 GALFY (ガルフィー) 炎上大学フレアジャージ 漆黒
56608 ROLLING CRADLE THUNDER GATE DENIM -1st damage type- / BLUE
56978 VIRGO CREST PANTS 21 NAVY
58678 NieR (ニーア) 2WAY SARROUEL PANTS【切替ASYMMETRY】PURPLE BEAT
58679 NieR (ニーア) 7分丈SIDE BELT WIDE PANTS【Butterfly】
58680 NieR (ニーア) RED ROSE WIDE PANTS
52048 Zephyren(ゼファレン) KNEE CLASHED SKINNY BLACK
56985 VIRGO Special Petaurista cargo pants BLACK
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
56403 Subciety (サブサエティ) PAISLEY SLACKS- BLACK
57083 NieR (ニーア) SILVER ベロアワイドパンツ
56299 RIP DESIGN WORXX Ashly Smileシェフパンツ
56893 SALUTE CARGO PANTS
56548 NieR (ニーア) 2WAY SIDE ZIP WIDE PANTS【格子柄】
56549 NieR (ニーア) 2WAY SIDE ZIP WIDE PANTS【蝶柄】
56554 NieR (ニーア) SILVER ベロアワイドパンツ
56111 N.B.O. PATCH-PRINT TROUSERS
54346 Subciety(サブサエティ) LEOPARD SLACKS BEIGE
54820 PUNK DRUNKERS INDOORパンツ - BLACK
54821 PUNK DRUNKERS INDOORパンツ - M.GRAY
55313 NieR (ニーア) 2WAY SARROUEL PANTS【切替ASYMMETRY】
55934 NieR (ニーア) SARROUEL PANTS YELLOWxBLUE
55935 NieR (ニーア) 2WAY SIDE ZIP WIDE PANTS【monochrome rose】
55936 NieR (ニーア) 2WAY SARROUEL PANTS【切替ASYMMETRY】DIAMOND
55937 NieR (ニーア) TIE DYE PANTS
55938 NieR (ニーア) 4POCKET RELAX WEAR PANTS
54762 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS SAX
54763 PSYCHOLOGICAL METAMORPHOSIS PMLP CHINO EAZY PANTS BLACK
54764 PSYCHOLOGICAL METAMORPHOSIS PMLP STRIPE EAZY PANTS WHITE/NAVY
55685 RIP DESIGN WORXX シークレットスマイルスキニーパンツ CRUSH
55299 NieR (ニーア) SARROUEL PANTS【ZIP NieR patchwork】
55306 NieR (ニーア) 2WAY SARROUEL PANTS【切替ASYMMETRY】PURPLE BEAT
5293 DROP DEAD CLOTHING FLORAL LEGGINGS
8800 FAMOUS STARS AND STRAPS Capture Cargo Short Black
9249 PUNK DRUNKERS 見てるぞデニム USED
9329 MISHKA (ミシカ) FRAGRANT WORK PANTS OLIVE
10068 MISHKA (ミシカ) BORIS SKINNY-LEG DENIM BLACK
10466 PUNK DRUNKERS 幼虫クロップドパンツ BEIGE
10467 PUNK DRUNKERS 幼虫クロップドパンツ BLACK
10468 PUNK DRUNKERS カメさんデニム INDIGO
10469 PUNK DRUNKERS カメさんデニム GREEN
11625 KILL STAR CLOTHING KAWAII LEGGINGS
11626 KILL STAR CLOTHING SIAMESE LEGGINGS
12042 DISTURBIA CLOTHING Bunnies Leggings
13339 IRON FIST CLOTHING SKULL A DOT LEGGING
14455 PUNK DRUNKERS 切替ピチパン SILVER.GLAY
15000 PUNK DRUNKERS 100ミリタリーパンツ あいつCAMO
15158 DROP DEAD CLOTHING BLACK STABBATH LEGGINS
15315 PUNK DRUNKERS ステージコーデュロイパンツ
15602 PUNK DRUNKERS デニーム USED
16375 PUNK DRUNKERS 2WAYチノパン BEIGE
16681 LILWHITE. -REVERSE CROSS- CHAMPION GUM SHORTS
17187 ZEPHYREN (ゼファレン) WORK PANTS PRINTED -SKULL HEAD- BLACK
17188 ZEPHYREN (ゼファレン) WORK PANTS PRINTED -SKULL HEAD- BEIGE
17203 ZEPHYREN (ゼファレン) WORK SHORTS PRINTED -SKULL HEAD- NAVY
18182 DISTURBIA CLOTHING Hater Acid Wash Jeans
18866 PUNK DRUNKERS ブロックコーデュロイショーツ GREEN
18921 LILWHITE. HDL SHORTS GRAY
19608 Zephyren STADS WORK PANTS - BLACK
19906 ROLLING CRADLE RC×THRASHER SHORTS / Beige
20116 KILL STAR CLOTHING CRUE DENIM JEANS [B]
20293 REBEL8 WOMENS MARLED KNIT PANT
20300 REBEL8 WOMENS 8 LOGO LEGGINGS
20462 SILLENT FROM ME LUST -Skinny- BLACK
20463 SILLENT FROM ME LUST -Skinny- BLACK/WHITE
20569 ROLLING CRADLE WARM UP SWEAT PANTS / Gray
20570 ROLLING CRADLE WARM UP SWEAT PANTS / Blue
20615 MISHKA (ミシカ) IVAN RADIOACTIVE JEANS
21016 NineMicrophones DENIM-Punk skaters- BLACKII
21187 PUNK DRUNKERS リフレクタージョガーパンツ2015 BLACK
21209 Stay Sick Clothing Anchor Black - Ladies Leggings
21629 DISTURBIA CLOTHING Hell Jeans
21631 DISTURBIA CLOTHING Heaven Jeans
21789 AGAPE ATTIRE ASTON JOGGERS
21946 PUNK DRUNKERS 【PDSxストリートファイター】ガイルのミリタリーパンツ G.CAMO
21947 PUNK DRUNKERS 【PDSxストリートファイター】ガイルのミリタリーパンツ B.CAMO
22190 KILL STAR CLOTHING Dollar Sweatpants [B]
22273 KILL STAR CLOTHING Mendes Leggings
22423 KILL STAR CLOTHING(キルスター・クロージング) Rex Sweatpants
22740 PUNK DRUNKERS ベトジョガーパンツ NAVY
22741 PUNK DRUNKERS ベトジョガーパンツ CAMO
22834 PUNK DRUNKERS 富士山オーバーオール INDIGO
22835 PUNK DRUNKERS 富士山オーバーオール BLACK
22933 PARADOX - DENIM JOGGER PANTS ICE
22934 PARADOX - DENIM JOGGER PANTS BLACK
23386 PUNK DRUNKERS ワイドパンツ GRAY
23387 PUNK DRUNKERS ワイドパンツ BLACK
23722 SILLENT FROM ME HOOKY -Cuffed Track Pants- BLACK
23723 SILLENT FROM ME HOOKY -Cuffed Track Pants- WHITE
23754 9mm Parabellum Bullet ハーフパンツ[滝モデル] BLK
23775 9mm Parabellum Bullet ハーフパンツ[滝モデル] 迷彩
23792 KILL STAR CLOTHING (キルスター・クロージング) Spider Denim Jeans
23874 DEADHEARTZ D Paisley SHORT PANTS
24182 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- BLACK
24184 SILLENT FROM ME RUEFUL -Easy Sarouel Pants- WHITE
24364 KILL STAR CLOTHING (キルスター・クロージング) Cult Leggings [B]
24985 PUNK DRUNKERS 骨ジャンケン総柄ショーツ BLACK
25154 WE CAME AS ROMANS Hope Finger Black - Mesh Shorts
25286 PUNK DRUNKERS ペンペンジョガーパンツ BLUE/NAVY
25287 PUNK DRUNKERS ペンペンジョガーパンツ BUR/BEIGE
25288 PUNK DRUNKERS イージーDOパンツ NAVY
25289 PUNK DRUNKERS イージーDOパンツ ASH
25339 PARADOX SKINNY PANTS BLACK