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 dtb_products AS p
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-23 22:25:40')
AND pc.classcategory_id1 IN( 11)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 628)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
61108 VIRGO (ヴァルゴ) NOISE S/S TEE BLACK
56995 VIRGO Off the dye GRAY
56997 VIRGO Off the dye BLACK
57026 VIRGO Perfection 21 (3/4) 「B.S」 WHITE
57027 VIRGO Perfection 21 (3/4) 「B.S」 RED
57028 VIRGO Perfection 21 (3/4) 「B.S」 BLACK
61120 VIRGO VGW BUDDY SWT PANTS BLACK
56999 VIRGO Dolman cross V BLACK
61079 VIRGO VGW BUDDY HOODIE BLACK
61081 VIRGO LOOSE FIT SWEAT GRAY
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN
58727 VIRGO VGW ALOHA SHIRTS RED
52984 VIRGO VG-SH-215 NOSTALGIC CHECK TOP BLACK
57011 VIRGO Middle Cuban shirt WHITE
57033 VIRGO Upright zip swt NAVY
61107 VIRGO (ヴァルゴ) NOISE S/S TEE WHITE
61419 VIRGO (ヴァルゴ) GLOWING EYES WHITE
61420 VIRGO (ヴァルゴ) GLOWING EYES BLACK
59166 VIRGO MEXICAN VG HOODIE NAVY
59167 VIRGO MEXICAN VG HOODIE BLACK
55388 VIRGO KURT MOHAIR CARDIGAN - BLACK
57004 VIRGO Relaxed uniform shirts BEIGE
61109 VIRGO 90S FAT INDIGO(ONE WASH)
61124 VIRGO CREST PANTS(CLASSIC LINE) BEIGE
64244 VIRGO (ヴァルゴ) FC VGW TOP
61078 VIRGO VGW BUDDY HOODIE GRAY
57010 VIRGO Dolman miry 2face BLACK
71756 VIRGOwearworks (ヴァルゴウェアワークス)Std S/S BLACK
71757 VIRGOwearworks (ヴァルゴウェアワークス)Std S/S WHITE
57017 VIRGO Big neck sell hoodie BLACK
59185 VIRGO SQUARE PKT SPECIAL CARGO BLACK
59186 VIRGO SQUARE PKT SPECIAL CARGO CHARCOAL
59187 VIRGO SQUARE PKT SPECIAL CARGO KHAKI
64245 VIRGO (ヴァルゴ) FC VGW SHORTS
63979 VIRGO(ヴァルゴ)SQUARE BLACK
63980 VIRGO(ヴァルゴ)SQUARE WHITE
52987 VIRGOVG-CUT-400 PERFECTION NEO US [3/4 SLEEVE] BLACK
52988 VIRGOVG-CUT-400 PERFECTION NEO US [3/4 SLEEVE] WHITE
52989 VIRGOVG-CUT-400 PERFECTION NEO US [3/4 SLEEVE] RED
61070 VIRGO VGW SWEAT RIDERS BLACK
61130 VIRGO 90S VINTAGE FAT DENIME INDIGO(VINTAGE)
71758 VIRGOwearworks (ヴァルゴウェアワークス)Ultimate [C] BLACK
71759 VIRGOwearworks (ヴァルゴウェアワークス)Ultimate [C] RED
69477 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI BLACK
69478 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI WHITE
55435 VIRGO LOABT LST - BLACK
55436 VIRGO LOABT LST - WHITE
59162 VIRGO TY MOCK NECK WHITE
59164 VIRGO TY MOCK NECK BLACK
63989 VIRGO(ヴァルゴ)BIG HIND BLACK
63990 VIRGO(ヴァルゴ)BIG HIND WHITE
69221 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス UTOPIA LST BLACK
69222 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス) UTOPIA LST ORANGE
69223 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス) UTOPIA LST WHITE
69268 VIRGOwearworks (ヴァルゴウェアワークス) VGPKT LS OD
69269 VIRGOwearworks (ヴァルゴウェアワークス) VGPKT LS WHITE
65532 VIRGO(ヴァルゴ) SPLASH VGW SHIRTS BLUE
55403 VIRGO ROCKET LONG SHIRTS - WHITE
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
55379 VIRGO VINTAGE RATS LONG COAT - WHITE