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-04-28 06:34:35')
AND pc.price02 > 2727
AND price02 <= 4545
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, 75
69679 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER RED
69680 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER ORANGE
69678 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER PURPLE
64214 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - WHITE
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
63675 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - ORANGE
63232 TOY MACHINE (トイマシーン) AXEL SS TEE - WHITE
63234 TOY MACHINE (トイマシーン) AXEL SS TEE - PURPLE
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63227 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - WHITE
62611 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - L. BLUE
67443 TOY MACHINE (トイマシーン) PYRAMID SECT DENIM CAP BLACK
68246 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG GRAY
68245 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG NATURAL
67442 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE BLACK
64442 PUNK DRUNKERS x TOY MACHINE 組体操TEE - SUMI
63676 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - BLACK
63674 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - WHITE
62537 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - WHITE
63213 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BEIGE
62609 TOY MACHINE (トイマシーン) ERIC FOUNTAIN HEAVY WEIGHT BIG SS TEE - WHITE
61691 TOY MACHINE (トイマシーン) OG MONSTER SWEAT PANTS BLACK
61563 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - BLACK
61564 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - WHITE
61565 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - GREEN
61216 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - WHITE
61218 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - WHITE
60806 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - M. GREY
60296 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - WHITE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58787 TOY MACHINE (トイマシーン) PPRINT SHORTS BLACK
58586 TOY MACHINE (トイマシーン) STRETCH NYLON POCKET SHORT PANTS 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
58158 TOY MACHINE MONSTER T-Shirt BLUE
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
58042 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - BLACK
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
56747 TOY MACHINE BOA FLEECE TOTE BAG - BLACK
55947 TOY MACHINE FIST EMBROIDERY LONG TEE - WHITE
18253 TOY MACHINE MONSTER TEE
18254 TOY MACHINE TEE TM1003 BLK
18256 TOY MACHINE Sect Cleavage T-SHIRTS BLK
18257 TOY MACHINE BLOODSHOT TEE NVY
18259 TOY MACHINE BLOODSHOT TEE RED
18260 TOY MACHINE TEE TM1017
18261 TOY MACHINE TEE TM1021 BLK
18262 TOY MACHINE TEE TM1021 WHT
18263 TOY MACHINE Sect Cleavage T-SHIRTS WHT
39205 TOY MACHINE TMP18BN23 KNIT BEANIE BLACK
39244 TOY MACHINE TMP18CP22 BLACK
39245 TOY MACHINE TMP18CP22 PINK
39276 TOY MACHINE TMP18ST7 camo monster st black
39277 TOY MACHINE TMP18ST7 camo monster st white
39278 TOY MACHINE TMP18ST7 camo monster st yellow
39279 TOY MACHINE TMP18ST8 dotmonster st black
39280 TOY MACHINE TMP18ST8 dotmonster st white
39281 TOY MACHINE TMP18ST8 dotmonster st pink
40471 TOY MACHINE TMS18ST8 Toy Machine Logo ss WHITE-A
40472 TOY MACHINE TMS18ST8 Toy Machine Logo ss BLACK-A
40473 TOY MACHINE TMS18ST8 Toy Machine Logo ss S.GREEN
40474 TOY MACHINE TMS18ST8 Toy Machine Logo ss H.PINK
40475 TOY MACHINE TMS18ST8 Toy Machine Logo ss S.ORANGE
40863 TOY MACHINE TMS18ST14 POCKET TEE WHITE
41245 TOY MACHINE TMS18TW35 TOWEL BLACK
41246 TOY MACHINE TMS18TW36 TOWEL YELLOW
41814 TOY MACHINE TMJ18BG3 mouseketter2 sbg BLACK
42930 TOY MACHINE TMJ18HW2 MESH CAP BLACK
42931 TOY MACHINE TMJ18HW2 MESH CAP WHITE