SELECT SQL_CALC_FOUND_ROWS 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-25 15:36:18')
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
50462 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつステッカー WHITE
50463 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつステッカー P.ORANGE
41815 TOY MACHINE TMJ18STK4 Sticker assort set (3pak)
11532 TOY MACHINE MONSTER ARGYLE SOX YE/BL
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
57320 TOY MACHINE FLAME FIST MEBROIDERY SIX PANEL CAP(GREEN TEA)
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
60809 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BROWN
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
58782 TOY MACHINE (トイマシーン) DESIGN PRINT TEE PINK
58784 TOY MACHINE (トイマシーン) DESIGN PRINT TEE FUNNEL CAKE
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
39217 TOY MACHINE TMP18SX1 WHITE
39218 TOY MACHINE TMP18SX1 BLACK
39239 TOY MACHINE TMP18SX2 BLACK
39240 TOY MACHINE TMP18SX2 WHITE
39241 TOY MACHINE TMP18SX3 WHITE
39242 TOY MACHINE TMP18SX3 PINK
39243 TOY MACHINE TMP18SX6 WHITE
39251 TOY MACHINE TMP18SX4 WHITE/BLACK
39252 TOY MACHINE TMP18SX5 WHITE
40867 TOY MACHINE TMP18SX5 SOCKS GREY
62539 TOY MACHINE (トイマシーン) TM & EYE BB CAP - PURPLE
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
56273 TOY MACHINE GROCERY BAG - BLACK
56274 TOY MACHINE GROCERY BAG - YELLOW
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
61692 TOY MACHINE (トイマシーン) FLAME FIST BB CAP BLACK
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
67443 TOY MACHINE (トイマシーン) PYRAMID SECT DENIM CAP 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
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
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
56747 TOY MACHINE BOA FLEECE TOTE BAG - BLACK
58592 TOY MACHINE (トイマシーン) CHARACTERS SS TEE WHITE
63232 TOY MACHINE (トイマシーン) AXEL SS 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
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
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
67442 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE 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
58586 TOY MACHINE (トイマシーン) STRETCH NYLON POCKET SHORT PANTS 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
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