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 =328
)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-28 04:51:35')
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
52953 Survive Said The Prophet EVERY DAY SOX A
11121 REBEL8 RUN TO THE HILLS SOCKS BLK/WHT
11123 REBEL8 MUERTOS SOCKS
11124 REBEL8 BLACK LOGO SOCKS
13723 REBEL8 TILTED 8 LOGO SOCKS BLK
14856 REBEL8 BLACK/YELLOW LOGO SOCKS
15133 FAMOUS STARS AND STRAPS PAISLEY SOCKS BLK
17939 アマツカミ うそつき Socks
18111 KILL STAR CLOTHING COZMIC DEATH SOCKS
18112 KILL STAR CLOTHING THELEMA SOCKS
18648 Subciety GYM SOCKS - BLACK
19749 Zephyren (ゼファレン) GYM SOCKS -VISIONARY - BLACK
19814 MISHKA (ミシカ) CYCO REAPER SOCKS
20154 REBEL8 STEALTH WHITE SOCKS BLACK
20289 REBEL8 COVER THE 8 SOCKS
20586 FAMOUS STARS AND STRAPS HEAD LINE SOCKS
21400 アマツカミ 「あまつかみ」 Socks BLACK
21699 FAMOUS STARS AND STRAPS ANARCHY SOCKS
21820 FAMOUS STARS AND STRAPS MISFITS FACE SOCKS
21943 MISHKA (ミシカ) KEEP WATCH SOCKS BLACK/YELLOW
22280 KILL STAR CLOTHING Sad Socks
22373 PUNK DRUNKERS 反区庁靴下 黒文字
22374 PUNK DRUNKERS 反区庁靴下 白文字
22428 KILL STAR CLOTHING (キルスター・クロージング) Purrfect Socks
23285 REBEL8 DEGENERATE BLACK/RED SOCKS
23289 REBEL8 FLIP BLACK/GREY SOCKS
24221 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) SELF MADE SOCKS BLACK
24266 KILL STAR CLOTHING (キルスター・クロージング) Idol Socks
24267 KILL STAR CLOTHING (キルスター・クロージング) Ouija Socks
24746 WHITECHAPEL Sawblade Black - Socks
25017 REBEL8 8 PATTERN SOCKS
27526 KILL STAR CLOTHING (キルスター・クロージング) Killin' It Sporty Socks [B]
27969 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Pazer Socks
28032 SPITFIRE Bighead Old E Socks - Black/White
28259 STAY SICK CLOTHING Anchor Logo Black
28260 STAY SICK CLOTHING Galaxy All-Over-Print
28356 REBEL8 FLIP BLACK/RED SOCKS
29857 PARADOX PILE SOCKS (LAZOR)
29861 REBEL8 BLACK LOGO SOCKS
30042 KILL STAR CLOTHING Cats Ankle Socks [B]
31754 KILL STAR CLOTHING (キルスター・クロージング) Moonchild Ankle Socks [B]
31762 KILL STAR CLOTHING (キルスター・クロージング) Purr Evil Long Socks [B]
31771 KILL STAR CLOTHING (キルスター・クロージング) Salem Over The Knee Socks [B]
31781 KILL STAR CLOTHING (キルスター・クロージング) Bolt Superstar Long Socks [B]
32405 KILL STAR CLOTHING Pentagram Ankle Socks [B]
32579 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) BIG BEAT Socks BLACK
33943 KILL STAR CLOTHING (キルスター・クロージング) My Cat Ankle Socks [B]
33945 KILL STAR CLOTHING (キルスター・クロージング) Crafty Ankle Socks [B]
36207 RIP DESIGN WORXX 666 SWASH LOGO MIDDLE SOX
37050 MARILYN MANSON×KILL STAR CLOTHING Mansonite Stockings
37051 MARILYN MANSON×KILL STAR CLOTHING Number Of The Boss Stockings
37062 MARILYN MANSON×KILL STAR CLOTHING Snake Eyes Ankle Socks
38719 MISHKA (ミシカ) 2018 HAPPY BAG
39200 RIP DESIGN WORXX ショートソックス
39218 TOY MACHINE TMP18SX1 BLACK
39239 TOY MACHINE TMP18SX2 BLACK
39440 PUNK DRUNKERS UCIC靴下 BLACK
39526 KILL STAR CLOTHING Sweet Beams Long Socks [B]
39527 KILL STAR CLOTHING Sweet Beams Ankle Socks
39671 Subciety CREW SOCKS BLACK
39880 PARADOX GRAPHIC SOCKS BLACK
39913 SANTA CRUZ Hand Socks Black
39916 SANTA CRUZ OGSC Mini Socks Black
39935 PUNK DRUNKERS 骨靴下 BLACK
40549 KILL STAR CLOTHING Eden Ankle Socks [B]
40771 PUNK DRUNKERS アイツホンソックス BLACK
41925 MISHKA (ミシカ) MAW183301 SOCKS 1color
41926 MISHKA (ミシカ) MAW183302 SOCKS Black
41928 MISHKA (ミシカ) MAW183304 SOCKS Black
41950 MISHKA (ミシカ) MAW183305 SOCKS Black
41952 MISHKA (ミシカ) MAW183306 SOCKS Black
43001 Subciety (サブサエティ) SHADOW SOCKS BLACK
43162 RUDIE'S PHAT SOCKS BLACK
44009 SLIGHTLY NUMB FASTEAER SOCKS BLACK
44035 SANTA CRUZ SPANGLE SOCKS BLACK
44054 SANTA CRUZ SCREAMING VACATION SOCKS BLACK
44056 SANTA CRUZ HANDS ALLOVER SOCKS BLACK
44849 ROB ZOMBIE×KILL STAR CLOTHING Hellbilly Socks
45198 PUNK DRUNKERS [PDSxPAC-MAN]パックマンゴースト靴下 BLACK
45201 PUNK DRUNKERS 一つ目靴下 BLACK
45203 PUNK DRUNKERS 泥酔靴下 BLACK
46238 RUDIE'S DRAWING SOCKS BLACK
46755 ANIMALIA(アニマリア) AN19S-AC04 KNEE-HIGHS : LOGO BLACK
47627 SANTA CRUZ WALL HAND CREW SOCKS BLACK
47884 PUNK DRUNKERS 三段ロゴ靴下 BLACK
48182 KILL STAR CLOTHING Under The Stars Long Socks
48199 Subciety (サブサエティ) SOCKS-VINYL- BLACK
48573 MAGICAL MOSH MISFITS MxMxM どろどろ HIGHSOX BK/WH
48574 MAGICAL MOSH MISFITS MxMxM どろどろ HIGHSOX BK/GRN
48575 MAGICAL MOSH MISFITS MxMxM どろどろ HIGHSOX BK/DOKU
48576 MAGICAL MOSH MISFITS MxMxM どろどろ HIGHSOX BK/PNK
48577 MAGICAL MOSH MISFITS MxMxM どろどろ HIGHSOX BK/BLU
49463 SANTA CRUZ CHECK OGSC SOCKS BLACK
49465 SANTA CRUZ DOT REFLECTION SOCKS BLACK
49649 MISHKA MAW193308 SOCKS
49651 MISHKA MAW193301 SOCKS
49892 RUDIE'S MIGHTY SOCKS BLACK
51006 Subciety (サブサエティ) PAISLEY SOCKS BLACK
51287 VANS APPAREL SKATE CREW BLACK
51318 KILL STAR CLOTHING Moonbeam Long Socks
51527 MISHKA MSS203302F99 SOCKS BLACK
51632 【予約商品】MUSIC SAVED MY LIFE M1A1-GD01 LINE SOX WHITE&BLACK
51634 【予約商品】MUSIC SAVED MY LIFE M1A1-GD01 LINE SOX BLACK&WHITE
51768 PUNK DRUNKERS あいつ持たれてる靴下 BLACK
52417 Zephyren 2020 NEW YEAR BAG
52723 PUNK DRUNKERS ださいはカッコいい靴下 BLACK
52745 ROLLING CRADLE TYEDIE SOX ORANGE
52954 Survive Said The Prophet EVERY DAY SOX B
52955 Survive Said The Prophet EVERY DAY SOX C
52956 Survive Said The Prophet EVERY DAY SOX D
52965 RIPNDIP Lord Nermal Socks (Black Tie Dye)
52966 RIPNDIP Pill Socks (Black Tie Dye)
52971 RIPNDIP Lord Nermal Low Socks (Black)
53113 SAMURAI CORE 日ノ出 靴下 BLACK
53968 ANIMALIA AN20SP-AC01 MID SOX-Ealge BLACK
54531 SAMURAI CORE SR-AC-031C 風車靴下 BLACK
54658 MISHKA(ミシカ) MSS203305 SOCKS BLACK
54725 PUNK DRUNKERS レントゲン靴下 BLACK
49484 SANTA CRUZ CRUZ SOCKS CREW BLACK
33345 Zephyren (ゼファレン) GYM SOX -VISIOBARY- BLACKxWHITE