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 =571
)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 01:40:01')
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
71511 Subciety(サブサエティ) JACQUARD PAISLEY SHIRT BLACK
71508 Subciety(サブサエティ) OPEN COLLAR STRIPE SHIRT BLACK
71246 Subciety(サブサエティ) FLOWER PAISLEY SHIRT BLACK
70822 Subciety(サブサエティ)LACE SHIRT BLACK
70921 glamb (グラム) LA Photo Shirt Black
70925 glamb (グラム) Eaten Apple Shirt Black
70023 glamb (グラム) Leopard Bowling Shirts / レオパードボウリングシャツ Black
69277 TOY MACHINE (トイマシーン) FIST WAPPEN STRIPE LOOSE FIT SS SHIRTS BLACK
69276 TOY MACHINE (トイマシーン) VACCINE LOOSE FIT SS SHIRTS BLACK
69063 Dogmatic Gourmet x over print x RIP DESIGN WORXX キューバシャツセットアップ
67608 PUNK DRUNKERS(パンクドランカーズ)PDS CARDシャツ - BLACK
68355 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) RIDE CLUB SHIRT Black
68592 SABBAT13(サバトサーティーン) SPOOK CUBA SHIRTS BLACK
68382 SABBAT13(サバトサーティーン) LAST PARADISE S/S SHIRTS (BLACK)
68531 RIPNDIP (リップンディップ) Big Pussy Energy Button Up BLACK
68074 Subciety(サブサエティ) GINGHAM CHECK EMBLEM SHIRT BLACK
68047 Subciety (サブサエティ)FLOWER PATTERN SHIRT BLACK×YELLOW
67401 Subciety (サブサエティ) CUBA SHIRT BLACK
63104 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLACK
1581 Subciety EMBLEM SHIRT S/S-Plain- BLACK
68460 VIRGOwearworks (ヴァルゴウェアワークス) Vintage mily hawaii shirt BLACK
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
68256 BAD BOY (バッドボーイ) FRAME JQD KNIT SHIRT BLACK
58579 MISHKA(ミシカ) M21000204 S/S Shirt
62655 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - BLACK
65145 ANIMALIA BIG SILHOUETTE POLO SHIRTS -WORK SUCKS-
64246 SABBAT13(サバトサーティーン) SPOOK SAFARI SHIRTS BLACK
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
64268 RIPNDIP (リップンディップ) Aloha Nerm Short Sleeve Button Up (Black)
62152 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLACK
62648 PUNK DRUNKERS ホラーアロハシャツ - CHARCOAL
63408 ZERO EVOKE (ゼロイヴォーク) Irregular logo S/S shirt BLACK
63885 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / BLACK
60887 PUNK DRUNKERS [PDSx阪神タイガース]阪神ベースボールシャツ - BLACK
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
63216 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - BLACK
63214 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BLACK
63725 over print (オーバープリント) Lotus HS shirts (black)
61380 SLEEPING TABLET X [ WIDE SHORT SLEEVE SHIRTS ] BLACK
62214 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - PAISLEY
62228 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - BLACK / DRAGONFLY
62226 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - FLOWER
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK
57442 Zephyren(ゼファレン) EMBLEM SHIRT S/S MIX
62208 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK / PAISLEY
62209 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK CHECK
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
61925 glamb (グラム) Nixon Aloha SH - Black
62566 NineMicrophones CRAZY SHIRT BLACK/WHITE
62567 NineMicrophones CRAZY SHIRT MULTI
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
61096 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BLACK
60159 Anti Social Social Club STATIC ORANGE BUTTON UP
60158 Anti Social Social Club STATIC BLACK BUTTON UP
58172 PUNK DRUNKERS 豹シャツ - BLACK/GRAY
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
57438 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BLACK
57451 Zephyren(ゼファレン) SHIRT S/S - Resolve - FLOWER
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
56433 Subciety CHILL SHIRT- BLACK
59226 ROLLING CRADLE TV STATIC SHIRT BLACK
58362 KILL STAR CLOTHING Wild Side Work Shirt
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58546 SABBAT13 13TALED FOX ALOHA SHIRTS ブラック
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
58491 RUDIE'S SPARK OPENCOLLAR SHIRTS BLACK
58372 WASTED PARIS Shirt Apologies Black
58373 WASTED PARIS Shirt Mazzy Black
54767 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS BLACK
55649 THRASHER TH5179 S/S WORK SHIRT BLACK
55647 THRASHER TH5178 SKATE AND DESTROY S/S Shirt BLACK
53256 Zephyren(ゼファレン)PHOTO PRINT SHIRT S/S BLACK / PAISLEY
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
16882 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - BLACK
54592 PARADOX PX17-SH01 REFLECTOR SHIRTS BLACK
52762 Subciety MARIA WORK SHIRT BLACK
12817 Subciety SNAKE SHIRT S/S BLACK
16045 Subciety LIBERTY SHIRT S/S - BLACK
22997 Subciety BOWLING SHIRT S/S-NX- BLACK
22999 Subciety LARGE GLORIOUS SHIRT S/S BLACK
23018 Subciety WORK SHIRT S/S-Reborn- BLACK
23020 Subciety OMBRE CHECK SHIRT S/S-THRON- BLACK
39583 Subciety SALLOW SHIRT BLACK
39590 Subciety EMBLEM SHIRT S/S-DENIM- BLACK
40747 Subciety (サブサエティ) WORK SHIRT-STORY- BLACK
48402 Subciety (サブサエティ) MILITARY SHIRT BLACK
50915 Subciety (サブサエティ) SWITCH WORK SHIRT BLACK
51914 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S BLACK
54747 Dezzn Savior Shirt BLACK
54551 MAGICAL MOSH MISFITS MxMxM どろどろシャツ DOKU
54552 MAGICAL MOSH MISFITS MxMxM どろどろシャツ PINK
11060 VANS APPAREL RUSDEN IKAT S/S SHIRT NAVY
12146 THRASHER MAG LOGO WORK SHIRTS BLACK
18119 ZEPHYREN (ゼファレン) WORK SHIRT S/S -10-FEET BLK
20594 FAMOUS STARS AND STRAPS CHAINLINK KNIT BASEBALL
20676 Subciety POCKET PALM SHIRT S/S-Conductor- BLACK
20684 Subciety WORK SHIRT S/S-ROCK SMITH- BLACK
23003 Subciety ALOHA SHIRT S/S BLACK
23487 NineMicrophones CHECK SHIRT S/S-Comrade- - BLACK
23977 ANIMALIA AN16U-SH05 JD No.49 BLACK
24392 Zephyren (ゼファレン) STRIPE SHIRT S/S -CASINO- BLACK
24728 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- BLACK
24965 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- BLACK
25091 Zephyren (ゼファレン) STRIPE SHIRT -PAISLEY- BLACK
25094 Zephyren (ゼファレン) PAISLEY PRINT SHIRT S/S BLACK
25097 Zephyren (ゼファレン) EMBLEM SHIRT S/S STAR DOT BLACK
25099 Zephyren (ゼファレン) CAMOUFLAGE SHIRT -Charmed SQ Tone- CAMO IV
25110 Zephyren (ゼファレン) BASEBALL SHIRT BLACK STRIPE
25111 Zephyren (ゼファレン) BASEBALL SHIRT BLACK
25113 Zephyren (ゼファレン) BASEBALL SHIRT GREEN STRIPE
25266 DOCAN! ANARCHY workshirt
25498 ROLLING CRADLE OVER GROW SHIRT / Black
25568 Zephyren (ゼファレン) MEANINGxZephyren S/S SHIRT -Precious-
25626 Subciety EMBLEM SHIRT S/S-CAMOUFLAGE- BLACK
26335 ROLLING CRADLE ONE BEER WORK SHIRT / Black
26377 Zephyren (ゼファレン) SWITCHING LONG SHIRT S/S -Resolve- BLACKxCHECK
27479 Zephyren (ゼファレン) TIE DYE TRIBAL SHIRT -Resolve- BLACK
27481 Zephyren (ゼファレン) S/S SHIRT -Microphones- BLACK