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-25 01:45:52')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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 360, 120
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 パイルショーツ