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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =588
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-24 03:22:19')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 480, 120
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19014 REVOCATION Deathless Album Black
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
20722 Subciety (サブサエティ) PARKA-COLLEGE- GRAY/BURGUNDY
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
23453 HER NAME IN BLOOD NEON HOODIE
23591 HER NAME IN BLOOD HOODIE
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
25135 SEAWAY Colour Blind Logo Grey - Pullover
25484 PIERCE THE VEIL San Diego Navy - Pullover
26230 OPETH Morningrise Hoodie
32082 ライブキッズあるある フェス余韻パーカー
40491 THRASHER TH8501 MAG LOGO HOODIE NAVY/WHITE
45577 TOY MACHINE TMP19SW16 FIST EMBRO SWEAT PARKA BLACK
47643 SANTA CRUZ CLASSIC DOT HEAVYWEIGHT P/O HOODED SWEATSHIRT BLACK
48233 Zephyren(ゼファレン)PONCHO HOODY S/S WHITE / 如意宝珠
49756 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW ORANGE
49758 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW YELLOW
49759 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Pullover Designed by RIPDW GREEN
50445 LIGHTWEIGHT FLY HOODIE BOLT
51162 SLEEPING TABLET PATIENT [ HALF BUTTON VELOUR PULLOVER ] NAVY
51240 SAMURAI CORE SR-PK-07-B PUNK侍 pk black
51475 ANIMALIA AN19W-SW02 P/O HOODIE - CONVERT BLACK
52285 あゆみくりかまき×ゲキクロ×ripdw AKM STAR HOODIE
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
52915 FILA × STAPLE FM9880 WHITE
53074 SAMURAI CORE 釈迦 HOODIE BLACK
53075 SAMURAI CORE 釈迦 HOODIE WHITE
53076 SAMURAI CORE 釈迦 HOODIE RED
53110 SAMURAI CORE 夜露死苦哀愁 HOODIE BLACK
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
53892 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 BLACK
53917 PSYCHOLOGICAL METAMORPHOSIS PLMP PILE WAPPEN PARKA GREEN
53927 KEYTALK 丁寧な刺繍パーカー パープル
53928 KEYTALK 丁寧な刺繍パーカー ブラック
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
54221 ANIMALIA S/S SIDE ZIP HOODIE GRAY
54222 ANIMALIA S/S SIDE ZIP HOODIE RED
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT