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-27 10:24:08')
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 p.update_date
LIMIT 0, 120
47524 VIRGO VG-CUT-381 VINTAGE RAGLAN CUTSEW 染めカットソー BLACK
28760 VIRGO 90S PSYCO SHIRTS BLACK
28761 VIRGO 90S PSYCO SHIRTS RED
28762 VIRGO 90S PSYCO SHIRTS YELLOW
28763 VIRGO CARPE DIEM ZIP PARKA BLACK
28765 VIRGO SWITCHING SPORTS HOOD BK-GYhood
28766 VIRGO SWITCHING SPORTS HOOD GRY-BLK
28767 VIRGO SWITCHING SPORTS HOOD WHT-BLK
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
28776 VIRGO GOAST DRAPE DOLMAN SHIRTS BLACK
28777 VIRGO GOAST DRAPE DOLMAN SHIRTS WHITE
28778 VIRGO W-MOUNTAIN LST BLACK
28779 VIRGO W-MOUNTAIN LST WHITE
28785 VIRGO MICROS PANTS BLACK
28786 VIRGO MICROS PANTS BEIGE
28787 VIRGO UKS SST BLACK
28788 VIRGO UKS SST WHITE
28789 VIRGO UKS SST CHARCOAL
29577 VIRGO BASEZ BLACK
29578 VIRGO BASEZ CHARCOAL
29580 VIRGO VARIANT CUTSHIRTS BLACK
29581 VIRGO VARIANT CUTSHIRTS NAVY
29582 VIRGO VARIANT CUTSHIRTS WHITE
29583 VIRGO ANTAX CAVES BLACK
29584 VIRGO ANTAX CAVES WHITE
29593 VIRGO FRAGMENT MONSTER PARKA BLACK
29945 VIRGO MARS CRAZE BORDER MOHAIR RED
29946 VIRGO COEXISTENCE PARKA BLACK
29947 VIRGO COEXISTENCE PARKA NATURAL
30119 BAND-MAID VIRGO Tシャツ(白)
30120 BAND-MAID VIRGO Tシャツ(黒)
32019 VIRGO Heavyz Classic BLACK
32124 VIRGO Eyes VG sweat hoodie BLACK
32125 VIRGO Eyes VG sweat hoodie GRAY
32126 VIRGO 2FACE KNIT BLK/CHA
32127 VIRGO 2FACE KNIT NVY/BLU
32128 VIRGO BIGWAVE BLACK
32129 VIRGO BIGWAVE WHITE
32164 VIRGO Vintage Eagle Souvenir JKT Special NAVY
32302 VIRGO Sweathood long coat スウェットロングコート BLACK
32303 VIRGO Sweathood long coat スウェットロングコート NATURAL
32307 VIRGO Variable change shirts 切り替えチェックシャツ BLUE
32308 VIRGO Variable change shirts 切り替えチェックシャツ RED
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
32431 VIRGO Comfyz 無地カットソー BLACK
32432 VIRGO Comfyz 無地カットソー CHACOAL
32434 VIRGO Comfyz 無地カットソー RED
32436 VIRGO Comfyz 無地カットソー WHITE
32556 VIRGO Fortress Big Hood Parka BLACK
32557 VIRGO Fortress Big Hood Parka GRAY
32558 VIRGO Protect Sweatriders Jkt BLACK
32559 VIRGO Original Fatsole Slip On BLACK
32560 VIRGO Original Fatsole Slip On NAVY
33428 VIRGO Airship dolmania BURGANDY
33432 VIRGO Big V leather ring
33433 VIRGO Loose atmosphere cardigan BLACK
33434 VIRGO Loose atmosphere cardigan CHARCOAL
33922 VIRGO Step switch long shirts ロングシャツ BLACK
33923 VIRGO Step switch long shirts ロングシャツ WHITE
34275 VIRGO CLIMBER SWT PANTS BLACK
34276 VIRGO CREST THE CARGO BLACK
34277 VIRGO CREST THE CARGO OLIVE
34288 VIRGO SUMMER NOMAD BLACK
34416 VIRGO TRUE S/Snit White
34417 VIRGO TRUE S/Snit Black
34418 VIRGO COMPLETION TEE ”17” White
34419 VIRGO COMPLETION TEE ”17” Black
34420 VIRGO COMPLETION TEE V ”17” Black
34421 VIRGO COMPLETION TEE V ”17” White
34929 VIRGO DIVISION WAY BLACK
34930 VIRGO DIVISION WAY GRAY
35211 VIRGO LANTANA ALOHA SHIRTS WHITE
35212 VIRGO LANTANA ALOHA SHIRTS BLACK
35216 VIRGO LANTANA ALOHA SHORTS WHITE
35217 VIRGO LANTANA ALOHA SHORTS BLACK
35218 VIRGO EXALTED SHORTS OLIVE
35219 VIRGO EXALTED SHORTS BLACK
36089 VIRGO CELLULAR ONE BIG-TEE BLACK
36090 VIRGO CELLULAR ONE BIG-TEE WHITE
36096 VIRGO SUNBLIND MOTTLE PARKA RED
36097 VIRGO SUNBLIND MOTTLE PARKA NAVY
36098 VIRGO SUNBLIND MOTTLE PARKA BLACK
36101 VIRGO CELLULAR ONE SHORTS{MOLAR} ダメージショートパンツ BLACK
36102 VIRGO FINE ROLLER GRAY
36103 VIRGO FINE ROLLER BLACK
36205 VIRGO REFINED MIDDLE SHIRTS BLACK
36341 VIRGO CELLULAR ONE L/S {GIRAFFE} WHITE
36342 VIRGO CELLULAR ONE L/S {GIRAFFE} BLACK
36343 VIRGO AMPHIBIOUS SHORTS BLACK
36344 VIRGO AMPHIBIOUS SHORTS OLIVE
36386 VIRGO TREE REPETITION S/S WHITE
36387 VIRGO TREE REPETITION S/S BLACK
36751 VIRGO Logo プリントTシャツ White
36752 VIRGO Logo プリントTシャツ Black
37003 VIRGO LIGHT SHIP L/S BLACK
37004 VIRGO LIGHT SHIP L/S NAVY
37181 VIRGO SOUVENIR LONG CARDIGAN BLACK
37182 VIRGO SOUVENIR LONG CARDIGAN BGD
37192 VIRGO CAT HAND MOHAIR CARDIGAN BLACK
37193 VIRGO CAT HAND MOHAIR CARDIGAN NAVY
37505 VIRGO NY side line set pants BLK
37506 VIRGO NY side line set pants NAVY
37550 VIRGO 2face big knit ドルマンカットソー 【VIRGO】 [VG-CUT-350] BLK/CHA
37551 VIRGO 2face big knit ドルマンカットソー 【VIRGO】 [VG-CUT-350] NVY/GRY
37573 VIRGO Turtle wave special knit タートルネックニット 【VIRGO】 [VG-KNIT-64]
37699 VIRGO NATIVE MIDDLE CHECK SHIRTS BLK
37700 VIRGO Urban refraction mt parka BLK
37701 VIRGO Urban refraction mt parka NAVY
37702 VIRGO VIRGO×MACKDADDY special long shirts WHT/BLK
38556 VIRGO Big square hoodie jkt Khaki
38557 VIRGO Big square hoodie jkt Black
38558 VIRGO NEW PETAURISTA SPECIAL CARGO Black
38668 VIRGO VG-JKT-178 UMA stretch boa vest black
38669 VIRGO UMA stretch boa pants Black
38670 VIRGO Native mix crust pants black