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-26 10:21:15')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
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
23879 DEADHEARTZ BELT BRONZE
24571 SILLENT FROM ME STARVE -Ring Belt- BLACK
24572 SILLENT FROM ME STARVE -Ring Belt- WHITE
30132 BAND-MAID ガチャベルト 黒x白
31667 BAND-MAID ガチャベルト カーキxホワイト
31668 BAND-MAID ガチャベルト カーキxブラック
31669 BAND-MAID ガチャベルト 黒x黒
31690 Zephyren LETHER BELT-CRAFT LOGO - BLACK×WHITE
31785 REBEL8 STANDARD ISSUE BELT
33069 SPITFIRE BIG-H ST WEB BELTS BLACK/ORANGE
33070 SPITFIRE BH LTB WEB BELTS NICKLE/ARMY
33071 SPITFIRE CLASSIC WEB BELTS BLACK
33770 ANIMALIA AN17U-AC19 COTTON BELT 17SU TURQUOISE
33774 ANIMALIA AN17U-AC19 COTTON BELT 17SU BLUE
33777 ANIMALIA AN17U-AC19 COTTON BELT 17SU RED
33778 ANIMALIA AN17U-AC19 COTTON BELT 17SU PINK
33921 SILLENT FROM ME CRYPTIC -W Cord Belt- BLACK
34771 Subciety (サブサエティ) LONG WEB BELT ORANGE
34772 Subciety (サブサエティ) LONG WEB BELT OLIVE-DRAB
34773 Subciety (サブサエティ) LONG WEB BELT BLACK
34774 Subciety (サブサエティ) MEDICAL BELT BLACK
34775 Subciety (サブサエティ) MEDICAL BELT WHITE
35151 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT RED
35152 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT ORANGE
35153 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT BLACK/RED
35154 LILWHITE(dot) (リルホワイトドット) -PSYCHO- LONG BELT BLACK/WHITE
35962 Zephyren (ゼファレン) PAISLEY LETHER BELT WHITE
35963 Zephyren (ゼファレン) PAISLEY LETHER BELT BLACK
35967 Zephyren (ゼファレン) PAISLEY G.I BELT DARK.GREEN
36196 PUNK DRUNKERS pd総柄ガチャベルト - BROWN
36504 【ゲキクロ限定・予約商品】 a crowd of rebellion Gingerol Belt Black
36505 【ゲキクロ限定・予約商品】 a crowd of rebellion Gingerol Belt Yellow
36506 【ゲキクロ限定・予約商品】 a crowd of rebellion Gingerol Belt Red
36714 SILLENT FROM ME CRYPTIC -W Cord Belt-
36931 RIP DESIGN WORXX ガチャベルト WHITE
36932 RIP DESIGN WORXX ガチャベルト MINT GREEN
36933 RIP DESIGN WORXX ガチャベルト PURPLE
36934 RIP DESIGN WORXX ガチャベルト RED
37005 ALIVE YOU'RE ALIVE BELT Emerald
37006 ALIVE YOU'RE ALIVE BELT White
37770 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW BLK
37771 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW NAVY
37772 ANIMALIA LIAAN17A-AC03 COTTON BELT 17AW OLIVE
37903 NineMicrophones NYLON WEB BELT BLACK
38772 SILLENT FROM ME CHAOSTIAN -Web Belt- BLK/WHT
38773 SILLENT FROM ME CHAOSTIAN -Web Belt- BLK/BLK
39021 DISTURBIA CLOTHING Ring Pentagram Belt
39669 Subciety SHOELACE BELT SET(BLACK,WHITE,ORANGE)
39774 PUNK DRUNKERS あいつ目ガチャベルト WHITE
39775 PUNK DRUNKERS あいつ目ガチャベルト BLACK
39776 PUNK DRUNKERS あいつ目ガチャベルト ORANGE
39929 SANTA CRUZ Classic Dot Belt Charchoal
39930 SANTA CRUZ Classic Dot Belt Black
40304 Zephyren LONG TAPE G.I BELT BLACK
40841 SABBAT13 BORN TO BE BONE LONG BELT
40842 SABBAT13 BORN TO BE BONE LONG BELT RED
40843 SABBAT13 BORN TO BE BONE LONG BELT YELLOW
40977 LILWHITE(dot) (リルホワイトドット) LW-18SU-A01 -DIVIDED- LONG BELT BLKxWHT
40978 LILWHITE(dot) (リルホワイトドット) LW-18SU-A01 -DIVIDED- LONG BELT BLKxRED
40979 LILWHITE(dot) (リルホワイトドット) LW-18SU-A01 -DIVIDED- LONG BELT RED
40980 LILWHITE(dot) (リルホワイトドット) LW-18SU-A01 -DIVIDED- LONG BELT YELLOW
41156 ANIMALIA ANAN18S-AC13 COTTON BELT #002 BLACK
41157 ANIMALIA ANAN18S-AC13 COTTON BELT #002 WHITE
41491 Subciety (サブサエティ) LEATHER RING BELT BLACK
41492 Subciety (サブサエティ) LEATHER RING BELT YELLOW
41689 ANIMALIA AN18U-AC07 SASH BELT NAVY
41690 ANIMALIA AN18U-AC07 SASH BELT OLIVE
42375 【限定アイテム】 a crowd of rebellion Ill Reversible Belt BLACKxWHITE
42376 【限定アイテム】 a crowd of rebellion Ill Reversible Belt BLACKxRED
42377 【限定アイテム】 a crowd of rebellion Ill Reversible Belt ORANGE
42378 【限定アイテム】 a crowd of rebellion Ill Reversible Belt BLUE
42421 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT BLACK
42422 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT WHITE
42423 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT ORANGE
42524 SQUARE G.I. BELT BLACK
42525 SQUARE G.I. BELT WHITE
42526 SQUARE G.I. BELT RED
42527 SQUARE G.I. BELT ORANGE
42553 DISTURBIA CLOTHING Chainz Belt
42554 DISTURBIA CLOTHING Long Eyelet Belt
43270 EPTM.(エピトミ) EP8575 LOGO BELT BLACK
43272 EPTM.(エピトミ) EP8578 LOGO BELT RED
43978 SLIGHTLY NUMB VERTICAL CANVAS BELT CAMO
44092 mnml(ミニマル) WEB BELT YELLOW
44871 mnml(ミニマル) WEB BELT WHITE
45191 PUNK DRUNKERS リングバックルベルト GREEN/YELLOW
45192 PUNK DRUNKERS リングバックルベルト BLUE/GRAY
45379 Subciety 2019 福袋 -NEW YEAR BAG-
45671 mnml(ミニマル) WEB BELT Volt
45672 mnml(ミニマル) WEB BELT Lilac
45694 Subciety (サブサエティ) MAGNET G.I BELT BLACK
45695 Subciety (サブサエティ) MAGNET G.I BELT ORANGE
45696 Subciety (サブサエティ) MAGNET G.I BELT YELLOW
46759 mnml(ミニマル) WEB BELT Dust
48370 【Subciety x RADIO EVA】 SHOELACE BELT -RADIOEVA TOUR- SET(PURPLE,RED,YELLO)
48419 PUNK DRUNKERS たて四本ロゴガチャベルト WHITE
48420 PUNK DRUNKERS たて四本ロゴガチャベルト Black
48549 ROLLING CRADLE RING BELT / Pink
48550 ROLLING CRADLE RING BELT / Purple
48551 ROLLING CRADLE RING BELT / Blue
48564 MAGICAL MOSH MISFITS MxMxM CHECKER BELT (2WAY) WHITE
48565 MAGICAL MOSH MISFITS MxMxM CHECKER BELT (2WAY) GREEN
48566 MAGICAL MOSH MISFITS MxMxM CHECKER BELT (2WAY) PURPLE
48567 MAGICAL MOSH MISFITS MxMxM CHECKER BELT (2WAY) PINK
49617 DISTURBIA CLOTHING Studded Belt (Black)
49618 DISTURBIA CLOTHING Studded Belt (White)
49800 STAY SICK CLOTHING Anchor Logo Black Belt & Buckle
50129 SILLENT FROM ME KNOWN -G.I Web Belt- BLACK/WHITE
50130 SILLENT FROM ME KNOWN -G.I Web Belt- BLACK/BLACK
50305 LILWHITE(dot) LW-19AW-A01 LONG BELT (BLK)