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-04-30 22:06:04')
AND pc.price02 > 9090
AND price02 <= 13636
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
57795 SALUTE EVAE* X BLACKLUX NECKLACE
50650 CHORD NUMBER EIGHT CH01-01K5-PL07 SIDE LINE CHECK CROPPED PANTS BLACK&RED
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
60165 Anti Social Social Club THE REAL ME WHITE TEE
55640 【予約商品】Anti Social Social Club WEIRD CAP BLACK
59839 Evae mob *EVAE+Tyga Collaboration Necklace
59841 Evae mob *EVAE+Tyga Collaboration Tee
56215 Anti Social Social Club Headrush Cap
57406 SALUTE Cactus flower flame necklace
56122 N.B.O. BLUE FLARED DENIM PANTS
57812 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×WHITE
57813 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×BURGUNDY
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
56767 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts BLACK
56768 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts WHITE
49896 FOG ESSENTIALS Boxy T-Shirt LIGHT HEATHER
55892 SALUTE FLOWER ANARCHY NECKLACE
56203 Anti Social Social Club Birdbath Black Hoodie
56204 Anti Social Social Club Headrush All Over White Hoodie
56207 Anti Social Social Club Sweeter Then You Think Black Hoodie
56210 Anti Social Social Club Enrique White Vneck Tee
56212 Anti Social Social Club Arkansas White Tee
56213 Anti Social Social Club Headrush All Over White Tee
56214 Anti Social Social Club Goodbye Summer Black Tank
56216 Anti Social Social Club Belong 2 You Black Sidebag
56114 N.B.O. TIE-DYE COLORBLOCK HOODIE
56109 N.B.O. CONTRAST EMBROIDERY T KHAKI
56113 N.B.O. STITCHING EMBROIDERED SWEATPANTS
56124 N.B.O. FLOWER PRINT T
56034 PARADOX DAMAGED ZIP SKIRT
55641 Anti Social Social Club ASHTON BLACK CAP
11130 REBEL8 STANDARD ISSUE LOGO ZIP UP HOODIE
11131 REBEL8 STANDARD ISSUE LOGO PULLOVER
11765 REBEL8 FIGHT THE POWER BLACK PULLOVER
14154 REBEL8 ANY MEANS BLACK ZIP-UP HOODIE
14857 REBEL8 JOIN OR DIE BLACK PULLOVER
15077 REBEL8 RIBBON FLOW BLACK PULLOVER
15086 REBEL8 EIGHTERS ZIP-UP HOODIE
15283 REBEL8 WOMENS JOIN OR DIE PULLOVER
15288 REBEL8 WOMENS RIBBON FLOW PULLOVER
15293 REBEL8 WOMENS BANDANA 8 ZIP-UP HOODIE
15557 FAR★STAR 百目 ハーフパンツ
15560 FAR★STAR 六芒星 パーカー WHT
15561 FAR★STAR 六芒星 パーカー BLK
15569 FAR★STAR 目苺パーカー
16568 REBEL8 WOMENS HI-RISE INDIGO JEAN
16569 REBEL8 GIANT FLASH BACKPACK
16826 REBEL8 CROSSBONES COACHES JACKET
18002 FAR★STAR チェーンスター ZIPパーカー
18004 FAR★STAR 六Bone星 パーカー
20283 REBEL8 ARROWHEAD CHAMBRAY BUTTON-UP
20291 REBEL8 DOMINEIGHT BACKPACK
20294 REBEL8 WOMENS MARLED KNIT CREWNECK
20296 REBEL8 BLACK DENIM BUTTON-UP
20343 REBEL8 WORSHIP WORTHY SWEATSHIRT
20344 REBEL8 GUILLOCHE HOODIE
20345 REBEL8 COVER THE 8 ZIP HOODIE
20478 FAR★STAR チェーンハーフパンツ
20480 FAR★STAR Sperm ハーフ.パンツ
21938 FAR★STAR XXX RABBIT ジップパーカー
22045 REBEL8 UNTIL DEATH ZIP-UP HOODIE
22065 REBEL8 NIGHT WATCH HOODIE
22081 REBEL8 WOMENS NIGHT WATCH PULLOVER HOODIE
22082 REBEL8 WOMENS 8 LOGO SWEATER
22084 REBEL8 STRIPED BUTTON-UP
22086 REBEL8 STANDARD FIT DUCK CANVAS BLACK PANTS
22087 REBEL8 SLIM CUT DENIM PANTS
22088 REBEL8 TOP GUNNER ZIP-UP HOODIE
22389 FAR★STAR 惡の華XFAR★STAR パーカー
22390 FAR★STAR 惡の華XFAR★STAR パーカー2
22919 REBEL8 PROPERTY OF PULLOVER HOODIE
23259 REBEL8 CHALLENGER BLUE FLANNEL BUTTON-UP
23260 REBEL8 CHALLENGER RED FLANNEL BUTTON-UP
23267 REBEL8 RIOT REGULATORS HEATHER GREY CREWNECK
23270 REBEL8 WORK PANTS BLACK
23272 REBEL8 WORK PANTS KHAKI
23274 REBEL8 SLIM CUT DUCK CANVAS BLACK PANTS
23275 REBEL8 PROPERTY OF BLACK SWEATPANT
23276 REBEL8 LOGO COLLAGE ZIP-UP CHARCOAL HOODIE
23292 REBEL8 GO FUCK YOURSELF COACHES JACKET
23406 PARADOX - MA-1 (ICE)
23407 PARADOX - GRAPHIC BIG MA-1 (WATER)
23408 PARADOX - MA-1 (BLACK)
23409 PARADOX - GRAPHIC BIG MA-1 (DARK WATER)
23657 FAR★STAR Sperm パーカー
24357 PARADOX - GRAPHIC BIG MA-1 (BANDANNA)
25019 REBEL8 SLIM CUT BURGUNDY PANTS BURGUNDY
25027 REBEL8 GIANT FLASH DUFFLE BAG
25345 PARADOX SOUVENIR PULLOVER PINK
25354 REBEL8 WOMENS LO-RISE INDIGO JEAN
25355 REBEL8 WOMENS HI-RISE BLACK JEAN
28137 REBEL8 BILL GREY FLANNEL
28138 REBEL8 BILL RED FLANNEL
28140 REBEL8 ANGELINO ZIP-UP HOODIE
28216 REBEL8 WOMENS CONSPIRACY SHIRT DRESS
28225 REBEL8 STANDARD FIT DUCK CANVAS GREY PANTS
28226 REBEL8 STANDARD FIT DENIM PANT
28227 REBEL8 BOMB SQUAD EMBROIDERED BLACK CREWNECK
28840 FAR★STAR OCTOPUS Eddy ジップパーカー
28843 FAR★STAR クリオネパーカー
28889 REBEL8 STANDING STRONG COACHES JACKET
28890 REBEL8 STANDING STRONG PULLOVER HOODIE
29870 REBEL8 WOMENS TWO FACED HOODED DRESS
29885 REBEL8 DESCANSO ETERNO ZIP-UP BLACK HOODIE
29886 REBEL8 HIT THE WALLS GREY CREWNECK
29887 REBEL8 TWO FACED PULLOVER BLACK HOODIE
29888 REBEL8 DEATH ZAP PULLOVER NAVY HOODIE
29905 REBEL8 WORLDWIDE DISTRO COACHES JACKET
29918 REBEL8 HARSH REALM FLANNEL
29919 REBEL8 BEAT IT HEATHER GREY CREWNECK
29921 REBEL8 HEART AND SOUL ZIP UP HOODIE BLACK
31789 REBEL8 STANDARD FIT PANT BLACK DENIM
31995 FAR★STAR 百目 ハーフパンツ 充血
31996 FAR★STAR 練乳目苺 ハーフパンツ
31997 FAR★STAR 夏の終わり パーカー
31998 FAR★STAR 目苺 トレーナー
31999 FAR★STAR チェーンスター トレーナー
32000 FAR★STAR ラインチェーンスター トレーナー
32001 FAR★STAR 六芒星 トレーナー
32320 REBEL8 HELL CAN'T US ZIP-UP HOODIE