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-28 23:35:02')
AND FIND_IN_SET(1, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 120, 120
58839 NieR (ニーア) STYLISH BLACK Y-SHIRT
58844 NieR (ニーア) COSMO Y-SHIRT
58149 RIP DESIGN WORXX Rest in Punk メッセージシャツ BLACK
58341 SILLENT FROM ME CHEAP -Band collar Shirts- BLACK
58481 TRAVAS TOKYO Print Denim 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
53167 RIP DESIGN WORXX クロスドルーズシャツ CHICANO BLACK
56561 CIVARIZE【シヴァーライズ】 ZIP付きロングシャツ BLACK
56232 SLEEPING TABLET STONE [ FRAYED HEM LOOSE SHIRTS ] BLACK
56155 CIVARIZE【シヴァーライズ】 3WAYドレープシャツ
55401 VIRGO ROCKET LONG SHIRTS - BLACK
55919 MISHKA MAW200201 SHIRTS
56115 SILLENT FROM ME CULTISM Long Length Shirts BLK
56117 SILLENT FROM ME CULTISM Long Length Shirts BK/WH
55532 HEDWiNG Big Silhouette Plaid Shirt
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
55941 NieR (ニーア) ブロッキングプルオーバーシャツ【NieR LOGO】
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
51448 NieR (ニーア) ORIGINAL Y-SHIRT【insecure】
55304 NieR (ニーア) ブロッキングプルオーバーシャツ【♠♡♣♢】
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
26711 Zephyren (ゼファレン) EMBLEM SHIRT L/S CHECKⅡ
26733 Zephyren (ゼファレン) LONG SHIRT BLACKxAce of spades
27079 Zephyren (ゼファレン) LONG CHECK SHIRT -Resolve- WHITE
27080 Zephyren (ゼファレン) LONG CHECK SHIRT -Resolve- BLACK
28137 REBEL8 BILL GREY FLANNEL
28237 Subciety (サブサエティ) BOWLING SHIRT L/S-NX- BLACK
28418 RUDIE'S SPARK WORK SHIRTS BLK
28423 RUDIE'S VICE WORK SHIRTS BLK
28545 Subciety PAISLEY POCKET SHIRTS L/S-Conductor- BLK
28776 VIRGO GOAST DRAPE DOLMAN SHIRTS BLACK
29172 Subciety (サブサエティ) OMBRE CHECK WESTERN SHIRT L/S-Praha- BLACK
29404 NineMicrophones (ナインマイクロフォンズ) CHECK SHIRT L/S-Comrade- BLACK
29407 NineMicrophones (ナインマイクロフォンズ) OXFORD SHIRT L/S-Sunny- BLACK
29843 RUDIE'S ANIMAL LONG HOOD SHIRTS BLACK
29845 RUDIE'S DRAWING LONG CHECK SHIRTS BLACK
30038 KILL STAR CLOTHING Aurora Magical F**k Button-Up Shirt [B]
30054 DISTURBIA CLOTHING Anti-Social Shirt
30063 DISTURBIA CLOTHING Melvin Plaid Shirt
30086 【予約商品】MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT WHITE
30149 Zephyren(ゼファレン) LONG SHIRT -CocaCola- BLACK
30207 Zephyren(ゼファレン) CHECK SHIRT L/S BLACK
30212 Zephyren(ゼファレン) LONG SHIRT L/S PAISLEY
30218 Zephyren(ゼファレン) LONG CHECK SHIRT L/S BLACK
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
32322 REBEL8 WWD FLANNEL
32392 THE TEST GRAPHIC SHIRTS
32538 PUNK DRUNKERS あいつクロス切替シャツ BLACK
32543 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT Black
33416 アマツカミ 弔 Long Sleeve Shirt
33436 SILLENT FROM ME NAP -Wide Shirts- BLACK
33446 LILWHITE(dot) -SEI TO SHI- RIBBON HOODSHIRT BLKxWHT
33922 VIRGO Step switch long shirts ロングシャツ BLACK
33988 PARADOX - LONG SHIRTS (BLACK)
34651 Subciety (サブサエティ) PAISLEY SHIRT BLACK
34653 Subciety (サブサエティ) DENIM WESTERN SHIRT BLACK
34660 Subciety (サブサエティ) WORK STRIPE SHIRT BLACK
34856 NineMicrophones TWIST CHECK SHIRT L/S BLACK
34862 NineMicrophones WORK SHIRT L/S-ANTI- BLACK
35757 Zephyren (ゼファレン) EMBLEM SHIRT L/S BLACKxPAINT
35760 Zephyren (ゼファレン) BANDANA CHECK SHIRT L/S -Inhale the black- BLACK
35769 Zephyren (ゼファレン) PONCHO SHIRT L/S -Resolve- BLACK
35770 Zephyren (ゼファレン) PONCHO SHIRT L/S -Resolve- PAISLEY