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 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-19 21:13:37')
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 p.update_date DESC
LIMIT 480, 120
26150 I KILLED THE PROM QUEEN Monogram Tee
26152 I KILLED THE PROM QUEEN Monogram Zip Hoodie
26173 PARKWAY DRIVE PWD Black-Gray Beanie
26230 OPETH Morningrise Hoodie
26281 DROPKICK MURPHYS Drinking Skeleton Cross Zip Hood
26290 DROPKICK MURPHYS Jolly Roger Patch
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
28020 MYKA RELOCATE MYK-T01 TEE
28025 ATTILA BASEBALL T-SHIRT
28026 ATTILA A T-Shirt
28240 CITY LIGHTS Skeleton T-shirt
28295 THE BROWNING Skull Black
28301 UPON A BURNING BODY Logo All Over T-Shirt
28310 FRONZILLA Party People's Anthem Black TankTop
28569 EXODUS HORNED SKUL
28607 PINK FLOYD MELTING PRISM
28609 PINK FLOYD COMPASS
28627 GUNS N' ROSES HEADS VINTAGE
28641 AMON AMARTH WOLFORD
28663 DEMON HUNTER BASIC
28694 AUGUST BURNS RED DOVE
28710 SOILWORK ANCHOR
29691 T.U.K. SHOES A9230 Sleeping With Sirens Core
35602 DISTURBED FIRE BEHIND T-SHIRTS
35603 DISTURBED Up Your Fist T-Shirts
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
35619 GUNS N' ROSES 30th Photo T-Shrts
35690 NIRVANA Bleach Cassette Photo T-shirt
36238 SLAYER No Mercy-Black T-shirt
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
36695 SLAYER LARGE BLACK EAGLE
36784 DISTURBEDMusic As A Weapon 06-07 Tour T-shirt
36829 DISTURBED Ravens Jumbo Print-White t-shirt
36878 DISTURBED Up Your Fist T-Shirts RED
37032 PANTERA Reinventing Band
37034 PANTERA Band Flames T-Shirt
37737 SUICIDAL TENDENCIES 2ACSSPNST SUIOCIDAL CROSS LOGO PIN
39163 BLACK SABBATH LOTW white Tee
44862 ROB ZOMBIE×KILL STAR CLOTHING Baby Death Skater Skirt
49846 DISTURBED LOST SOULS
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
50415 MODERN DAY BABYLON 『COMA』
50416 MODERN DAY BABYLON 『Undefeated』
50417 MODERN DAY BABYLON 『Travelers』
50418 MODERN DAY BABYLON 『The Ocean Atlas』
51173 brokker “METALLICA” フィギュア
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
52509 BILLIE EILISH UNISEX TEE BLACK RACER LOGO (SLEEVE PRINT)
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52511 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) LIME GREEN
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52864 BILLIE EILISH UNISEX LONG SLEEVED TEE: SMILE (BACK & ARM PRINT) BLUE
52865 BILLIE EILISH UNISEX LONG SLEEVED TEE: MANINMAN BLUE
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress