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-20 05:31:57')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.price02 > 4545
AND price02 <= 9090
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
70210 VIRGOwearworks (ヴァルゴウェアワークス) GRADIENT ORANGE
70209 VIRGOwearworks (ヴァルゴウェアワークス) GRADIENT WHITE
69478 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI WHITE
69477 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI BLACK
69222 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス) UTOPIA LST ORANGE
69221 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス UTOPIA LST BLACK
69223 MICHIKO LONDON KOSHINO×VIRGOwearworks (ヴァルゴウェアワークス) UTOPIA LST WHITE
70881 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt OD
70880 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt NAVY
70879 VIRGOwearworks (ヴァルゴウェアワークス) Vg belt BLACK
69269 VIRGOwearworks (ヴァルゴウェアワークス) VGPKT LS WHITE
69268 VIRGOwearworks (ヴァルゴウェアワークス) VGPKT LS OD
65532 VIRGO(ヴァルゴ) SPLASH VGW SHIRTS BLUE
64046 VIRGO(ヴァルゴ)HALF ROUND CHAIN BRACELET SILVER
63979 VIRGO(ヴァルゴ)SQUARE BLACK
63980 VIRGO(ヴァルゴ)SQUARE WHITE
63989 VIRGO(ヴァルゴ)BIG HIND BLACK
63990 VIRGO(ヴァルゴ)BIG HIND WHITE
64048 VIRGO(ヴァルゴ)CARVED CHAIN BRACELET SILVER
64036 VIRGO(ヴァルゴ)BOSTONS BLACK-BLACK
64037 VIRGO(ヴァルゴ)BOSTONS BLACK-BLUE
64038 VIRGO(ヴァルゴ)BOSTONS BLACK-GRAY
64045 VIRGO(ヴァルゴ)3WAY CHAIN NECKLACE SILVER
61107 VIRGO (ヴァルゴ) NOISE S/S TEE WHITE
64244 VIRGO (ヴァルゴ) FC VGW TOP
64245 VIRGO (ヴァルゴ) FC VGW SHORTS
61130 VIRGO 90S VINTAGE FAT DENIME INDIGO(VINTAGE)
61109 VIRGO 90S FAT INDIGO(ONE WASH)
61070 VIRGO VGW SWEAT RIDERS BLACK
61078 VIRGO VGW BUDDY HOODIE GRAY
57011 VIRGO Middle Cuban shirt WHITE
61124 VIRGO CREST PANTS(CLASSIC LINE) BEIGE
61419 VIRGO (ヴァルゴ) GLOWING EYES WHITE
61420 VIRGO (ヴァルゴ) GLOWING EYES BLACK
59198 VIRGO CROSS V WOOL CAP GRAY
59200 VIRGO CROSS V WOOL CAP BLACK
59185 VIRGO SQUARE PKT SPECIAL CARGO BLACK
59186 VIRGO SQUARE PKT SPECIAL CARGO CHARCOAL
59187 VIRGO SQUARE PKT SPECIAL CARGO KHAKI
59179 VIRGO MIDDLE TAILORED JKT KHAKI
59215 VIRGO VG SLACKS KHAKI
60718 VIRGO NYLON RACER MOD HOODIE
59178 VIRGO ATS DAMAGE KNIT ZIP CARDIGAN BLACK
59177 VIRGO ATS DAMAGE KNIT ZIP CARDIGAN GRAY
59164 VIRGO TY MOCK NECK BLACK
59166 VIRGO MEXICAN VG HOODIE NAVY
59167 VIRGO MEXICAN VG HOODIE BLACK
59162 VIRGO TY MOCK NECK WHITE
59224 VIRGO VIRTALIA BRAID KICKS BLACK
59150 VIRGO WORLD SQUARE GRAY×BLACK
59151 VIRGO WORLD SQUARE BROWN×BLACK
56978 VIRGO CREST PANTS 21 NAVY
55403 VIRGO ROCKET LONG SHIRTS - WHITE
56985 VIRGO Special Petaurista cargo pants BLACK
57004 VIRGO Relaxed uniform shirts BEIGE
57006 VIRGO Relaxed uniform shirts BLACK
57010 VIRGO Dolman miry 2face BLACK
57017 VIRGO Big neck sell hoodie BLACK
57038 VIRGO Little giant wallet GRAY
57041 VIRGO Little giant wallet BLACK
57033 VIRGO Upright zip swt NAVY
55509 VIRGO UTOPIA P(EAU DE PARFUM) - CLEAR
57786 VIRGO VG-GD-663 Quench BLK×BLU
57052 VIRGO 2Face crust stole BLK×BLK
57050 VIRGO 2Face crust stole BLK×BLU
57049 VIRGO 2Face crust stole BLK×RED
57042 VIRGO Old dime casket CAMEL
57044 VIRGO Old dime casket BLACK
55388 VIRGO KURT MOHAIR CARDIGAN - BLACK
55435 VIRGO LOABT LST - BLACK
55436 VIRGO LOABT LST - WHITE
28770 VIRGO W-MOUNTAIN SST BLACK
28771 VIRGO W-MOUNTAIN SST WHITE
28772 VIRGO W-MOUNTAIN SST NAVY
28773 VIRGO VWV SST BLACK
28774 VIRGO VWV SST WHITE
28775 VIRGO VWV SST GRAY
28778 VIRGO W-MOUNTAIN LST BLACK
28779 VIRGO W-MOUNTAIN LST WHITE
28780 VIRGO VWW OLDSCHOOL WOOL CAP BLACK
28781 VIRGO VWW OLDSCHOOL WOOL CAP NAVY
28783 VIRGO CCV CAP BLK/BLK
28784 VIRGO CCV CAP WHT/BLK
28787 VIRGO UKS SST BLACK
28788 VIRGO UKS SST WHITE
28789 VIRGO UKS SST CHARCOAL
29585 VIRGO BABY CHEEK STALL BLACK
29656 VIRGO MOUNTAIN MOUTH DAMAGE KNIT BLACK
29657 VIRGO MOUNTAIN MOUTH DAMAGE KNIT RED
29942 VIRGO PROTECT CLUTCHBAG
32011 VIRGO Blended Beads Bracelet BLACK
32012 VIRGO Blended Beads Bracelet RED
32013 VIRGO Blended Beads Bracelet TURQUOISE
32019 VIRGO Heavyz Classic BLACK
32431 VIRGO Comfyz 無地カットソー BLACK
32432 VIRGO Comfyz 無地カットソー CHACOAL
32434 VIRGO Comfyz 無地カットソー RED
32436 VIRGO Comfyz 無地カットソー WHITE
32556 VIRGO Fortress Big Hood Parka BLACK
33434 VIRGO Loose atmosphere cardigan CHARCOAL
34414 VIRGO HAPPINESS HAT WHITE
34415 VIRGO HAPPINESS HAT BLACK
34416 VIRGO TRUE S/Snit White
34417 VIRGO TRUE S/Snit Black
34419 VIRGO COMPLETION TEE ”17” Black
34420 VIRGO COMPLETION TEE V ”17” Black
34421 VIRGO COMPLETION TEE V ”17” White
34439 VIRGO APRONBAG MINI BLACK
34440 VIRGO APRONBAG MIN KHAKI
34929 VIRGO DIVISION WAY BLACK
34930 VIRGO DIVISION WAY GRAY
35213 VIRGO LANTANA ALOHA BAG WHITE
35214 VIRGO LANTANA ALOHA BAG RED
35215 VIRGO LANTANA ALOHA BAG BLACK
36087 VIRGO W FACE BELT BLACK
36088 VIRGO W FACE BELT OLIVE
36099 VIRGO CELLULAR ONE S/S{HEDGEHOG} BLACK
36386 VIRGO TREE REPETITION S/S WHITE
36387 VIRGO TREE REPETITION S/S BLACK
36751 VIRGO Logo プリントTシャツ White