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-08 06:54:48')
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, 100
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
70627 TOY MACHINE (トイマシーン) Hirotton monster bomber jacket BLACK
70628 TOY MACHINE (トイマシーン) Hirotton monster bomber jacket OLIVE
70893 TOY MACHINE (トイマシーン) VACCINE GET INJECTED DENIM JACKET ONE WASH
70894 TOY MACHINE (トイマシーン) VACCINE GET INJECTED DENIM JACKET LIGHT WASH
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
70680 TOY MACHINE (トイマシーン) MATOKIE MONSTER ANORAK PARKA BLACK
70681 TOY MACHINE (トイマシーン) MATOKIE MONSTER ANORAK PARKA L.BEIGE
70682 TOY MACHINE (トイマシーン) MATOKIE MONSTER ANORAK PARKA L.GREEN
69718 TOY MACHINE (トイマシーン) DESTROYS WIND TRACK JACKET BLACK
69719 TOY MACHINE (トイマシーン) DESTROYS WIND TRACK JACKET NAVY
56229 TOY MACHINE PEPPER SECT CORDUROY JACKET - BEIGE
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
71166 TOY MACHINE (トイマシーン) ERIC FOUNTAIN ART COACH JACKET BLACK
71167 TOY MACHINE (トイマシーン) ERIC FOUNTAIN ART COACH JACKET KHAKI
71168 TOY MACHINE (トイマシーン) RITUAL SECT TRACK JACKET BLACK
71169 TOY MACHINE (トイマシーン) RITUAL SECT TRACK JACKET BLUE
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
70511 TOY MACHINE (トイマシーン) 【Hirotton collab.】Hirotton monster hoody BLACK
70512 TOY MACHINE (トイマシーン) 【Hirotton collab.】Hirotton monster hoody CAMEL
70901 TOY MACHINE (トイマシーン) DOES'N LOVE YOU WORK SHIRTS L.Gray
70902 TOY MACHINE (トイマシーン) DOES'N LOVE YOU WORK SHIRTS L.BLUE
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
69723 TOY MACHINE (トイマシーン) BLOOD HAND SWEAT PARKA CAMEL
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
58029 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - L. PINK
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
65937 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLACK
65938 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLUE
65939 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-M.BROWN
65942 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-BLACK
65943 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-TAN
65944 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-BROWN
69283 TOY MACHINE (トイマシーン) DRUGGED EYES DENIM BUCKET HAT L.BLUE
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
56225 TOY MACHINE TOYMONSTER EMBROIDERY SWEAT CREW - SAND
56226 TOY MACHINE TOYMONSTER EMBROIDERY SWEAT CREW - BLACK
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