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-11 20:51:41')
AND pc.classcategory_id1 IN( 14,61,35)
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 DESC
LIMIT 0, 180
26134 BRING ME THE HORIZON Sickle Zip Hoodie
35502 SLIPKNOT Blocks T-Shirt
10233 METALLICA DORIS T-Shirt
10235 METALLICA VINTAGE METAL UP T-Shirt
1097 RED HOT CHILI PEPPERS Asterisk Logo White
585 RED HOT CHILI PEPPERS Asterisk Logo Black
10258 GUNS N' ROSES CROSS T-Shirt
4598 NIRVANA Happy Face T-Shirt
4599 NIRVANA MANY Happy Face T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
42575 RED HOT CHILI PEPPERS DISTRESSED OUTLINED LOGO TEE
35589 BRING ME THE HORIZON The H T-Shirts
36768 NIRVANA Happy Face Striped-Ugly Sweater
10234 METALLICA RIDE LIGHTNING T-Shirt
35655 PANTERA Red Vulgar T-Shirts
12067 PANTERA HOSTILE SKULL T-Shirt
37586 MEGADETH -Dystopia-Black t-shirt
36680 MEGADETH DYSTOPIA
36532 BRING ME THE HORIZON -Sempiternal- Black T-Shirt
35292 SLIPKNOT PAUL GRAY
35660 PANTERA 101 Proof Sweatshirts
35659 PANTERA Original Cover T-Shirts
35535 BULLET FOR MY VALENTINE Long Sleeved Tee: Temper Temper Gas Mask
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
35635 KORN SKULLDELIS T-SHIRTS
35288 SLIPKNOT Antennas to Hell
35295 SLIPKNOT WAVES
10259 GUNS N' ROSES DISTRESSED BULLET
35637 KORN STAGE T-SHIRTS
26295 FALLING IN REVERSE X RAY CAT
15470 CROWN THE EMPIRE Beak White T-Shirt
57802 FEVER333 Black Cat Fever Tee T-shirt
35566 BRING ME THE HORIZON CANYON T-Shirts
12020 EVANESCENCE SHINE T-Shirt
13969 METALLICA KING NOTHING T-Shirt
36849 METALLICA Flame Skulls-Black Lightweight T-shirt
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
1364 RANCID Out Come The Wolves Slim-Fit 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
2647 Iwrestledabearonce Claw Black 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
4349 ENTER SHIKARI Destabilize Tour Black
4457 SYSTEM OF A DOWN AERIALS T-Shirt
4596 BLINK182 BOXES T-Shirt
4671 KORN CLASSIC 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
6145 PROTEST THE HERO Don't Judge A Band White W/ Black
6147 THE WORD ALIVE Minotaur 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
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
7506 MAYDAY PARADE Meowday Purrrade Black
7675 AVENGED SEVENFOLD WORLD DIES T-Shirt
7676 BLINK182 DRIPTYPE T-Shirt
7677 ENTER SHIKARI ALBUM T-Shirt
7685 RED HOT CHILI PEPPERS FLY T-Shirt
7687 HOLLYWOOD UNDEAD H.U.4.L. 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
8211 OUR LAST NIGHT Evolution Heather GRY/BLK
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
9401 MISERY SIGNALS Eagle Flame BlackT-Shirt
9402 MISS MAY I New Lion Black Tank Top
9403 MISS MAY I New Lion Black T-Shirt
9404 SHADOWS FALL Wasteland Black T-Shirt
9410 SLEEPING WITH SIRENS Feather White T-Shirt
9415 WE CAME AS ROMANS Sideways Black Tank Top
9421 WE CAME AS ROMANS I Am Alive Black/White Baseball
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
9433 OH SLEEPER Endseekers 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
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
10245 LAMB OF GOD CANDLELIGHT T-Shirt
10247 HATEBREED WINGED SKULL T-Shirt
10253 MESHUGGAH CATCH 33 T-Shirt
10254 NOFX BUZZ T-Shirt
10255 NOFX OLD SKULL T-Shirt
10256 NAPALM DEATH SCUM VINTAGE T-Shirt
10260 RANCID 40 oz T-Shirt
10261 RANCID MONSTER PRINT T-Shirt
10262 PARKWAY DRIVE BAY CREST T-Shirt
10264 FIVE FINGER DEATH PUNCH WOTF NINJA T-Shirt
10266 FIVE FINGER DEATH PUNCH THE WAY T-Shirt
10270 FALLING IN REVERSE MEDUSA T-Shirt
10271 GREEN DAY PATCHWORK T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
10273 IRON MAIDEN OVERSIZED TROOPER Large Print T-Shirt
10310 ESKIMO CALLBOY Cinema T-Shirt
10311 ESKIMO CALLBOY Polar Bear T-Shirt
10312 ESKIMO CALLBOY Puke Girl T-Shirt
11159 BLESS THE FALL Anchor Hoodie Black
11160 MEMPHIS MAY FIRE Shield Heather Hooded
11161 MEMPHIS MAY FIRE Opportunity Black
11162 MEMPHIS MAY FIRE Crest Black Hooded
11164 MOTIONLESS IN WHITE We're Here To Stay Hoodie
11168 PROTEST THE HERO Vulture Black Crewneck
11169 PROTEST THE HERO Vulture Black Hooded
11170 PROTEST THE HERO Bird Dive Black Crewneck
11204 ATTILA Death Is Calling Hoodie Black
11205 BLACK VEIL BRIDES Skyline Hoodie Black
11208 ENTER SHIKARI Skankers Hoodie Black
11210 THE FACELESS Autotheism Hoodie Black
11212 I SEE STARS Logo Black Hoodie