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-20 21:49:28')
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 p.update_date
LIMIT 0, 120
45484 TOY MACHINE TMS19ST17 SECT PROTOP PRINT SS TEE BLACK
39052 TOY MACHINE TMP18LT1 turtleboy emb ls WHITE
39053 TOY MACHINE TMP18LT2 colintotymachine logo ls WHITE
39054 TOY MACHINE TMP18LT3 dot toymonster ls WHITE
39056 TOY MACHINE TMP18LT6 axel boardslide ls WHITE
39057 TOY MACHINE TMP18SWT17 tm sect cn PURPLE
39058 TOY MACHINE TMP18SW14 bloodsucking po TURQUOISE
39059 TOY MACHINE TMP18SW15 fist po BLACK
39060 TOY MACHINE TMP18JK18 toymach jk BLACK
39079 TOY MACHINE TMP18LT1 turtleboy emb ls BLACK
39080 TOY MACHINE TMP18LT1 turtleboy emb ls PURPLE
39081 TOY MACHINE TMP18LT2 colintotymachine logo ls BLACK
39082 TOY MACHINE TMP18LT2 colintotymachine logo ls PINK
39083 TOY MACHINE TMP18LT3 dot toymonster ls BLACK
39084 TOY MACHINE TMP18LT3 dot toymonster ls ORANGE
39085 TOY MACHINE TMP18LT6 dot toymonster ls BLACK
39086 TOY MACHINE TMP18SWT17 tm sect cn BLACK
39087 TOY MACHINE TMP18SWT17 tm sect cn MIX GRAY
39088 TOY MACHINE TMP18SW14 bloodsucking po NAVY
39089 TOY MACHINE TMP18SW14 bloodsucking po BLACK
39090 TOY MACHINE TMP18SW15 fist po YELLOW
39207 TOY MACHINE TMP18JK26 TRACK JACKET BLACK
39208 TOY MACHINE TMP18JK26 TRACK JACKET NAVY
39209 TOY MACHINE TMP18PT27 TRACK PANTS BLACK
39210 TOY MACHINE TMP18PT27 TRACK PANTS NAVY
39211 TOY MACHINE TMP18PT28 TRACK PANTS BLACK
39212 TOY MACHINE TMP18PT28 TRACK PANTS NAVY
39213 TOY MACHINE TMP18JK31 ANORAK JACKET WHITE
39214 TOY MACHINE TMP18JK31 ANORAK JACKET NAVY
39215 TOY MACHINE TMP18JK32 ANORAK JACKET ORANGE
39216 TOY MACHINE TMP18JK32 ANORAK JACKET BLACK
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
39282 TOY MACHINE TMP18ST12 fist st white
39283 TOY MACHINE TMP18ST12 fist st navy
39284 TOY MACHINE TMP18ST12 fist st pink
39444 TOY MACHINE TMP18JK25 TRACK JACKET BLACK
39445 TOY MACHINE TMP18JK25 TRACK JACKET SAX
39524 TOY MACHINE TMP18JK19 toymach jk BLACK
39525 TOY MACHINE TMP18JK19 toymach jk BURGUNDY
39975 TOY MACHINE Longsleeve tee 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
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
40603 TOY MACHINE TMP18JK32 ANORAK JACKET NAVY
40605 TOY MACHINE TMP18JK31 ANORAK JACKET BLACK
40973 TOY MACHINE TMS19SH33 PRINT SHIRT BLACK
40974 TOY MACHINE TMS18SP21 PRINT SHORT PANTS BLACK
40975 TOY MACHINE TMS19SH34 PRINT SHIRT BLACK
40976 TOY MACHINE TMS19SH34 PRINT SHIRT GOLD
41239 TOY MACHINE TMS18ST24 PIGMENT PRINT TEE WHITE
41240 TOY MACHINE TMS18ST24 PIGMENT PRINT TEE BLACK
41812 TOY MACHINE TMJ118ST1 mouseketter2 st WHITE
41813 TOY MACHINE TMJ118ST1 mouseketter2 st BLACK
42919 TOY MACHINE TMF18LT1 SECT_W LST BLACK
42920 TOY MACHINE TMF18LT1 SECT_W LST ORANGE
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
42928 TOY MACHINE TMF18LT6 SECT_W LST PINK
42929 TOY MACHINE TMF18LT1 SECT_W LST WHITE
43295 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA WHITE
43296 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA BLACK
43299 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA RED
43300 TOY MACHINE TMF18SW9 SQUARE MONSTER SWEAT PARKA BLACK
43302 TOY MACHINE TMF18SW9 SQUARE MONSTER SWEAT PARKA WHITE
43304 TOY MACHINE TMF18SW9 SQUARE MONSTER SWEAT PARKA GRAY
43306 TOY MACHINE TMF18SW10 DOUBLE MOUSEKATER SWEAT PARKA WHITE
43308 TOY MACHINE TMF18SW10 DOUBLE MOUSEKATER SWEAT PARKA BLACK
43309 TOY MACHINE TMF18SW12 TAPE LOGO SWEAT CREW BLACK
43311 TOY MACHINE TMF18SW12 TAPE LOGO SWEAT CREW WHITE
43413 TOY MACHINE TMF18JK14 SECT PROTOP COACH JACKET - BLACK
43414 TOY MACHINE TMF18JK15 SKETCHY MONSTER COACH JACKET PARKA - BLACK
43415 TOY MACHINE TMF18JK16 EF LOGO ANORAK PARKA - BLACK
43416 TOY MACHINE TMF18JK16 EF LOGO ANORAK PARKA - NAVY / GREEN
43417 TOY MACHINE TMF18JK17 FIST LOGO ANORAK PARKA - BLACK
43418 TOY MACHINE TMF18JK17 FIST LOGO ANORAK PARKA - NAVY
43623 TOY MACHINE TMF18JK18 BOA FLEECE JACKET BLACK
43624 TOY MACHINE TMF18JK18 BOA FLEECE JACKET GRAY
43625 TOY MACHINE TMF18JK19 BOMBER JACKET BLACK
43626 TOY MACHINE TMF18JK19 BOMBER JACKET OLIVE
43627 TOY MACHINE TMF18JK20 BOMBER JACKET (REVERSIBLE) BLACK
43628 TOY MACHINE TMF18JK20 BOMBER JACKET (REVERSIBLE) OLIVE
43629 TOY MACHINE TMF18JK21 COACH JACKET(INSULATION) BLACK
43630 TOY MACHINE TMF18JK21 COACH JACKET(INSULATION) NAVY
45130 TOY MACHINE TMP19LT3 TAPE LOGO PT LT(LONG TEE) WHITE
45131 TOY MACHINE TMP19LT3 TAPE LOGO PT LT(LONG TEE) BLACK
45132 TOY MACHINE TMP19LT3 TAPE LOGO PT LT(LONG TEE) GRAY
45133 TOY MACHINE TMP19LT5 SKATE DATE PT LT(LONG TEE) WHITE
45134 TOY MACHINE TMP19LT5 SKATE DATE PT LT(LONG TEE) BLACK
45135 TOY MACHINE TMP19LT5 SKATE DATE PT LT(LONG TEE) RED
45136 TOY MACHINE TMP19LT6 SECT ATTACK PT LT(LONG TEE) WHITE
45137 TOY MACHINE TMP19LT6 SECT ATTACK PT LT(LONG TEE) BLACK
45138 TOY MACHINE TMP19LT6 SECT ATTACK PT LT(LONG TEE) NAVY
45139 TOY MACHINE TMP19JK7 SECT EYE COACH JACKET WHITE
45140 TOY MACHINE TMP19JK7 SECT EYE COACH JACKET BLACK
45433 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE WHITE
45434 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE BLACK
45437 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE PINK
45438 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE YELLOW
45442 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE LIME
45449 TOY MACHINE TMS19ST3 DUMPSTER PRINT SS TEE WHITE
45451 TOY MACHINE TMS19ST3 DUMPSTER PRINT SS TEE BLACK
45453 TOY MACHINE TMS19ST3 DUMPSTER PRINT SS TEE LT.BLUE
45454 TOY MACHINE TMS19ST6 ORIGINAL MONSTER PRINT SS POCKET TEE WHITE
45460 TOY MACHINE TMS19ST6 ORIGINAL MONSTER PRINT SS POCKET TEE BLACK
45473 TOY MACHINE TMS20ST9 TOYMONSTER LOGO PRINT SS TEE WHITE