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-27 02:06:23')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 447)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 720, 120
22566 Zephyren (ゼファレン) PARKA -PAISLEY- NVY
22568 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x PAISLEY
22569 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- CHACOAL x PAISLEY
22570 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- BLACK x CHECK
22571 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- CHACOAL x CHECK
22589 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- RED
22590 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- NAVY
22591 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- BLACK
22638 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE PARKA -VISIONARY- CAMO I
22639 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE PARKA -VISIONARY- CAMO II
22640 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE PARKA -VISIONARY- LEOPARD I
22641 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE PARKA -VISIONARY- LEOPARD II
22642 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE ZIP PARKA -Resolve- CAMO I
22643 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE ZIP PARKA -Resolve- CAMO II
22644 Zephyren (ゼファレン) CROSS PAISLEY PARKA BLACK x WHITE
22645 Zephyren (ゼファレン) CROSS PAISLEY PARKA BLACK
22646 Zephyren (ゼファレン) CROSS PAISLEY PARKA BURGUNDY
22647 Zephyren (ゼファレン) CROSS PAISLEY ZIP PARKA BLACK x WHITE
22648 Zephyren (ゼファレン) CROSS PAISLEY ZIP PARKA BLACK
22649 Zephyren (ゼファレン) CROSS PAISLEY ZIP PARKA BURGUNDY
22650 Zephyren (ゼファレン) PARKA -PROVIDENCE- BLACK x WHITE
22651 Zephyren (ゼファレン) PARKA -PROVIDENCE- BLACK
22652 Zephyren (ゼファレン) PARKA -PROVIDENCE- BURGUNDY
22653 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK
22654 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BURGUNDY
22742 Zephyren (ゼファレン) SAFARI JKT BLACK x CAMO
22743 Zephyren (ゼファレン) SAFARI JKT BLACK x PAISLEY
22744 Zephyren (ゼファレン) ZIP PARKA -PROVIDENCE- BLACK x WHITE
22745 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- WHITE
22746 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- BLACK
22747 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- BURGUNDY
22748 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- NAVY
22749 Zephyren (ゼファレン) BUCKET HAT -SKULL HEAD- CAMO II
22751 Zephyren(ゼファレン)METAL NECKLACE -STUDS CROSS- GOLD
22752 Zephyren(ゼファレン)METAL NECKLACE -STUDS CROSS- SILVER
22754 Zephyren (ゼファレン) METAL NECKLACE -STUDS CROSS- ANTIQUE SILVER
22755 Zephyren (ゼファレン) STUDS PIERCE ANTIQUE GOLD
22756 Zephyren (ゼファレン) STUDS METAL RING BLACK
22757 Zephyren (ゼファレン) STUDS METAL RING GOLD
22761 Zephyren (ゼファレン) STUDS PIERCE ANTIQUE SILVER
22887 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/WHITE
22888 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLACK/BURGUNDY
22889 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- GRAY
22890 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- BLUE
22891 Zephyren (ゼファレン) THRASHER x Zephyren S/S TEE -PENETRATE- WHITE
22893 Zephyren (ゼファレン) THRASHER x Zephyren S/S TEE -PENETRATE- BURGUNDY
22894 Zephyren (ゼファレン) S/S TEE -BEYOND- CHACOAL
22896 Zephyren (ゼファレン) FLIP iPhone 6 CASE -Scream of Aggression-
22920 Zephyren (ゼファレン) GEKIROCK CLOTHING x Zephyren LONG SHIRT RED
22921 Zephyren (ゼファレン) GEKIROCK CLOTHING x Zephyren LONG SHIRT MUSTARD YELLOW
22958 Zephyren (ゼファレン) PAISLEY SHIRT L/S -Resolve- RED
22959 Zephyren (ゼファレン) CAMOUFLAGE SHIRT L/S -Charmed SQ Tone- CAMO I
23262 Zephyren (ゼファレン) S/S TEE -VISIONARY- BLACK/RED
23265 Zephyren (ゼファレン) S/S TEE -VISIONARY- GRAY
23268 Zephyren (ゼファレン) S/S TEE -SKULL HEAD- CHACOAL
23269 Zephyren (ゼファレン) VNECK TEE -VISIONARY- WHITE
23271 Zephyren (ゼファレン) VNECK TEE -VISIONARY- BLACK
23273 Zephyren (ゼファレン) VNECK TEE -VISIONARY- GRAY
23395 Zephyren (ゼファレン) STRIPE SHIRT L/S -CASINO- BLACK
23396 Zephyren (ゼファレン) STRIPE SHIRT L/S -CASINO- WHITE
23609 Zephyren (ゼファレン) SLACKS SHORTS CAMO
23610 Zephyren (ゼファレン) EMBLEM SHIRT S/S BLACK STRIPE
23611 Zephyren (ゼファレン) EMBLEM SHIRT S/S NAVY STRIPE
23613 Zephyren (ゼファレン) EMBLEM SHIRT S/S CAMO II
23897 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- CHA/CHK
23898 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- CHA/PAI
23899 Zephyren (ゼファレン) SWITCHING S/S LONG HOODY -Resolve- BLK/CHK
23911 Zephyren (ゼファレン) SWITCHING S/S LONG TEE -VISIONARY- BLACK x PAISLEY
23912 Zephyren (ゼファレン) SWITCHING S/S LONG TEE -VISIONARY- BLACK x CHECK
23913 Zephyren (ゼファレン) SIDE EMBROIDERY B.B CAP -VISIONARY- BLACK
23914 Zephyren (ゼファレン) SIDE EMBROIDERY B.B CAP -VISIONARY- NAVY
23915 Zephyren (ゼファレン) SIDE EMBROIDERY B.B CAP -VISIONARY- BURGUNDY
23916 Zephyren (ゼファレン) SIDE EMBROIDERY B.B CAP -VISIONARY- BLACK PAISLEY
24391 Zephyren (ゼファレン) STRIPE SHIRT S/S -CASINO- WHITE
24392 Zephyren (ゼファレン) STRIPE SHIRT S/S -CASINO- BLACK
24393 Zephyren (ゼファレン) SWITCHING S/S TEE -VISIONARY- WHITE
24394 Zephyren (ゼファレン) SWITCHING S/S TEE -VISIONARY- BLACK
24395 Zephyren (ゼファレン) TANK TOP -BEYOND- KHAKI
24396 Zephyren (ゼファレン) S/S TEE -DAWN- WHITE
24397 Zephyren (ゼファレン) S/S TEE -DAWN- BLACK
24398 Zephyren (ゼファレン) S/S TEE -DAWN- BLACK/RED
24709 Zephyren (ゼファレン) PAISLEY POCKET TEE WHITE
24710 Zephyren (ゼファレン) PAISLEY POCKET TEE GRAY
24711 Zephyren (ゼファレン) PAISLEY POCKET TEE NAVY
24712 Zephyren (ゼファレン) LONG NOSLEEVE -PROVIDENCE- WHITE
24713 Zephyren (ゼファレン) LONG NOSLEEVE -PROVIDENCE- BLACK
24714 Zephyren (ゼファレン) LONG NOSLEEVE -PROVIDENCE- BURGUNDY
24715 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- BLACK x PAISLEY
24716 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- CHACOAL x PAISLEY
24717 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- BLACK x CHECK
24718 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- CHACOAL x CHECK
24719 Zephyren (ゼファレン) S/S TEE -ALCHEMY- WHITE
24720 Zephyren (ゼファレン) S/S TEE -ALCHEMY- BLACK
24721 Zephyren (ゼファレン) S/S TEE -REBEL FLAG- WHITE
24722 Zephyren (ゼファレン) S/S TEE -REBEL FLAG- BLACK
24723 Zephyren (ゼファレン) S/S TEE -REBEL FLAG- BLACK/RED
24724 Zephyren (ゼファレン) S/S TEE -REBEL FLAG- BURGUNDY
24725 Zephyren (ゼファレン) SWEAT SHORTS CAMO I
24727 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- RED
24728 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- BLACK
24729 Zephyren (ゼファレン) CAMOUFLAGE SHIRT S/S -Charmed SQ Tone- CAMO I
24730 Zephyren (ゼファレン) CAMOUFLAGE SHIRT S/S -Charmed SQ Tone- CAMO II
24731 Zephyren (ゼファレン) CAMOUFLAGE SHIRT S/S -Charmed SQ Tone- CAMO V
24732 Zephyren (ゼファレン) PATCH S/S TEE -VISIONARY- WHITE
24733 Zephyren (ゼファレン) PATCH S/S TEE -VISIONARY- BLACK
24782 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - BLACK
24783 ZEPHYREN (ゼファレン) TIE DYE TRIBAL PARKA -Resolve - NAVY
24917 Zephyren (ゼファレン) LONG BEANIE -You Are Here- CHACOAL
24918 Zephyren (ゼファレン) LONG BEANIE -You Are Here- BURGUNDY
24919 Zephyren (ゼファレン) LONG BEANIE -You Are Here- BLUE
24923 Zephyren (ゼファレン) BUCKET HAT -VISIONARY- CAMO II
24924 Zephyren (ゼファレン) BUCKET HAT -SPADE- WHITE
24927 Zephyren (ゼファレン) BUCKET HAT -SPADE- BLACK
24928 Zephyren (ゼファレン) BUCKET HAT -SPADE- BURGUNDY
24929 Zephyren (ゼファレン) BUCKET HAT -SPADE- NAVY
24930 Zephyren (ゼファレン) BUCKET HAT -SPADE- CAMO I
24931 Zephyren (ゼファレン) BUCKET HAT -SPADE- CAMO II
24932 Zephyren (ゼファレン) WIDE BRIM PANAMA HAT BLACK
24933 Zephyren (ゼファレン) WIDE BRIM PANAMA HAT BEIGE
24934 Zephyren (ゼファレン) WIDE BRIM PANAMA HAT MIX