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-05-09 07:52:56')
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
61514 ANIMALIA AN22SP-SH01 CHAMBRAY SHIRTS - A.C. Brand DENIMxWHITE
57123 SABBAT13 BLACK HEART CHECK SHIRTS BEIGE
61144 SABBAT13 SPOOK CHECK SHIRTS GREEN
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
56857 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” BLACK CHECK
58975 Subciety (サブサエティ) WESTERN SHIRT - BLACK/GRAY
58977 Subciety (サブサエティ) WESTERN SHIRT - NAVY/SILVER
60365 GoneR GR30SH001 Tattoo Flash Chambray Shirts Chambray
52984 VIRGO VG-SH-215 NOSTALGIC CHECK TOP BLACK
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
59500 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - FLOWER
59507 Zephyren(ゼファレン) SHIRT L/S - Resolve - BLACK / PAISLEY
59536 Zephyren(ゼファレン) BIG SHIRT L/S DRAGONFLY
57011 VIRGO Middle Cuban shirt WHITE
55012 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - RED
59538 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S YELLOW / BLACK
59539 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S MIX
60455 ROLLING CRADLE CHECK NELSHIRT / BLUE
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
58149 RIP DESIGN WORXX Rest in Punk メッセージシャツ BLACK
57004 VIRGO Relaxed uniform shirts BEIGE
55969 ANIMALIA AN20A-SH02 “R.I.B. SHIRTS” BLACK
55970 ANIMALIA AN20A-SH02 “R.I.B. SHIRTS” BLUE
58108 MISHKA M21000251 SHIRT
61513 ANIMALIA AN22SP-SH01 CHAMBRAY SHIRTS - A.C. Brand DENIMxBLACK
61145 SABBAT13 SPOOK CHECK SHIRTS PURPLE
55917 MISHKA MAW200210 SHIRTS
59535 Zephyren(ゼファレン) BIG SHIRT L/S NAVY / PAISLEY
69311 FACT101 (ファクトイチマルイチ) 『memory』 ブロードルーズフィット ロングスリーブ シャツ WHITE
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
60454 ROLLING CRADLE CHECK NELSHIRT / YELLOW
69312 FACT101 (ファクトイチマルイチ) 『Poppy, Viola, Sweet pea』 ブロードルーズフィット ロングスリーブ シャツ WHITE
64970 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / COLOR
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
55403 VIRGO ROCKET LONG SHIRTS - WHITE
65937 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLACK
65938 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLUE
65939 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-M.BROWN
66508 GALFY (ガルフィー) わんわん落書きカラフルシャツ WHITE
66509 GALFY (ガルフィー) わんわん落書きカラフルシャツ BLACK
66510 GALFY (ガルフィー) わんわん落書きカラフルシャツ L.PURPLE
70427 GALFY (ガルフィー) わんわんネオンパジャマシャツ BLACK
67454 RUDIE'S(ルーディーズ) SHADOW LOGO WORK SHIRTS
67417 矢野緋彩 × アマツカミ コラボ限定シャツ
68501 over print (オーバープリント) Sheer Shirts BLACK
68502 over print (オーバープリント) Sheer Shirts BLUE
68503 over print (オーバープリント) Sheer Shirts MINT
70886 over print(オーバープリント)UMBRO * OVER PRINT GAME SHIRTS SAX
70887 over print(オーバープリント)UMBRO * OVER PRINT GAME SHIRTS BLACK
70531 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ZOMBIE NEL SHIRT BLUE
70532 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ZOMBIE NEL SHIRT BROWM
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
3039 Subciety EMBLEM SHIRT L/S-Plain- BLACK
5938 Subciety EMBLEM SHIRT L/S-Plain- WHITE
52875 【バンドリ!×ゲキクロ 第5弾復刻】Subciety×瀬田 薫コラボ 限定 L/S シャツ
62987 over print (オーバープリント) stripe shirts
62988 over print (オーバープリント) check shirts (navy * red)
63151 over print (オーバープリント) check shirts (black * blue)
65547 over print (オーバープリント) gate park shirts
65548 over print (オーバープリント) bone shirts
66957 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLACK
66958 TOY MACHINE (トイマシーン) PEPPER SECT LOOSE FIT SHIRTS BLUE
68498 over print (オーバープリント) Stripe Shirts BLUE
68499 over print (オーバープリント) Stripe Shirts BLACK
68500 over print (オーバープリント) Stripe Shirts GREEN
70901 TOY MACHINE (トイマシーン) DOES'N LOVE YOU WORK SHIRTS L.Gray
70902 TOY MACHINE (トイマシーン) DOES'N LOVE YOU WORK SHIRTS L.BLUE
71456 【予約商品】 要 楽奈×Am10:24 コラボ限定シャツ
61087 VIRGO MIXTURE LONG SHIRTS KHAKI
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
52480 【バンドリ!×ゲキクロ 第4弾復刻】ZEPHYREN×氷川 日菜コラボ 限定 L/S シャツ
54992 Zephyren(ゼファレン)EMBLEM SHIRT L/S MIX
54993 Zephyren(ゼファレン)EMBLEM SHIRT L/S WHITE / fiat lux
54994 Zephyren(ゼファレン)EMBLEM SHIRT L/S BLACK / fiat lux
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
65183 Subciety (サブサエティ) PAISLEY OVER SHIRT-NAVY
65184 Subciety (サブサエティ) PAISLEY OVER SHIRT-BLACK
65462 Subciety (サブサエティ) EMBLEM CHECK SHIRT-KHAKI
65463 Subciety (サブサエティ) EMBLEM CHECK SHIRT-WHITE
56620 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズデニムシャツ - LT.BLUE
56621 PUNK DRUNKERS しみシャツ - WHITE
56622 PUNK DRUNKERS しみシャツ - LT.BLUE
69513 AILE VIVANTES(エイルヴィヴァンテス) BELT-short [SWITCH STANCE] SHORT.ver GRAY
69514 AILE VIVANTES(エイルヴィヴァンテス) BELT-short [SWITCH STANCE] SHORT.ver WHITE
54799 PUNK DRUNKERS オタネルシャツ - GREEN
54800 PUNK DRUNKERS オタネルシャツ - ORANGE
57125 SABBAT13 BLACK HEART CHECK SHIRTS GRAY
54279 Subciety WORK SHIRT BLACK
54999 Zephyren(ゼファレン)LONG SHIRT L/S FLOWER
56029 RUDIE'S PHAT CHECK SHIRTS RED
56030 RUDIE'S PHAT CHECK SHIRTS YELLOW
56858 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” GRAY CHECK
56859 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” RED CHECK
57368 MISHKA M21000201 Shirt
58115 MISHKA MS21000207 L/S Shirt
58123 MISHKA M21000202 Shirt
58976 Subciety (サブサエティ) WESTERN SHIRT - BLACK/BEIGE
59492 Zephyren(ゼファレン) EMBLEM SHIRT L/S WHITE
59493 Zephyren(ゼファレン) EMBLEM SHIRT L/S BLACK
60663 MISHKA M61000203 SHIRT BLACK
54784 PUNK DRUNKERS [PDSxTHUNDERBOX]ピクトグラムシャツ - BEIGE/BROWN
58310 ROLLING CRADLE BIG CHECK SHIRT / BEIGE
64392 PUNK DRUNKERS 光る目シャツ - BLACK
54273 Subciety PAISLEY SHIIRT BLACK
55006 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S WHITE / variat omnia tempus
55007 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S BLACK / variat omnia tempus
55008 Zephyren(ゼファレン)PHOTO PRINT SHIRT L/S WHITE / aurea mediocritas
55011 Zephyren(ゼファレン)SWITCHING LONG SHIRT L/S - Resolve - BLACK
58978 Subciety (サブサエティ) STRIPE OVER SHIRT - GRAY
58979 Subciety (サブサエティ) STRIPE OVER SHIRT - BLUE
59498 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - WHITE
59499 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - BLACK
59534 Zephyren(ゼファレン) BIG SHIRT L/S BROWN / PAISLEY
66796 NineMicrophones(ナインマイクロフォンズ) ENVELOPE MILITARY SHIRT BLACK
66797 NineMicrophones(ナインマイクロフォンズ) ENVELOPE MILITARY SHIRT KHAKI
69715 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BLACK
69716 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET RED
69717 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BROWN