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 dtb_products AS p
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-24 11:31:33')
AND pc.price02 > 13636
AND FIND_IN_SET(22, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70000 glamb (グラム) Holy Punks M-65 / ホーリーパンクスエムシックスティファイブ Check
69999 glamb (グラム) Holy Punks M-65 / ホーリーパンクスエムシックスティファイブ Brown
69717 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BROWN
69715 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BLACK
69716 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET RED
68639 PUNK DRUNKERS(パンクドランカーズ)ボンテージ風チェックパンツ - RED CHECK
68640 PUNK DRUNKERS(パンクドランカーズ)ボンテージ風チェックパンツ - YELLOW CHECK
70598 over print (オーバープリント) Rebirth shirts etc A-8
70597 over print (オーバープリント) Rebirth shirts etc A-7
70263 VIRGO(ヴァルゴ) PARALLEL SHIRT RED
64105 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] PURPLE
67606 PUNK DRUNKERS(パンクドランカーズ)泥酔チェックシャツ - GREEN CHECK
66990 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Yellow
66991 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Red
66989 glamb (グラム)GB0223/SH06 : Stand Collar Check SH / スタンドカラーチェックシャツ - Blue
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
65889 over print(オーバープリント) Crochet knitting Shirts (renga)
58374 WASTED PARIS Worker Pants Houdstooth Brown
64135 SLEEPING TABLET(スリーピング・タブレット) FARM [ FRINGE WOOL CHECK STOLE ] GREEN
64133 SLEEPING TABLET(スリーピング・タブレット) FARM [ FRINGE WOOL CHECK STOLE ] BLACK
64134 SLEEPING TABLET(スリーピング・タブレット) FARM [ FRINGE WOOL CHECK STOLE ] GRAY
65890 over print(オーバープリント) Crochet knitting Shirts (black)
65888 over print(オーバープリント) Crochet knitting Shirts (cream)
65859 ROLLING CRADLE(ローリングクレイドル) CHECK SHIRT / MULTI
63594 glamb (グラム) Heavy Damaged SH - Blue
63593 glamb (グラム) Heavy Damaged SH - Black
63386 Anti Social Social Club Dialtone Black Tie Dye Flannel
63384 Anti Social Social Club Dialtone Olive Tie Dye Flannel
63385 Anti Social Social Club Chromey Red Tie Dye Flannel
62209 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK CHECK
57456 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - RED CHECK
57455 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - NAVY CHECK
61376 SLEEPING TABLET (スリーピングタブレット) PYLON [ 6 POCKETS CHECK CARGO PANTS ] BROWN
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61034 MISHKA M61000617 JACKET
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
59459 Zephyren(ゼファレン) WIDE TAILORD JACKET BLACK / CHECK
60549 ROLLING CRADLE FLUFFY CREWNECK / BEIGE
60547 ROLLING CRADLE FLUFFY CREWNECK / BLACK
60548 ROLLING CRADLE FLUFFY CREWNECK / BLUE
60546 ROLLING CRADLE HOOD CHECK SHIRT / BLACK
57583 Zephyren(ゼファレン) EASY PANTS BROWN CHECK
57587 Zephyren(ゼファレン) EASY PANTS 8/S BROWN CHECK
49887 Zephyren(ゼファレン)LONG CHECK SHIRT S/S BLACK
57594 Zephyren(ゼファレン) SHORTS BROWN CHECK
58484 SILLENT FROM ME LAWYER -Wide Slacks- GRAY CHECK
56859 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” RED CHECK
58304 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] BLACK
58305 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] GRAY
58310 ROLLING CRADLE BIG CHECK SHIRT / BEIGE
58312 ROLLING CRADLE BIG CHECK SHORTS / BEIGE
57125 SABBAT13 BLACK HEART CHECK SHIRTS GRAY
56468 Subciety (サブサエティ) CPO COACH JKT- YELLOW
54986 Zephyren(ゼファレン)TRENCH COAT TWEED
54968 Zephyren(ゼファレン)WIDE TAILORD JACKET TWEED
56858 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” GRAY CHECK
56799 ROLLING CRADLE CHECK HOOD JACKET BLUE
56253 SILLENT FROM ME HARRIET -6pockets Wrap Skirt- GRAY CHECK
56255 SILLENT FROM ME HARRIET -6pockets Wrap Skirt- BLACK CHECK
56257 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- GRAY CHECK
56258 SILLENT FROM ME SILLENT FROM ME HARRY -Slim Slacks- BLACK CHECK
54784 PUNK DRUNKERS [PDSxTHUNDERBOX]ピクトグラムシャツ - BEIGE/BROWN
54800 PUNK DRUNKERS オタネルシャツ - ORANGE
55532 HEDWiNG Big Silhouette Plaid Shirt
54132 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] NAVY
54133 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] GRAY
54212 SLEEPING TABLET M [ FRAYED HEM LOOSE SHIRTS ] GREEN
55013 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - GREEN
56033 PARADOX PRINTED CHECK SHIRTS (BLUE)
53234 Zephyren(ゼファレン)SWITCHING SHIRT S/S MIX
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
47859 Subciety (サブサエティ) CHECK SHIRTS-BABYLON- YELLOW
15842 ROLLING CRADLE SWALLOW TAIL SHIRTL / Gray/Red
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
15844 ROLLING CRADLE RAKURAI LONG NEL / Red
16663 ROLLING CRADLE POP-ART CRAZY SHIRT / BigCrazy
16664 ROLLING CRADLE POP-ART CRAZY SHIRT / SmallCrazy
20665 Subciety CRAZY CHECK SHIRT L/S-Praha- BLACK
20666 Subciety CRAZY CHECK SHIRT L/S-Praha- GREEN
20669 Subciety GINGHAM CHECK SHIRT L/S-GLORIOUS- WHITE
22955 ROLLING CRADLE RAKURAI BIG SHIRT / White-Navy
22956 ROLLING CRADLE RAKURAI BIG SHIRT / Navy-Red
23975 ANIMALIA AN16U-SH04 SWAGGER #003 RED
23976 ANIMALIA AN16U-SH04 SWAGGER #003 BLACK
25646 Subciety DOBBY CHECK SHIRT L/S-Praha- BURGUNDY
25647 Subciety DOBBY CHECK SHIRT L/S-Praha- KHAKI
25648 Subciety OMBRE CHECK SHIRT L/S-THRON- BLACK
25649 Subciety OMBRE CHECK SHIRT L/S-THRON- RED
25650 Subciety OMBRE CHECK SHIRT L/S-THRON- MUSTARD
25667 Subciety BACK ZIP LONG SHIRT-CHECK- BLACK
26003 NineMicrophones OMBRE CHECK SHIRTL/S-Comrade- BLACK
26007 NineMicrophones CHECK SHIRT L/S-9MC Crew- RED
26008 NineMicrophones CHECK SHIRT L/S-9MC Crew- GREEN
26382 Zephyren (ゼファレン) LONG CHECK SHIRT S/S -Resolve- WHITE
26383 Zephyren (ゼファレン) LONG CHECK SHIRT S/S -Resolve- RED
26385 Zephyren (ゼファレン) LONG CHECK SHIRT S/S -Resolve- GRAY
27355 SQUARE 4/3 CHECK SHIRTS RED CHECK
27356 SQUARE 4/3 CHECK SHIRTS BLUE CHECK
28760 VIRGO 90S PSYCO SHIRTS BLACK
28762 VIRGO 90S PSYCO SHIRTS YELLOW
28865 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Red
28866 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Navy
28897 ROLLING CRADLE GRAVY BIG SHIRTS / Black
29143 Subciety (サブサエティ) PAISLEY COACH JACKET-GLORIOUS- BLACK
29412 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLACK
29413 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLUE
30018 SQUARE (スクエア) HOOD CHECK SHIRTS BLUE×RED
30020 SQUARE (スクエア) HOOD CHECK SHIRTS GREEN×YELLOW
30086 【予約商品】MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT WHITE
30087 MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT YELLOW
32283 SABBAT13 IGOR L/L HOOD NEL SHIRTS (WH)
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
37649 MUSIC SAVED MY LIFE (MSML) REVERSIBLE BOMBER JKT RED CHECK-PINK
38776 VIRGO Gradation check middle shirts RED
38777 VIRGO Gradation check middle shirts BLUE
39188 SQUARE LV CHECK SHIRTS BLUE CHECK
39189 SQUARE LV CHECK SHIRTS RED CHECK