SELECT SQL_CALC_FOUND_ROWS 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 =588
)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-04-26 17:27:37')
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, 120
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
11160 MEMPHIS MAY FIRE Shield Heather Hooded
11162 MEMPHIS MAY FIRE Crest Black Hooded
11164 MOTIONLESS IN WHITE We're Here To Stay Hoodie
11169 PROTEST THE HERO Vulture Black Hooded
11205 BLACK VEIL BRIDES Skyline Hoodie Black
11210 THE FACELESS Autotheism Hoodie Black
11212 I SEE STARS Logo Black Hoodie
11219 OF MICE & MEN Wave Faithfulness Black Hooded
15324 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather / Black
15325 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather/Burgundy
15392 ANIMALS AS LEADERS Green Emblem Black Hooded Pullo
15424 ISSUES Logo Heather Hooded
15432 ISSUES Logo Dark Heather Hooded
15433 ISSUES Monster Heather Hoodie
15600 TEXAS IN JULY Gatekeeper Black Hooded Pullover
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19014 REVOCATION Deathless Album Black
19019 WHITECHAPEL Bloody Blade Black
19806 CAPTURE THE CROWN Geisha Heather Hoodie
19855 OF MICE & MEN Text Heather Athletic Grey Hooded S.
24643 NECK DEEP Generic Pop Punk Red Marble - Pullover
24645 NECK DEEP Flag BlackShooting Eye Black - Pullover
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24676 SLEEPING WITH SIRENS Radio Black - Pullover
24754 WHITECHAPEL Crate Black - Pullover
25135 SEAWAY Colour Blind Logo Grey - Pullover
25185 IWRESTLEDABEARONCE Surf Dracula Multi-Rainbow - Pullover
25225 POLYPHIA Clouds Black - Pullover
25238 BLACK VEIL BRIDES Stitch Black - Pullover
25239 BLACK VEIL BRIDES Swirl Black - Pullover
25484 PIERCE THE VEIL San Diego Navy - Pullover
26230 OPETH Morningrise Hoodie
26268 DESCENDENTS Milo Goes To College Pullover
26291 DROPKICK MURPHYS Shamrock & Roll Pullover
26294 EMPEROR Logo Shield
26318 STRUNG OUT STWB Pullover
28299 UPON A BURNING BODY Horns Black - Pullover
36569 SLAYER Pentagram HOODIE
36767 RED HOT CHILI PEPPERS Washed Out Asterisk Hoodie
39165 BLACK SABBATH Sabbath LOTW Hoody
39167 LINKIN PARK Logo Hoody
39171 KORN Baby Hoody
39176 GUNS N' ROSES Logo Hoody
39181 MY CHEMICAL ROMANCE Haunt Hoody
41060 OBEY x Misfits Legacy of Phenome Pullover Hood BLACK
41061 OBEY x Misfits Legacy of Phenome Pullover Hood GREEN
41062 OBEY x Misfits Legacy of Phenome Pullover Hood WHITE
41063 OBEY The OBEY Fiend Club Pullover Hood PINK
41064 OBEY The OBEY Fiend Club Pullover Hood BLACK
41065 OBEY The OBEY Fiend Club Pullover Hood GRAY
41579 MOTORHEAD×LAKAI War Pigs Hoodie
43341 BRING ME THE HORIZON EYE HOODIE
43342 BRING ME THE HORIZON DYNAMITE HOODIE
44851 ROB ZOMBIE×KILL STAR CLOTHING Hellbilly Hockey Jersey
45656 BRING ME THE HORIZON YOU'RE CURSED HOODIE
45665 BRING ME THE HORIZON DYNAMITE HOODIE charcoal
50180 LINKIN PARK OML Oversize Hoody
51422 GREEN DAY Unisex Pullover Hoodie: Logo & Grenade
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
52592 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO & STAR (APPLIQUE MOTIFS)
52666 REBEL8×SLAYER Slayer Army Pullover Hoodie
52667 REBEL8×SLAYER South Of Heaven Pullover Hoodie
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
56759 AC/DC UNISEX PULLOVER HOODIE: CANNON SWIG
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
57296 SLIPKNOT UNISEX PULLOVER HOODIE: GOAT-S (BACK PRINT)
57295 IRON MAIDEN UNISEX PULLOVER HOODIE: LOTB LIVE ALBUM (ARM & BACK PRINT)
57800 CRADLE OF FILTH The Principle Of Evil Made Flesh Hoodie
35558 BRING ME THE HORIZON BANNER HOODIE
51194 SLIPKNOT UNISEX PULLOVER HOODIE: GRAPHIC GOAT (BACK PRINT)
61671 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) BLACK
61672 BEASTIE BOYS UNISEX PULLOVER HOODIE: CHECK YOUR HEAD (BACK PRINT) GRAY
61673 Ed Sheeran UNISEX PULLOVER HOODIE: BAD HABITS (BACK PRINT)
61664 METALLICA UNISEX PULLOVER HOODIE: 40TH ANNIVERSARY SONGS LOGO
53185 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: CROWN OF ROSES
61823 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: LARGE LOGO & ALBUM
57235 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: THE END (ARM PRINTS)
57234 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: HEX PHSH COVER
45657 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: AMO SYMBOLS
66969 PANTERA UNISEX PULLOVER HOODIE: 101 PROOF
66960 MEGADETH UNISEX PULLOVER HOODIE: COUNTDOWN TO EXTINCTION
57233 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: LOVE (BACK PRINT)
61826 LINKIN PARK UNISEX PULLOVER HOODIE: SMOKE LOGO
56761 AVENGED SEVENFOLD UNISEX PULLOVER HOODIE: SEIZE THE DAY
69364 NINE INCH NAILS UNISEX PULLOVER HOODIE: CLASSIC LOGO
69359 DEFTONES UNISEX PULLOVER HOODIE: AROUND THE FUR NAVY BLUE
69368 RAGE AGAINST THE MACHINE UNISEX PULLOVER HOODIE: NUNS (BACK PRINT) SAND
69367 RAGE AGAINST THE MACHINE UNISEX PULLOVER HOODIE: NUNS BLACK
69370 THE 1975 UNISEX PULLOVER HOODIE: BLACK TOUR
69369 THE 1975 UNISEX PULLOVER HOODIE: NOACF
69362 MOTLEY CRUE UNISEX PULLOVER HOODIE: DISTRESSED LOGO
69793 SLAYERxDC SHOES(ディーシーシューズ) ALLOVER PH
70277 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: LOGO
70281 KORN UNISEX PULLOVER HOODIE: ISSUES TRACKLIST (BACK PRINT)
69357 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: LOST
70944 SLEEP TOKEN UNISEX PULLOVER HOODIE: TOMB
70943 SLEEP TOKEN UNISEX PULLOVER HOODIE: HYPNOSIS
71252 MÅNESKIN Unisex Pullover Hoodie: Zitti e Buoni (Back Print & Ex-Tour)
58067 FOO FIGHTERS UNISEX PULLOVER HOODIE: MEDICINE AT MIDNIGHT TAPED
69365 NIRVANA UNISEX PULLOVER HOODIE: XEROX HAPPY FACE PINK GREY
69366 NIRVANA UNISEX PULLOVER HOODIE: YELLOW HAPPY FACE BLACK
56758 GREEN DAY UNISEX HOODIE: AMERICAN IDIOT
70933 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SKULL
69363 MY CHEMICAL ROMANCE UNISEX PULLOVER HOODIE: XV MARCHING FRAME (BACK PRINT)
56809 MY CHEMICAL ROMANCE UNISEX HOODIE: RACEWAY
66947 MY CHEMICAL ROMANCE UNISEX PULLOVER HOODIE: THE BLACK PARADE COVER
67509 RED HOT CHILI PEPPERS UNISEX PULLOVER HOODIE: CLASSIC ASTERISK
61822 METALLICA UNISEX PULLOVER HOODIE: SKULL FLOWER WASHED
69361 METALLICA UNISEX PULLOVER HOODIE: SKULL SCREAMING RED BLACK
70282 METALLICA UNISEX PULLOVER HOODIE: 72 SEASONS CHARRED LOGO (BACK PRINT)
69360 MARILYN MANSON UNISEX PULLOVER HOODIE: CLASSIC LOGO
66943 KORN UNISEX PULLOVER HOODIE: REQUIEM (BACK PRINT)
70679 KORN UNISEX PULLOVER HOODIE: STILL A FREAK (BACK PRINT)
70684 LINKIN PARK UNISEX PULLOVER HOODIE: METEORA WALL ART
70683 LINKIN PARK UNISEX PULLOVER HOODIE: STREET SOLDIER
61670 SLIPKNOT UNISEX PULLOVER HOODIE: MINNEAPOLIS '09 (BACK PRINT)
67510 SLIPKNOT UNISEX PULLOVER HOODIE: DON'T EVER JUDGE ME (BACK PRINT)
67511 SLIPKNOT UNISEX PULLOVER HOODIE: SELF-TITLED (BACK PRINT)