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-18 20:29:14')
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
LIMIT 0, 120
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