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-18 14:23:39')
AND FIND_IN_SET(1, p.color)
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
LIMIT 0, 60
1581 Subciety EMBLEM SHIRT S/S-Plain- BLACK
3039 Subciety EMBLEM SHIRT L/S-Plain- BLACK
14639 Subciety PARKA-GLORIOUS- BLACK/WHITE
16037 Subciety PAISLEY TEE-Parantica sita- BLACK
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
17678 Subciety 15th GLORIOUS S/S BLACK/WHITE
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18447 Subciety GLORIOUS S/S - BLACK/WHITE
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
18604 Subciety (サブサエティ) METAL NECKLACE-JESUS- BLACK
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
20846 Subciety CLIMBING SHORTS BLACK
23090 Subciety(サブサエティ) THRON S/S BLACK
23124 Subciety COLLEGE S/S BLACK/BURGUNDY
25854 Subciety (サブサエティ) BANDANNA SKIRT-PAISLEY- BLACK
52994 Subciety PAISLEY WAIST BAG
53021 Subciety Daisy S/S BLACK
53023 Subciety EMOTION S/S BLACK
53025 Subciety Guadalupe S/S BLACK
53027 Subciety RATIO S/S BLACK
53081 Subciety (サブサエティ) COLOR BLOCK SHORTS BLACK
54181 Subcietyx攻殻機動隊SAC_2045 ZIP PARKA-GHOST HACK- BLACK
54184 Subcietyx攻殻機動隊SAC_2045 GHOST HACK L/S BLACK
54187 Subcietyx攻殻機動隊SAC_2045 Major S/S BLACK
54190 Subcietyx攻殻機動隊SAC_2045 Ghost in the Subciety S/S BLACK
54191 Subcietyx攻殻機動隊SAC_2045 Ghost in the Subciety S/S RED
54225 Subciety COACH JKT-MIDDLE LOGO- BLACK
54227 Subciety LEOPARD SWING TOP BLACK
54238 Subciety (サブサエティ) DOWN JKT BLACK
54251 Subciety LOOP TIE PARKA BLACK
54264 Subciety A-2PARKA BLACK
54273 Subciety PAISLEY SHIIRT BLACK
54276 Subciety PANEL SHIRT BLACK/BLACK
54279 Subciety WORK SHIRT BLACK
54304 Subciety FIVE LIGHTS L/S BLACK
54325 Subciety Purgatory L/S BLACK
54330 Subciety (サブサエティ) SKINNY PANTS BLACK
54338 Subciety(サブサエティ) BEANIE BLACK
55834 Subciety liquid S/S BLACK
56020 Subciety (サブサエティ) HALF ZIP BOA PARKA BLACK
56292 Subciety (サブサエティ) TROOPER HAT BLACK
56385 Subciety (サブサエティ) BEANIE-SERVER - BLACK
56388 Subciety PAISLEY BUCKET HAT - BLACK
56401 Subciety SNAP BACK CAP-SERVER- BLACK/WHITE
56403 Subciety (サブサエティ) PAISLEY SLACKS- BLACK
56409 Subciety POCKET TEE-crew- BLACK
56412 Subciety HYPER BIG TEE -MIDDLE LOGO- BLACK
56423 Subciety (サブサエティ) LABO. S/S - BLACK
56425 Subciety (サブサエティ) SERVER L/S - BLACK
56428 Subciety VANDALIZE L/S - BLACK
56433 Subciety CHILL SHIRT- BLACK
56442 Subciety (サブサエティ) SWEAT-SERVER-BLACK
56449 Subciety (サブサエティ) VANDALIZE PARKA- BLACK
56454 Subciety (サブサエティ) BREAK PARKA- BLACK
56457 Subciety (サブサエティ) SOUVENIR PARKA- BLACK
56460 Subciety (サブサエティ) FACTORY JKT- BLACK
56467 Subciety (サブサエティ) CPO COACH JKT - BLACK
56514 Subciety (サブサエティ) DOWN MUFFLER BLACK
56829 Subcietyx攻殻機動隊 CONNECT PULLOVER PARKA BLACK
56830 Subcietyx攻殻機動隊 SECTION9 PULLOVER PARKA BLACK