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 23:14:16')
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` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
44916 MISHKA (ミシカ) 2019 福袋 -NEW YEAR BAG-
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
66301 Subciety 2023 福袋 -NEW YEAR BAG-
45379 Subciety 2019 福袋 -NEW YEAR BAG-
50321 Subciety 2020 福袋 -NEW YEAR BAG-
56066 Subciety 2021 福袋 -NEW YEAR BAG-
52226 MISHKA (ミシカ) 2020福袋 -NEW YEAR BAG-
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
52417 Zephyren 2020 NEW YEAR BAG
63296 Anti Social Social Club Playboy x ASSC Bunny White Socks
63297 Anti Social Social Club Playboy x ASSC Bunny Black Socks
38719 MISHKA (ミシカ) 2018 HAPPY BAG
61280 LONELY論理 ONIBI SOCKS 3PACK
55642 Anti Social Social Club SOCAL WHITE SOCKS
55643 Anti Social Social Club SOCAL BLACK SOCKS
55644 Anti Social Social Club BROKEN ANKLE BLACK SOCKS
55645 Anti Social Social Club BROKEN ANKLE WHITE SOCKS
60204 Anti Social Social Club No Drama Black Socks
60205 Anti Social Social Club No Drama Pink Socks
63300 Anti Social Social Club Down The Tube Black/White Socks
63301 Anti Social Social Club Collapse Black Socks
63302 Anti Social Social Club Collapse White Socks
63387 Anti Social Social Club Down The Tube Pink/White Socks
63388 Anti Social Social Club Down The Tube Blue/White Socks
61629 TRAVAS TOKYO【トラバストーキョー】ロゴ刺繍ルーズレッグウォーマー White
61630 TRAVAS TOKYO【トラバストーキョー】ロゴ刺繍ルーズレッグウォーマー Black
22034 ROLLING CRADLE RC SOCKS 3PACK / A-set
22035 ROLLING CRADLE RC SOCKS 3PACK / B-set
22036 ROLLING CRADLE RC SOCKS 3PACK / C-set
61604 HYPER CORE VACCINATEDニーハイ
61605 HYPER CORE BOOSTニーハイ
61606 HYPER CORE GRUDGEニーハイ
61607 HYPER CORE MUMMYディザイアニーハイ
61608 HYPER CORE ピザイアニーハイ
47627 SANTA CRUZ WALL HAND CREW SOCKS BLACK
47628 SANTA CRUZ WALL HAND CREW SOCKS WHITE
49483 SANTA CRUZ CRUZ SOCKS CREW WHITE
49484 SANTA CRUZ CRUZ SOCKS CREW BLACK
56006 Subciety (サブサエティ) NEON SOCKS ORANGE
56007 Subciety (サブサエティ) NEON SOCKS YELLOW
56008 Subciety (サブサエティ) NEON SOCKS GREEN
58567 Subciety (サブサエティ) SOCKS BLACK
58568 Subciety (サブサエティ) SOCKS WHITE
68785 美園 礼音 × LONELY論理 コラボ限定ソックス
69310 高木美佑×DI:VISION×GEKIROCK CLOTHINGスペシャル・コラボ・ソックス
11039 VANS APPAREL CLASSIC LOW 3 PACK SOCKS BLACK
60770 TRAVAS TOKYO【トラヴァストーキョー】 LOGO KNEE HIGHSOX
51002 Subciety (サブサエティ) SOCKS-THE BASE- WHITE/BLUE
51003 Subciety (サブサエティ) SOCKS-THE BASE- WHITE/BURGUNDY
51004 Subciety (サブサエティ) SOCKS-THE BASE- YELLOW
51006 Subciety (サブサエティ) PAISLEY SOCKS BLACK
37050 MARILYN MANSON×KILL STAR CLOTHING Mansonite Stockings
37051 MARILYN MANSON×KILL STAR CLOTHING Number Of The Boss Stockings
62167 Subciety (サブサエティ) 3P LINE SOCKS
68540 RIPNDIP (リップンディップ) Nermal Loves Socks WHITE
68541 RIPNDIP (リップンディップ) Nermal Loves Socks BLACK
69580 RIPNDIP (リップンディップ) LORD NERMAL MID SOCKS DUSTY LAVENDER
69581 RIPNDIP (リップンディップ) NERMAL LOVES MID SOCKS (BLACK)
69582 RIPNDIP (リップンディップ) NERMAL LOVES SOCKS (CHARCOAL)
69583 RIPNDIP (リップンディップ) PEEKING NERMAL SOCKS (PURPLE & GOLD)
69584 RIPNDIP (リップンディップ) MONEYBAG SOCKS (OLIVE)
69585 RIPNDIP (リップンディップ) SUSHI NERM SOCKS
70615 RIPNDIP (リップンディップ)PEEKING NERMAL SOCKS (WHITE/LILAC)
70616 RIPNDIP (リップンディップ)LORD NERMAL SOCKS (WARM GRAY)
70617 RIPNDIP (リップンディップ)LORD NERMAL SOCKS (BLACK HEATHER)
71299 RIPNDIP (リップンディップ) ILY FUCKIN FUCK SOCKS
71300 RIPNDIP (リップンディップ) PEEKING NERMAL SOCKS (WHITE)
71301 RIPNDIP (リップンディップ) LORD NERMAL SOCKS (CHARCOAL)
71302 RIPNDIP (リップンディップ) LOVE YOU MID SOCKS (WHITE)
56050 SILLENT FROM ME CULTISM -Socks- BLACK&WHITE
70808 AIKA ELECTRONICS(アイカエレクトロニクス) Classic Leg Warmers【BLACK】
70809 AIKA ELECTRONICS(アイカエレクトロニクス) Classic Leg Warmers【WHITE】
11122 REBEL8 WHITE LOGO SOCKS
15133 FAMOUS STARS AND STRAPS PAISLEY SOCKS BLK
20586 FAMOUS STARS AND STRAPS HEAD LINE SOCKS
21697 FAMOUS STARS AND STRAPS SWA Socks
21699 FAMOUS STARS AND STRAPS ANARCHY SOCKS
21700 FAMOUS STARS AND STRAPS HEAD LINE SOCKS WHT
21820 FAMOUS STARS AND STRAPS MISFITS FACE SOCKS
28259 STAY SICK CLOTHING Anchor Logo Black
28260 STAY SICK CLOTHING Galaxy All-Over-Print
50674 NineMicrophones SOCKS-Name- BLACK
50675 NineMicrophones SOCKS-Name- WHITE
52744 ROLLING CRADLE TYEDIE SOX PINK
52745 ROLLING CRADLE TYEDIE SOX ORANGE
59208 WASTED PARIS Socks Wasted x Jimbo Phillips Monster WHITE
59211 WASTED PARIS Columbia Bridge Socks Pink
59212 WASTED PARIS Columbia Bridge Socks Lilac
59213 WASTED PARIS Columbia Bridge Socks Black
65391 SUPPLIER (サプライヤー) SNAKE SKATE SOCKS WHITE
65392 SUPPLIER (サプライヤー) SNAKE SKATE SOCKS BLACK
67895 RIPNDIP (リップンディップ) Lord Nermal Socks (Light Slate)
67896 RIPNDIP (リップンディップ) Lord Nermal Mid Socks (Olive)
49979 ガリュウホンポ 七目ソックス
49980 ガリュウホンポ 嫌ソックス
61720 HEDWiNG Back to laughter Socks White
20535 SPITFIRE Biggerhead socks - dip dye
48198 Subciety (サブサエティ) SOCKS-VINYL- WHITE
48199 Subciety (サブサエティ) SOCKS-VINYL- BLACK
64974 ROLLING CRADLE RC x KUDAN LOGO SOX / PINK
64975 ROLLING CRADLE RC x KUDAN LOGO SOX / BLUE
39526 KILL STAR CLOTHING Sweet Beams Long Socks [B]
12494 STANCE SOCKS SANTIAGO
12495 STANCE SOCKS ISABELLE
12502 STANCE SOCKS PLAYA DE PALM
16627 DEADHEARTZ SOX BLACK
16628 DEADHEARTZ SOX WHITE
47345 RIPNDIP Lord Nermal Socks (Light Orange)
47346 RIPNDIP Lord Nermal Socks (Baby Blue)
47347 RIPNDIP Lord Nermal Socks (Safety Green)
47348 RIPNDIP Lord Nermal Socks (Mint)
47349 RIPNDIP Lord Nermal Socks (Royal)
47350 RIPNDIP Lord Nermal Socks (Watermelon)
52845 Subciety GYM SOCKS WHITE/YELLOW
52846 Subciety GYM SOCKS WHITE/GREEN
52847 Subciety GYM SOCKS WHITE/BLUE
52964 RIPNDIP Lord Nermal Socks (Baby Blue Tie Dye)