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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-24 19:34:50')
AND pc.classcategory_id1 IN( 11)
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
56820 THE 1975 UNISEX TEE: BLACK TOUR
59265 Ed Sheeran Unisex Tee: Chords
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
17951 AVENGED SEVENFOLD STELLAR
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
69356 BAD OMENS UNISEX T-SHIRT: RAM SKULL BLACK
36670 IRON MAIDEN HIGHWAY
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
71496 THE BLACK DAHLIA MURDER UNISEX T-SHIRT: DETROIT (BACK PRINT)
71497 BAD OMENS UNISEX T-SHIRT: SUNFLOWER
69765 BAD OMENS UNISEX T-SHIRT: TAKE ME
71498 DEFTONES UNISEX T-SHIRT: SPHYNX
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
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
69443 BRING ME THE HORIZON UNISEX T-SHIRT: NEX GEN COVER
69444 BRING ME THE HORIZON UNISEX T-SHIRT: DISTRESSED NEX GEN
69446 BRING ME THE HORIZON UNISEX T-SHIRT: IMPRINT NEX GEN
67935 BRING ME THE HORIZON UNISEX T-SHIRT: SPRAY HEX
69354 BRING ME THE HORIZON UNISEX T-SHIRT: FLAMING HEX BLACK
68831 BRING ME THE HORIZON UNISEX T-SHIRT: BARBED WIRE (BACK PRINT)
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)
43345 BRING ME THE HORIZON Sempiternal TEE
71251 MÅNESKIN UNISEX T-SHIRT: LOUD KIDS EUROPEAN TOUR '23 (BACK PRINT & EX-TOUR)
71250 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 POSTER (EX-TOUR)
70819 POLYPHIA UNISEX T-SHIRT: RITUAL
70821 POLYPHIA UNISEX T-SHIRT: SPEAR ANGEL
70820 POLYPHIA UNISEX T-SHIRT: SKULL CIRCLE P
70818 POLYPHIA UNISEX T-SHIRT: CHERUB
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)
68582 SLIPKNOT UNISEX T-SHIRT: ADDERALL FACEBACK (BACK PRINT)
68583 SLIPKNOT UNISEX T-SHIRT: THE END (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
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
70686 LINKIN PARK UNISEX T-SHIRT: SHIFT
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
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
35645 MARILYN MANSON THE PALE EMPEROR T-SHIRTS
60191 MARILYN MANSON UNISEX T-SHIRT: WE ARE CHAOS (BACK PRINT)
67965 MARILYN MANSON UNISEX T-SHIRT: AMERICAN FAMILY (BACK PRINT)
28592 MARILYN MANSON CROWN T-Shirts
35642 MARILYN MANSON RED LIPS T-SHIRTS
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
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
8372 FALLING IN REVERSE Lips T-Shirt BLACK
55729 OASIS UNISEX TEE: DECCA LOGO BLACK
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
1097 RED HOT CHILI PEPPERS Asterisk Logo White
585 RED HOT CHILI PEPPERS Asterisk Logo Black
70938 RED HOT CHILI PEPPERS UNISEX HI-BUILD T-SHIRT: CLASSIC ASTERISK LOGO
60192 RED HOT CHILI PEPPERS UNISEX T-SHIRT: GETAWAY ALBUM ASTERISK
67504 RED HOT CHILI PEPPERS UNISEX T-SHIRT: BLACK & WHITE LOGO
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
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
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
70561 SUM41 UNISEX T-SHIRT: DOES THIS LOOK LIKE ALL KILLER NO FILLER EUROPEAN TOUR 20
67506 SUM41 UNISEX T-SHIRT: GRINNING SKULL
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
70935 BLINK-182 UNISEX T-SHIRT: OVERBOARD EVENT
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
53186 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SMILEY
51426 GREEN DAY Unisex Tee: Hypno 4
68568 GREEN DAY UNISEX T-SHIRT: FLOWER POT (WASH COLLECTION)
68569 GREEN DAY UNISEX T-SHIRT: DOOKIE LONGVIEW (WASH COLLECTION)
10258 GUNS N' ROSES CROSS T-Shirt
36663 GUNS N' ROSES BULLET LOGO
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
59255 NIRVANA Unisex Tee:White Happy Face
4598 NIRVANA Happy Face T-Shirt
4599 NIRVANA MANY 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
59258 Kurt Cobain Unisex Tee: Coloured Side View
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
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58064 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TILT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
10236 METALLICA JUSTICE FOR ALL T-Shirt
67956 KORN UNISEX T-SHIRT: STILL A FREAK (BACK PRINT)
70946 SLEEP TOKEN UNISEX T-SHIRT: EUCLID
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
70945 SLEEP TOKEN UNISEX T-SHIRT: TAKE ME BACK TO EDEN
67936 BRING ME THE HORIZON UNISEX T-SHIRT: SYMBOLS (BACK PRINT)
70941 SUM41 UNISEX T-SHIRT: BAND PHOTO EUROPEAN TOUR 2022 (BACK PRINT & EX-TOUR)
67507 SUM41 UNISEX T-SHIRT: BLUE DEMON (BACK PRINT)
42575 RED HOT CHILI PEPPERS DISTRESSED OUTLINED LOGO TEE
69794 SLAYERxDC SHOES(ディーシーシューズ) SHOESLAYERxDC SHOES(ディーシーシューズ) 1981 HSS
69796 SLAYERxDC SHOES(ディーシーシューズ) DC STAR HSS
69797 SLAYERxDC SHOES(ディーシーシューズ) SHOECO HSS
67934 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE HANDS
45950 BRING ME THE HORIZON WONDERFUL LIFE BLACK
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
69163 MOTLEY CRUE UNISEX T-SHIRT: FEELGOOD HOLLYWOOD REVISION
69164 MOTLEY CRUE UNISEX T-SHIRT: THEATRE OF PAIN CRY
69165 MOTLEY CRUE UNISEX T-SHIRT: BAD BOYS SHIELD
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)
69355 BAD OMENS UNISEX T-SHIRT: HOLY WATER BLACK
69157 METALLICA UNISEX T-SHIRT: AND JUSTICE FOR ALL TRACKS (BACK PRINT)
55728 NIRVANA UNISEX TEE: YELLOW Happy Face
67937 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE EYE (BACK PRINT)
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
68571 IRON MAIDEN UNISEX T-SHIRT: THE FUTURE PAST TOUR '23 CIRCLE ART
68572 IRON MAIDEN UNISEX T-SHIRT: THE FUTURE PAST TOUR '23 GREYSCALE
45951 BRING ME THE HORIZON PLASMA TEE BLACK
67964 MACHINE GUN KELLY UNISEX T-SHIRT: DIGITAL COVER
67969 NIRVANA UNISEX T-SHIRT: TRAPPER HAT
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
67933 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE ARMY
67963 MACHINE GUN KELLY UNISEX T-SHIRT: LASER EYE (BACK PRINT)
10234 METALLICA RIDE LIGHTNING T-Shirt
67930 BLINK-182 UNISEX RINGER T-SHIRT: ANIME
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
35655 PANTERA Red Vulgar T-Shirts
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
37586 MEGADETH -Dystopia-Black t-shirt
36680 MEGADETH DYSTOPIA
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
66942 BAD RELIGION UNISEX T-SHIRT: LIVE 1980
59269 BULLET FOR MY VALENTINE Unisex Tee: Red Snake
55719 ALL TIME LOW UNISEX TEE: DA BOMB (RETAIL PACK)
37811 ALL TIME LOW UNISEX TEE: SCRATCH
60190 MISFITS UNISEX T-SHIRT: HANDS
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
43343 BRING ME THE HORIZON UMBRELLA TEE
53874 MY CHEMICAL ROMANCE COFFIN T-Shirts
59373 BRING ME THE HORIZON UNISEX T-SHIRT: LABYRINTH (BACK PRINT)
36532 BRING ME THE HORIZON -Sempiternal- Black T-Shirt
35581 BRING ME THE HORIZON SHADOW MOSES
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
51202 SLIPKNOT UNISEX TEE: WANYK BACK HIT (BACK PRINT)
35292 SLIPKNOT PAUL GRAY
61666 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY GARAGE (BACK PRINT)
61668 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY RIPPER
59374 METALLICA UNISEX T-SHIRT: MASTER OF PUPPETS DISTRESSED
35659 PANTERA Original Cover T-Shirts
12072 PANTERA STRONGER T-Shirt
49799 ISSUES Feathers Deep Heather Grey
59270 BRING ME THE HORIZON UNISEX TEE: LOVE IS ALL WE HAVE (BACK PRINT)
57236 BRING ME THE HORIZON UNISEX TEE: HEX PHSH COVER (BACK PRINT)
57239 BRING ME THE HORIZON UNISEX TEE: WIPE THE SYSTEM (BACK PRINT)
45659 BRING ME THE HORIZON AMO SYMBOLS TEE
59268 BULLET FOR MY VALENTINE Unisex Tee: Gravity
56821 THE 1975 UNISEX TEE: ABIIOR SIDE FACE TIME (BACK PRINT)
61665 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY FORTY YEARS (BACK PRINT)
61667 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY HORSEMEN
61669 METALLICA UNISEX T-SHIRT: 40TH ANNIVERSARY SONGS LOGO (BACK PRINT)
57294 BRING ME THE HORIZON UNISEX TEE: PARASITE (BACK PRINT)
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
13970 CHILDREN OF BODOM DEATH WANTS YOU T-Shirt
35635 KORN SKULLDELIS T-SHIRTS
55725 KORN UNISEX TEE: KNOCK WALL
35288 SLIPKNOT Antennas to Hell
35295 SLIPKNOT WAVES
49512 SLIPKNOT .5 THE GRAY CHAPTER
60188 SLIPKNOT UNISEX T-SHIRT: IOWA GOAT SHADOW (BACK PRINT)
60193 SLIPKNOT UNISEX T-SHIRT: GRAY CHAPTER SKULL (BACK PRINT)
60184 BLINK-182 UNISEX T-SHIRT: SIX ARROW SMILEY PURPLE
60186 GUNS N' ROSES UNISEX T-SHIRT: MONOCHROME CROSS (DIP-DYE)
60187 GUNS N' ROSES UNISEX T-SHIRT: APPETITE WASHED (DIP-DYE/MINERAL WASH)
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
10259 GUNS N' ROSES DISTRESSED BULLET
57801 BRING ME THE HORIZON Label Rip Yellow Amo T-shirt
35637 KORN STAGE T-SHIRTS
59856 PANTERA Pot Leaf Logo on Neon Green T-shirt
57238 BRING ME THE HORIZON UNISEX TEE: THE END (BACK PRINT)
45949 BRING ME THE HORIZON HEXAGRAM AMO SMALL YELLOW
59271 Children Of Bodom Unisex Tee: Nouveau Reaper
59272 IRON MAIDEN Unisex Tee: Trooper
59260 Kurt Cobain Unisex Tee: One Colour
59259 Kurt Cobain Unisex Tee: You Know You're Right
59277 MISFITS Unisex Tee: Classic Vintage
57237 BRING ME THE HORIZON UNISEX TEE: LOVE (BACK PRINT)
35590 BRING ME THE HORIZON COLOURS T-SHIRTS