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-30 17:09:49')
AND pc.stock > 0
AND pc.classcategory_id1 IN( 13,35,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 DESC
LIMIT 0, 240
71493 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX BALLOONS
71494 AVRIL LAVIGNE UNISEX T-SHIRT: LOVE SUX (BACK PRINT)
71495 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: WOLFMAN
71497 BAD OMENS UNISEX T-SHIRT: SUNFLOWER
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
71499 DEFTONES UNISEX T-SHIRT: STATIC SKULL (BACK PRINT)
71500 DEFTONES UNISEX T-SHIRT: STAR & PONY
71501 MOTIONLESS IN WHITE UNISEX T-SHIRT: SPLIT SCREEN
71502 MOTIONLESS IN WHITE UNISEX T-SHIRT: GRAVEYARD SHIFT
71503 NINE INCH NAILS UNISEX T-SHIRT: DOWNWARD SPIRAL (BACK PRINT)
71504 NINE INCH NAILS UNISEX T-SHIRT: HEAD LIKE A HOLE
71505 SYSTEM OF A DOWN UNISEX T-SHIRT: DOVE OVERCOME
69445 BRING ME THE HORIZON UNISEX T-SHIRT: GREEN NEX GEN
69444 BRING ME THE HORIZON UNISEX T-SHIRT: DISTRESSED NEX GEN
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
68831 BRING ME THE HORIZON UNISEX T-SHIRT: BARBED WIRE (BACK PRINT)
45947 BRING ME THE HORIZON UMBRELLA (BURN OUT) GRAY
67940 BRING ME THE HORIZON UNISEX T-SHIRT: WARRIOR
70554 BRING ME THE HORIZON UNISEX T-SHIRT: WHY...?
69441 BRING ME THE HORIZON UNISEX T-SHIRT: LOST (BACK PRINT)
69442 BRING ME THE HORIZON UNISEX T-SHIRT: ALL HAIL (BACK PRINT)
70552 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: NEX GEN COVER
70553 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: BUG
70555 BRING ME THE HORIZON UNISEX ZIPPED HOODIE: BLUE CROW WINGS (BACK PRINT)
71250 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 POSTER (EX-TOUR)
71314 MÅNESKIN UNISEX TANK T-SHIRT: GAY FOR MANESKIN
71247 MÅNESKIN UNISEX PULLOVER HOODIE: FUCK MANESKIN (BACK PRINT & EX-TOUR)
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
71431 SKINDRED UNISEX T-SHIRT: RASTA LOGO
71430 SKINDRED UNISEX T-SHIRT: LOUD MUSIC
68839 SLIPKNOT UNISEX T-SHIRT: AMUSEMENT PARK (BACK PRINT)
67505 SLIPKNOT UNISEX T-SHIRT: SID PHOTO (BACK PRINT)
68833 SLIPKNOT UNISEX T-SHIRT: ZOMBIE (BACK PRINT)
51199 SLIPKNOT UNISEX TEE: WANYK LOGO (BACK PRINT)
35296 SLIPKNOT UNISEX T-SHIRT: .5: THE GRAY CHAPTER (BACK PRINT)
35289 SLIPKNOT UNISEX T-SHIRT: BAND FRAME
68837 SLIPKNOT UNISEX T-SHIRT: 20TH ANNIVERSARY TATTERED & TORN (BACK PRINT)
68835 SLIPKNOT UNISEX T-SHIRT: DEVIL SINGLE - LOGO BLUR (BACK PRINT)
68580 SLIPKNOT UNISEX T-SHIRT: ALIEN (BACK PRINT)
68581 SLIPKNOT UNISEX T-SHIRT: SKELETON & PENTAGRAM (BACK PRINT)
35502 SLIPKNOT Blocks T-Shirt
70283 SLIPKNOT UNISEX LONG SLEEVE T-SHIRT: THE END SO FAR GROUP PHOTO TRIBAL-S NONAGRA
67970 SLIPKNOT UNISEX LONG SLEEVE T-SHIRT: SPIT IT OUT
70939 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
36789 SLIPKNOT Gray Chapter Skeleton Hooded Sweatshirt
67512 SLIPKNOT UNISEX PULLOVER HOODIE: ARCHED GROUP PHOTO
57297 SLIPKNOT UNISEX PULLOVER HOODIE: CHOIR (BACK PRINT)
67511 SLIPKNOT UNISEX PULLOVER HOODIE: SELF-TITLED (BACK PRINT)
61670 SLIPKNOT UNISEX PULLOVER HOODIE: MINNEAPOLIS '09 (BACK PRINT)
67958 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY WHITE
67957 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY BLACK
68577 LINKIN PARK UNISEX T-SHIRT: LIVING THINGS ALBUM
70685 LINKIN PARK UNISEX T-SHIRT: METEORA PORTRAITS
68575 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO BLACK
68576 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO WHITE
70683 LINKIN PARK UNISEX PULLOVER HOODIE: STREET SOLDIER
70684 LINKIN PARK UNISEX PULLOVER HOODIE: METEORA WALL ART
68573 KORN UNISEX T-SHIRT: REQUIEM ALBUM COVER (BACK PRINT)
66944 KORN UNISEX T-SHIRT: BLOCKS
52907 KORN UNISEX TEE: DEATH DREAM
67955 KORN UNISEX T-SHIRT: BLOCK PHOTO
68574 KORN UNISEX HI-BUILD T-SHIRT: LOGO
70679 KORN UNISEX PULLOVER HOODIE: STILL A FREAK (BACK PRINT)
66943 KORN UNISEX PULLOVER HOODIE: REQUIEM (BACK PRINT)
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
35642 MARILYN MANSON RED LIPS T-SHIRTS
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
69360 MARILYN MANSON UNISEX PULLOVER HOODIE: CLASSIC LOGO
37810 BULLET FOR MY VALENTINE Logo T-shirt Black
70279 BULLET FOR MY VALENTINE UNISEX T-SHIRT: FLORAL OMEN
70280 BULLET FOR MY VALENTINE UNISEX T-SHIRT: RAM (BACK PRINT)
70278 BULLET FOR MY VALENTINE UNISEX T-SHIRT: THRASH SKULL
59257 NINE INCH NAILS Unisex Tee: Classic Logo
10233 METALLICA DORIS T-Shirt
700 METALLICA-KILL EM ALL
59275 METALLICA UNISEX TEE: Ride The Lightning Tracks (Back Print)
56823 METALLICA UNISEX TEE: MASTER OF PUPPETS TRACKS (BACK PRINT)
59276 METALLICA UNISEX TEE: Heart Explosive (Back Print)
10235 METALLICA VINTAGE METAL UP T-Shirt
70282 METALLICA UNISEX PULLOVER HOODIE: 72 SEASONS CHARRED LOGO (BACK PRINT)
69361 METALLICA UNISEX PULLOVER HOODIE: SKULL SCREAMING RED BLACK
61822 METALLICA UNISEX PULLOVER HOODIE: SKULL FLOWER WASHED
1097 RED HOT CHILI PEPPERS Asterisk Logo White
585 RED HOT CHILI PEPPERS Asterisk Logo Black
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
67509 RED HOT CHILI PEPPERS UNISEX PULLOVER HOODIE: CLASSIC ASTERISK
70937 RED HOT CHILI PEPPERS UNISEX SWEATSHIRT: SCRIBBLE ASTERISK
52903 MY CHEMICAL ROMANCE UNISEX TEE: SHREDDED
68578 MY CHEMICAL ROMANCE UNISEX T-SHIRT: SPIDER
66953 MY CHEMICAL ROMANCE UNISEX T-SHIRT: CIRCLE MARCH
55726 MY CHEMICAL ROMANCE UNISEX TEE: KILLJOYS PIN-UP
70556 MY CHEMICAL ROMANCE UNISEX SWEATSHIRT: MARCH (SLEEVE PRINT)
66947 MY CHEMICAL ROMANCE UNISEX PULLOVER HOODIE: THE BLACK PARADE COVER
56809 MY CHEMICAL ROMANCE UNISEX HOODIE: RACEWAY
69363 MY CHEMICAL ROMANCE UNISEX PULLOVER HOODIE: XV MARCHING FRAME (BACK PRINT)
70948 SUM41 UNISEX T-SHIRT: AKNF SKELETON EUROPEAN TOUR 2022 (BACK PRINT & EX-TOUR)
70561 SUM41 UNISEX T-SHIRT: DOES THIS LOOK LIKE ALL KILLER NO FILLER EUROPEAN TOUR 20
70557 SUM41 UNISEX T-SHIRT: REAPER
67508 SUM41 UNISEX T-SHIRT: OUT FOR BLOOD (BACK PRINT)
53188 BLINK-182 UNISEX TEE: SIX ARROW SMILEY BLACK
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
70933 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SKULL
53186 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SMILEY
70934 BLINK-182 UNISEX SWEATSHIRT: BIG SMILE (SLEEVE PRINT)
51426 GREEN DAY Unisex Tee: Hypno 4
69350 GUNS N' ROSES UNISEX LONG SLEEVE T-SHIRT: HOLLYWOOD TOUR (BACK & SLEEVE PRINT)
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
59255 NIRVANA Unisex Tee:White Happy Face
4598 NIRVANA Happy Face T-Shirt
67967 NIRVANA UNISEX T-SHIRT: SORBET RAY Happy Face
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
69352 NIRVANA UNISEX LONG SLEEVE T-SHIRT: GRADIENT HAPPY FACE (BACK & SLEEVE PRINT)
69351 NIRVANA UNISEX LONG SLEEVE T-SHIRT: ANGELIC GRADIENT (BACK & SLEEVE PRINT)
69366 NIRVANA UNISEX PULLOVER HOODIE: YELLOW HAPPY FACE BLACK
59266 Ed Sheeran Unisex Tee: Divide
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
67953 FALL OUT BOY UNISEX T-SHIRT: TAKE THIS TO YOUR GRAVE
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
58067 FOO FIGHTERS UNISEX PULLOVER HOODIE: MEDICINE AT MIDNIGHT TAPED
70943 SLEEP TOKEN UNISEX PULLOVER HOODIE: HYPNOSIS
70944 SLEEP TOKEN UNISEX PULLOVER HOODIE: TOMB
70946 SLEEP TOKEN UNISEX T-SHIRT: EUCLID
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
67971 SLIPKNOT UNISEX VARSITY JACKET: 9 POINT STAR (BACK PRINT) BLACK
67972 SLIPKNOT UNISEX VARSITY JACKET: 9 POINT STAR (BACK PRINT) RED
69362 MOTLEY CRUE UNISEX PULLOVER HOODIE: DISTRESSED LOGO
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
69164 MOTLEY CRUE UNISEX T-SHIRT: THEATRE OF PAIN CRY
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69160 DEF LEPPARD UNISEX T-SHIRT: SHATTER
69161 DEF LEPPARD UNISEX T-SHIRT: HYSTERIA WORLD TOUR (BACK PRINT)
69369 THE 1975 UNISEX PULLOVER HOODIE: NOACF
69370 THE 1975 UNISEX PULLOVER HOODIE: BLACK TOUR
69348 DAVID BOWIE UNISEX LONG SLEEVE T-SHIRT: HAMMERSMITH ODEON (SLEEVE PRINT)
69368 RAGE AGAINST THE MACHINE UNISEX PULLOVER HOODIE: NUNS (BACK PRINT) SAND
69359 DEFTONES UNISEX PULLOVER HOODIE: AROUND THE FUR NAVY BLUE
69364 NINE INCH NAILS UNISEX PULLOVER HOODIE: CLASSIC LOGO
56761 AVENGED SEVENFOLD UNISEX PULLOVER HOODIE: SEIZE THE DAY
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
35655 PANTERA Red Vulgar T-Shirts
12067 PANTERA HOSTILE SKULL T-Shirt
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
36681 MEGADETH MEGADETH YAMAHA DRUMS
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
53184 ALL TIME LOW UNISEX TEE: DA BOMB
68584 SYSTEM OF A DOWN UNISEX T-SHIRT: TOXICITY
68585 SYSTEM OF A DOWN UNISEX T-SHIRT: TRIPLE STACK BOX
68586 SYSTEM OF A DOWN UNISEX T-SHIRT: BANNER MARCHES
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
67941 EVANESCENCE UNISEX T-SHIRT: SYNTHESIS
66960 MEGADETH UNISEX PULLOVER HOODIE: COUNTDOWN TO EXTINCTION
66969 PANTERA UNISEX PULLOVER HOODIE: 101 PROOF
61671 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) BLACK
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
61674 Ed Sheeran UNISEX LONG SLEEVED T-SHIRT: BAD HABITS
61675 Ed Sheeran UNISEX LONG SLEEVED T-SHIRT: BAD HABITS STACK
60194 TWENTY ONE PILOTS UNISEX T-SHIRT: BANDITO BIRD
60195 TWENTY ONE PILOTS UNISEX T-SHIRT: TRENCH CLIFF
60196 TWENTY ONE PILOTS UNISEX T-SHIRT: TORCH BEARERS
57797 FALLING IN REVERSE Knit Sweater Sweatshirt
57798 CRADLE OF FILTH Krampus T-shirt + ornament
57295 IRON MAIDEN UNISEX PULLOVER HOODIE: LOTB LIVE ALBUM (ARM & BACK PRINT)
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
56759 AC/DC UNISEX PULLOVER HOODIE: CANNON SWIG
56760 AC/DC LADIES ZIPPED HOODIE: LOGO (BACK PRINT)
55718 ASKING ALEXANDRIA UNISEX TEE: SKULL SHIELD (RETAIL PACK)
55722 CROWN THE EMPIRE UNISEX TEE: SACRIFICE (RETAIL PACK)
11984 ANTHRAX WORSHIP MUSIC T-Shirt
54740 ANTHRAX UNISEX TEE: AMONG THE LIVING
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
7432 WOE IS ME Griffin Black
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9424 WHITECHAPEL Riot Black T-Shirt
9428 THE WORD ALIVE Bullets Black T-Shirt
10236 METALLICA JUSTICE FOR ALL T-Shirt
11278 DANGERKIDS CAD Charcoal T-Shirt
11283 CAPTURE THE CROWN Gargoyle Black
11451 TEXAS IN JULY Without A Head! Black
15327 CHUNK!NO,CAPTAIN CHUNK! Open Your Ears Camo
15342 WHITECHAPEL Doom Black
15383 WITHIN THE RUINS Red Crest Black Tank Top
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
15427 THE WORD ALIVE Lighthouse Black
15435 PIERCE THE VEIL Logo Black
15437 THE WORD ALIVE Poseiden Black
15471 CROWN THE EMPIRE Axe Navy
15496 ALL THAT REMAINS A War You Cannot Win Black
15509 WE CAME AS ROMANS Reasons Black
18987 WE CAME AS ROMANS Howl At The Moon White
19001 WHITECHAPEL Pocket Blade Black
19104 ATTILA RAGEAHOLICS WHITE
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
19844 FOR TODAY IMMORTAL RED
19867 BREATHE CAROLINA Savages Album White T-Shirt
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
21118 WE CAME AS ROMANS Horse & Rider All-Over-Print
21123 ATTILA Rage Tomahawk Royal Blue
21124 ATTILA Dirty Black
21220 ATTILA RageAholics Red - T-Shirt
22586 I THE BREATHER SERCH FOR A BETTER LIFE
24662 ISSUES I Have Issues Black - T-Shirt
24700 MEMPHIS MAY FIRE Logo Two Tone - TankTop
24756 WHITECHAPEL Sawblade Maroon on Charcoal - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24758 WHITECHAPEL Sawblade Camo on Black - T-Shirt
25009 THE STORY SO FAR Snake Girl White - T-Shirt
25127 THE STORY SO FAR Snakes Black - T-Shirt
25134 SEAWAY Colour Blind TV Logo Yellow - T-Shirt
25158 WE CAME AS ROMANS TROY White - T-Shirt
25164 WE CAME AS ROMANS Regular Dudes Black - T-Shirt
25166 WE CAME AS ROMANS Conquer Maroon - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
25231 LIKE MOTHS TO FLAMES Devil Tie Dye
25257 CAPTURE THE CROWN We Are All Royalty Black - T-Shirt
25262 A SKYLIT DRIVE Soldier Black - Long Sleeve Shirt
25264 A SKYLIT DRIVE Hangin' So Loose White - T-Shirt
25302 BEFORE THEIR EYES Cross Black - T-Shirt
25313 EMAROSA Side Fox Tr-Blend Heather Grey - TankTop
25489 SECRETS Fragile Figures White/Blue - Baseball Tee
25491 THE SUMMER SET Legendary Black - T-Shirt
25492 THE SUMMER SET Perfectly Wasted Youth White - T-Shirt
26144 ARCHITECTS Daybreaker Crewneck
26230 OPETH Morningrise Hoodie
26455 SLEEPING WITH SIRENS Red Chain
27374 THE USED VULNERABLE T
27794 LANDON TEWERS The Captain Black
28295 THE BROWNING Skull Black