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 =394
)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-20 06:57:07')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
35835 Zephyren (ゼファレン) BIG JAGUARD KNIT -Cut the world- BLACK
45758 RIPNDIP Multi Knit Sweater (Multi)
9306 MISHKA (ミシカ) KEEP WATCH CARDIGAN RED BERRY
2851 DROP DEAD CLOTHING Girls Chillin
4794 DROP DEAD CLOTHING EYE HEART DROP DEAD
8139 MISHKA (ミシカ) KEEP WATCH CARDIGAN HEATHER GREY
8875 DROP DEAD CLOTHING DOOM CARDIGAN
10762 DROP DEAD CLOTHING YARD SALE KNITTED SWEATER
13520 RUDIE'S DIA KNIT CARDIGAN BLACK
13633 DROP DEAD CLOTHING CRAZY LIFE KNIT TOP
14469 Subciety 2015 福袋 25,000
14527 PUNK DRUNKERS にっとっとカーデ MINT
14528 PUNK DRUNKERS にっとっとカーデ BLUE
14635 Subciety GLORIOUS KNIT BLACK
14649 NineMicrophones PATCHWORK SWEATER BLACK/BURGUNDY
14651 NineMicrophones PATCHWORK SWEATER NAVY
15057 DROP DEAD CLOTHING Black Stabbath Crewneck
15115 NineMicrophones LINING CAMO CARDIGAN Black/white
15117 NineMicrophones LINING CAMO CARDIGAN KHAKI
15359 KILL STAR CLOTHING CHURCH KNIT SWEATER [B]
15853 Subciety EMBLEM CARDIGAN BLK
16643 DROP DEAD CLOTHING Gerald Jumper
16645 DROP DEAD CLOTHING Bad Luck Jumper
17501 DROP DEAD CLOTHING Cut Up Jumper
17508 DROP DEAD CLOTHING Join Us Crop Top
18181 DISTURBIA CLOTHING Slacker Stripe Cardigan
18340 Subciety V NECK KNIT-New Jack- - BLACK
18341 Subciety V NECK KNIT-New Jack- - GRAY
18344 Subciety GLORIOUS KNIT - GRAY
18349 Subciety CARDIGAN-Conductor- - BLACK
18350 Subciety CARDIGAN-Conductor- - GRAY
19352 ZEPHYREN (ゼファレン) EMBLEM CARDIGAN - BLACK
19353 ZEPHYREN (ゼファレン) EMBLEM CARDIGAN - BURGUNDY
19354 ZEPHYREN (ゼファレン) EMBLEM CARDIGAN - BLACK/STRIPE
19961 IRON FIST CLOTHING MISFITS CARDIGAN
20118 KILL STAR CLOTHING CREEP KNIT SWEATER [B]
20407 DROP DEAD CLOTHING Buzzing Jumper
20408 DROP DEAD CLOTHING Stay Dead Jumper
20410 DROP DEAD CLOTHING Buzzing Crop Top
21183 PUNK DRUNKERS 【PDSxROBOCOP】ロボコップニット BLACK
21455 THRASHER LOGO KINTTED NAVY
21456 THRASHER LOGO KINTTED GREEN
21767 PUNK DRUNKERS 【PDSxストリートファイター】コマンドニット RED
21769 PUNK DRUNKERS 【PDSxストリートファイター】コマンドニット GRAY
21866 ROLLING CRADLE CYCLOPS SHOUT KNIT / Blue
21867 ROLLING CRADLE CYCLOPS SHOUT KNIT / Navy
21870 DROP DEAD CLOTHING TYTC Jumper
22082 REBEL8 WOMENS 8 LOGO SWEATER
22083 REBEL8 WOMENS SHORT SLEEVE SWEATER LOGO TEE
22186 KILL STAR CLOTHING Skeletor Knit Sweater RED
22187 KILL STAR CLOTHING Skeletor Knit Sweater WHITE
22260 KILL STAR CLOTHING(キルスター・クロージング) Forever Knit Sweater
22261 KILL STAR CLOTHING(キルスター・クロージング) Ouija Knit Sweater
22276 KILL STAR CLOTHING Dropout Dead Crop Sweater
22277 KILL STAR CLOTHING Dropout Pentagram Crop Sweater
22412 KILL STAR CLOTHING(キルスター・クロージング) Hamsa Knit Sweater
22413 KILL STAR CLOTHING (キルスター・クロージング) My Eye Knit Sweater
22414 KILL STAR CLOTHING(キルスター・クロージング) Nobody Knit Sweater
22415 KILL STAR CLOTHING (キルスター・クロージング) Symbolic Knit Sweater
22416 KILL STAR CLOTHING (キルスター・クロージング) Pugsley Knit Sweater
22470 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Knit Hoodie
22471 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Knit Joggers
22472 DROP DEAD CLOTHING (ドロップデッド・クロージング) Blasphemy Cardigan
22475 DROP DEAD CLOTHING (ドロップデッド・クロージング) Shameless Knit Jumper
22483 DROP DEAD CLOTHING (ドロップデッド・クロージング) Avalanche Waffle Knit Jumper
22523 Zephyren (ゼファレン) EMBLEM CARDIGAN - BLACK
22524 Zephyren (ゼファレン) EMBLEM CARDIGAN - GRY
23356 GoneR Flower Skull Cardigan - Grey
23357 GoneR Flower Skull Cardigan - Navy
23358 GoneR Flower Skull Cardigan - Black
23397 ROLLING CRADLE 16BIT CROSS-KEY KNIT / Black
23399 ROLLING CRADLE 16BIT YXBA CARDIGAN / Black
23400 ROLLING CRADLE 16BIT CROSS-KEY KNIT / Black
23735 ANIMALIA Cotton Cardigan NAVY
23736 ANIMALIA Cotton Cardigan GRAY
23743 SABBAT13 IGOR C/N SWEAT CARDIGAN (BLACK)
23744 SABBAT13 IGOR C/N SWEAT CARDIGAN (OLIVE)
23771 KILL STAR CLOTHING (キルスター・クロージング) Abduction Knit Sweater [LTD]
24340 KILL STAR CLOTHING (キルスター・クロージング) Skeletor Knit Sweater [B]
24385 DISTURBIA CLOTHING PENTAGRAM CABLE
24588 アマツカミ 「悲。」 カーディガン BLK
24589 アマツカミ 「悲。」 カーディガン WHT
25603 Subciety (サブサエティ) LINE SWEATER-GLORIOUS- BLACK
25604 Subciety (サブサエティ) LINE SWEATER-GLORIOUS- BURGUNDY
25605 Subciety PAISLEY PATTERNED SWEATER OFF WHITE
25606 Subciety PAISLEY PATTERNED SWEATER CHARCOAL
25609 Subciety (サブサエティ) EMBLEM CARDIGAN BLACK
25610 Subciety (サブサエティ) EMBLEM CARDIGAN BEIGE
25923 Subciety (サブサエティ) ROVING SNOOD BLACK
25924 Subciety (サブサエティ) ROVING SNOOD GRAY
25925 Subciety (サブサエティ) ROVING SNOOD NAVY
27086 Zephyren (ゼファレン) EMBLEM CARDIGAN WHITE
27089 Zephyren (ゼファレン) LONG CARDIGAN -Resolve- BLACK
27092 Zephyren (ゼファレン) LONG CARDIGAN -Resolve- BLUE
27128 Zephyren (ゼファレン) SWITCHING BORDER LONG KNIT BLACK
27129 Zephyren (ゼファレン) SWITCHING BORDER LONG KNIT BLACKxWHITE
27130 Zephyren (ゼファレン) SWITCHING BORDER LONG KNIT GRAY
27135 Zephyren (ゼファレン) HOUNDSTOOTH KNIT WHITE
27136 Zephyren (ゼファレン) HOUNDSTOOTH KNIT WHITExBLACK
27531 KILL STAR CLOTHING (キルスター・クロージング) Stray Batwing Knit Top [B]
27532 KILL STAR CLOTHING (キルスター・クロージング) Got Plans Batwing Knit Top [B]
27533 KILL STAR CLOTHING (キルスター・クロージング) Hexagram Split-Knit Sweater [B]
27534 KILL STAR CLOTHING (キルスター・クロージング) Skeletor Split Knit Sweater [B]
27535 KILL STAR CLOTHING (キルスター・クロージング) Sketchy Batwing Knit Top [B]
27607 ANIMALIA AN16A-KN02 Sweater #002 NAVYL
28737 Subciety (サブサエティ) LINE SWEATER-GLORIOUS- NAVY
28945 PARADOX - CACHECOEUR (BLACK)
29124 KILL STAR CLOTHING (キルスター・クロージング) Luna Knit Sweater [B]
29125 KILL STAR CLOTHING (キルスター・クロージング) Season Knit Sweater [B]
29126 KILL STAR CLOTHING (キルスター・クロージング) The Calling Knit Dress [B]
29498 ROLLING CRADLE (ロリクレ) VAGABOND CYCLOPS -USA- KNIT / Navy
29658 VIRGO EVOLUTION DAMAGE MOHAIR ダメージニット
29945 VIRGO MARS CRAZE BORDER MOHAIR RED
30016 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK/WHITE
30017 SILLENT FROM ME MIMICRY -Knit Sweater- BLACK
30019 SILLENT FROM ME MIMICRY -Knit Sweater- WHITE
30036 KILL STAR CLOTHING Diana 90's Weirdo Crop Sweater [B]
30048 KILL STAR CLOTHING Horror Stayin In Knit Sweater [B]
30060 DISTURBIA CLOTHING Vex Destro Jumper
30061 DISTURBIA CLOTHING Pentagram Cardi