SELECT SQL_CALC_FOUND_ROWS 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 >= '2023-02-09 12:44:48')
AND pc.stock > 0
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 p.update_date DESC
LIMIT 0, 120
66646 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS MUSTARD
66647 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS BLACK
66648 TOY MACHINE (トイマシーン) SECT VS LO SANGELES LONG TEE WHITE
66649 TOY MACHINE (トイマシーン) SECT VS LO SANGELES LONG TEE BLACK
66650 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE WHITE
66651 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE BLACK
66781 TOY MACHINE (トイマシーン) MARKED MONSTER SIX PANEL CAP(NAVY)
66784 TOY MACHINE (トイマシーン) MARKED MONSTER COACH-JACKET MUSTARD
66785 TOY MACHINE (トイマシーン) MARKED MONSTER COACH-JACKET BLACK
65935 TOY MACHINE (トイマシーン) WINGED SECT ROCKET PADDING JACKET-BLACK
65936 TOY MACHINE (トイマシーン) BLOOD SUCKING DUCK PARKA-BLACK
65938 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLUE
65939 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-M.BROWN
65940 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY SWEAT CREW-SAND
65941 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY SWEAT CREW-F.GREEN
65942 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-BLACK
65943 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-TAN
65946 TOY MACHINE (トイマシーン) PYRAMID SECT CORDUROY HAT-NAVY
65947 TOY MACHINE (トイマシーン) PEPPER SECT CORDEUROY HAT-BLACK
64442 PUNK DRUNKERS x TOY MACHINE 組体操TEE - SUMI
64443 PUNK DRUNKERS × TOY MACHINE 組体操TEE - D.GREEN
64213 TOY MACHINE×PUNK DRUNKERS AITSU AND THE CHARACTERS SS TEE - BLACK
64214 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - WHITE
64215 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - MINT
64216 TOY MACHINE×PUNK DRUNKERS AITSU AND TOYMONSTER IN TURTLE HEAD SS TEE - WHITE
64217 TOY MACHINE×PUNK DRUNKERS AITSU AND TOYMONSTER IN TURTLE HEAD SS TEE - SAND
64218 TOY MACHINE×PUNK DRUNKERS SECT FROM AITSU SS TEE - WHITE
64219 TOY MACHINE×PUNK DRUNKERS SECT FROM AITSU SS TEE - BLACK
65388 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-INDIGO BLUE
65339 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-WHITE
65342 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS-MUSTARD
65344 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS-BLACK
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
63771 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - OFF WHITE
63773 TOY MACHINE (トイマシーン) TRIPLE PEPPER SECT EMBROIDERY LOOSE FIT CARGO SHORTS - BLAC
63676 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - BLACK
63674 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - WHITE
63675 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - ORANGE
63232 TOY MACHINE (トイマシーン) AXEL SS TEE - WHITE
63007 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - WHITE
63226 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - F.GREEN
63231 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - L.BLUE
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
63234 TOY MACHINE (トイマシーン) AXEL SS TEE - PURPLE
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63227 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - WHITE
63228 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - BLACK
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63211 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - WHITE
63212 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - BLACK
62537 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - WHITE
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
63209 TOY MACHINE (トイマシーン) HIROTTON COLLABO HAT SECT SHARK - BEIGE
63210 TOY MACHINE (トイマシーン) HIROTTON COLLABO HAT SECT SHARK - BLACK
63213 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BEIGE
63004 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - WHITE
63005 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - YELLOW
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63008 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - SAND
63009 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - BLACK
62609 TOY MACHINE (トイマシーン) ERIC FOUNTAIN HEAVY WEIGHT BIG SS TEE - WHITE
62612 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - WHITE
62611 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - L. BLUE
62531 TOY MACHINE (トイマシーン) BLOOD SUCKING COVERALL JACKET - L.BLUE
62532 TOY MACHINE (トイマシーン) BLOOD SUCKING COVERALL JACKET - ONE WASH
62540 TOY MACHINE (トイマシーン) TM & EYE BB CAP - BLACK
62539 TOY MACHINE (トイマシーン) TM & EYE BB CAP - PURPLE
63229 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - WHITE
61687 TOY MACHINE (トイマシーン) FLAME FIST SWEAT HOODY NATURAL
61688 TOY MACHINE (トイマシーン) FLAME FIST SWEAT HOODY NAVY
61690 TOY MACHINE (トイマシーン) EYES SWEAT HOODY BLACK
61691 TOY MACHINE (トイマシーン) OG MONSTER SWEAT PANTS BLACK
61692 TOY MACHINE (トイマシーン) FLAME FIST BB CAP BLACK
61695 TOY MACHINE (トイマシーン) TM & EYE STADIUM JACKET NAVY
61561 TOY MACHINE (トイマシーン) TURTLE HEAD LONG TEE - BLACK
61562 TOY MACHINE (トイマシーン) TURTLE HEAD LONG TEE - WHITE
61563 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - BLACK
61565 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - GREEN
61216 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - WHITE
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
61218 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - WHITE
60804 TOY MACHINE (トイマシーン) CAMO REVERSIBLE FLEECE PARKA - L.BLUE
60805 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - BLACK
60806 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - M. GREY
60807 TOY MACHINE (トイマシーン) TOYDIVISION SWEAT PARKA - BLACK
60809 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BROWN
60303 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BEIGE
60304 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BLACK
60535 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SWEAT CREW - BLACK
60538 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SWEAT CREW - PURPLE
60541 TOY MACHINE (トイマシーン) PEPPER SECT COTTON DUCK JACKET - BLACK
60296 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - WHITE
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
60301 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - WHITE
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58586 TOY MACHINE (トイマシーン) STRETCH NYLON POCKET SHORT PANTS BLACK
58589 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE WHITE
58590 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE BLACK
58155 TOY MACHINE (トイマシーン) TURTLEBOY T-Shirt WHITE
58156 TOY MACHINE TURTLEBOY T-Shirt BLACK
58041 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - ORANGE
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
57317 TOY MACHINE LOYAL PAWN BOMBER JACKET(OLIVE)
57319 TOY MACHINE NEW BLOOD LOGO SIX PANEL CAP(SMOKE PINK)
57320 TOY MACHINE FLAME FIST MEBROIDERY SIX PANEL CAP(GREEN TEA)
57218 TOY MACHINE MARBLE PATTERN FIST COACH JACKET - BLACK
57108 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE WHITE
45507 TOY MACHINE TMS19SH33 LINE MONSTER PRINT SHIRT NAVY
45577 TOY MACHINE TMP19SW16 FIST EMBRO SWEAT PARKA BLACK
53161 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE WHITE
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
54205 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - YELLOW