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 10:45:29')
AND pc.stock > 0
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 MAX(price02)
LIMIT 0, 240
26290 DROPKICK MURPHYS Jolly Roger Patch
37737 SUICIDAL TENDENCIES 2ACSSPNST SUIOCIDAL CROSS LOGO PIN
68080 ANIMALIA (アニマリア) SOX - Panther -
49833 SLIPKNOT Barcode-CD Wallet
50415 MODERN DAY BABYLON 『COMA』
50416 MODERN DAY BABYLON 『Undefeated』
50417 MODERN DAY BABYLON 『Travelers』
50418 MODERN DAY BABYLON 『The Ocean Atlas』
56817 BLACK SABBATH FACE MASK: WAVY LOGO
56818 PANTERA FACE MASK: LOGO
56819 THE ROLLING STONES FACE MASK: CLASSIC TONGUE
51191 SLIPKNOT TURNTABLE SLIPMAT SET: THE GRAY CHAPTER
919 The Devil Wears Prada Virus Allover Print T-Shirt
4349 ENTER SHIKARI Destabilize Tour Black
9415 WE CAME AS ROMANS Sideways Black Tank Top
9424 WHITECHAPEL Riot Black T-Shirt
9433 OH SLEEPER Endseekers T-Shirt
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
11236 WOE IS ME Circus Revenge Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11261 CHUNK!NO,CAPTAIN CHUNK! Bats Navy
11284 ENTER SHIKARI Stealth Black
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11311 ENTER SHIKARI Return To Black
11419 CAPTURE THE CROWN Doggie Black
11436 ATTILA Reaper Navy/Heather Tank Top
11440 TEXAS IN JULY Bed Of Nails Black
11451 TEXAS IN JULY Without A Head! Black
11939 AMON AMARTH LOGO RUNE T-Shirt
12026 MEGADETH EXPLODING VIC T-Shirt
12067 PANTERA HOSTILE SKULL T-Shirt
17973 UNEARTH SKATE RAGE
19096 ATTILA Bad Reputation Black
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19836 MAYDAY PARADE Upstage White Tank Top
21123 ATTILA Rage Tomahawk Royal Blue
21124 ATTILA Dirty Black
21125 BEARTOOTH Generation Of Disorder Black
21220 ATTILA RageAholics Red - T-Shirt
22588 WATCHOUT! THERES GHOSTS MONSTER TEE
24541 ATTILA Fuck Your Shit Camo Black - T-Shirt
24662 ISSUES I Have Issues Black - T-Shirt
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
24679 SLEEPING WITH SIRENS Sealed Lips Black - T-Shirt
24680 SLEEPING WITH SIRENS Punk Patch Black - Girls/JRS t-shirt
24704 MEMPHIS MAY FIRE Smokey Black - T-Shirt
24748 WHITECHAPEL Pyro Black - T-Shirt
24755 WHITECHAPEL Crate Black - T-Shirt
24756 WHITECHAPEL Sawblade Maroon on Charcoal - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24758 WHITECHAPEL Sawblade Camo on Black - T-Shirt
24762 NORTHLANE Glitch Navy - T-Shirt
24892 NORTHLANE Terence White - T-Shirt
25009 THE STORY SO FAR Snake Girl White - T-Shirt
25127 THE STORY SO FAR Snakes Black - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25134 SEAWAY Colour Blind TV Logo Yellow - T-Shirt
25137 SEAWAY Crystal Ball Black - T-Shirt
25158 WE CAME AS ROMANS TROY White - T-Shirt
25166 WE CAME AS ROMANS Conquer Maroon - T-Shirt
25193 IWRESTLEDABEARONCE Witch Black - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
25230 LIKE MOTHS TO FLAMES Pizza Black - T-Shirt
25232 LIKE MOTHS TO FLAMES Baseball Black - T-Shirt
25248 CAPTURE THE CROWN Banners Red - T-Shirt
25257 CAPTURE THE CROWN We Are All Royalty Black - T-Shirt
25264 A SKYLIT DRIVE Hangin' So Loose White - T-Shirt
25302 BEFORE THEIR EYES Cross Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
25308 CHIODOS Snowman Black - T-Shirt
25415 I SEE STARS Old Dude
25443 MAYDAY PARADE Dying To Meet You Black - T-Shirt
25450 MAYDAY PARADE Bright Idea
25487 SECRETS Scuba Black - T-Shirt
25488 SECRETS Flag White - T-Shirt
25508 WHITECHAPEL Memorial Black - Girl Shirt
26142 CONVERGE Poacher Black
26150 I KILLED THE PROM QUEEN Monogram Tee
26451 MOTION CITY SOUNDTRACK GO Album Logo
26454 REFUSED All Dressed Up
26455 SLEEPING WITH SIRENS Red Chain
26456 SLEEPING WITH SIRENS Grey Crest
27374 THE USED VULNERABLE T
27794 LANDON TEWERS The Captain Black
28240 CITY LIGHTS Skeleton T-shirt
28295 THE BROWNING Skull Black
28310 FRONZILLA Party People's Anthem Black TankTop
28569 EXODUS HORNED SKUL
28607 PINK FLOYD MELTING PRISM
28609 PINK FLOYD COMPASS
28641 AMON AMARTH WOLFORD
28663 DEMON HUNTER BASIC
28710 SOILWORK ANCHOR
55718 ASKING ALEXANDRIA UNISEX TEE: SKULL SHIELD (RETAIL PACK)
55722 CROWN THE EMPIRE UNISEX TEE: SACRIFICE (RETAIL PACK)
22703 5 SECONDS OF SUMMER Jet Black Heart Tee
28026 ATTILA A T-Shirt
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
28020 MYKA RELOCATE MYK-T01 TEE
28025 ATTILA BASEBALL T-SHIRT
10242 JOB FOR A COWBOY JOB RORSCHACH T-Shirt
11932 AC/DC THUNDER LOGO T-Shirt
22586 I THE BREATHER SERCH FOR A BETTER LIFE
7432 WOE IS ME Griffin 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
9369 ATTILA Sugar Skull Black T-Shirt
9391 CROWN THE EMPIRE Axe Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
9430 TEXAS IN JULY Draw The Line Red/Orange Tie Dye
11278 DANGERKIDS CAD Charcoal T-Shirt
11283 CAPTURE THE CROWN Gargoyle Black
11432 WHITECHAPEL Priest Black T-Shirt
11445 WHITECHAPEL Ouija Black Girl T-Shirt
11454 THE WORD ALIVE I'd Rather Die Black
15342 WHITECHAPEL Doom Black
15346 WHITECHAPEL Spark Black Tank Top
15351 WHITECHAPEL Backfire Black
15378 THE SUMMER SET Logo Camo
15383 WITHIN THE RUINS Red Crest Black Tank Top
15386 NORTHLANE Snakes Black
15408 MEMPHIS MAY FIRE Red Logo Black
15409 MEMPHIS MAY FIRE Texas Torch Black
15427 THE WORD ALIVE Lighthouse Black
15428 THE WORD ALIVE REAL. Album Art Black Tank Top
15430 THE WORD ALIVE Press Photo White T-Shirt
15431 THE WORD ALIVE Press Photo White Girl's Tank Top
15435 PIERCE THE VEIL Logo Black
15436 PIERCE THE VEIL Seal Black T-Shirt
15437 THE WORD ALIVE Poseiden Black
15464 MOTIONLESS IN WHITE Raven Black TEE
15466 CHIODOS Chaos White T-Shirt
15467 CHIODOS This Is Love Band - T-Shirt
15471 CROWN THE EMPIRE Axe Navy
15496 ALL THAT REMAINS A War You Cannot Win Black
15508 WE CAME AS ROMANS Dave & Kyle Live Black T-Shirt
15509 WE CAME AS ROMANS Reasons Black
15510 WE CAME AS ROMANS Hope Crest Black
15513 WE CAME AS ROMANS My Home Your Heart White
15515 WE CAME AS ROMANS Ancestor Heather Grey Tank Top
15517 WE CAME AS ROMANS Scratchy Text Dark Heather
15532 MAYDAY PARADE Photo Black
15535 MAYDAY PARADE Broken Heart Black
15537 MAYDAY PARADE Chain Gang Black
15540 MAYDAY PARADE Ghosts Lyric White GIRLS Shirt
15579 SECRETS Heart Black Tank Top
15582 TEXAS IN JULY Vice Black
15584 TEXAS IN JULY Ministry Maroon
15601 TEXAS IN JULY Draw The Line Black Tie Dye
18972 MEMPHIS MAY FIRE Blue Fun Crest Heather
18973 MEMPHIS MAY FIRE BLUE LOGO HEATHER GREY
18979 MEMPHIS MAY FIRE Nautical Black
18980 MEMPHIS MAY FIRE Eagle Dagger Red
18981 MEMPHIS MAY FIRE Cartoon Matty Black
18983 WE CAME AS ROMANS Wont Fade Away Navy
18987 WE CAME AS ROMANS Howl At The Moon White
18988 WE CAME AS ROMANS Floral Script HeatherMountain
19001 WHITECHAPEL Pocket Blade Black
19004 WHITECHAPEL Simple Flag Black
19093 ATTILA South By Suck My Fuck Black
19095 ATTILA Biker Black T-Shirt
19104 ATTILA RAGEAHOLICS WHITE
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19821 MAYDAY PARADE Label Crimson Tie Dye
19835 THE SUMMER SET Floral Triangle Teal
19844 FOR TODAY IMMORTAL RED
19867 BREATHE CAROLINA Savages Album White T-Shirt
19881 TEXAS IN JULY Brain Black
19883 WITHIN THE RUINS Green Crest Black Tank Top
19884 WITHIN THE RUINS Agent Of Chaos Black
19894 FINCH Hand Heather RED T-Shirt
20553 PALISADES Wolves...TS Black
21115 ISSUES Too Many Moons Heather Tank Top
25148 WE CAME AS ROMANS Slytherin' Carcoal - T-Shirt
25162 WE CAME AS ROMANS Bombs White
25234 CHUNK!NO,CAPTAIN CHUNK! City Night White - TankTop
25482 PIERCE THE VEIL Orange Seal Black - T-Shirt
25491 THE SUMMER SET Legendary Black - T-Shirt
35603 DISTURBED Up Your Fist T-Shirts
36238 SLAYER No Mercy-Black T-shirt
36784 DISTURBEDMusic As A Weapon 06-07 Tour T-shirt
36829 DISTURBED Ravens Jumbo Print-White t-shirt
37032 PANTERA Reinventing Band
37034 PANTERA Band Flames T-Shirt
37586 MEGADETH -Dystopia-Black t-shirt
39163 BLACK SABBATH LOTW white Tee
10236 METALLICA JUSTICE FOR ALL T-Shirt
10261 RANCID MONSTER PRINT T-Shirt
10272 IRON MAIDEN KILLERS Large Print T-Shirt
15327 CHUNK!NO,CAPTAIN CHUNK! Open Your Ears Camo
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
28627 GUNS N' ROSES HEADS VINTAGE
35292 SLIPKNOT PAUL GRAY
35502 SLIPKNOT Blocks T-Shirt
35589 BRING ME THE HORIZON The H T-Shirts
35602 DISTURBED FIRE BEHIND T-SHIRTS
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
35619 GUNS N' ROSES 30th Photo T-Shrts
36537 FIVE FINGER DEATH PUNCH Purgatory 2014 Tour-
36657 FIVE FINGER DEATH PUNCH EAGLE PUNCH
36662 GUNS N' ROSES BULLET CLASSIC GRAY
36664 GUNS N' ROSES APPETITE LOGO Beanie
36665 GUNS N' ROSES BULLET LOGO Beanie
36668 IRON MAIDEN BOOK OF SOULS EDDIE
36670 IRON MAIDEN HIGHWAY
36673 JUDAS PRIEST PAINKILLER SOLO
36681 MEGADETH MEGADETH YAMAHA DRUMS
36695 SLAYER LARGE BLACK EAGLE
51190 SLIPKNOT UNISEX FINGERLESS GLOVES: LOGO
24740 MEMPHIS MAY FIRE Shield Royal Blue - T-Shirt
24741 MEMPHIS MAY FIRE Challenger Red - T-Shirt
35598 BRING ME THE HORIZON Alone & Depressed
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
52509 BILLIE EILISH UNISEX TEE BLACK RACER LOGO (SLEEVE PRINT)
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
15425 ISSUES Logo White Tank Top
36878 DISTURBED Up Your Fist T-Shirts RED
49846 DISTURBED LOST SOULS
12066 OF MICE & MEN SNAKE Raglan T-Shirt
25231 LIKE MOTHS TO FLAMES Devil Tie Dye
26173 PARKWAY DRIVE PWD Black-Gray Beanie
35690 NIRVANA Bleach Cassette Photo T-shirt
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
56814 AC/DC UNISEX BEANIE HAT: OVAL LOGO (CABLE-KNIT)
56815 AC/DC TURNTABLE SLIPMAT SET: LET THERE BE ROCK/ROCK & ROLL (RETAIL PACK)
71316 MÅNESKIN UNISEX MESH BACK CAP: LOUD KIDS ON TOUR
24702 MEMPHIS MAY FIRE Logo Bleached Dye - T-Shirt
25489 SECRETS Fragile Figures White/Blue - Baseball Tee
585 RED HOT CHILI PEPPERS Asterisk Logo Black
700 METALLICA-KILL EM ALL
1097 RED HOT CHILI PEPPERS Asterisk Logo White
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
4598 NIRVANA Happy Face T-Shirt