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 19:30:02')
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 480, 120
57115 TOY MACHINE WELCOME TO HELL LONG TEE BLACK
57221 TOY MACHINE CLAIRVOYANT BB CAP - BLACK
57222 TOY MACHINE CLAIRVOYANT BB CAP - WHITE
57319 TOY MACHINE NEW BLOOD LOGO SIX PANEL CAP(SMOKE PINK)
58025 TOY MACHINE ED MONSTER PRINT LONG TEE - WHITE
58028 TOY MACHINE OG MONSTER PRINT LONG TEE - BLACK
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58037 TOY MACHINE BACKET HAT-BLACK
58038 TOY MACHINE BACKET HAT-BLUE
58156 TOY MACHINE TURTLEBOY T-Shirt BLACK
58582 TOY MACHINE SECT EYE MESH CAP ORANGE
58583 TOY MACHINE SECT EYE MESH CAP BLACK
62610 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - BLACK
62612 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - WHITE
63005 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - YELLOW
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63229 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - WHITE
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
63231 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - L.BLUE
68238 TOY MACHINE (トイマシーン) SLING SHOT SS TEE WHITE
68239 TOY MACHINE (トイマシーン) SLING SHOT SS TEE BLACK
68240 TOY MACHINE (トイマシーン) SLING SHOT SS TEE PURPLE
68241 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE BLACK
68242 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE L. YELLOW
68243 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE WHITE
71432 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE WHITE
71433 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE BLACK
39205 TOY MACHINE TMP18BN23 KNIT BEANIE BLACK
39244 TOY MACHINE TMP18CP22 BLACK
39245 TOY MACHINE TMP18CP22 PINK
58158 TOY MACHINE MONSTER T-Shirt BLUE
58591 TOY MACHINE CHARACTERS SS TEE PINK
63213 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BEIGE
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63234 TOY MACHINE (トイマシーン) AXEL SS TEE - PURPLE
63674 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - WHITE
63675 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - ORANGE
63676 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - BLACK
58787 TOY MACHINE (トイマシーン) PPRINT SHORTS BLACK
60806 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - M. GREY
61564 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - WHITE
61691 TOY MACHINE (トイマシーン) OG MONSTER SWEAT PANTS BLACK
58042 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - BLACK
64442 PUNK DRUNKERS x TOY MACHINE 組体操TEE - SUMI
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
41245 TOY MACHINE TMS18TW35 TOWEL BLACK
41246 TOY MACHINE TMS18TW36 TOWEL YELLOW
42930 TOY MACHINE TMJ18HW2 MESH CAP BLACK
42931 TOY MACHINE TMJ18HW2 MESH CAP WHITE
45475 TOY MACHINE TMS19ST10 TOYMONSTER LOGO PRINT SS TEE LIME
45476 TOY MACHINE TMS19ST12 TAPE LOGO PRINT SS TEE WHITE
45477 TOY MACHINE TMS19ST12 TAPE LOGO PRINT SS TEE BLACK
45478 TOY MACHINE TMS19ST12 TAPE LOGO PRINT SS TEE LT.YELLOW
45488 TOY MACHINE TMS19ST21 SQUARE MONSTER PRINT SS TEE WHITE
45489 TOY MACHINE TMS19ST21 SQUARE MONSTER PRINT SS TEE BLACK
45502 TOY MACHINE TMS19ST30 TOYMACHINE LOGO EMBROIDERY TANK TOP WHITE
45503 TOY MACHINE TMS19ST30 TOYMACHINE LOGO EMBROIDERY TANK TOP BLACK
45504 TOY MACHINE TMS19ST31 BRAINWASH GRADATION PRINT TANK TOP WHITE
45505 TOY MACHINE TMS19ST31 BRAINWASH GRADATION PRINT TANK TOP BLACK
69678 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER PURPLE
69679 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER RED
69680 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER ORANGE
64214 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG 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
58586 TOY MACHINE (トイマシーン) STRETCH NYLON POCKET SHORT PANTS BLACK
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
67442 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE BLACK
48461 TOY MACHINE PTM19BG08 PACMAN GAMEOVER SECT BAG N.WHITE
48462 TOY MACHINE PTM19BG08 PACMAN GAMEOVER SECT BAG BLACK
53972 TOY MACHINE TOYMONSTER DOLL - PURPLE
53973 TOY MACHINE TOYMONSTER DOLL - ORANGE
53974 TOY MACHINE TOYMONSTER DOLL - RED
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
58153 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt WHITE
58154 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt BLACK
62611 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - L. BLUE
61216 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - WHITE
61218 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - WHITE
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
62537 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - WHITE
56747 TOY MACHINE BOA FLEECE TOTE BAG - BLACK
58592 TOY MACHINE (トイマシーン) CHARACTERS SS TEE WHITE
63232 TOY MACHINE (トイマシーン) AXEL SS TEE - WHITE
41814 TOY MACHINE TMJ18BG3 mouseketter2 sbg BLACK
42932 TOY MACHINE TMJ18BG3 mouseketter2 sbg WHITE
62609 TOY MACHINE (トイマシーン) ERIC FOUNTAIN HEAVY WEIGHT BIG SS TEE - WHITE
63227 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - WHITE
68245 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG NATURAL
68246 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG GRAY
40863 TOY MACHINE TMS18ST14 POCKET TEE WHITE
54210 TOY MACHINE SKATE SECT TIE-DYE SST - SATURN
55947 TOY MACHINE FIST EMBROIDERY LONG TEE - WHITE
58785 TOY MACHINE (トイマシーン) DESIGN PRINT TEE COTTON CANDY
60296 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - WHITE
61563 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - BLACK
61565 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - GREEN
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
64216 TOY MACHINE×PUNK DRUNKERS AITSU AND TOYMONSTER IN TURTLE HEAD SS TEE - WHITE
67443 TOY MACHINE (トイマシーン) PYRAMID SECT DENIM CAP BLACK