SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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-28 23:27:36')
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, 180
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
28780 VIRGO VWW OLDSCHOOL WOOL CAP BLACK
28781 VIRGO VWW OLDSCHOOL WOOL CAP NAVY
28782 VIRGO 4FACE ASHTRA WHITE
28783 VIRGO CCV CAP BLK/BLK
28784 VIRGO CCV CAP WHT/BLK
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
29585 VIRGO BABY CHEEK STALL BLACK
29591 VIRGO PROTECT MOUNTAIN BACKPACK BLACK
29592 VIRGO PROTECT MOUNTAIN BACKPACK KHAKI
29593 VIRGO FRAGMENT MONSTER PARKA BLACK
29594 VIRGO FRAGMENT MONSTER PARKA GRAY
29656 VIRGO MOUNTAIN MOUTH DAMAGE KNIT BLACK
29657 VIRGO MOUNTAIN MOUTH DAMAGE KNIT RED
29658 VIRGO EVOLUTION DAMAGE MOHAIR ダメージニット
29659 VIRGO REFRACION WAVE JKT
29942 VIRGO PROTECT CLUTCHBAG
29943 VIRGO MARS GLOOVE PUP/BLK
29944 VIRGO MARS GLOOVE YEL/BLK
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シャツ(黒)
32009 VIRGO BIG V Mobile Case(Android+iPhone6plus)
32010 VIRGO BIG V Mobile Case (iPhone6&6S)
32011 VIRGO Blended Beads Bracelet BLACK
32012 VIRGO Blended Beads Bracelet RED
32013 VIRGO Blended Beads Bracelet TURQUOISE
32014 VIRGO Virgers Force Spectacle Watch BLACK
32015 VIRGO Smiles CAP BLACK
32016 VIRGO Smiles CAP BEIGE
32017 VIRGO Smiles CAP IND
32018 VIRGO Smiles CAP NAVY
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
32218 VIRGO Vintage Eagle Souvenir JKT Special BLACK
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
33429 VIRGO Amulet key holder BLACK
33430 VIRGO Amulet key holder BROWN
33431 VIRGO Amulet key holder NAVY
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
34272 VIRGO HAPPINESS CAP BLACK
34273 VIRGO HAPPINESS CAP KHAKI
34274 VIRGO HAPPINESS CAP SAX
34275 VIRGO CLIMBER SWT PANTS BLACK
34276 VIRGO CREST THE CARGO BLACK
34277 VIRGO CREST THE CARGO OLIVE
34288 VIRGO SUMMER NOMAD BLACK
34289 VIRGO MINI STAZ KEYHOLDER
34414 VIRGO HAPPINESS HAT WHITE
34415 VIRGO HAPPINESS HAT 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
34439 VIRGO APRONBAG MINI BLACK
34440 VIRGO APRONBAG MIN KHAKI
34929 VIRGO DIVISION WAY BLACK
34930 VIRGO DIVISION WAY GRAY
35211 VIRGO LANTANA ALOHA SHIRTS WHITE
35212 VIRGO LANTANA ALOHA SHIRTS BLACK
35213 VIRGO LANTANA ALOHA BAG WHITE
35214 VIRGO LANTANA ALOHA BAG RED
35215 VIRGO LANTANA ALOHA BAG BLACK
35216 VIRGO LANTANA ALOHA SHORTS WHITE
35217 VIRGO LANTANA ALOHA SHORTS BLACK
35218 VIRGO EXALTED SHORTS OLIVE
35219 VIRGO EXALTED SHORTS BLACK
36087 VIRGO W FACE BELT BLACK
36088 VIRGO W FACE BELT OLIVE
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
36099 VIRGO CELLULAR ONE S/S{HEDGEHOG} 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
36926 VIRGO VGW CAP WHITE
36927 VIRGO VGW CAP BLACK
36928 VIRGO VGW CAP NAVY
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
37183 VIRGO NATIVE CIRCLE L/S BLACK
37184 VIRGO NATIVE CIRCLE L/S NATURAL
37186 VIRGO ASSIMILATION BERET BLACK
37187 VIRGO ASSIMILATION BERET GRAY
37188 VIRGO ASSIMILATION BERET NAVY
37189 VIRGO SIMPLE KNIT BLACK
37190 VIRGO SIMPLE KNIT GRAY
37191 VIRGO SIMPLE KNIT NAVY
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
37552 VIRGO Military quilting square backpack バッグパック 【VIRGO】 [VG-GD-509] BLACK
37553 VIRGO Military quilting square backpack バッグパック 【VIRGO】 [VG-GD-509] KHAKI
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
38559 VIRGO Layering groove YELLOW
38560 VIRGO Layering groove BLACK
38561 VIRGO Layering groove RED
38562 VIRGO Layering groove PURPLE
38563 VIRGO Big Waffle Knit Cap Black
38564 VIRGO Big Waffle Knit Cap Gray