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-19 11:32:20')
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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, 120
70904 TOY MACHINE (トイマシーン) OG MONSTER DENIM BUCKET HAT BLACK
70903 TOY MACHINE (トイマシーン) OG MONSTER DENIM BUCKET HAT Light Wash
69714 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY BEANIE OLIVE
69713 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY BEANIE BLACK
69712 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY BEANIE PURPLE
70514 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP RED
70515 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP GRAY
70513 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP BLACK
69711 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY BEANIE BLACK
69679 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER RED
69680 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER ORANGE
69678 TOY MACHINE (トイマシーン) TOYMONSTER PUPPET DOLL KEYHOLDER PURPLE
69219 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY TWILL HAT NAVY
69218 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY TWILL HAT BLACK
68244 TOY MACHINE (トイマシーン) TOYMONSTER PIGMENT 2 TONE CAP BLACK
67443 TOY MACHINE (トイマシーン) PYRAMID SECT DENIM CAP BLACK
67440 TOY MACHINE (トイマシーン) PYRAMID SECT DENIM CAP BLUE
66959 TOY MACHINE (トイマシーン) OG MONSTER BB CAP BLACK/RED
65946 TOY MACHINE (トイマシーン) PYRAMID SECT CORDUROY HAT-NAVY
65947 TOY MACHINE (トイマシーン) PEPPER SECT CORDEUROY HAT-BLACK
68246 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG GRAY
68245 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG NATURAL
66781 TOY MACHINE (トイマシーン) MARKED MONSTER SIX PANEL CAP(NAVY)
65948 TOY MACHINE (トイマシーン) OG MONSTER PU LEATHER HAT-BLACK
64220 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG MESH CAP - BLACK
64221 TOY MACHINE×PUNK DRUNKERS AITSU AND FIST NYLON HAT - BLACK
63209 TOY MACHINE (トイマシーン) HIROTTON COLLABO HAT SECT SHARK - BEIGE
63210 TOY MACHINE (トイマシーン) HIROTTON COLLABO HAT SECT SHARK - BLACK
62540 TOY MACHINE (トイマシーン) TM & EYE BB CAP - BLACK
62539 TOY MACHINE (トイマシーン) TM & EYE BB CAP - PURPLE
61692 TOY MACHINE (トイマシーン) FLAME FIST BB CAP BLACK
61693 TOY MACHINE (トイマシーン) FLAME FIST BB CAP RED
60808 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BLACK
60809 TOY MACHINE (トイマシーン) OG MONSTER BEANIE - BROWN
60303 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BEIGE
60304 TOY MACHINE (トイマシーン) TOYMONSTER CAT BB CAP - BLACK
58783 TOY MACHINE BUCKET HAT BLACK
58780 TOY MACHINE BUCKET HAT BLACK
58582 TOY MACHINE SECT EYE MESH CAP ORANGE
58583 TOY MACHINE SECT EYE MESH CAP BLACK
58041 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - ORANGE
58042 TOY MACHINE TOYMONSTER HELLO KITTY EMB BEANIE - 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
57319 TOY MACHINE NEW BLOOD LOGO SIX PANEL CAP(SMOKE PINK)
57320 TOY MACHINE FLAME FIST MEBROIDERY SIX PANEL CAP(GREEN TEA)
57221 TOY MACHINE CLAIRVOYANT BB CAP - BLACK
57222 TOY MACHINE CLAIRVOYANT BB CAP - WHITE
56746 TOY MACHINE BOA FLEECE TOTE BAG - WHITE
56747 TOY MACHINE BOA FLEECE TOTE BAG - BLACK
56271 TOY MACHINE BOA FLEECE BUCKET HAT BLACK
56272 TOY MACHINE BOA FLEECE BUCKET HAT WHITE
56262 TOY MACHINE MONSTER MARKED EMBROIDERY BEANIE - BLACK
56263 TOY MACHINE FIST EMBROIDERY BEANIE - BLACK
56264 TOY MACHINE SECT WAX EMBROIDERY BEANIE - BLACK
56273 TOY MACHINE GROCERY BAG - BLACK
56274 TOY MACHINE GROCERY BAG - YELLOW
55945 TOY MACHINE TOYMONSTER BB CAP - BLACK
11532 TOY MACHINE MONSTER ARGYLE SOX YE/BL
39061 TOY MACHINE TMP18BC20 american monster bbc BLACK
39062 TOY MACHINE TMP18BC21 sect eye bbc BLUE
39091 TOY MACHINE TMP18BC20 american monster bbc WHITE
39092 TOY MACHINE TMP18BC21 sect eye bbc NAVY
39205 TOY MACHINE TMP18BN23 KNIT BEANIE BLACK
39206 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Purple
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
39244 TOY MACHINE TMP18CP22 BLACK
39245 TOY MACHINE TMP18CP22 PINK
39251 TOY MACHINE TMP18SX4 WHITE/BLACK
39252 TOY MACHINE TMP18SX5 WHITE
39969 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Orange
39970 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Charcharl
40865 TOY MACHINE TMS18CP18 BASEBALL CAP BLACK
40866 TOY MACHINE TMS18CP18 BASEBALL CAP BLACK/RED
40867 TOY MACHINE TMP18SX5 SOCKS GREY
41241 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP BLACK
41242 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP GRAY
41243 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP RED
41244 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP GREEN
41245 TOY MACHINE TMS18TW35 TOWEL BLACK
41246 TOY MACHINE TMS18TW36 TOWEL YELLOW
41814 TOY MACHINE TMJ18BG3 mouseketter2 sbg BLACK
41815 TOY MACHINE TMJ18STK4 Sticker assort set (3pak)
42930 TOY MACHINE TMJ18HW2 MESH CAP BLACK
42931 TOY MACHINE TMJ18HW2 MESH CAP WHITE
42932 TOY MACHINE TMJ18BG3 mouseketter2 sbg WHITE
45141 TOY MACHINE TMP19HW12 PYLAMID SECT EBRO CAP BLACK
45142 TOY MACHINE TMP19HW12 PYLAMID SECT EBRO CAP RED
45471 TOY MACHINE TMS19HW8 MONSTER MARKED EMBROIDERY CAP CHARCOAL
45472 TOY MACHINE TMS19HW8 MONSTER MARKED EMBROIDERY CAP GOLD
45490 TOY MACHINE TMS19HW23 TAPE LOGO EMBROIDERY CAP BLACK
45491 TOY MACHINE TMS19HW23 TAPE LOGO EMBROIDERY CAP BEIGE
45492 TOY MACHINE TMS19HW24 MONSTER MARKED EMBROIDERY HAT BEIGE
45493 TOY MACHINE TMS19HW24 MONSTER MARKED EMBROIDERY HAT BLACK
45587 TOY MACHINE TMP19HW21 DISTRESSED TOY EMBRO CAP BLACK
45588 TOY MACHINE TMP19HW21 DISTRESSED TOY EMBRO CAP NAVY
46214 TOY MACHINE TMP19HW29 COLLIN TOY LOGO EMBRO CAP - NAVY
46215 TOY MACHINE TMP19HW29 COLLIN TOY LOGO EMBRO CAP - GRAY
46216 TOY MACHINE TMP19HW30 SECT WAX EMBRO CAP - BLACK
48458 TOY MACHINE PTM19HW06 PACMAN GAMEOVER SECT CAP BLACK
48459 TOY MACHINE PTM19HW06 PACMAN GAMEOVER SECT CAP NAVY
48460 TOY MACHINE PTM19HW07 PACMAN PACMONSTER TM CAP BLACK
48461 TOY MACHINE PTM19BG08 PACMAN GAMEOVER SECT BAG N.WHITE
48462 TOY MACHINE PTM19BG08 PACMAN GAMEOVER SECT BAG BLACK
50460 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつCAP BLACK
50462 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつステッカー WHITE
50463 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつステッカー P.ORANGE
51208 TOY MACHINE TMF19HW24 BLOOD SUCKING BEANIE BLACK
51209 TOY MACHINE TMF19HW24 BLOOD SUCKING BEANIE F.GREEN
51210 TOY MACHINE TMF19HW24 BLOOD SUCKING BEANIE GOLD
51211 TOY MACHINE TMF19HW17 EMBRO CORDY CAP BLACK
51212 TOY MACHINE TMF19HW17 EMBRO CORDY CAP TAN