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 04:17:03')
AND pc.classcategory_id1 IN( 11)
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)
LIMIT 0, 120
45473 TOY MACHINE TMS20ST9 TOYMONSTER LOGO PRINT SS TEE WHITE
45474 TOY MACHINE TMS20ST9 TOYMONSTER LOGO PRINT SS TEE BLACK
53162 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE BLACK
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
58589 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE WHITE
58590 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE BLACK
63007 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - WHITE
60301 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - WHITE
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
63212 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - BLACK
54209 TOY MACHINE SKATE SECT TIE-DYE SST - PINK
57108 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE WHITE
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
58157 TOY MACHINE MONSTER T-Shirt BLACK
58159 TOY MACHINE MONSTER T-Shirt WHITE
58027 TOY MACHINE OG MONSTER PRINT LONG TEE - WHITE
58155 TOY MACHINE (トイマシーン) TURTLEBOY T-Shirt WHITE
63004 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - WHITE
63008 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - SAND
63009 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - BLACK
61687 TOY MACHINE (トイマシーン) FLAME FIST SWEAT HOODY NATURAL
61688 TOY MACHINE (トイマシーン) FLAME FIST SWEAT HOODY NAVY
61562 TOY MACHINE (トイマシーン) TURTLE HEAD LONG TEE - WHITE
65339 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-WHITE
65388 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-INDIGO BLUE
67441 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE WHITE
60535 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SWEAT CREW - BLACK
60538 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SWEAT CREW - PURPLE
60805 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - BLACK
60807 TOY MACHINE (トイマシーン) TOYDIVISION SWEAT PARKA - BLACK
61690 TOY MACHINE (トイマシーン) EYES SWEAT HOODY BLACK
64216 TOY MACHINE×PUNK DRUNKERS AITSU AND TOYMONSTER IN TURTLE HEAD SS TEE - WHITE
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
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
62609 TOY MACHINE (トイマシーン) ERIC FOUNTAIN HEAVY WEIGHT BIG SS TEE - WHITE
63227 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - WHITE
58592 TOY MACHINE (トイマシーン) CHARACTERS SS TEE WHITE
63232 TOY MACHINE (トイマシーン) AXEL SS TEE - WHITE
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
62537 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - WHITE
61216 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - WHITE
61218 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - WHITE
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
67442 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE BLACK
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
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
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
64442 PUNK DRUNKERS x TOY MACHINE 組体操TEE - SUMI
61564 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - WHITE
58787 TOY MACHINE (トイマシーン) PPRINT SHORTS BLACK
60806 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - M. GREY
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
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
39052 TOY MACHINE TMP18LT1 turtleboy emb ls WHITE
39054 TOY MACHINE TMP18LT3 dot toymonster ls WHITE
39056 TOY MACHINE TMP18LT6 axel boardslide ls WHITE
39083 TOY MACHINE TMP18LT3 dot toymonster ls BLACK
39084 TOY MACHINE TMP18LT3 dot toymonster ls ORANGE
39085 TOY MACHINE TMP18LT6 dot toymonster ls BLACK
39282 TOY MACHINE TMP18ST12 fist st white
39283 TOY MACHINE TMP18ST12 fist st navy
39284 TOY MACHINE TMP18ST12 fist st pink
40468 TOY MACHINE TMS18ST3 colin provost secxt attack ss
40469 TOY MACHINE TMS18ST3 colin provost secxt attack ss Black
40470 TOY MACHINE TMS18ST3 colin provost secxt attack ss Lime
42921 TOY MACHINE TMF18LT4 FIST_M LST WHITE
42922 TOY MACHINE TMF18LT4 FIST_M LST BLACK
42923 TOY MACHINE TMF18LT4 FIST_M LST PURPLE
42924 TOY MACHINE TMF18LT5 TOYMONSTER MARKED WHITE
42925 TOY MACHINE TMF18LT5 TOYMONSTER MARKED BLACK
42926 TOY MACHINE TMF18LT6 SECT_W LST WHITE
42927 TOY MACHINE TMF18LT6 SECT_W LST BLACK