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-23 18:47:57')
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 180, 180
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
11295 SECRETS Floral Skull Black
11296 THE DEVIL WEARS PRADA Trooper Slate Gray
11299 I SEE STARS Wolf Black
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11303 MEMPHIS MAY FIRE Richer Black Tank Top
11304 MISERY SIGNALS Absent Light Cover Art Black
11305 ENTER SHIKARI Band Charcoal
11308 MOTIONLESS IN WHITE Grim Reaper Black
11310 MOTIONLESS IN WHITE Puppet Black
11311 ENTER SHIKARI Return To Black
11418 CAPTURE THE CROWN Don't Be A... Black
11419 CAPTURE THE CROWN Doggie Black
11422 BLESS THE FALL Hollow Bodies White T-Shirt
11423 ESKIMO CALLBOY Established Black
11424 OF MICE & MEN Restoring Force Album Heather GRY
11427 IWRESTLEDABEARONCE Letters To Stallone Black
11428 MISERY SIGNALS Rebirth Denim Blue
11429 LIKE MOTHS TO FLAMES Fuck This Life Black
11431 CROWN THE EMPIRE End Of The World Black
11432 WHITECHAPEL Priest Black T-Shirt
11433 CHUNK!NO,CAPTAIN CHUNK! Story Black
11434 ERRA Augment Album Art White T-Shirt
11436 ATTILA Reaper Navy/Heather Tank Top
11437 ATTILA Double Skull Black
11439 PROTEST THE HERO Dog Black T-Shirt
11440 TEXAS IN JULY Bed Of Nails Black
11441 MAYDAY PARADE Keyhole Black / White
11443 CROWN THE EMPIRE Skull Book Green Black
11444 PROTEST THE HERO Vulture Black T-Shirt
11449 ATTILA Punisher Black
11451 TEXAS IN JULY Without A Head! Black
11454 THE WORD ALIVE I'd Rather Die Black
11456 WE CAME AS ROMANS Tracing Back Roots Black TankTop
11459 LIKE MOTHS TO FLAMES Middle Finger Black Tank Top
11460 I SEE STARS Billboard Black T-Shirt
11901 ASKING ALEXANDRIA EAGLE T-Shirt
11929 AC/DC BACK IN BLACK 4 T-Shirt
11932 AC/DC THUNDER LOGO T-Shirt
11935 ALTER BRIDGE BAND PHOTO T-Shirt
11936 AMON AMARTH FIRE HORSES T-Shirt
11937 AMON AMARTH DECEIVER ALBUM T-Shirt
11938 AMON AMARTH SHIELD WALL T-Shirt
11939 AMON AMARTH LOGO RUNE T-Shirt
11981 ANDREW W.K. RED AND BLACK T-Shirt
11982 ANTHRAX PERSISTENCE T-Shirt
11986 AVENGED SEVENFOLD POWER TOUR T-Shirt
11988 BAD RELIGION GUITAR PEDAL T-Shirt
11990 BETWEEN THE BURIED AND ME CIRCUS T-Shirt
11991 BLACK VEIL BRIDES STILL T-Shirt
11994 CANNIBAL CORPSE FOLLOWED HOME T-Shirt
12012 CARCASS STEEL CASEUS T-Shirt
12016 CRADLE OF FILTH WHORING DARKNESS T-Shirt
12017 CRADLE OF FILTH DARKLY 2 T-Shirt
12019 EMMURE BRIDE T-Shirt
12021 FEAR FACTORY MIND KILLER T-Shirt
12022 FEAR FACTORY DEMANUFACTURE T-Shirt
12025 MEGADETH VIC CANISTER T-Shirt
12026 MEGADETH EXPLODING VIC T-Shirt
12027 MEGADETH ZOMBIE GROUP T-Shirt
12028 MEGADETH RED BONES T-Shirt
12037 GUNS N' ROSES FLAG T-Shirt
12057 MISFITS LARGE SKULL LOGO T-Shirt
12061 NIGHTWISH VEHICLE T-Shirt
12062 NIRVANA GALAXY IN UTERO T-Shirt
12065 OF MICE & MEN GRADIENT LOGO T-Shirt
12066 OF MICE & MEN SNAKE Raglan T-Shirt
12071 PANTERA 101 T-Shirt
12073 SLAYER RITUAL SKULL T-Shirt
12074 SLAYER JUMBO EAGLE T-Shirt
12075 SLAYER SEASONS IN THE ABYSS T-Shirt
12077 WARBRINGER TOUR WITHOUT END T-Shirt
12078 WARBRINGER WAKING INTO NIGHTMARES T-Shirt
12937 AC/DC HIGH VOLTAGE T-Shirt
12944 BLACK VEIL BRIDES WHAT WHAT T-Shirt
13791 SLIPKNOT STAR CREST T-Shirt
13830 FOO FIGHTERS SLANTED LOGO T-Shirt
13904 BLACK VEIL BRIDES DUSK MASK
13964 AC/DC HIGHWAY TO HELL T-Shirt
13966 MISS MAY I GLOBE T-Shirt
13967 NIGHTWISH PRAYER T-Shirt
13968 PANTERA DOMINATION T-Shirt
14007 PANTERA EIGHTY ONE T-Shirt
14103 SLIPKNOT THORNS ALL OVER T-Shirt
14116 KORN DEATH DEREAM MENS TEE
14117 KORN MOSAIC TEE
14167 GUNS N' ROSES CARDS MENS TEE
14168 GUNS N' ROSES FIREPOWER MENS TEE
14169 GUNS N' ROSES G&R GUNS MENS TEE
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
14429 GREEN DAY DOOKIE VINTAGE T-Shirt(B)
14433 THE DEVIL WEARS PRADA Custom BlackGrey Pants(B)
15323 CHUNK!NO,CAPTAIN CHUNK! Floral White/Black
15324 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather / Black
15325 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather/Burgundy
15326 CHUNK!NO,CAPTAIN CHUNK! Navajo Grey/Black Baseball
15327 CHUNK!NO,CAPTAIN CHUNK! Open Your Ears Camo
15328 CHUNK!NO,CAPTAIN CHUNK! In Friends We Trust Camo
15329 CHUNK!NO,CAPTAIN CHUNK! Crown White T-Shirt
15330 YELLOWCARD Logo Black Charcoal - Two-Tone Zip-Up
15333 YELLOWCARD You're The Light Silver
15334 ESKIMO CALLBOY Haters & Lovers White - T-Shirt
15336 WHITECHAPEL Freedom Black
15337 WHITECHAPEL Strike Through Salute Black
15338 WHITECHAPEL Simple Flag Black Crewneck Sweatshir
15339 WHITECHAPEL I Dementia Black
15341 WHITECHAPEL Rise Black
15342 WHITECHAPEL Doom Black
15343 WHITECHAPEL Make It Bleed Black Zip-Up Sweatshirt
15344 WHITECHAPEL Doomsday Flag Black
15345 WHITECHAPEL Tetanus Black Zip-Up Sweatshirt
15346 WHITECHAPEL Spark Black Tank Top
15347 WHITECHAPEL Psychle Black
15348 WHITECHAPEL Stacker White
15349 WHITECHAPEL Freedom Black - Zip-Up Sweatshirt
15351 WHITECHAPEL Backfire Black
15352 WHITECHAPEL Sawblades Black Pockets
15353 WHITECHAPEL Hold The World Black
15363 TONIGHT ALIVE Lyric 13 Black
15364 TONIGHT ALIVE Crest Heather Grey Crewneck Sweat
15365 TONIGHT ALIVE Indian Pattern White T-Shirt
15368 FINCH Hand Heather Grey T-Shirt
15369 FINCH Linear Red T-Shirt
15371 FINCH Linear Black Zip-Up Sweatshirt
15373 NEW FOUND GLORY Juggernaut Black T-Shirt
15374 NEW FOUND GLORY Prophet Black T-Shirt
15375 THE USED Imaginary Enemy Military Green T-Shirts
15376 THE USED Heart White T-Shirt
15377 FINCH Linear Black T-Shirt
15378 THE SUMMER SET Logo Camo
15382 IWRESTLEDABEARONCE Late For Nothing Mesh Shorts
15383 WITHIN THE RUINS Red Crest Black Tank Top
15384 WITHIN THE RUINS Phenomena Black T-Shirt
15385 MISERY SIGNALS Holy Water Black
15386 NORTHLANE Snakes Black