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-25 15:52:28')
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
LIMIT 0, 180
9419 WE CAME AS ROMANS Truth Black T-Shirt
14181 METALLICA RIDE LYRICS All Over TEE
35286 SLIPKNOT Long Sleeved Tee: Blocks
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
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
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
11214 Iwrestledabearonce Late Crest Black/Heather Crew
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
11217 MISERY SIGNALS Absent Light Navy Zip-Up Hoodie
11219 OF MICE & MEN Wave Faithfulness Black Hooded
11220 WHITECHAPEL Demon Shield Hoodie Black
11231 BLACK VEIL BRIDES Swirl Black
11232 ENTER SHIKARI Fear Not Navy
11234 CAPTURE THE CROWN Woman & Skull Black
11236 WOE IS ME Circus Revenge Black
11237 FOR ALL THOSE SLEEPING The Birds White
11241 ERRA Self Control Black
11242 ENTER SHIKARI Police Natural
11243 ENTER SHIKARI Blue Tour Navy
11245 BLESS THE FALL Tiger Black Tank Top
11246 BREATHE CAROLINA Mammoth Black
11248 PROTEST THE HERO Crest White
11249 PROTEST THE HERO Bird Dive Navy Blue
11250 ESKIMO CALLBOY Hairy Black T-Shirt
11251 MOTIONLESS IN WHITE Mask Black
11252 THE FACELES Autotheism Black Long T-Shirt
11253 WITHIN THE RUINS Hand Black
11254 BLESS THE FALL We Are The Saints Black
11256 MAYDAY PARADE Photo Collage Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11260 I SEE STARS Digital Renegade Black
11261 CHUNK!NO,CAPTAIN CHUNK! Bats Navy
11262 WITHIN THE RUINS Face Black
11277 MAKE ME FAMOUS Lose Your Fear Black
11278 DANGERKIDS CAD Charcoal T-Shirt
11280 PROTEST THE HERO Floating Ship Black
11283 CAPTURE THE CROWN Gargoyle Black
11284 ENTER SHIKARI Stealth Black
11288 BLACK VEIL BRIDES Stitch Black