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-07 01:46: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 p.update_date DESC
LIMIT 225, 75
60807 TOY MACHINE (トイマシーン) TOYDIVISION SWEAT PARKA - BLACK
60808 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BLACK
60809 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BROWN
60542 TOY MACHINE PEPPER SECT COTTON DUCK PANTS - BLACK
60536 TOY MACHINE LOYAL PAWN EMBROIDERY SWEAT CREW - BLACK
60537 TOY MACHINE LOYAL PAWN EMBROIDERY SWEAT CREW - SAND
60540 TOY MACHINE SKATE DATE PRINT SWEAT CREW - L. PURPLE
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
60539 TOY MACHINE (トイマシーン) SKATE DATE PRINT SWEAT CREW - BLACK
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
60299 TOY MACHINE SKETCHY MONSTER EMBROIDERY LONG TEE - WHITE
60300 TOY MACHINE SKETCHY MONSTER EMBROIDERY LONG TEE - BLACK
60301 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - WHITE
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
58783 TOY MACHINE BUCKET HAT BLACK
58780 TOY MACHINE BUCKET HAT BLACK
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS 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
58787 TOY MACHINE (トイマシーン) PPRINT SHORTS BLACK
58582 TOY MACHINE SECT EYE MESH CAP ORANGE
58583 TOY MACHINE SECT EYE MESH CAP BLACK
58584 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS PINK
58585 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS KHAKI
58586 TOY MACHINE (トイマシーン) STRETCH NYLON POCKET SHORT PANTS BLACK
58587 TOY MACHINE OG MONSTER SS WIDE TEE WHITE
58588 TOY MACHINE (トイマシーン) OG MONSTER SS WIDE TEE BLACK
58589 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE WHITE
58590 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE BLACK
58591 TOY MACHINE CHARACTERS SS TEE PINK
58592 TOY MACHINE (トイマシーン) CHARACTERS SS TEE WHITE
58153 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt WHITE
58154 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt BLACK
58155 TOY MACHINE (トイマシーン) TURTLEBOY T-Shirt WHITE
58156 TOY MACHINE TURTLEBOY T-Shirt BLACK
58157 TOY MACHINE MONSTER T-Shirt BLACK
58158 TOY MACHINE MONSTER T-Shirt BLUE
58159 TOY MACHINE MONSTER T-Shirt WHITE
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
58041 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - ORANGE
58042 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - BLACK
58022 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BEIGE
58023 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BLACK
58025 TOY MACHINE ED MONSTER PRINT LONG TEE - WHITE
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
58027 TOY MACHINE OG MONSTER PRINT LONG TEE - WHITE
58028 TOY MACHINE OG MONSTER PRINT LONG TEE - BLACK
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
58032 TOY MACHINE DEAD MONSTER EMBROIDERY SWEAT CREW NECK - BLACK
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58037 TOY MACHINE BACKET HAT-BLACK
58038 TOY MACHINE BACKET HAT-BLUE
58039 TOY MACHINE TOYMONSTER HELLO KITTY EMB SIX PANEL CAP - PINK
58040 TOY MACHINE TOYMONSTER HELLO KITTY EMB SIX PANEL CAP - BLACK
57317 TOY MACHINE LOYAL PAWN BOMBER JACKET(OLIVE)
57318 TOY MACHINE LOYAL PAWN BOMBER JACKET(BLACK)
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
57219 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - BLACK
57220 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - KHAKI
57221 TOY MACHINE CLAIRVOYANT BB CAP - BLACK