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 =395
)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-29 03:43:05')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
20698 Subciety SWEAT-CAMOUFLAGE SALOON- WHITE
20704 Subciety (サブサエティ) SWEAT-COLLEGE- BLACK/ORANGE
35482 Zephyren (ゼファレン) SWEAT -PORTAL- BLACK
29707 SABBAT13 MONSTERS C/N SWEAT GREY
37117 SILLENT FROM ME RUBRIC -Crew Sweat- BLACK
45543 Zephyren(ゼファレン)SWEAT -MONOLITH- YELLOW
52447 STAPLE Neo Sport Nylon Crew
4795 DROP DEAD CLOTHING MONROE
7304 KILL STAR CLOTHING OCCULT SWEATSHIRT [B]
7487 TONIGHT ALIVE Tonight Alive Heart Script Eco Grey.
9047 SANTA CRUZ CLASSIC DOT CREW NECK LS BLACK
9862 KILL STAR CLOTHING MAGICK SWEATSHIRT [B]
9872 KILL STAR CLOTHING BATS SWEATSHIRT [B]
9873 KILL STAR CLOTHING BONE SWEATSHIRT [CAMO]
9877 KILL STAR CLOTHING NO SWEETHEART SWEATSHIRT
9879 KILL STAR CLOTHING LUCIFER SWEATSHIRT [CAMO]
9881 KILL STAR CLOTHING ABRACADABRA SWEATSHIRT
9883 KILL STAR CLOTHING 420 SWEATSHIRT
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
9894 KILL STAR CLOTHING GOETIA SWEATSHIRT
10027 MISHKA (ミシカ) AOD NECRONOMICON CREWNECK BLACK
10748 DROP DEAD CLOTHING CLIQUE SWEATER
10749 DROP DEAD CLOTHING OWENS SWEATER
10755 DROP DEAD CLOTHING RUPERT SWEATER
10949 FAMOUS STARS AND STRAPS Splatter Crewneck BLK
11168 PROTEST THE HERO Vulture Black Crewneck
11170 PROTEST THE HERO Bird Dive Black Crewneck
11214 Iwrestledabearonce Late Crest Black/Heather Crew
11317 BLACK CRAFT Wolf Howl Crewneck Sweater
11320 BLACK CRAFT Death Card Crewneck Sweater
11591 KILL STAR CLOTHING BANDANA SWEATSHIRT [B]
11592 KILL STAR CLOTHING DARKROOM SWEATSHIRT [B]
11593 KILL STAR CLOTHING EARTHLINGS SWEATSHIRT [B]
11595 KILL STAR CLOTHING ILLUMINATI SWEATSHIRT [B]
11596 KILL STAR CLOTHING KABBALAH SWEATSHIRT [B]
11600 KILL STAR CLOTHING PIZZAGRAM SWEATSHIRT [B]
11601 KILL STAR CLOTHING PURRGATORY SWEATSHIRT [B]
11602 KILL STAR CLOTHING REPTILE SWEATSHIRT [B]
11604 KILL STAR CLOTHING SPELL SWEATSHIRT [B]
11606 KILL STAR CLOTHING ABRACADABRA 50/50 SWEATSHIRT
11607 KILL STAR CLOTHING RIBCAGE 50/50 SWEATSHIRT
11620 KILL STAR CLOTHING FABLE CREW [MULTI]
11621 KILL STAR CLOTHING GET HIGH CREW [MULTI]
11622 KILL STAR CLOTHING MIDAS CREW [MULTI]
11623 KILL STAR CLOTHING PLZ DIE CREW [MULTI]
12667 KILL STAR CLOTHING WHATEVER SWEATSHIRT [B]
12672 KILL STAR CLOTHING ANCIENT SPACE CREW [MULTI]
12673 KILL STAR CLOTHING BLACK CATS CREW [MULTI]
12675 KILL STAR CLOTHING PASTEL MOON SWEATSHIRT
13620 DROP DEAD CLOTHING LIGHT AS CREWNECK
13896 DROP DEAD CLOTHING GOLDEN AXE
14295 ROLLING CRADLE CHIPS SWEAT WHITE
14297 ROLLING CRADLE CHIPS SWEAT NAVY
14325 ICECREAM CREWNECK ROYAL BLUE K820
14326 ICECREAM CREWNECK PINK K820
14327 ICECREAM CREWNECK BlACK K820
14337 KILL STAR CLOTHING COBRA SWEATSHIRT [MULTI]
14370 KILL STAR CLOTHING ZERO SWEATSHIRT [B]
14372 KILL STAR CLOTHING AS/IF SWEATSHIRT [MULTI]
14373 KILL STAR CLOTHING UNSOCIAL SWEATSHIRT [B]
14390 アマツカミ Mice Heart Sweat
14419 PUNK DRUNKERS 1/3切替トレーナー ORANGE
14468 KILL STAR CLOTHING KITTYGRAM SWEATSHIRT [B]
14523 KILL STAR CLOTHING BABYLON ROSE SWEATSHIRT [MULTI]
14524 KILL STAR CLOTHING COFFEE SWEATSHIRT [B]
14652 KILL STAR CLOTHING MORTEM II SWEATSHIRT [B]
14653 KILL STAR CLOTHING UTOPIA SWEATSHIRT
14682 FAMOUS STARS AND STRAPS RUCKUS CREWNECK FLEECE
14706 RUDIE'S DISORDER CREW SW
14757 KILL STAR CLOTHING NIGHTMARE SWEATSHIRT [B]
14847 ICECREAM CONES&BONES SWET GREEN
14912 MISHKA (ミシカ) OVERSIZED DEATH ADDER CREWNECK BLACK
14982 Agape Attire LIGHT IN THE DARK SWEATER
14994 RUDIE'S PASTE CREW SW BLUE/RED
15026 DROP DEAD CLOTHING CBA Crewneck
15108 GLAMOUR KILLS WOODSMAN CDR PULLOVER
15120 FAMOUS STARS AND STRAPS Paisley Big BOH Belt
15135 FAMOUS STARS AND STRAPS WRECKING CREWNECK FLEECE
15168 フクザワ 路地男子トレーナー 灰×白
15169 フクザワ 路地男子トレーナー 黒×金
15284 REBEL8 WOMENS LOGO LOCK UP CREWNECK
15338 WHITECHAPEL Simple Flag Black Crewneck Sweatshir
15364 TONIGHT ALIVE Crest Heather Grey Crewneck Sweat
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
15469 BLESS THE FALL Hollow Bodies Black Crewneck Sweats
15481 ATTILA Kings Black Crewneck
15499 MISHKA (ミシカ) Autopsy Vex Crew Neck
15531 ICECREAM CHERRY FACE CREANECK
15585 TEXAS IN JULY Void Charcoal Crewneck Sweatshirt
15653 ZEPHYREN (ゼファレン) SWEAT -Skull head- BLK
15657 ZEPHYREN (ゼファレン) SWEAT -Script- BLK
15659 ZEPHYREN (ゼファレン) SWEAT -Script- BLK×GLD
15660 ZEPHYREN (ゼファレン) SWEAT -Script- GRY
15662 ZEPHYREN (ゼファレン) SWEAT -VISIONARY- BLK
15779 KILL STAR CLOTHING SACRIFICE SWEATSHIRT [B]
15816 BLACK CRAFT Hail Satan And Drink Coffee Crewneck
15819 KILL STAR CLOTHING DEATH SWEATSHIRT [50/50]
15912 PUNK DRUNKERS hi-lifeトレーナー GRAY
15914 PUNK DRUNKERS hi-lifeトレーナー BURGUNDY
16532 KILL STAR CLOTHING Tartan Sweatshirt
16538 FAMOUS STARS AND STRAPS Mens Archer Crewneck Pull
16647 DROP DEAD CLOTHING For Your Pleasure Crewneck
16716 ICECREAM ALL OVER POPSICLE PINK
16717 ICECREAM ALL OVER POPSICLE BLUE
17504 DROP DEAD CLOTHING For Your Pleasure Crewneck
17942 KILL STAR CLOTHING GIZA SWEATSHIRT [B]
17943 KILL STAR CLOTHING(キルスター・クロージング) LUNAR SWEATSHIRT [B]
17944 KILL STAR CLOTHING PIZZA ORDER SWEATSHIRT [B]
17945 KILL STAR CLOTHING RUNE SWEATSHIRT [GLOSS]
17946 KILL STAR CLOTHING SERPENTINE SWEATSHIRT [B]
17947 KILL STAR CLOTHING SPACE GRASS SWEATSHIRT
17948 KILL STAR CLOTHING SUCK MY SYMBOL SWEATSHIRT [B]
17949 KILL STAR CLOTHING(キルスター・クロージング) UNICORN TAROT SWEATSHIRT [B]
18397 Subciety SWEAT-LARGE GLORIOUS- - WHITE
18401 Subciety SWEAT-SALOON- - BLACK
18405 Subciety SWEAT-New Jack- BLACK/WHITE
18984 WE CAME AS ROMANS Varsity Custom Heather Grey Crew
19100 ATTILA Guilty Pleasure Black Crewneck
19558 ZEPHYREN (ゼファレン) SWEAT -BEYOND - GRAY
19570 ZEPHYREN (ゼファレン) SWEAT -SKULL HEAD - BLACK