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-05-20 09:57:10')
AND pc.classcategory_id1 IN( 13,35,44)
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, 60
52930 TOY MACHINE TMBT02 WIDE EASY PANTS BEIGE
52931 TOY MACHINE TMBT02 WIDE EASY PANTS BLACK
52932 TOY MACHINE TMP20LT19 L/S T-Shirt WHITE
52933 TOY MACHINE TMP20LT19 L/S T-Shirt BLACK
53162 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE BLACK
53163 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE ORANGE
53970 TOY MACHINE SKATE DATE SST (BIG SIZE) - WHITE
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK
54202 TOY MACHINE NEON PRINT SS SHIRT - WINE
54203 TOY MACHINE NEON PRINT SS SHIRT - BLACK
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
54206 TOY MACHINE PRINT POCKET SST (BIG SIZE) - WHITE
54207 TOY MACHINE PRINT POCKET SST (BIG SIZE) - BLACK
54208 TOY MACHINE SKATE SECT TIE-DYE SST - BLAST
54209 TOY MACHINE SKATE SECT TIE-DYE SST - PINK
54210 TOY MACHINE SKATE SECT TIE-DYE SST - SATURN
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
56227 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BLACK
56228 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BEIGE
56230 TOY MACHINE PEPPER SECT CORDUROY JACKET - 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
56267 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - BLACK
56268 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - WHITE
56269 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - SAND
56270 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - BLACK
56744 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - WHITE/BLACK
56745 TOY MACHINE BOA FLEECE REVERSIBLE JACKET - BLACK/BURGANDY
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
57114 TOY MACHINE CLAIRVOYANT LONG TEE BLACK
57115 TOY MACHINE WELCOME TO HELL LONG TEE BLACK
57218 TOY MACHINE MARBLE PATTERN FIST COACH JACKET - BLACK
57219 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - BLACK
57220 TOY MACHINE BURY THE HATCHET EMBROIDERY COACH JACKET - KHAKI
57317 TOY MACHINE LOYAL PAWN BOMBER JACKET(OLIVE)
57318 TOY MACHINE LOYAL PAWN BOMBER JACKET(BLACK)
58022 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BEIGE
58023 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BLACK
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
58025 TOY MACHINE ED MONSTER PRINT LONG TEE - WHITE
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
58027 TOY MACHINE OG MONSTER PRINT LONG TEE - WHITE
58028 TOY MACHINE OG MONSTER PRINT LONG TEE - BLACK
58030 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - BLACK
58031 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - TAN
58032 TOY MACHINE DEAD MONSTER EMBROIDERY SWEAT CREW NECK - BLACK
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
58034 TOY MACHINE MONSTER 3/4 SLEEVE TEE-BLACK
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58153 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt WHITE
58154 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt BLACK