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-16 02:16:41')
AND pc.classcategory_id1 IN( 13,35,44)
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
70182 TOY MACHINE (トイマシーン) SECT EYE STITCH QUILTED BOMBER JACKET GREEN
56744 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - WHITE/BLACK
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
66952 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM JACKET L.BLUE
69718 TOY MACHINE (トイマシーン) DESTROYS WIND TRACK JACKET BLACK
69719 TOY MACHINE (トイマシーン) DESTROYS WIND TRACK JACKET NAVY
56230 TOY MACHINE PEPPER SECT CORDUROY JACKET - BLACK
57318 TOY MACHINE LOYAL PAWN BOMBER JACKET(BLACK)
62531 TOY MACHINE (トイマシーン) BLOOD SUCKING COVERALL JACKET - L.BLUE
62532 TOY MACHINE (トイマシーン) BLOOD SUCKING COVERALL JACKET - ONE WASH
61694 TOY MACHINE TM & EYE STADIUM JACKET BLACK
66784 TOY MACHINE (トイマシーン) MARKED MONSTER COACH-JACKET MUSTARD
66785 TOY MACHINE (トイマシーン) MARKED MONSTER COACH-JACKET BLACK
69715 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BLACK
69716 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET RED
69717 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BROWN
70895 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM PANTS ONE WASH
70896 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM PANTS LIGHT WASH
70676 TOY MACHINE (トイマシーン) MATOKIE MONSTER CARGO PANTS BLACK
70677 TOY MACHINE (トイマシーン) MATOKIE MONSTER CARGO PANTS L.BEIGE
70678 TOY MACHINE (トイマシーン) MATOKIE MONSTER CARGO PANTS L.GREEN
57218 TOY MACHINE MARBLE PATTERN FIST COACH JACKET - BLACK
57219 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - BLACK
57220 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - KHAKI
56231 TOY MACHINE FRONT POCKET ZIP SHIRTS - BLACK
66954 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM EGG PANTS BLACK
66956 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM EGG PANTS L.BLUE
66957 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLACK
66958 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLUE
69277 TOY MACHINE (トイマシーン) FIST WAPPEN STRIPE LOOSE FIT SS SHIRTS BLACK
69278 TOY MACHINE (トイマシーン) FIST WAPPEN STRIPE LOOSE FIT SS SHIRTS BLUE
70127 TOY MACHINE (トイマシーン) LIGHTNING EYE RIB LINE SWEAT HALF ZIP BLACK
70128 TOY MACHINE (トイマシーン) LIGHTNING EYE RIB LINE SWEAT HALF ZIP ASH GRAY
70184 TOY MACHINE (トイマシーン) CORDUROY CARPENTER PANTS BLACK
70185 TOY MACHINE (トイマシーン) CORDUROY CARPENTER PANTS MUSTARD
60542 TOY MACHINE PEPPER SECT COTTON DUCK PANTS - BLACK
62533 TOY MACHINE (トイマシーン) LOOSE FIT CARPENTER PANTS - L.BLUE
62534 TOY MACHINE (トイマシーン) LOOSE FIT CARPENTER PANTS - ONE WASH
65342 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS-MUSTARD
65343 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS-GREEN
69276 TOY MACHINE (トイマシーン) VACCINE LOOSE FIT SS SHIRTS BLACK
69720 TOY MACHINE (トイマシーン) LAST SUPPER SWEAT PARKA BLACK
69721 TOY MACHINE (トイマシーン) LAST SUPPER SWEAT PARKA ASH GRAY
61213 TOY MACHINE TM × SOUTHPARK COLLABO SWEAT PARKA - BLACK
69722 TOY MACHINE (トイマシーン) BLOOD HAND SWEAT PARKA NAVY
52930 TOY MACHINE TMBT02 WIDE EASY PANTS BEIGE
52931 TOY MACHINE TMBT02 WIDE EASY PANTS BLACK
54202 TOY MACHINE NEON PRINT SS SHIRT - WINE
54203 TOY MACHINE NEON PRINT SS SHIRT - BLACK
56227 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BLACK
56228 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BEIGE
56267 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - BLACK
56268 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - WHITE
58030 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - BLACK
58031 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - TAN
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
63771 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - OFF WHITE
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
63214 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BLACK
63215 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - WHITE
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
66950 TOY MACHINE (トイマシーン) PEPPER SECT SWEAT PARKA YELLOW
56265 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - MIX GREY
56266 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - BLACK
56269 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - SAND
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
60537 TOY MACHINE LOYAL PAWN EMBROIDERY SWEAT CREW - SAND
63773 TOY MACHINE (トイマシーン) TRIPLE PEPPER SECT EMBROIDERY LOOSE FIT CARGO SHORTS - BLAC
65940 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY SWEAT CREW-SAND
65941 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY SWEAT CREW-F.GREEN
66646 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS MUSTARD
66647 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS BLACK
61689 TOY MACHINE (トイマシーン) EYES SWEAT HOODY GRAY
61695 TOY MACHINE (トイマシーン) TM & EYE STADIUM JACKET NAVY
58584 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS PINK
58585 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS KHAKI
60539 TOY MACHINE (トイマシーン) SKATE DATE PRINT SWEAT CREW - BLACK
60540 TOY MACHINE SKATE DATE PRINT SWEAT CREW - L. PURPLE
68400 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE NAVY
68401 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE YELLOW
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63226 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - F.GREEN
58022 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BEIGE
58023 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BLACK
66650 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE WHITE
66651 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE BLACK
70897 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE WHITE
70898 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE BLACK
70899 TOY MACHINE (トイマシーン) PUZZLE SS TEE WHITE
70900 TOY MACHINE (トイマシーン) PUZZLE SS TEE BLACK
68821 TOY MACHINE (トイマシーン) SKB3 COLLAB. BALOON SS TEE WHITE
68822 TOY MACHINE (トイマシーン) SKB3 COLLAB. BALOON SS TEE BLACK
71238 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE BLACK
71239 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE WHITE
69279 TOY MACHINE (トイマシーン) (BIG SIZE) WINGED SECT ROCKET EMBROIDERY SS TEE WHITE
69280 TOY MACHINE (トイマシーン) (BIG SIZE) WINGED SECT ROCKET EMBROIDERY SS TEE BLACK
53970 TOY MACHINE SKATE DATE SST (BIG SIZE) - WHITE
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK
54206 TOY MACHINE PRINT POCKET SST (BIG SIZE) - WHITE
54207 TOY MACHINE PRINT POCKET SST (BIG SIZE) - BLACK
58587 TOY MACHINE OG MONSTER SS WIDE TEE WHITE
58588 TOY MACHINE (トイマシーン) OG MONSTER SS WIDE TEE BLACK
63228 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - BLACK
67867 TOY MACHINE (トイマシーン) TALLY HO SS TEE WHITE
67872 TOY MACHINE (トイマシーン) TALLY HO SS TEE BLACK
52932 TOY MACHINE TMP20LT19 L/S T-Shirt WHITE
52933 TOY MACHINE TMP20LT19 L/S T-Shirt BLACK
54208 TOY MACHINE SKATE SECT TIE-DYE SST - BLAST
55946 TOY MACHINE FIST EMBROIDERY LONG TEE - BLACK
55948 TOY MACHINE MONSTER MARKED EMBROIDERY LONG TEE - BLACK
55949 TOY MACHINE MONSTER MARKED EMBROIDERY LONG TEE - WHITE