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-26 17:50:38')
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
LIMIT 0, 120
11532 TOY MACHINE MONSTER ARGYLE SOX YE/BL
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
39052 TOY MACHINE TMP18LT1 turtleboy emb ls WHITE
39053 TOY MACHINE TMP18LT2 colintotymachine logo ls WHITE
39054 TOY MACHINE TMP18LT3 dot toymonster ls WHITE
39055 TOY MACHINE TMF17LT2 toymachine logo Long Tee Black
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
39061 TOY MACHINE TMP18BC20 american monster bbc BLACK
39062 TOY MACHINE TMP18BC21 sect eye bbc BLUE
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
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
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
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
39253 TOY MACHINE TMP18SW15 fist po GRAY
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
39966 TOY MACHINE TMFJK2 scribmonster-monster Coach Jacket Black
39967 TOY MACHINE TMFJK2 scribmonster-monster Coach Jacket Burgundy
39968 TOY MACHINE TMFJK2 scribmonster-monster Coach Jacket Green
39969 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Orange
39970 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Charcharl
39971 TOY MACHINE TMF18LT5 toymachine logo Long Tee Black
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
40861 TOY MACHINE TMS18ST13 POCKET TEE BLACK
40862 TOY MACHINE TMS18ST13 POCKET TEE WHITE
40863 TOY MACHINE TMS18ST14 POCKET TEE WHITE
40864 TOY MACHINE TMS18ST14 POCKET TEE BLACK
40865 TOY MACHINE TMS18CP18 BASEBALL CAP BLACK
40866 TOY MACHINE TMS18CP18 BASEBALL CAP BLACK/RED
40867 TOY MACHINE TMP18SX5 SOCKS GREY
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
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
41812 TOY MACHINE TMJ118ST1 mouseketter2 st WHITE
41813 TOY MACHINE TMJ118ST1 mouseketter2 st BLACK
41814 TOY MACHINE TMJ18BG3 mouseketter2 sbg BLACK
41815 TOY MACHINE TMJ18STK4 Sticker assort set (3pak)
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