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:54:48')
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 349)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
70183 TOY MACHINE (トイマシーン) CORDUROY PUFFER JACKET BLACK
70181 TOY MACHINE (トイマシーン) SECT EYE STITCH QUILTED BOMBER JACKET BLACK
70627 TOY MACHINE (トイマシーン) Hirotton monster bomber jacket BLACK
43627 TOY MACHINE TMF18JK20 BOMBER JACKET (REVERSIBLE) BLACK
45582 TOY MACHINE TMP19JK18 TOYMACHINE LOGO WIND JACKET BLACK
51206 TOY MACHINE TMF19JK22 TOYDIVISION FUR PARKA
56745 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - BLACK/BURGANDY
60804 TOY MACHINE (トイマシーン) CAMO REVERSIBLE FLEECE PARKA - L.BLUE
65936 TOY MACHINE (トイマシーン) BLOOD SUCKING DUCK PARKA-BLACK
66951 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM JACKET BLACK
70680 TOY MACHINE (トイマシーン) MATOKIE MONSTER ANORAK PARKA BLACK
43415 TOY MACHINE TMF18JK16 EF LOGO ANORAK PARKA - BLACK
43417 TOY MACHINE TMF18JK17 FIST LOGO ANORAK PARKA - BLACK
45584 TOY MACHINE TMP19JK19 TAPE LOGO ANORAK JACKET BLACK
52473 TOY MACHINE TMP20JK12 PATTERN PRINT ANORAK JACKET BLACK
69718 TOY MACHINE (トイマシーン) DESTROYS WIND TRACK JACKET BLACK
39216 TOY MACHINE TMP18JK32 ANORAK JACKET BLACK
40605 TOY MACHINE TMP18JK31 ANORAK JACKET BLACK
43625 TOY MACHINE TMF18JK19 BOMBER JACKET BLACK
43629 TOY MACHINE TMF18JK21 COACH JACKET(INSULATION) BLACK
45516 TOY MACHINE TMP19SW9 BLOODSUCKING SWEAT HALF ZIP BLACK
45518 TOY MACHINE TMP19SW10 TOYMONSTER LOGO SWEAT HALF ZIP PARKA BLACK
52594 TOY MACHINE TMP20JK17 ANORAK JACKET BLACK
52595 TOY MACHINE TMP20JK17 ANORAK JACKET ORANGE
57318 TOY MACHINE LOYAL PAWN BOMBER JACKET(BLACK)
61694 TOY MACHINE TM & EYE STADIUM JACKET BLACK
43623 TOY MACHINE TMF18JK18 BOA FLEECE JACKET BLACK
45574 TOY MACHINE TMP19SW15 TOYMACHINE LOGO SWEAT PARKA BLACK
45577 TOY MACHINE TMP19SW16 FIST EMBRO SWEAT PARKA BLACK
51207 TOY MACHINE TMF19JK21 TAPE LOGO FLEECE JKT
66785 TOY MACHINE (トイマシーン) MARKED MONSTER COACH-JACKET BLACK
69715 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BLACK
71166 TOY MACHINE (トイマシーン) ERIC FOUNTAIN ART COACH JACKET BLACK
71168 TOY MACHINE (トイマシーン) RITUAL SECT TRACK JACKET BLACK
70676 TOY MACHINE (トイマシーン) MATOKIE MONSTER CARGO PANTS BLACK
39207 TOY MACHINE TMP18JK26 TRACK JACKET BLACK
39444 TOY MACHINE TMP18JK25 TRACK JACKET BLACK
43414 TOY MACHINE TMF18JK15 SKETCHY MONSTER COACH JACKET PARKA - BLACK
45580 TOY MACHINE TMP19SW17 SQUARE MONSTER EMBRO SWEAT CREW BLACK
57218 TOY MACHINE MARBLE PATTERN FIST COACH JACKET - BLACK
57219 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - BLACK
39060 TOY MACHINE TMP18JK18 toymach jk BLACK
39524 TOY MACHINE TMP18JK19 toymach jk BLACK
39966 TOY MACHINE TMFJK2 scribmonster-monster Coach Jacket Black
40973 TOY MACHINE TMS19SH33 PRINT SHIRT BLACK
40975 TOY MACHINE TMS19SH34 PRINT SHIRT BLACK
43413 TOY MACHINE TMF18JK14 SECT PROTOP COACH JACKET - BLACK
45140 TOY MACHINE TMP19JK7 SECT EYE COACH JACKET BLACK
45586 TOY MACHINE TMP19PT20 TOYMACHINE LOGO WIND PANTS BLACK
56231 TOY MACHINE FRONT POCKET ZIP SHIRTS - BLACK
66954 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM EGG PANTS BLACK
66957 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLACK
69277 TOY MACHINE (トイマシーン) FIST WAPPEN STRIPE LOOSE FIT SS SHIRTS BLACK
70127 TOY MACHINE (トイマシーン) LIGHTNING EYE RIB LINE SWEAT HALF ZIP BLACK
70184 TOY MACHINE (トイマシーン) CORDUROY CARPENTER PANTS BLACK
70511 TOY MACHINE (トイマシーン) 【Hirotton collab.】Hirotton monster hoody BLACK
40974 TOY MACHINE TMS18SP21 PRINT SHORT PANTS BLACK
45520 TOY MACHINE TMP19SW11 SQUARE MONSTER SWEAT PANTS BLACK
60542 TOY MACHINE PEPPER SECT COTTON DUCK PANTS - BLACK
69276 TOY MACHINE (トイマシーン) VACCINE LOOSE FIT SS SHIRTS BLACK
69720 TOY MACHINE (トイマシーン) LAST SUPPER SWEAT PARKA BLACK
61213 TOY MACHINE TM × SOUTHPARK COLLABO SWEAT PARKA - BLACK
50804 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつパーカ BLACK
51236 TOY MACHINE×PUNK DRUNKERS TOY DRUNKERS SWEAT PARKA - BLACK
39059 TOY MACHINE TMP18SW15 fist po BLACK
39089 TOY MACHINE TMP18SW14 bloodsucking po BLACK
39209 TOY MACHINE TMP18PT27 TRACK PANTS BLACK
39211 TOY MACHINE TMP18PT28 TRACK PANTS BLACK
43296 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA BLACK
43300 TOY MACHINE TMF18SW9 SQUARE MONSTER SWEAT PARKA BLACK
43308 TOY MACHINE TMF18SW10 DOUBLE MOUSEKATER SWEAT PARKA BLACK
45573 TOY MACHINE TMP19SW14 RIP TORN MONSTER SWEAT PARKA BLACK
51213 TOY MACHINE TMF19SW15 MONSTER MARKED EMBRO SWEAT PARKA BLACK
51216 TOY MACHINE TMF19SW16 BRAINWASH SLEEVE PRINT SWEAT PARKA BLACK
52596 TOY MACHINE TMP20SW15 PULLOVER PARKA BLACK
54203 TOY MACHINE NEON PRINT SS SHIRT - BLACK
56227 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BLACK
56267 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - BLACK
58030 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - BLACK
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
65937 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLACK
65942 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-BLACK
63214 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BLACK
63216 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - BLACK
65935 TOY MACHINE (トイマシーン) WINGED SECT ROCKET PADDING JACKET-BLACK
66948 TOY MACHINE (トイマシーン) PEPPER SECT SWEAT PARKA BLACK
39086 TOY MACHINE TMP18SWT17 tm sect cn BLACK
43309 TOY MACHINE TMF18SW12 TAPE LOGO SWEAT CREW BLACK
56266 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - BLACK
56270 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - BLACK
58032 TOY MACHINE DEAD MONSTER EMBROIDERY SWEAT CREW NECK - BLACK
60536 TOY MACHINE LOYAL PAWN EMBROIDERY SWEAT CREW - BLACK
63773 TOY MACHINE (トイマシーン) TRIPLE PEPPER SECT EMBROIDERY LOOSE FIT CARGO SHORTS - BLAC
66647 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS BLACK
70771 TOY MACHINE (トイマシーン) (HEAVY WEIGHT) LIVING TOY - TRANSMISSIONATOR LONG TEE BLACK
56224 TOY MACHINE TOYDIVISION PRINT SWEAT CREW - BLACK
60539 TOY MACHINE (トイマシーン) SKATE DATE PRINT SWEAT CREW - BLACK
68400 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE NAVY
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
69438 TOY MACHINE (トイマシーン) SKB3 COLLAB. SECT & TOYMOONSTER BLACK
69440 TOY MACHINE (トイマシーン) SKB3 COLLAB. SECT FALLING DOWN LONG T BLACK
69204 TOY MACHINE (トイマシーン) ROCKET SECT EMBROIDERY LONG TEE BLACK
70517 TOY MACHINE (トイマシーン) LIVING TOY - FIST LONG TEE BLACK
61214 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - BLACK
58023 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BLACK
66651 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE BLACK
70898 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE BLACK
70900 TOY MACHINE (トイマシーン) PUZZLE SS TEE BLACK
62540 TOY MACHINE (トイマシーン) TM & EYE BB CAP - BLACK
65948 TOY MACHINE (トイマシーン) OG MONSTER PU LEATHER HAT-BLACK
68822 TOY MACHINE (トイマシーン) SKB3 COLLAB. BALOON SS TEE BLACK
71238 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE BLACK
58780 TOY MACHINE BUCKET HAT BLACK
58783 TOY MACHINE BUCKET HAT BLACK
69280 TOY MACHINE (トイマシーン) (BIG SIZE) WINGED SECT ROCKET EMBROIDERY SS TEE BLACK
51233 TOY MACHINE×PUNK DRUNKERS * FIST LONG TEE - BLACK
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK
54207 TOY MACHINE PRINT POCKET SST (BIG SIZE) - BLACK
58588 TOY MACHINE (トイマシーン) OG MONSTER SS WIDE TEE BLACK