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 =329
)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 02:21:13')
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 p.update_date DESC
LIMIT 0, 120
70881 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt OD
70880 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt NAVY
70879 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt BLACK
43842 Artemis Classic ACBT0010 4ピース唐草ベルト
67419 矢野緋彩 × アマツカミ コラボ限定ベルト
68070 Subciety (サブサエティ) G.I BELT WHITE
68069 Subciety (サブサエティ) G.I BELT BLUE
68068 Subciety (サブサエティ) G.I BELT BLACK
67499 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Apple green
67500 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Gold
67497 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Black
67498 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Wine red
65299 花巻 乙和×DI:VISION コラボ 限定 ガチャベルト
61271 Zephyren 2022 NEW YEAR BAG
61347 SLEEPING TABLET BANDAGE [ W RING BELT ] BLACK
65653 SAMURAI CORE(サムライコア) 初期衝動宣言BELT BLACK
65654 SAMURAI CORE(サムライコア) 初期衝動宣言BELT RED
65655 SAMURAI CORE(サムライコア) 初期衝動宣言BELT WHITE
36195 PUNK DRUNKERS pd総柄ガチャベルト - カラフル
65324 over print(オーバープリント) Belt×UNIVERSAL OVERALL white
65325 over print(オーバープリント) Belt×UNIVERSAL OVERALL boader
65326 over print(オーバープリント) Belt×UNIVERSAL OVERALL black
61348 SLEEPING TABLET BANDAGE [ W RING BELT ] WHITE
61349 SLEEPING TABLET BANDAGE [ W RING BELT ] BLUE
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
52488 【バンドリ!×ゲキクロ 第4弾復刻】DI:VISION×若宮 イヴ コラボ 限定 ベルト
52877 【バンドリ!×ゲキクロ 第5弾復刻】Subciety×瀬田 薫コラボ 限定 ベルト
58502 ガリュウホンポ ロゴガチャベルト
57952 Subciety (サブサエティ) CAUCHO BELT - NAVY/BURGUNDY
57953 Subciety (サブサエティ) CAUCHO BELT - NAVY/GREEN
49505 DI:VISION “REPEATED” LONG BELT WHITE
49504 DI:VISION “REPEATED” LONG BELT BLACK
58241 PUNK DRUNKERS 立ち入り禁止ガチャベルト - WHITE/BLACK
58240 PUNK DRUNKERS 立ち入り禁止ガチャベルト - YELLOW/BLACK
52828 Subciety CAUCHO BELT BLACK
35970 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- BLACK
50365 ANIMALIA AN19M-AC02 ROPE-BELT BLACK
30782 Zephyren(ゼファレン) PAISLEY G.I BELT BLACK
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
35969 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- WHITE
56066 Subciety 2021 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
57215 RIP DESIGN WORXX 2021 ライダース福袋 BLACK
57216 RIP DESIGN WORXX 2021 ライダース福袋 BEIGE
55226 Zephyren(ゼファレン)PAISLEY G.I BELT BEIGE
56217 Anti Social Social Club See Right Thru Me Pink Belt
56218 Anti Social Social Club See Right Thru Me Black Belt
55588 SABBAT13 GHOST LOGO BELT ブラック
55589 SABBAT13 GHOST LOGO BELT レッド
55590 SABBAT13 GHOST LOGO BELT イエロー
30786 Zephyren(ゼファレン) PAISLEY G.I BELT NAVY
49978 ガリュウホンポ ガリュウホンポガチャベルト
35971 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- NAVY
35972 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- BEIGE
44091 mnml(ミニマル) WEB BELT BLACK
44093 mnml(ミニマル) WEB BELT RED
44094 mnml(ミニマル) WEB BELT ORANGE
46773 mnml(ミニマル) WEB BELT OLIVE
52830 Subciety CAUCHO BELT NAVY/GREEN
52829 Subciety CAUCHO BELT NAVY/BURGUNDY
54724 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 クリアベルト YELLOW
54723 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 クリアベルト CLEAR
4406 Nine Microphones LEATHER BELT -Punk Skater-WH/BK
4407 NineMicrophones LEATHER BELT -Punk Skater-BK/WH
4755 Subciety LEATHER BELT -CRAFT LOGO- BLK/GOLD
4826 LOWLIFE Wallace - Riveted Belt Slate Grey
4827 LOWLIFE Wallace Riveted Belt BLACK
4828 LOWLIFE Triples Studded Belt Black/White
6470 NineMicrophones G.I BELT Black
6471 NineMicrophones G.I BELT Blue
6472 NineMicrophones G.I BELT Beige
6473 NineMicrophones G.I BELT Khaki
7056 Subciety CAUCHO BELT GREEN
7057 Subciety CAUCHO BELT BLACK/RED
7058 Subciety CAUCHO BELT BLACK/GREEN
8460 raise 8 apparel NY leather belt BLACK
8461 raise 8 apparel NY leather belt RED
10344 LOWLIFE IRON MAIDEN BOTB STUD REVERSIBLE Belt
10345 LOWLIFE IRON MAIDEN Live After Death Belt
10346 LOWLIFE JACK PHOTO PRINT Belt
10347 LOWLIFE Black Red Swyd Perf Belt
10572 LOWLIFE FALLEN STAR STUD Belt BLACK/PINK
10573 LOWLIFE FALLEN STAR STUD Belt BLACK/YELLOW
10583 LOWLIFE COVER UP SLIM Belt BLACK
10660 MISHKA (ミシカ) ETD CRACKLED DEBOSSED BELT BLACK
13249 LOWLIFE SHRINK PYRAMID STUDDED BELT - GUN/RED
13251 LOWLIFE Devoid Studded Belt - Black/Blue
13254 LOWLIFE Wallace The Blk Blue Rivets
13255 LOWLIFE Clyde Textured Black
13258 LOWLIFE Triple S Studded Belt Royal Blue/Blue
13259 LOWLIFE Thrash Digtal print
13260 LOWLIFE MIX Degital Print
14629 REBEL8 ZEUS BELT
15521 ICECREAM GI BELT GREEN
15526 ICECREAM GI BELT BLUE
16245 Subciety LEATHER BELT-CRAFT LOGO- BLACK/WHITE
16246 Subciety LEATHER BELT-CRAFT LOGO- BLACK/GOLD
16247 Subciety LEATHER BELT-CRAFT LOGO- BROWN
16248 Subciety CAUCHO BELT - BLACK
18621 Subciety G.I.BELT - BLACK/WHITE
18622 Subciety G.I.BELT - BLACK/BURGUNDY
18623 Subciety G.I.BELT - BURGUNDY
18624 Subciety G.I.BELT - BEIGE
19109 LOWLIFE DUB Neon green yellow
19113 LOWLIFE ADDER Leopard
19115 LOWLIFE TRIPLE S Neon Yellow
19116 LOWLIFE TRIPLE S Neon Green
19119 LOWLIFE MOTORHEAD WARPIG
19120 LOWLIFE SINGLE STUD Black Silver
19121 LOWLIFE SINGLE STUD Neon Pink
19125 LOWLIFE CLYDE Brown
19740 Zephyren LETHER BELT-CRAFT LOGO - WHITE
19741 Zephyren LETHER BELT-CRAFT LOGO - BLACK
20030 LOWLIFE Cover Up Neon Pink
20160 REBEL8 SUDS BELT
20197 THRASHER Skategoat CLAMP BELT
23234 Subciety ALOHA BELT NAVY
23877 DEADHEARTZ BELT BLK
23878 DEADHEARTZ BELT GOLD