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-05-02 05:58:43')
AND pc.stock > 0
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
LIMIT 0, 120
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
2282 ASKING ALEXANDRIA DEVOUR T-Shirt
6582 ASKING ALEXANDRIA KILLER ROBOT T-Shirt
17973 UNEARTH SKATE RAGE
28694 AUGUST BURNS RED DOVE
35602 DISTURBED FIRE BEHIND T-SHIRTS
35609 FIVE FINGER DEATH PUNCH SGT MAJOR
39163 BLACK SABBATH LOTW white Tee
49846 DISTURBED LOST SOULS
50367 MODERN DAY BABYLON Ocean Atlas T-shirt
50369 MODERN DAY BABYLON Travelers T-shirt
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52511 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) LIME GREEN
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
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
12020 EVANESCENCE SHINE T-Shirt
51424 GREEN DAY Unisex Fashion Tee: American Idiot Vintage
54741 ANTHRAX UNISEX TEE: STATE OF EUPHORIA
55731 SLAYER UNISEX TEE: SOLDIER CROSS V.2
55734 SLAYER UNISEX TEE: SILVER EAGLE
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
56760 AC/DC LADIES ZIPPED HOODIE: LOGO (BACK PRINT)
56810 AC/DC UNISEX TEE: ANGUS STATUE
57797 FALLING IN REVERSE Knit Sweater Sweatshirt
59274 IRON MAIDEN Unisex Tee: Duality
59273 IRON MAIDEN Unisex Tee: Eddie Chained Legacy
60195 TWENTY ONE PILOTS UNISEX T-SHIRT: TRENCH CLIFF
60194 TWENTY ONE PILOTS UNISEX T-SHIRT: BANDITO BIRD
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
61823 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: LARGE LOGO & ALBUM
66969 PANTERA UNISEX PULLOVER HOODIE: 101 PROOF
66960 MEGADETH UNISEX PULLOVER HOODIE: COUNTDOWN TO EXTINCTION
67941 EVANESCENCE UNISEX T-SHIRT: SYNTHESIS
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
67976 YUNGBLUD UNISEX T-SHIRT: WEIRD FLAMING SKELETONS (BACK PRINT)
53874 MY CHEMICAL ROMANCE COFFIN T-Shirts
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
37811 ALL TIME LOW UNISEX TEE: SCRATCH
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
66966 MEGADETH UNISEX T-SHIRT: RUST IN PEACE 30TH ANNIVERSARY (BACK PRINT)
66968 MEGADETH UNISEX T-SHIRT: PEACE SELLS… TRACK LIST (BACK PRINT)
66967 MEGADETH UNISEX T-SHIRT: KILLING IS MY BUSINESS (BACK PRINT)
35655 PANTERA Red Vulgar T-Shirts
67503 PANTERA UNISEX T-SHIRT: HORNED SKULL STENCIL (BACK PRINT)
67931 BLUR UNISEX T-SHIRT: CIRCLE LOGO
2974 FOO FIGHTERS UNISEX TEE WASTING LIGHT
68572 IRON MAIDEN UNISEX T-SHIRT: THE FUTURE PAST TOUR '23 GREYSCALE
68570 IRON MAIDEN UNISEX T-SHIRT: PIECE OF MIND MULTI HEAD EDDIE
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
69367 RAGE AGAINST THE MACHINE UNISEX PULLOVER HOODIE: NUNS BLACK
69349 FOO FIGHTERS UNISEX LONG SLEEVE T-SHIRT: WASTING LIGHT (BACK & SLEEVE PRINT)
69353 SYSTEM OF A DOWN UNISEX LONG SLEEVE T-SHIRT: EYE COLLAGE
69370 THE 1975 UNISEX PULLOVER HOODIE: BLACK TOUR
69369 THE 1975 UNISEX PULLOVER HOODIE: NOACF
69161 DEF LEPPARD UNISEX T-SHIRT: HYSTERIA WORLD TOUR (BACK PRINT)
69160 DEF LEPPARD UNISEX T-SHIRT: SHATTER
69159 DEF LEPPARD UNISEX T-SHIRT: TRIANGLE LOGO
69158 DEF LEPPARD UNISEX T-SHIRT: CLASSIC TRIANGLE
69165 MOTLEY CRUE UNISEX T-SHIRT: BAD BOYS SHIELD
69164 MOTLEY CRUE UNISEX T-SHIRT: THEATRE OF PAIN CRY
69163 MOTLEY CRUE UNISEX T-SHIRT: FEELGOOD HOLLYWOOD REVISION
69162 MOTLEY CRUE UNISEX T-SHIRT: TOO FAST CYCLE
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
67972 SLIPKNOT UNISEX VARSITY JACKET: 9 POINT STAR (BACK PRINT) RED
67971 SLIPKNOT UNISEX VARSITY JACKET: 9 POINT STAR (BACK PRINT) BLACK
70945 SLEEP TOKEN UNISEX T-SHIRT: TAKE ME BACK TO EDEN
70947 SLEEP TOKEN UNISEX T-SHIRT: THE LOVE YOU WANT SKELETON
70946 SLEEP TOKEN UNISEX T-SHIRT: EUCLID
70944 SLEEP TOKEN UNISEX PULLOVER HOODIE: TOMB
70943 SLEEP TOKEN UNISEX PULLOVER HOODIE: HYPNOSIS
71313 MÅNESKIN UNISEX T-SHIRT: LIVE AT CIRCO MASSIMO 2022 FACES
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
67954 FALL OUT BOY UNISEX T-SHIRT: POISONED YOUTH
59266 Ed Sheeran Unisex Tee: Divide
59265 Ed Sheeran Unisex Tee: Chords
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
69366 NIRVANA UNISEX PULLOVER HOODIE: YELLOW HAPPY FACE BLACK
69351 NIRVANA UNISEX LONG SLEEVE T-SHIRT: ANGELIC GRADIENT (BACK & SLEEVE PRINT)
69352 NIRVANA UNISEX LONG SLEEVE T-SHIRT: GRADIENT HAPPY FACE (BACK & SLEEVE PRINT)
67968 NIRVANA UNISEX T-SHIRT: NEVERMIND ALBUM
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
68579 NIRVANA UNISEX T-SHIRT: HEART (WASH COLLECTION)
4598 NIRVANA Happy Face T-Shirt
59255 NIRVANA Unisex Tee:White Happy Face
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
69350 GUNS N' ROSES UNISEX LONG SLEEVE T-SHIRT: HOLLYWOOD TOUR (BACK & SLEEVE PRINT)
35620 GUNS N' ROSES BIG GUNS T-SHIRTS
36663 GUNS N' ROSES BULLET LOGO
10258 GUNS N' ROSES CROSS T-Shirt
68569 GREEN DAY UNISEX T-SHIRT: DOOKIE LONGVIEW (WASH COLLECTION)
68568 GREEN DAY UNISEX T-SHIRT: FLOWER POT (WASH COLLECTION)
51426 GREEN DAY Unisex Tee: Hypno 4
56758 GREEN DAY UNISEX HOODIE: AMERICAN IDIOT
53186 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SMILEY
70933 BLINK-182 UNISEX PULLOVER HOODIE: SIX ARROW SKULL
60185 BLINK-182 UNISEX T-SHIRT: NEON LOGO
67929 BLINK-182 UNISEX T-SHIRT: LONELY NIGHTS
70936 BLINK-182 UNISEX T-SHIRT: BIG SMILE