SELECT SQL_CALC_FOUND_ROWS 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-19 13:01:52')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(1, 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, 120
71383 VIRGOwearworks (ヴァルゴウェアワークス) Spark shirts BLACK
71382 VIRGOwearworks (ヴァルゴウェアワークス) Spark pants BLACK
66329 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×ホワイト
66331 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×ベージュ
66397 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers pants ブラウン
66330 VIRGOwearworks (ヴァルゴウェアワークス) Ebony flowers Shirt ブラック×グリーン
66367 VIRGOwearworks (ヴァルゴウェアワークス) Airly wraps ブラック
66403 VIRGOwearworks (ヴァルゴウェアワークス) ARK quarter cargo ブラック
69477 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI BLACK
69221 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス UTOPIA LST BLACK
66414 VIRGOwearworks (ヴァルゴウェアワークス) Cross V cushion Sandals ブラック
70238 VIRGOwearworks (ヴァルゴウェアワークス) DIAGONAL ZIP DOWN JKT BLACK
70064 VIRGOwearworks (ヴァルゴウェアワークス) LIGHTNING KANJI KNIT GRY×BLK
69976 VIRGOwearworks (ヴァルゴウェアワークス) TITANS ZIP CARDIGAN BLACK
69660 VIRGOwearworks (ヴァルゴウェアワークス) SALLYS ARM SWT BLACK
69481 VIRGOwearworks (ヴァルゴウェアワークス) CREW STUDIUM BLOUSON BLACK
69224 VIRGOwearworks (ヴァルゴウェアワークス) SNAKE ZIP JKT BLACK
69220 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス) RESONANCE JKT BLACK×WHITE
66392 VIRGOwearworks (ヴァルゴウェアワークス) Special Petaurista cargo pants ブラック
69479 VIRGOwearworks (ヴァルゴウェアワークス) EXPLORATION FAT PANTS BLACK
69226 VIRGOwearworks (ヴァルゴウェアワークス) GENIE RELAX PANT BLACK
68460 VIRGOwearworks (ヴァルゴウェアワークス) Vintage mily hawaii shirt BLACK
66400 VIRGOwearworks (ヴァルゴウェアワークス) Vintage mily hawaii shorts BLACK
63929 VIRGO(ヴァルゴ)MILSPEC LOOSE HOODIE BLACK-BLACK
63926 VIRGO(ヴァルゴ)NATIVE KNIT SNAP SWT BLACK
59193 VIRGO STRUMMER CHESTER COAT BLACK
65533 VIRGO(ヴァルゴ) SPLASH VGW SHIRTS BLACK
65531 VIRGO(ヴァルゴ) SPLASH VGW PANTS BLACK
61108 VIRGO (ヴァルゴ) NOISE S/S TEE BLACK
61418 VIRGO KITE ZIPPER CUTSHIRTS BLACK
61106 VIRGO PERFECTION 22(BIG) BLACK
64244 VIRGO (ヴァルゴ) FC VGW TOP
64245 VIRGO (ヴァルゴ) FC VGW SHORTS
61093 VIRGO CLOTH CARRYING SHIRTS BLACK
61070 VIRGO VGW SWEAT RIDERS BLACK
61079 VIRGO VGW BUDDY HOODIE BLACK
61120 VIRGO VGW BUDDY SWT PANTS BLACK
61073 VIRGO COSMIC FLOWER 2FACE JKT BLACK/BLACK
61082 VIRGO LOOSE FIT SWEAT BLACK
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
61096 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BLACK
61126 VIRGO CREST PANTS(CLASSIC LINE) BLACK
61414 VIRGO BAGGY-D CARGO 22[CLASSIC LINE] CHARCOAL
61415 VIRGO BAGGY-D CARGO 22[CLASSIC LINE] BLACK
61420 VIRGO (ヴァルゴ) GLOWING EYES BLACK
59185 VIRGO SQUARE PKT SPECIAL CARGO BLACK
59180 VIRGO MIDDLE TAILORED JKT BLACK
59216 VIRGO VG SLACKS BLACK
60830 VIRGO VA-1 TYPE BOA BLACK
60718 VIRGO NYLON RACER MOD HOODIE
59178 VIRGO ATS DAMAGE KNIT ZIP CARDIGAN BLACK
59182 VIRGO ETHNIC ARMS SWEATSHIRT BLACK
59164 VIRGO TY MOCK NECK BLACK
59167 VIRGO MEXICAN VG HOODIE BLACK
56997 VIRGO Off the dye BLACK
59224 VIRGO VIRTALIA BRAID KICKS BLACK
56979 VIRGO CREST PANTS 21 BLACK
58728 VIRGO VGW ALOHA SHIRTS BLACK
55396 VIRGO VIRTALY CHANGE SHIRTS - BLACK
56999 VIRGO Dolman cross V BLACK
56985 VIRGO Special Petaurista cargo pants BLACK
57006 VIRGO Relaxed uniform shirts BLACK
56982 VIRGO Relaxed uniform jogger pants BLACK
57010 VIRGO Dolman miry 2face BLACK
57017 VIRGO Big neck sell hoodie BLACK
57013 VIRGO Middle Cuban shirt BLACK
57028 VIRGO Perfection 21 (3/4) 「B.S」 BLACK
57034 VIRGO Upright zip swt BLACK
56989 VIRGO Wacky color track pants BLACK
57021 VIRGO Wacky color track suit BLACK
57055 VIRGO BAGGY-D CARGO 21[CLASSIC LINE] BLACK
55448 VIRGO NINJAS CORDUROY - BLACK
55383 VIRGO ANIMALISTIC BOA JKT - BLACK
55337 VIRGO COMPOSITION VA1 - BLACK
55388 VIRGO KURT MOHAIR CARDIGAN - BLACK
55452 VIRGO 2WAY JOGGER CARGO - BLACK
55341 VIRGO VINTAGE RATS LONG COAT - BLACK
55401 VIRGO ROCKET LONG SHIRTS - BLACK
55457 VIRGO BAGGY-D CARGO 20「CLASSIC LINE」 - CHARCOAL
55435 VIRGO LOABT LST - BLACK
28763 VIRGO CARPE DIEM ZIP PARKA BLACK
28765 VIRGO SWITCHING SPORTS HOOD BK-GYhood
28770 VIRGO W-MOUNTAIN SST BLACK
28773 VIRGO VWV SST BLACK
28776 VIRGO GOAST DRAPE DOLMAN SHIRTS BLACK
28778 VIRGO W-MOUNTAIN LST BLACK
28785 VIRGO MICROS PANTS BLACK
28787 VIRGO UKS SST BLACK
29577 VIRGO BASEZ BLACK
29578 VIRGO BASEZ CHARCOAL
29580 VIRGO VARIANT CUTSHIRTS BLACK
29583 VIRGO ANTAX CAVES BLACK
29593 VIRGO FRAGMENT MONSTER PARKA BLACK
29946 VIRGO COEXISTENCE PARKA BLACK
30120 BAND-MAID VIRGO Tシャツ(黒)
32019 VIRGO Heavyz Classic BLACK
32124 VIRGO Eyes VG sweat hoodie BLACK
32126 VIRGO 2FACE KNIT BLK/CHA
32127 VIRGO 2FACE KNIT NVY/BLU
32128 VIRGO BIGWAVE BLACK
32302 VIRGO Sweathood long coat スウェットロングコート BLACK
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
32431 VIRGO Comfyz 無地カットソー BLACK
32556 VIRGO Fortress Big Hood Parka BLACK
32558 VIRGO Protect Sweatriders Jkt BLACK
32559 VIRGO Original Fatsole Slip On BLACK
33432 VIRGO Big V leather ring
33433 VIRGO Loose atmosphere cardigan BLACK
33922 VIRGO Step switch long shirts ロングシャツ BLACK
34275 VIRGO CLIMBER SWT PANTS BLACK
34276 VIRGO CREST THE CARGO BLACK
34288 VIRGO SUMMER NOMAD BLACK
34417 VIRGO TRUE S/Snit Black
34419 VIRGO COMPLETION TEE ”17” Black
34420 VIRGO COMPLETION TEE V ”17” Black
34929 VIRGO DIVISION WAY BLACK
35212 VIRGO LANTANA ALOHA SHIRTS BLACK
35217 VIRGO LANTANA ALOHA SHORTS BLACK
35219 VIRGO EXALTED SHORTS BLACK
36089 VIRGO CELLULAR ONE BIG-TEE BLACK