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-05-01 14:05:17')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 77)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 360, 120
20638 Subciety SWING TOP-GLORIOUS- BLACK
20639 Subciety SWING TOP-GLORIOUS- KHAKI
20648 Subciety EMBROIDERY SHIRT L/S-GLORIOUS- WHITE
20650 Subciety (サブサエティ) EMBROIDERY SHIRT L/S-GLORIOUS- OD
20651 Subciety EMBROIDERY SHIRT L/S-GLORIOUS- MUSTARD
20654 Subciety EMBLEM VEST STRIPE
20658 Subciety EMBLEM SHIRT L/S CAMOUFLAGE
20659 Subciety EMBLEM SHIRT L/S CHAMBRAY
20665 Subciety CRAZY CHECK SHIRT L/S-Praha- BLACK
20666 Subciety CRAZY CHECK SHIRT L/S-Praha- GREEN
20669 Subciety GINGHAM CHECK SHIRT L/S-GLORIOUS- WHITE
20671 Subciety GINGHAM CHECK SHIRT L/S-GLORIOUS- GREEN
20675 Subciety POCKET PALM SHIRT S/S-Conductor- WHITE
20676 Subciety POCKET PALM SHIRT S/S-Conductor- BLACK
20684 Subciety WORK SHIRT S/S-ROCK SMITH- BLACK
20689 Subciety (サブサエティ) SWEAT S/S-FLAG- BLACK
20691 Subciety (サブサエティ) SWEAT S/S-FLAG- NAVY
20697 Subciety SWEAT-GLORIOUS- NAVY/WHITE
20699 Subciety SWEAT-CAMOUFLAGE SALOON- BLACK
20701 Subciety SWEAT-PAISLEY GLORIOUS- BLACK
20715 Subciety PARKA-CAMOUFLAGE SALOON- WHITE
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
20718 Subciety PARKA-PAISLEY GLORIOUS- BLACK
20721 Subciety (サブサエティ) PARKA-COLLEGE- BLACK/ORANGE
20722 Subciety (サブサエティ) PARKA-COLLEGE- GRAY/BURGUNDY
20728 Subciety (サブサエティ) ZIP PARKA-Praha- BLACK
20729 Subciety (サブサエティ) ZIP PARKA-Praha- GRAY
20732 Subciety SALOON L/S-CAMOUFLAGE- WHITE
20734 Subciety GLORIOUS L/S-PAISLEY- WHITE
20750 Subciety BASEBALL TEE 7/S-COLLEGE- WHITE
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
20880 Subciety 7UNION×Subciety SNAP BACK CAP-SYMBOL- BLACK/KHAKI
20882 Subciety 7UNION×Subciety BUCKET HAT-SYMBOL- WHITE
20883 Subciety 7UNION×Subciety BUCKET HAT-SYMBOL- KHAKI
20935 Subciety PEN-THE BASE- BLACK
22145 Subciety HEAVY FLANNEL SHIRT-GLORIOUS- BLUE
22146 Subciety HEAVY FLANNEL SHIRT-GLORIOUS- RED
22147 Subciety HEAVY FLANNEL SHIRT-GLORIOUS- WHITE
22148 Subciety EMBLEM HEAVY FLANNEL SHIRT BLACK
22149 Subciety EMBLEM HEAVY FLANNEL SHIRT OFF WHITE
22152 Subciety EMBLEM HEAVY FLANNEL SHIRT NAVY
22962 Subciety EMBLEM SHIRT L/S YELLOW
22963 Subciety EMBLEM SHIRT L/S PINK
22964 Subciety EMBLEM SHIRT L/S SAX
22969 Subciety EMBLEM SHIRT S/S SAX
22982 Subciety EMBLEM SHIRT S/S-PAISLEY- BLACK
22985 Subciety MESH CAP-SYMBOL- BLACK
22986 Subciety MESH CAP-SYMBOL- CHARCOAL
22991 Subciety(サブサエティ) R.I.P. S/S BLACK
22995 Subciety BORDER TEE S/S-VIC.- NAVY
22996 Subciety BOWLING SHIRT S/S-NX- WHITE
22998 Subciety LARGE GLORIOUS SHIRT S/S WHITE
23003 Subciety ALOHA SHIRT S/S BLACK
23005 Subciety ALOHA SHORTS BLACK
23006 Subciety ALOHA SHORTS NAVY
23011 Subciety ALOHA BUCKET HAT BLACK
23012 Subciety ALOHA BUCKET HAT NAVY
23015 Subciety DOT SHORTS BLACK
23017 Subciety WORK SHIRT S/S-Reborn- WHITE
23033 Subciety POLO SHIRT-New Jack- WHITE
23034 Subciety POLO SHIRT-New Jack- BLACK
23041 Subciety FOOTBALL TEE S/S-SALOON- WHITE
23042 Subciety FOOTBALL TEE S/S-SALOON- GRAY
23048 Subciety TAPERED WORK PANTS-PAISLEY- BLACK
23049 Subciety TAPERED WORK PANTS-PAISLEY- BEIGE
23052 Subciety SNAP BACK CAP-GLORIOUS- ORANGE
23053 Subciety SNAP BACK CAP-GLORIOUS- BLACK/GREEN
23054 Subciety SNAP BACK CAP-GLORIOUS- BLACK/TEAL
23055 Subciety SNAP BACK CAP-GLORIOUS- PURPLE/YELLOW
23057 Subciety PAISLEY SHORTS BLACK
23059 Subciety LONG LENGTH TEE-GLORIOUS- BLACK
23060 Subciety LONG LENGTH TEE-GLORIOUS- NAVY
23067 Subciety SLIP-ON CAMOUFLAGE
23068 Subciety SLIP-ON WASH DENIM
23069 Subciety(サブサエティ) S to Y S/S WHITE
23070 Subciety(サブサエティ) S to Y S/S BLACK
23077 Subciety(サブサエティ) GLORIOUS S/S-BRIGHT- BLUE
23082 Subciety(サブサエティ) GLORIOUS S/S-MELT- WHITE/BLACK
23084 Subciety(サブサエティ) GLORIOUS S/S-MELT- BLACK/WHITE
23085 Subciety(サブサエティ) GLORIOUS S/S-MELT- BLACK/GREEN
23089 Subciety(サブサエティ) THRON S/S WHITE
23092 Subciety LONG LENGTH NO SLEEVE-GLORIOUS- BLACK
23099 Subciety GLORIOUS S/S BLUE
23100 Subciety GLORIOUS S/S YELLOW
23102 Subciety THE BASE S/S WHITE/RED
23104 Subciety THE BASE S/S BLACK/TARQUOISE
23109 Subciety SALOON S/S WHITE/NAVY
23115 Subciety FLAG S/S BLACK
23123 Subciety COLLEGE S/S WHITE/MUSTARD
23129 Subciety BALL CAP-GLORIOUS- WHITE
23130 Subciety BALL CAP-GLORIOUS- BLACK
23131 Subciety BALL CAP-GLORIOUS- NAVY
23133 Subciety BREAK DOWN WALLS S/S BLACK
23134 Subciety BREAK DOWN WALLS S/S YELLOW
23141 Subciety GLORIOUS S/S-ALOHA- WHITE
23142 Subciety GLORIOUS S/S-ALOHA- BLACK
23143 Subciety V-NECK TEE S/S-Praha- ASH
23144 Subciety V-NECK TEE S/S-Praha- BLACK
23157 Subciety TANK TOP-SYMBOL- BLACK
23159 Subciety GLORIOUS TANK TOP WHITE/MUSTARD
23161 Subciety GLORIOUS TANK TOP BLACK/TARQUOISE
23174 Subciety ALOHA SNAP BACK CAP-NOVEL- BLACK
23175 Subciety ALOHA SNAP BACK CAP-NOVEL- NAVY
23181 Subciety SNAP BACK CAP-New Jack- RED
23183 Subciety SNAP BACK CAP-New Jack- DARK GREEN
23184 Subciety ALOHA POCKET TEE S/S BLACK
23185 Subciety ALOHA POCKET TEE S/S NAVY
23186 Subciety GLORIOUS TANK TOP-ALOHA- WHITE
23187 Subciety GLORIOUS TANK TOP-ALOHA- BLACK
23190 Subciety TAPERED DENIM-GLORIOUS- INDIGO
23200 Subciety NECK STRAP-THE BASE- BLACK
23201 Subciety KNAPSACK-GLORIOUS- WHITE
23202 Subciety KNAPSACK-GLORIOUS- BLACK
23205 Subciety PILE HAT-SYMBOL- BLACK
23206 Subciety PILE HAT-SYMBOL- NAVY
23211 Subciety SYMBOL RING BLACK
23213 Subciety SYMBOL RING ANTIQUE SILVER
23216 Subciety (サブサエティ) MESSENGER BAG-GLORIOUS- BLACK
23225 Subciety BANDANNA BLACK
23234 Subciety ALOHA BELT NAVY