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-29 01:36:47')
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, 240
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
38565 VIRGO Big Waffle Knit Cap Navy
38668 VIRGO VG-JKT-178 UMA stretch boa vest black
38669 VIRGO UMA stretch boa pants Black
38670 VIRGO Native mix crust pants black
38671 VIRGO Wave way L/S Black
38672 VIRGO Wave way L/S White
38673 VIRGO Wave way L/S Navy
38776 VIRGO Gradation check middle shirts RED
38777 VIRGO Gradation check middle shirts BLUE
38778 VIRGO Gradation check middle shirts BLACK
38779 VIRGO Dual mouse leather mods coat Khaki
38940 VIRGO Mouton riders jkt Black
38990 VIRGO Slanting caves L/Sワッフルカットソー BLACK
38991 VIRGO Slanting caves L/Sワッフルカットソー NATURAL
39118 VIRGO SUPERIOR 2WAY HAIR BAND BLACK
39119 VIRGO PERVERSE BRACELET BLUE
39120 VIRGO PERVERSE BRACELET RED
39121 VIRGO PERVERSE BRACELET BLACK
39122 VIRGO HARD GAUGE KNIT BLACK
39123 VIRGO HARD GAUGE KNIT NAVY
39480 VIRGO VGW AWAY MINIBAG BLACK
39481 VIRGO VGW AWAY MINIBAG NAVY
39482 VIRGO CUSHION KNIT BLACK
39483 VIRGO CUSHION KNIT NAVY
39484 VIRGO FLAG 3/4 BLACK
39485 VIRGO FLAG 3/4 NAVY
39777 VIRGO SOFTNESS 7分袖カットソー VG-CUT-357 BLACK
39778 VIRGO SOFTNESS 7分袖カットソー VG-CUT-357 CHARCOAL
39779 VIRGO SOFTNESS 7分袖カットソー VG-CUT-357 WHITE
39780 VIRGO BIG VGW DOLMAN HOODIES VG-SWT-105 BLACK
39781 VIRGO BIG VGW DOLMAN HOODIES VG-SWT-105 NAVY
39849 VIRGO DIAGONAL DAMAGED White
39850 VIRGO DIAGONAL DAMAGED Charcoal
39882 VIRGO DIAGONAL DAMAGED Black
39999 VIRGO VIRGERS SAROUEL SWT PANTS BLACK
40000 VIRGO VIRGERS SAROUEL SWT PANTS KHAKI
40001 VIRGO VGW SUPREME OVERALL BLACK
40002 VIRGO VGW SUPREME OVERALL KHAKI
40003 VIRGO CRAZY OVER DYE INDIGO JKT SAX
40004 VIRGO CRAZY OVER DYE INDIGO JKT NAVY
40005 VIRGO WATER REPELLENT MILITARY COAT WHITE
40006 VIRGO WATER REPELLENT MILITARY COAT BLACK
40007 VIRGO GUITARIST DOLMAN SHIRTS RED
40008 VIRGO CURVATURE FOREST SHIRTS JKT BLACK
40563 VIRGO SNEAKERS SOLE MIDDLE BOOTS ミドルブーツ BLACK
40566 VIRGO VGW MILLSPEC TOTEBAG トートバッグ BEIGE
40567 VIRGO VGW MILLSPEC TOTEBAG トートバッグ BLACK
40572 VIRGO VGW MILLSPEC TOTEBAG トートバッグ OLIVE
40577 VIRGO OBLIQUE CHECK PANTS チェックサルエルパンツ GREEN
40582 VIRGO HARD GAUGE KNIT ニット BLACK
40882 VIRGO VG-GD-546 Flag cap キャップ BLK/GRY
40883 VIRGO VG-GD-546 Flag cap キャップ BLK/PP
40884 VIRGO VG-GD-546 Flag cap キャップ BLK/RED
40885 VIRGO Diamond logo crew jkt BLK
40886 VIRGO Diamond logo crew jkt BGD
41019 VIRGO VG-PT-297 Fluffy summer suit bottom パイルショーツ
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
41023 VIRGO VG-CUT-363 Native tale cut saw フリンジカットソー BLACK