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 02:43:21')
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 300, 75
57222 TOY MACHINE CLAIRVOYANT BB CAP - WHITE
57108 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE WHITE
57109 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE BLACK
57110 TOY MACHINE SECT STAFF GRADATION LONG TEE WHITE
57111 TOY MACHINE SECT STAFF GRADATION LONG TEE BLACK
57112 TOY MACHINE CLAIRVOYANT LONG TEE WHITE
57113 TOY MACHINE CLAIRVOYANT LONG TEE NEON YELLOW
57114 TOY MACHINE CLAIRVOYANT LONG TEE BLACK
57115 TOY MACHINE WELCOME TO HELL LONG TEE BLACK
56744 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - WHITE/BLACK
56745 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - BLACK/BURGANDY
56746 TOY MACHINE BOA FLEECE TOTE BAG - WHITE
56747 TOY MACHINE BOA FLEECE TOTE BAG - BLACK
56229 TOY MACHINE PEPPER SECT CORDUROY JACKET - BEIGE
56228 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BEIGE
56227 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BLACK
56231 TOY MACHINE FRONT POCKET ZIP SHIRTS - BLACK
56265 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - MIX GREY
56266 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - BLACK
56268 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - WHITE
56270 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - BLACK
56269 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - SAND
56223 TOY MACHINE TOYDIVISION PRINT SWEAT CREW - MIX GREY
56225 TOY MACHINE TOYMONSTER EMBROIDERY SWEAT CREW - SAND
56226 TOY MACHINE TOYMONSTER EMBROIDERY SWEAT CREW - 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
56224 TOY MACHINE TOYDIVISION PRINT SWEAT CREW - BLACK
56230 TOY MACHINE PEPPER SECT CORDUROY JACKET - BLACK
56267 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - BLACK
55946 TOY MACHINE FIST EMBROIDERY LONG TEE - BLACK
55947 TOY MACHINE FIST EMBROIDERY LONG TEE - WHITE
55948 TOY MACHINE MONSTER MARKED EMBROIDERY LONG TEE - BLACK
55949 TOY MACHINE MONSTER MARKED EMBROIDERY LONG TEE - WHITE
55945 TOY MACHINE TOYMONSTER BB CAP - BLACK
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