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-05-07 08:19:58')
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
62655 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - BLACK
54204 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - BLACK
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
54563 SABBAT13 GHOST CHECK S/S SHIRTS BLUE
54076 RUDIE'S (ルーディーズ) TUSK OPEN COLLAR SHIRTS BLACK
59220 LONELY論理 LONELISM SHIRTS white
62656 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - D.GREEN
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN
57461 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - WHITE
57920 Subciety (サブサエティ) WEEKENDER SHIRT - BLACK
62200 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - BURGUNDY
63105 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLUE
58727 VIRGO VGW ALOHA SHIRTS RED
62212 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - WHITE
62226 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - FLOWER
63213 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BEIGE
60156 Anti Social Social Club WOODY WHITE BUTTON UP
62207 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE / PAISLEY
62653 PUNK DRUNKERS PDベースボールシャツ - BLACK
59247 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLUE
65145 ANIMALIA BIG SILHOUETTE POLO SHIRTS -WORK SUCKS-
59221 LONELY論理 LONELISM SHIRTS black
62654 PUNK DRUNKERS PDベースボールシャツ - BLUE
57442 Zephyren(ゼファレン) EMBLEM SHIRT S/S MIX
57443 Zephyren(ゼファレン) EMBLEM SHIRT S/S WHITE / You are hare
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
57921 Subciety (サブサエティ) WEEKENDER SHIRT - BEIGE
63408 ZERO EVOKE (ゼロイヴォーク) Irregular logo S/S shirt BLACK
57453 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE CHECK
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
58703 GoneR GR29SH001 Chambray Work Shirts
62152 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLACK
68355 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) RIDE CLUB SHIRT Black
65986 PUNK DRUNKERS (パンクドランカーズ) ピーチポロシャツ - BLACK
55648 THRASHER (スラッシャー) TH5179 S/S WORK SHIRT WHITE
55649 THRASHER TH5179 S/S WORK SHIRT BLACK
64970 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / COLOR
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
65349 SUPPLIER (サプライヤー) VENOM REFLECTOR TEE
60074 GALFY ラガーシャツ WINE RED
63266 GALFY (ガルフィー) 東名阪チームシャツ WHITE (中日)
63267 GALFY (ガルフィー) 東名阪チームシャツ WHITEst (阪神)
63268 GALFY (ガルフィー) 東名阪チームシャツ GRAY (巨人)
64141 GALFY (ガルフィー) 犬デニムシャツ Indigo
64142 GALFY (ガルフィー) 犬デニムシャツ Blue
68137 GoneR(ゴナー) GR36SH001 Mexican Skull Shirts Black
68143 GoneR(ゴナー) GR36SH002 Rose Shirts Black
58491 RUDIE'S SPARK OPENCOLLAR SHIRTS BLACK
63214 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BLACK
63215 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - WHITE
63216 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - BLACK
63426 ZENON(ゼノン) Pocket remake setup S/S shirt BLACK
63819 Subciety(サブサエティ) MILITARY OVER SHIRT BLACK
68382 SABBAT13(サバトサーティーン) LAST PARADISE S/S SHIRTS (BLACK)
68383 SABBAT13(サバトサーティーン) LAST PARADISE S/S SHIRTS (SAND KAHKI)
68550 Subciety (サブサエティ) PATTERNED SHIRT A (BANDANNA)
68551 Subciety (サブサエティ) PATTERNED SHIRT B (MULTI)
68552 Subciety (サブサエティ) PATTERNED SHIRT C (WHITE)
71506 Subciety(サブサエティ) OPEN COLLAR STRIPE SHIRT GRAYBLUE
71507 Subciety(サブサエティ) OPEN COLLAR STRIPE SHIRT CAMEL