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-26 00:44:42')
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( 13,35,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 ブラック
71491 VIRGOwearworks (ヴァルゴウェアワークス) Grapping cargo SP BLACK
66414 VIRGOwearworks (ヴァルゴウェアワークス) Cross V cushion Sandals ブラック
70238 VIRGOwearworks (ヴァルゴウェアワークス) DIAGONAL ZIP DOWN JKT BLACK
70064 VIRGOwearworks (ヴァルゴウェアワークス) LIGHTNING KANJI KNIT GRY×BLK
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
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
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
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
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
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
57013 VIRGO Middle Cuban shirt BLACK
57028 VIRGO Perfection 21 (3/4) 「B.S」 BLACK
56989 VIRGO Wacky color track pants BLACK
57021 VIRGO Wacky color track suit BLACK
57055 VIRGO BAGGY-D CARGO 21[CLASSIC LINE] BLACK
55388 VIRGO KURT MOHAIR CARDIGAN - BLACK
55452 VIRGO 2WAY JOGGER CARGO - BLACK
55341 VIRGO VINTAGE RATS LONG COAT - BLACK
55457 VIRGO BAGGY-D CARGO 20「CLASSIC LINE」 - CHARCOAL
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
32128 VIRGO BIGWAVE BLACK
32218 VIRGO Vintage Eagle Souvenir JKT Special 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
36098 VIRGO SUNBLIND MOTTLE PARKA BLACK
36099 VIRGO CELLULAR ONE S/S{HEDGEHOG} BLACK
36101 VIRGO CELLULAR ONE SHORTS{MOLAR} ダメージショートパンツ BLACK
36103 VIRGO FINE ROLLER BLACK
36205 VIRGO REFINED MIDDLE SHIRTS BLACK
36342 VIRGO CELLULAR ONE L/S {GIRAFFE} BLACK
36343 VIRGO AMPHIBIOUS SHORTS BLACK
36387 VIRGO TREE REPETITION S/S BLACK
36752 VIRGO Logo プリントTシャツ Black
37003 VIRGO LIGHT SHIP L/S BLACK
37181 VIRGO SOUVENIR LONG CARDIGAN BLACK
37183 VIRGO NATIVE CIRCLE L/S BLACK
37192 VIRGO CAT HAND MOHAIR CARDIGAN BLACK
37505 VIRGO NY side line set pants BLK
37550 VIRGO 2face big knit ドルマンカットソー 【VIRGO】 [VG-CUT-350] BLK/CHA
37573 VIRGO Turtle wave special knit タートルネックニット 【VIRGO】 [VG-KNIT-64]
37699 VIRGO NATIVE MIDDLE CHECK SHIRTS BLK
37700 VIRGO Urban refraction mt parka BLK
38557 VIRGO Big square hoodie jkt Black
38558 VIRGO NEW PETAURISTA SPECIAL CARGO Black