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-23 19:10:14')
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 p.update_date
LIMIT 0, 120
52933 TOY MACHINE TMP20LT19 L/S T-Shirt BLACK
52934 TOY MACHINE TMP20HW26 CAP BLACK
53164 TOY MACHINE TMS20HW12 BB CAP BLACK
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK
54203 TOY MACHINE NEON PRINT SS SHIRT - BLACK
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
54207 TOY MACHINE PRINT POCKET SST (BIG SIZE) - BLACK
55945 TOY MACHINE TOYMONSTER BB CAP - BLACK
55948 TOY MACHINE MONSTER MARKED EMBROIDERY LONG TEE - BLACK
55946 TOY MACHINE FIST EMBROIDERY LONG TEE - BLACK
56224 TOY MACHINE TOYDIVISION PRINT SWEAT CREW - BLACK
56267 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - BLACK
56273 TOY MACHINE GROCERY BAG - BLACK
56263 TOY MACHINE FIST EMBROIDERY BEANIE - BLACK
56270 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - BLACK
56266 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - BLACK
56231 TOY MACHINE FRONT POCKET ZIP SHIRTS - BLACK
56227 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BLACK
56745 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - BLACK/BURGANDY
56747 TOY MACHINE BOA FLEECE TOTE BAG - BLACK
57109 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE BLACK
57111 TOY MACHINE SECT STAFF GRADATION LONG TEE BLACK
57114 TOY MACHINE CLAIRVOYANT LONG TEE BLACK
57115 TOY MACHINE WELCOME TO HELL LONG TEE BLACK
57218 TOY MACHINE MARBLE PATTERN FIST COACH JACKET - BLACK
57219 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - BLACK
57221 TOY MACHINE CLAIRVOYANT BB CAP - BLACK
57318 TOY MACHINE LOYAL PAWN BOMBER JACKET(BLACK)
58023 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BLACK
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
58028 TOY MACHINE OG MONSTER PRINT LONG TEE - BLACK
58030 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - BLACK
58032 TOY MACHINE DEAD MONSTER EMBROIDERY SWEAT CREW NECK - BLACK
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58037 TOY MACHINE BACKET HAT-BLACK
58040 TOY MACHINE TOYMONSTER HELLO KITTY EMB SIX PANEL CAP - BLACK
58042 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - BLACK
58154 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt BLACK
58156 TOY MACHINE TURTLEBOY T-Shirt BLACK
58157 TOY MACHINE MONSTER T-Shirt BLACK
58583 TOY MACHINE SECT EYE MESH CAP BLACK
58586 TOY MACHINE (トイマシーン) STRETCH NYLON POCKET SHORT PANTS BLACK
58588 TOY MACHINE (トイマシーン) OG MONSTER SS WIDE TEE BLACK
58590 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE BLACK
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58787 TOY MACHINE (トイマシーン) PPRINT SHORTS BLACK
58780 TOY MACHINE BUCKET HAT BLACK
58783 TOY MACHINE BUCKET HAT BLACK
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
60300 TOY MACHINE SKETCHY MONSTER EMBROIDERY LONG TEE - BLACK
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
60304 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BLACK
60535 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SWEAT CREW - BLACK
60539 TOY MACHINE (トイマシーン) SKATE DATE PRINT SWEAT CREW - BLACK
60541 TOY MACHINE (トイマシーン) PEPPER SECT COTTON DUCK JACKET - BLACK
60536 TOY MACHINE LOYAL PAWN EMBROIDERY SWEAT CREW - BLACK
60542 TOY MACHINE PEPPER SECT COTTON DUCK PANTS - BLACK
60804 TOY MACHINE (トイマシーン) CAMO REVERSIBLE FLEECE PARKA - L.BLUE
60805 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - BLACK
60807 TOY MACHINE (トイマシーン) TOYDIVISION SWEAT PARKA - BLACK
60808 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BLACK
61214 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - BLACK
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
61213 TOY MACHINE TM × SOUTHPARK COLLABO SWEAT PARKA - BLACK
61561 TOY MACHINE (トイマシーン) TURTLE HEAD LONG TEE - BLACK
61563 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - BLACK
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
61694 TOY MACHINE TM & EYE STADIUM JACKET BLACK
62540 TOY MACHINE (トイマシーン) TM & EYE BB CAP - BLACK
62610 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - BLACK
63009 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - BLACK
63214 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BLACK
63216 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - BLACK
63210 TOY MACHINE (トイマシーン) HIROTTON COLLABO HAT SECT SHARK - BLACK
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
62536 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE TOYMONSTER - BLACK
63212 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - BLACK
63676 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - BLACK
63773 TOY MACHINE (トイマシーン) TRIPLE PEPPER SECT EMBROIDERY LOOSE FIT CARGO SHORTS - BLAC
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
64221 TOY MACHINE×PUNK DRUNKERS AITSU AND FIST NYLON HAT - BLACK
64220 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG MESH CAP - BLACK
65340 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-BLACK
64213 TOY MACHINE×PUNK DRUNKERS AITSU AND THE CHARACTERS SS TEE - BLACK
64442 PUNK DRUNKERS x TOY MACHINE 組体操TEE - SUMI
65935 TOY MACHINE (トイマシーン) WINGED SECT ROCKET PADDING JACKET-BLACK
65936 TOY MACHINE (トイマシーン) BLOOD SUCKING DUCK PARKA-BLACK
65937 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLACK
65942 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-BLACK
65948 TOY MACHINE (トイマシーン) OG MONSTER PU LEATHER HAT-BLACK
66785 TOY MACHINE (トイマシーン) MARKED MONSTER COACH-JACKET BLACK
66951 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM JACKET BLACK
66649 TOY MACHINE (トイマシーン) SECT VS LO SANGELES LONG TEE BLACK
66651 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE BLACK
66948 TOY MACHINE (トイマシーン) PEPPER SECT SWEAT PARKA BLACK
67442 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE BLACK
67877 TOY MACHINE (トイマシーン) MAD MOUSE COMIC COLLAB BRAIN WASH SS TEE BLACK
65947 TOY MACHINE (トイマシーン) PEPPER SECT CORDEUROY HAT-BLACK
65946 TOY MACHINE (トイマシーン) PYRAMID SECT CORDUROY HAT-NAVY
66959 TOY MACHINE (トイマシーン) OG MONSTER BB CAP BLACK/RED
67443 TOY MACHINE (トイマシーン) PYRAMID SECT DENIM CAP BLACK
68244 TOY MACHINE (トイマシーン) TOYMONSTER PIGMENT 2 TONE CAP BLACK
65344 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS-BLACK
66647 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS BLACK
66954 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE DENIM EGG PANTS BLACK
66957 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLACK
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63228 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - BLACK
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
67872 TOY MACHINE (トイマシーン) TALLY HO SS TEE BLACK
68400 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE NAVY
64219 TOY MACHINE×PUNK DRUNKERS SECT FROM AITSU SS TEE - BLACK
69276 TOY MACHINE (トイマシーン) VACCINE LOOSE FIT SS SHIRTS BLACK