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 12:02:01')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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 MAX(price02)
LIMIT 0, 120
61108 VIRGO (ヴァルゴ) NOISE S/S TEE BLACK
56995 VIRGO Off the dye GRAY
56997 VIRGO Off the dye BLACK
61104 VIRGO PERFECTION 22(BIG) WHITE
61105 VIRGO PERFECTION 22(BIG) BLUE
61106 VIRGO PERFECTION 22(BIG) 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
30119 BAND-MAID VIRGO Tシャツ(白)
30120 BAND-MAID VIRGO Tシャツ(黒)
34418 VIRGO COMPLETION TEE ”17” White
61120 VIRGO VGW BUDDY SWT PANTS BLACK
33432 VIRGO Big V leather ring
56999 VIRGO Dolman cross V BLACK
61079 VIRGO VGW BUDDY HOODIE BLACK
51151 VIRGO VG-CUT-398 CRUST LINKS BLACK
61081 VIRGO LOOSE FIT SWEAT GRAY
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN
37506 VIRGO NY side line set pants NAVY
42766 VIRGO VG-PT-287 VGW swimsuit2 水陸両用ショーツ BLK/CHA
49292 VIRGO VG-PT-222 PANEL CARGO SHORTS KHA/BLK
56989 VIRGO Wacky color track pants BLACK
58727 VIRGO VGW ALOHA SHIRTS RED
43396 VIRGO VG-CB-81 D&V SPECIAL LONG SLEEVE TEE BLACK
52984 VIRGO VG-SH-215 NOSTALGIC CHECK TOP BLACK
49050 VIRGO VG-PT-226 LOOSE BIG CARGO SHORTS OLIVE
57011 VIRGO Middle Cuban shirt WHITE
57033 VIRGO Upright zip swt NAVY
59215 VIRGO VG SLACKS KHAKI
48193 VIRGO VG-SSPT-220 VGW GARLAND BLACK
48194 VIRGO VG-SSPT-220 VGW GARLAND WHITE
49635 VIRGO VG-SSPT-223A NOT A PIG【VALIANT】 BLACK
49636 VIRGO VG-SSPT-223A NOT A PIG【VALIANT】 WHITE
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
33434 VIRGO Loose atmosphere cardigan CHARCOAL
39123 VIRGO HARD GAUGE KNIT NAVY
43944 VIRGO VG-SH-191 VA-1 SHIRTS KHAKI
55388 VIRGO KURT MOHAIR CARDIGAN - BLACK
56978 VIRGO CREST PANTS 21 NAVY
57004 VIRGO Relaxed uniform shirts BEIGE
57006 VIRGO Relaxed uniform shirts BLACK
61109 VIRGO 90S FAT INDIGO(ONE WASH)
61124 VIRGO CREST PANTS(CLASSIC LINE) BEIGE
59224 VIRGO VIRTALIA BRAID KICKS BLACK
64244 VIRGO (ヴァルゴ) FC VGW TOP
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
28787 VIRGO UKS SST BLACK
28788 VIRGO UKS SST WHITE
28789 VIRGO UKS SST CHARCOAL
34416 VIRGO TRUE S/Snit White
34417 VIRGO TRUE S/Snit Black
36386 VIRGO TREE REPETITION S/S WHITE
36387 VIRGO TREE REPETITION S/S BLACK
36751 VIRGO Logo プリントTシャツ White
36752 VIRGO Logo プリントTシャツ Black
32556 VIRGO Fortress Big Hood Parka BLACK
61078 VIRGO VGW BUDDY HOODIE GRAY
34419 VIRGO COMPLETION TEE ”17” Black
34420 VIRGO COMPLETION TEE V ”17” Black
34421 VIRGO COMPLETION TEE V ”17” White
41020 VIRGO VG-CUT-364 Perfection Armor Tee 無地カットソー BLACK
41021 VIRGO VG-CUT-364 Perfection Armor Tee 無地カットソー WHITE
41022 VIRGO VG-CUT-364 Perfection Armor Tee 無地カットソー BURGUNDY
47767 VIRGO VG-CUT-391 PERFECTION HIDDEN V TEE BLACK
47768 VIRGO VG-CUT-391 PERFECTION HIDDEN V TEE WHITE
47769 VIRGO VG-CUT-391 PERFECTION HIDDEN V TEE RED
51148 VIRGO VG-KNIT-81 W CAT HAND KNIT GRAY
57010 VIRGO Dolman miry 2face BLACK
57017 VIRGO Big neck sell hoodie BLACK
59177 VIRGO ATS DAMAGE KNIT ZIP CARDIGAN GRAY
59178 VIRGO ATS DAMAGE KNIT ZIP CARDIGAN BLACK
59185 VIRGO SQUARE PKT SPECIAL CARGO BLACK
59186 VIRGO SQUARE PKT SPECIAL CARGO CHARCOAL
59187 VIRGO SQUARE PKT SPECIAL CARGO KHAKI
39484 VIRGO FLAG 3/4 BLACK
39485 VIRGO FLAG 3/4 NAVY
64046 VIRGO(ヴァルゴ)HALF ROUND CHAIN BRACELET SILVER
64245 VIRGO (ヴァルゴ) FC VGW SHORTS
45312 VIRGO STENCIL ロングスリーブT VG-LSPT-57 BLACK
45313 VIRGO STENCIL ロングスリーブT VG-LSPT-57 WHITE
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)
59179 VIRGO MIDDLE TAILORED JKT KHAKI
60718 VIRGO NYLON RACER MOD HOODIE
28778 VIRGO W-MOUNTAIN LST BLACK
28779 VIRGO W-MOUNTAIN LST WHITE
69477 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI BLACK
69478 VIRGOwearworks (ヴァルゴウェアワークス) WAVISAVI WHITE
32019 VIRGO Heavyz Classic BLACK
32431 VIRGO Comfyz 無地カットソー BLACK
32432 VIRGO Comfyz 無地カットソー CHACOAL
32434 VIRGO Comfyz 無地カットソー RED
32436 VIRGO Comfyz 無地カットソー WHITE
34929 VIRGO DIVISION WAY BLACK
34930 VIRGO DIVISION WAY GRAY
39777 VIRGO SOFTNESS 7分袖カットソー VG-CUT-357 BLACK
39778 VIRGO SOFTNESS 7分袖カットソー VG-CUT-357 CHARCOAL
39779 VIRGO SOFTNESS 7分袖カットソー VG-CUT-357 WHITE
41650 VIRGO VG-CUT-359 2 Superb chain robe リネンカットソー BLACK
43397 VIRGO VG-CB-81 D&V SPECIAL LONG SLEEVE TEE WHITE
55435 VIRGO LOABT LST - BLACK
59162 VIRGO TY MOCK NECK WHITE
59164 VIRGO TY MOCK NECK BLACK
63989 VIRGO(ヴァルゴ)BIG HIND BLACK
63990 VIRGO(ヴァルゴ)BIG HIND WHITE