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-04-28 21:34:32')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(3, p.color)
AND pc.classcategory_id1 IN( 12,44)
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 p.update_date DESC
LIMIT 0, 60
71387 VIRGOwearworks (ヴァルゴウェアワークス) Spark shirts WHITE
71386 VIRGOwearworks (ヴァルゴウェアワークス) Spark pants WHITE
66329 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×ホワイト
69478 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI WHITE
69223 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス) UTOPIA LST WHITE
69269 VIRGOwearworks (ヴァルゴウェアワークス) VGPKT LS WHITE
66368 VIRGO(ヴァルゴ) Airly wraps ホワイト
61107 VIRGO (ヴァルゴ) NOISE S/S TEE WHITE
61104 VIRGO PERFECTION 22(BIG) WHITE
61416 VIRGO KITE ZIPPER CUTSHIRTS WHITE
61092 VIRGO CLOTH CARRYING SHIRTS WHITE
57011 VIRGO Middle Cuban shirt WHITE
61124 VIRGO CREST PANTS(CLASSIC LINE) BEIGE
61419 VIRGO (ヴァルゴ) GLOWING EYES WHITE
59162 VIRGO TY MOCK NECK WHITE
56998 VIRGO Dolman cross V WHITE
57026 VIRGO Perfection 21 (3/4) 「B.S」 WHITE
57032 VIRGO Upright zip swt WHITE
55379 VIRGO VINTAGE RATS LONG COAT - WHITE
28767 VIRGO SWITCHING SPORTS HOOD WHT-BLK
28771 VIRGO W-MOUNTAIN SST WHITE
28774 VIRGO VWV SST WHITE
28777 VIRGO GOAST DRAPE DOLMAN SHIRTS WHITE
28779 VIRGO W-MOUNTAIN LST WHITE
28788 VIRGO UKS SST WHITE
29582 VIRGO VARIANT CUTSHIRTS WHITE
29584 VIRGO ANTAX CAVES WHITE
29947 VIRGO COEXISTENCE PARKA NATURAL
30119 BAND-MAID VIRGO Tシャツ(白)
32129 VIRGO BIGWAVE WHITE
32303 VIRGO Sweathood long coat スウェットロングコート NATURAL
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
32436 VIRGO Comfyz 無地カットソー WHITE
33923 VIRGO Step switch long shirts ロングシャツ WHITE
34416 VIRGO TRUE S/Snit White
34418 VIRGO COMPLETION TEE ”17” White
34421 VIRGO COMPLETION TEE V ”17” White
35211 VIRGO LANTANA ALOHA SHIRTS WHITE
35216 VIRGO LANTANA ALOHA SHORTS WHITE
36090 VIRGO CELLULAR ONE BIG-TEE WHITE
36341 VIRGO CELLULAR ONE L/S {GIRAFFE} WHITE
36386 VIRGO TREE REPETITION S/S WHITE
36751 VIRGO Logo プリントTシャツ White
37702 VIRGO VIRGO×MACKDADDY special long shirts WHT/BLK
38672 VIRGO Wave way L/S White
38991 VIRGO Slanting caves L/Sワッフルカットソー NATURAL
39779 VIRGO SOFTNESS 7分袖カットソー VG-CUT-357 WHITE
39849 VIRGO DIAGONAL DAMAGED White
40005 VIRGO WATER REPELLENT MILITARY COAT WHITE
41021 VIRGO VG-CUT-364 Perfection Armor Tee 無地カットソー WHITE
41024 VIRGO VG-CUT-363 Native tale cut saw フリンジカットソー WHITE
41337 VIRGO VG-PT-288 U.N.V big aloha shorts WHITE
42767 VIRGO VG-PT-287 VGW swimsuit2 水陸両用ショーツ PP/WHT
43116 VIRGO NATIVE OFF L/Sカットソー WHITE
43397 VIRGO VG-CB-81 D&V SPECIAL LONG SLEEVE TEE WHITE
44078 VIRGO VG-SWT-108 SPECIAL SIDE ZIP SWT WHITE
44080 VIRGO VG-JK-192 W-FACE BOA JKT NATURAL / OLIVE
44324 VIRGO VIRGOwearworks×montage SWEAT PARKA VG-CB-78 WHITE
45313 VIRGO STENCIL ロングスリーブT VG-LSPT-57 WHITE
45662 VIRGO VG-CUT-380 PERFECTION ARMOR 7/S TEE WHITE