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 =6
)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-30 18:31:25')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70655 glamb(グラム) Slight Flower Shirts Black
70922 glamb (グラム) Midnight Flower Shirt Black
71383 VIRGOwearworks (ヴァルゴウェアワークス) Spark shirts BLACK
66329 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×ホワイト
66331 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×ベージュ
66330 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×グリーン
70927 【予約商品】glamb (グラム) Astro Sound Shirt White × Black
70923 【予約商品】glamb (グラム) Abstract Galaxy Shirt Black
70887 over print(オーバープリント)UMBRO * OVER PRINT GAME SHIRTS BLACK
69715 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BLACK
69380 Subciety (サブサエティ) BUFFALO CHECK SHIRT JKT BLACK
64094 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] BLACK
64100 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL PLAIN SHIRTS ] BLACK
68765 SLEEPING TABLET (スリーピングタブレット) FORBIDDEN [ CHECK SHIRTS ] BLACK
67417 矢野緋彩 × アマツカミ コラボ限定シャツ
64102 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] BLACK
68330 SLEEPING TABLET (スリーピングタブレット) CRYPTO[PATERNED OPAL SHIRTS] BLACK/WHITE
66979 glamb (グラム)GB0223/SH02 : Orient Flower SH / オリエントフラワーシャツ - Black
66140 glamb (グラム) GB0123/SH08 : Watercolor Marble SH / ウォーターカラーマーブルシャツ - Black
66957 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLACK
68099 over print(オーバープリント) patch shirts black
67831 SLEEPING TABLET(スリーピング・タブレット) HIDDEN [ LEATHER SHIRTS ]
61271 Zephyren 2022 NEW YEAR BAG
65691 NineMicrophones DOLMAN SLEEVE SHIRT-BLACK
60560 MISHKA M61000251 CHECK SHIRT
66264 ANIMALIA (アニマリア) SWAGGER L/S SHIRTS - ROSE
65078 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Black×Navy
63593 glamb (グラム) Heavy Damaged SH - Black
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
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
59493 Zephyren(ゼファレン) EMBLEM SHIRT L/S BLACK
59499 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - BLACK
63151 over print (オーバープリント) check shirts (black * blue)
63080 MISHKA (ミシカ) M21100280 SHIRT
61944 glamb (グラム) Paisley Pajamas SH - Black
61936 glamb (グラム) Watercolor SH - Black
61093 VIRGO CLOTH CARRYING SHIRTS BLACK
61698 Subciety (サブサエティ) VELOUR RUGGER SHIRT BLACK
60290 MISHKA M61000209 L/S SHIRT
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60663 MISHKA M61000203 SHIRT BLACK
59500 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - FLOWER
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
59538 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S YELLOW / BLACK
58975 Subciety (サブサエティ) WESTERN SHIRT - BLACK/GRAY
58976 Subciety (サブサエティ) WESTERN SHIRT - BLACK/BEIGE
58985 Subciety (サブサエティ) COVER ALL SHIRT - BLACK
60546 ROLLING CRADLE HOOD CHECK SHIRT / BLACK
58597 SLEEPING TABLET REVERIE NOBLE [ SILKY PAJAMA SHIRTS ] BLACK
59507 Zephyren(ゼファレン) SHIRT L/S - Resolve - BLACK / PAISLEY
58341 SILLENT FROM ME CHEAP -Band collar Shirts- BLACK
58332 CIVARIZE【シヴァーライズ】バタフライ切り替えバイカラーシャツ Black
57006 VIRGO Relaxed uniform shirts BLACK
58304 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] BLACK
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
57368 MISHKA M21000201 Shirt
58108 MISHKA M21000251 SHIRT
57013 VIRGO Middle Cuban shirt BLACK
56320 NineMicrophones WIDE SHIRT L/S BLACK
55011 Zephyren(ゼファレン)SWITCHING LONG SHIRT L/S - Resolve - BLACK
55969 ANIMALIA AN20A-SH02 “R.I.B. SHIRTS” BLACK
56894 SALUTE RACING PRINTER SHIRT
56857 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” BLACK CHECK
56561 CIVARIZE【シヴァーライズ】 ZIP付きロングシャツ BLACK
56232 SLEEPING TABLET STONE [ FRAYED HEM LOOSE SHIRTS ] BLACK
56155 CIVARIZE【シヴァーライズ】 3WAYドレープシャツ
55919 MISHKA MAW200201 SHIRTS
56115 SILLENT FROM ME CULTISM Long Length Shirts BLK
56117 SILLENT FROM ME CULTISM Long Length Shirts BK/WH
54273 Subciety PAISLEY SHIIRT BLACK
54276 Subciety PANEL SHIRT BLACK/BLACK
54279 Subciety WORK SHIRT BLACK
55007 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S BLACK / variat omnia tempus
19298 ZEPHYREN (ゼファレン) EMBLEM SHIRT L/S - BLACK
30211 Zephyren(ゼファレン) LONG SHIRT L/S -Resolve- BLACK
54994 Zephyren(ゼファレン)EMBLEM SHIRT L/S BLACK / fiat lux
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
37514 RUDIE'S (ルーディーズ) DRAWING LONG SHIRTS NATIVE BLACK
3039 Subciety EMBLEM SHIRT L/S-Plain- BLACK
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
2131 Subciety EMBLEM SHIRT 7/S DOT
14074 NineMicrophones STUDS SHIRTS L/S -Comrade- BLK
14075 NineMicrophones STUDS SHIRTS L/S -Comrade- BLK/DE
14120 subciety HERRINGBONE SHIRTS L/S -VIDALOCA- BLACK
14244 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/BGD
14245 NineMicrophones PATCHWORKSHIRTS FIGHT BACK BLK/WHT
14256 Subciety PAISLEY POCKET SHIRTS L/S-praha- BLK
14887 Subciety PAISLEY SHIRTS L/S BLACK
15750 Subciety EMBLEM SHIRT L/S 15th Anniversary BLK
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
18356 Subciety DENIM SHIRT L/S-NX- BLACK
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18373 Subciety EMBROIDERY SHIRT L/S-GLORIOUS- - BLACK
18739 NineMicrophones CHECK SHIRTL/S -Comrade- BLACK
19310 ZEPHYREN (ゼファレン) PAISLEY POCKET SHIRT L/S - BLACK
19312 ZEPHYREN (ゼファレン) PAISLEY POCKET SHIRT L/S - BLACK/STRIPE
20296 REBEL8 BLACK DENIM BUTTON-UP
20658 Subciety EMBLEM SHIRT L/S CAMOUFLAGE
20665 Subciety CRAZY CHECK SHIRT L/S-Praha- BLACK
20969 NineMicrophones (ナイン・マイクロフォンズ) B.D.U L/S-Judgement- BLACK
20973 NineMicrophones (ナイン・マイクロフォンズ) SLEEVE BORDER SHIRT BLK/WHT
21731 ROLLING CRADLE OVERLOUD POCKET SHIRT / Black
21734 ROLLING CRADLE WAVELET SHIRT / Black
22147 Subciety HEAVY FLANNEL SHIRT-GLORIOUS- WHITE
22148 Subciety EMBLEM HEAVY FLANNEL SHIRT BLACK
22539 Zephyren (ゼファレン) SWITCHING LONG SHIRT -Resolve- BLACK x CAMO
22591 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- BLACK
23350 GoneR Flower Star Shirts Parka - Black
23380 PUNK DRUNKERS フットボール風7分シャツ BLACK/WHITE
23395 Zephyren (ゼファレン) STRIPE SHIRT L/S -CASINO- BLACK
24374 PARADOX - LONG SHIRTS (BLACK)
24378 SILLENT FROM ME BRAIN-Hood Shirts- BLK
25623 Subciety EMBLEM SHIRT L/S-CAMOUFLAGE- BLACK
25662 Subciety PAISLEY WORK SHIRT L/S-EMOTION- BLACK
26003 NineMicrophones OMBRE CHECK SHIRTL/S-Comrade- BLACK
26012 NineMicrophones CAMOUFLAGE SHIRT-Strum your mind- BLACK
26022 NineMicrophones DENIM SHIRT L/S-Pray with the microphones- BLK