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 18:51:03')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 83)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 50
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
10233 METALLICA DORIS T-Shirt
700 METALLICA-KILL EM ALL
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
10235 METALLICA VINTAGE METAL UP T-Shirt
70282 METALLICA UNISEX PULLOVER HOODIE: 72 SEASONS CHARRED LOGO (BACK PRINT)
69361 METALLICA UNISEX PULLOVER HOODIE: SKULL SCREAMING RED BLACK
61822 METALLICA UNISEX PULLOVER HOODIE: SKULL FLOWER WASHED
62576 METALLICA FADE TO BLACK DAYPACK BACKPACK
62577 METALLICA FADE TO BLACK SKATE BAG
62579 METALLICA FADE TO BLACK CROSSBODY BAG
62580 METALLICA KILL EM ALL CROSS BODY BAG
62578 METALLICA FADE TO BLACK WALLET
10234 METALLICA RIDE LIGHTNING T-Shirt
61666 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY GARAGE (BACK PRINT)
61668 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY RIPPER
59374 METALLICA UNISEX T-SHIRT: MASTER OF PUPPETS DISTRESSED
62581 METALLICA LIGHTNING SHOULDER BAG
61664 METALLICA UNISEX PULLOVER HOODIE: 40TH ANNIVERSARY SONGS LOGO
61665 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY FORTY YEARS (BACK PRINT)
61667 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY HORSEMEN
61669 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY SONGS LOGO (BACK PRINT)
57796 METALLICA Met Glitch Duck Jacket Jacket
13969 METALLICA KING NOTHING T-Shirt
36787 METALLICA Women's St. Anger Cut Out Babydoll Black
36849 METALLICA Flame Skulls-Black Lightweight T-shirt
55727 METALLICA UNISEX TEE: MASTER OF PUPPETS (BACK PRINT)
5665 METALLICA TIP SCALES T-Shirt
10231 METALLICA NEVER RED T-Shirt
10232 METALLICA NEVERMORE T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
10237 METALLICA TOUR 86 T-Shirt
10238 METALLICA SEEK AND DESTROY 3/4 Sleeve T-Shirt
10239 METALLICA HEART EXPLOSIVE T-Shirt
14170 METALLICA PITTSBURGH ARENA MENS TEE
14171 METALLICA BROWN STRAW MENS TEE
14172 METALLICA KILL EM MENS A/O TEE
14173 METALLICA HARVESTER MENS TEE
14175 METALLICA JUMP IN THE FIRE MENS TEE
14176 METALLICA ONE MENS TEE
14177 METALLICA KILLEM TOUR MENS TEE
14178 METALLICA SEEK WINGS COFFIN MENS TEE
14183 METALLICA JUSTICE GREEN STATUE MENS TEE
14184 METALLICA GOD WAKE ME MENS TEE
17726 METALLICA KILLEM ALL TILTED MENS TEE
17727 METALLICA Puppet Strings All Over T-Shirt
17728 METALLICA PUSHHEAD BORIS MENS TEE
17729 METALLICA MENS TEE