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-26 22:04:05')
AND pc.classcategory_id1 IN( 12,44)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 7
AND `category_type` IS NULL
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
9419 WE CAME AS ROMANS Truth Black T-Shirt
14181 METALLICA RIDE LYRICS All Over TEE
29535 CARCASS UNFIT TEE
35286 SLIPKNOT Long Sleeved Tee: Blocks
39172 KORN Face in the Fire Tanktop
51193 SLIPKNOT UNISEX FASHION TEE: LOGO & STAR (APPLIQUE MOTIFS)
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
595 CHILDREN OF BODOM-Bloody Reaper
910 LINKIN PARK Skull Bird T-Shirt
912 BRING ME THE HORIZON BELANGER T-Shirt
919 The Devil Wears Prada Virus Allover Print T-Shirt
1448 CHILDREN OF BODOM REAPER EARTH T-Shirt
2246 BRING ME THE HORIZON LADY OF LIFE T-Shirt
2251 SLIPKNOT 9 FRAMES T-shirt
2269 BLINK182 3BARS T-shirt
2270 BLINK182 CHAMP T-shirt
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
3064 GREEN DAY NEON WINGS T-shirt
3066 GREEN DAY VANDALS T-Shirt
3156 AVENGED SEVENFOLD SWEET SCREAM T-shirt
3160 CHILDREN OF BODOM REAPER LIGHTNING T-shirt
3410 UNEARTH RIBS T-Shirt
3616 AVENGED SEVENFOLD ALLOVER DEATHBATS T-Shirt
4457 SYSTEM OF A DOWN AERIALS T-Shirt
4596 BLINK182 BOXES T-Shirt
5577 MARILYN MANSON SKULL CROSS T-Shirt
5579 SLIPKNOT MASK HELL T-Shirt
5601 CHELSEA GRIN CROW T-Shirt
5638 OF MICE & MEN EAGLE T-Shirt
5665 METALLICA TIP SCALES T-Shirt
5714 MISS MAY I TIGER T-Shirt
5802 A DAY TO REMEMBER Out Of Time Cards T-Shirt
6021 OF MICE & MEN Faithfulness Black T-Shirt
6022 OF MICE & MEN Ice Age Black
6023 WOE IS ME - Number[s] Stack Black
6423 LINKIN PARK LIVING THINGS T-Shirt
6581 A DAY TO REMEMBER BROKEN RECORD T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
6585 GREEN DAY SPIRAL T-Shirt
6586 GREEN DAY DOOKIE VINTAGE T-Shirt
6621 THE USED CD COVER T-Shirt
6622 THE USED USED COLLAGE FACE T-Shirt
7432 WOE IS ME Griffin Black
7437 CHUNK!NO,CAPTAIN CHUNK! Bear Blue T-Shirt
7439 CHUNK!NO,CAPTAIN CHUNK! Eiffel Tower White T-Shirt
7445 MAYDAY PARADE All I Do Black
7448 ISSUES I Have - Heather Grey
7466 MEMPHIS MAY FIRE Richer Black
7467 MEMPHIS MAY FIRE Crest Black Tank Top
7477 ISSUES These Colors Don't Bleed Black
7495 OF MICE & MEN Wave Black Tank Top
7675 AVENGED SEVENFOLD WORLD DIES T-Shirt
7676 BLINK182 DRIPTYPE T-Shirt
7677 ENTER SHIKARI ALBUM T-Shirt
7682 TOOL CALIFORNIA REPUBLIC T-Shirt
7687 HOLLYWOOD UNDEAD H.U.4.L. T-Shirt
7711 MUSE ECLIPSE T-Shirt
7858 BRING ME THE HORIZON Suicide Season Green T-shirt
7859 BRING ME THE HORIZON Sempiternal Album Tee
7862 BRING ME THE HORIZON Suicide Season Red T-shirt
7952 BRING ME THE HORIZON Suicide Season Tank Top
8336 PARKWAY DRIVE Deep Blue Skyline T-Shirt BLACK
8337 PARKWAY DRIVE Kombi WHITE
8338 PARKWAY DRIVE Anchor Atlas T-Shirt WHITE
8354 PENNYWISE All or Nothing T-Shirt BLACK
8363 CONVERGE Florian White T-Shirt
8377 ALESANA Skeleton Heart T-Shirt BLACK
9022 ISSUES Effing Tri-Heather Gray T-SHIRT
9023 ISSUES Effing Black T-SHIRT
9026 OF MICE & MEN Wave Black T-Shirt
9173 MOTIONLESS IN WHITE America Black T-Shirt
9174 MOTIONLESS IN WHITE Middle Finger Black
9175 MOTIONLESS IN WHITE Chris Photo Black
9176 MOTIONLESS IN WHITE Devil's Night Black
9178 MOTIONLESS IN WHITE Frank White
9179 MOTIONLESS IN WHITE London In Terror Black
9313 MEMPHIS MAY FIRE Identity Navy Blue
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9317 MEMPHIS MAY FIRE Challenger Black T-Shirt
9322 CAPTURE THE CROWN Walking Dead Black
9367 ATTILA Kings Black Tank Top
9369 ATTILA Sugar Skull Black T-Shirt
9372 BLESS THE FALL Lyric Black T-Shirt
9373 BLESS THE FALL Hollow Bodies Album Art White Tank
9374 BLESS THE FALL Moon White T-Shirt
9378 A SKYLIT DRIVE Channels Heather Gray T-Shirt
9382 PIERCE THE VEIL P T V Camo Tank Top
9383 PIERCE THE VEIL Photo Black T-Shirt
9386 CHELSEA GRIN Evolve Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9400 MAYDAY PARADE Heart Photo White T-Shirt
9403 MISS MAY I New Lion Black T-Shirt
9404 SHADOWS FALL Wasteland Black T-Shirt
9409 SLEEPING WITH SIRENS Detailed Feather Whit T-Shirt
9410 SLEEPING WITH SIRENS Feather White T-Shirt
9415 WE CAME AS ROMANS Sideways Black Tank Top
9424 WHITECHAPEL Riot Black T-Shirt
9427 FACELESS Casting The Darkness Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
9432 TEXAS IN JULY One Reality Black T-Shirt
9692 SUICIDAL TENDENCIES ST TS 28 Possessed BLK
10227 ASKING ALEXANDRIA HELL GATE T-Shirt
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10229 AVENGED SEVENFOLD END OF DAYS T-Shirt
10231 METALLICA NEVER RED T-Shirt
10232 METALLICA NEVERMORE T-Shirt
10237 METALLICA TOUR 86 T-Shirt
10238 METALLICA SEEK AND DESTROY 3/4 Sleeve T-Shirt
10239 METALLICA HEART EXPLOSIVE T-Shirt
10241 LINKIN PARK GLITCH PORTRAIT T-Shirt
10245 LAMB OF GOD CANDLELIGHT T-Shirt
10247 HATEBREED WINGED SKULL T-Shirt
10254 NOFX BUZZ T-Shirt
10255 NOFX OLD SKULL T-Shirt
10256 NAPALM DEATH SCUM VINTAGE T-Shirt
10257 GUNS N' ROSES APPETITE TOUR T-Shirt