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-25 03:26:08')
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 120, 120
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
67962 MY CHEMICAL ROMANCE UNISEX T-SHIRT: MARCH
60189 MY CHEMICAL ROMANCE MY CHEMICAL ROMANCE UNISEX T-SHIRT: THE BLACK PARADE COVER
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)
67942 FALL OUT BOY UNISEX T-SHIRT: SAVE ROCK AND ROLL
67943 FALL OUT BOY UNISEX T-SHIRT: PUNK SCRATCH
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
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
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)
56758 GREEN DAY UNISEX HOODIE: AMERICAN IDIOT
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
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
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
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
69365 NIRVANA UNISEX PULLOVER HOODIE: XEROX HAPPY FACE PINK GREY
59264 Ed Sheeran Unisex Tee: Dashed Stage Photo
59265 Ed Sheeran Unisex Tee: Chords
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
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
70945 SLEEP TOKEN UNISEX T-SHIRT: TAKE ME BACK TO EDEN
67971 SLIPKNOT UNISEX VARSITY JACKET: 9 POINT STAR (BACK PRINT) BLACK
67972 SLIPKNOT UNISEX VARSITY JACKET: 9 POINT STAR (BACK PRINT) RED
70277 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: LOGO
69779 SLAYERxDC SHOES(ディーシーシューズ) SHOECO HSLAYERxDC SHOES(ディーシーシューズ) PURE
69780 SLAYERxDC SHOES(ディーシーシューズ) STAG
69793 SLAYERxDC SHOES(ディーシーシューズ) ALLOVER PH
67934 BRING ME THE HORIZON UNISEX T-SHIRT: ZOMBIE HANDS
50312 BRING ME THE HORIZON CROOKED YOUNG (BURN OUT) charcoal
35589 BRING ME THE HORIZON The H T-Shirts
35598 BRING ME THE HORIZON Alone & Depressed
69775 SLAYERxDC SHOES(ディーシーシューズ) MANTECA 4
69776 SLAYERxDC SHOES(ディーシーシューズ) MANUAL HI
69777 SLAYERxDC SHOES(ディーシーシューズ) MANUAL SLIP
69778 SLAYERxDC SHOES(ディーシーシューズ) SHOECO HSSLAYERxDC SHOES(ディーシーシューズ) NET
69362 MOTLEY CRUE UNISEX PULLOVER HOODIE: DISTRESSED LOGO
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)
62576 METALLICA FADE TO BLACK DAYPACK BACKPACK
62577 METALLICA FADE TO BLACK SKATE BAG
62580 METALLICA KILL EM ALL CROSS BODY BAG
62578 METALLICA FADE TO BLACK WALLET
69369 THE 1975 UNISEX PULLOVER HOODIE: NOACF
69370 THE 1975 UNISEX PULLOVER HOODIE: BLACK TOUR
62598 MY CHEMICAL ROMANCE PARADE TRAVEL BAG
62599 MY CHEMICAL ROMANCE PARADE WALLET
69347 CRADLE OF FILTH UNISEX LONG SLEEVE T-SHIRT: EXISTENCE BAND (BACK & SLEEVE PRINT)
69353 SYSTEM OF A DOWN UNISEX LONG SLEEVE T-SHIRT: EYE COLLAGE
69348 DAVID BOWIE UNISEX LONG SLEEVE T-SHIRT: HAMMERSMITH ODEON (SLEEVE PRINT)
69349 FOO FIGHTERS UNISEX LONG SLEEVE T-SHIRT: WASTING LIGHT (BACK & SLEEVE PRINT)
69367 RAGE AGAINST THE MACHINE UNISEX PULLOVER HOODIE: NUNS BLACK
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
68572 IRON MAIDEN UNISEX T-SHIRT: THE FUTURE PAST TOUR '23 GREYSCALE
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)
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
36681 MEGADETH MEGADETH YAMAHA DRUMS
66941 BAD RELIGION UNISEX T-SHIRT: BURNING BLACK
37811 ALL TIME LOW UNISEX TEE: SCRATCH
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