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-02 18:26:27')
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, 120
14639 Subciety PARKA-GLORIOUS- BLACK/WHITE
18604 Subciety (サブサエティ) METAL NECKLACE-JESUS- BLACK
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
56831 Subcietyx攻殻機動隊 Cyberbrain L/S TEE SHIRT BLACK
56838 Subcietyx攻殻機動隊 TACHIKOMA L/S TEE SHIRT BLACK
57277 Subciety (サブサエティ) PARKA-PROVIDENCE- BLACK
57321 Subciety (サブサエティ) DRIFTER PACK
57324 Subciety×仮面ライダードライブ DRIVE S/S BLACK
57327 Subciety×仮面ライダードライブ MACH L/S BLACK
57333 Subciety×仮面ライダードライブ MACH PARKA BLACK
57855 Subciety SHOULDER BAG - BLACK
57864 Subciety METRO HAT- BLACK
57868 Subciety LOWCAP-Robin- BLACK
57871 Subciety SNAPBACK CAP-Fuckyou- BLACK
57875 Subciety MUTANT CARGO PANTS- BLACK
57879 Subciety TANK TOP- BLACK
57884 Subciety (サブサエティ) WEEKENDER S/S- BLACK
57893 Subciety (サブサエティ) Robin S/S- BLACK
57899 Subciety AMBITION S/S - BLACK
57913 Subciety (サブサエティ) DRUNKER S/S- BLACK
57920 Subciety (サブサエティ) WEEKENDER SHIRT - BLACK
57922 Subciety (サブサエティ) HALF ZIP CUBA SHIRT- BLACK
57927 Subciety OPEN COLLAR SHIRT- BLACK
57939 Subciety (サブサエティ) WORK SHORTS-WORKER- BLACK
57957 Subciety (サブサエティ) METAL NECKLACE-PRAYING HANDS- BLACK
58450 Subciety (サブサエティ)×BORUTO-ボルト- NARUTO NEXT GENERATIONS BORUTO PARKA BLACK
58454 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S BLACK
58456 Subciety×NARUTO-ナルト- 疾風伝 KAKASHI&GUY L/S BLACK
58464 NARUTO-ナルト- 疾風伝 ×Subciety SASUKE S/S BLACK
58567 Subciety (サブサエティ) SOCKS BLACK
58949 Subciety (サブサエティ) M-65 FIELD JKT - BLACK
58951 Subciety (サブサエティ) EXTREME JKT - BLACK
58953 Subciety (サブサエティ) STADIUM FLIGHT JKT - BLACK/YELLOW
58958 Subciety (サブサエティ) SOUVENIR JKT - BLACK
58975 Subciety (サブサエティ) WESTERN SHIRT - BLACK/GRAY
58976 Subciety (サブサエティ) WESTERN SHIRT - BLACK/BEIGE
58985 Subciety (サブサエティ) COVER ALL SHIRT - BLACK
59012 Subciety (サブサエティ) PIGMENT PARKA - BLACK
59037 Subciety (サブサエティ) Separation PARKA - BLACK
59065 Subciety (サブサエティ) cardinal S/S - BLACK
59069 Subciety (サブサエティ) RAGLAN L/S - BLACK
59080 Subciety (サブサエティ) Separation L/S - BLACK
59086 Subciety (サブサエティ) EMBROIDERY BIG L/S - BLACK
59300 Subciety (サブサエティ) CORDUROY CHEF PANTS BLACK
59302 Subciety (サブサエティ) WEBBING BELT CHEF PANTS BLACK
59304 Subciety (サブサエティ) CROWD S/S BLACK
59305 Subciety (サブサエティ) BOXER SHORTS
59306 Subciety (サブサエティ) SNAPBACK CAP-CROWD- BLACK/WHITE
60067 Subciety (サブサエティ) CLASSIC S/S BLACK
60498 Subciety (サブサエティ) SUEDE SWITCHED L/S BLACK
60501 Subciety (サブサエティ) Layered PARKA BLACK
60504 Subciety (サブサエティ) SEA OTTER PARKA BLACK
60505 Subciety (サブサエティ) NYLON PANTS BLACK / WHITE
60506 Subciety (サブサエティ) NYLON JKT BLACK / WHITE
60561 Subciety 2022 福袋 -NEW YEAR BAG-
60650 Subciety (サブサエティ) CLASSIC PARKA BLACK
60652 Subciety (サブサエティ) BUBBLE L/S BLACK
60859 Subciety (サブサエティ) PAISLEY BOX PARKA BLACK
60861 Subciety (サブサエティ) DOWN JKT BLACK
60862 Subciety (サブサエティ) DOWN JKT BLACK/PAISLEY
60863 Subciety (サブサエティ) FLEECE JKT BLACK/GRAY
61132 Subciety (サブサエティ) SABBAT13 × Subciety L/S BLACK
61236 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive PARKA BLACK
61239 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション NIRVASH L/S BLACK
61241 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション EUREKA L/S BLACK
61243 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive TEE BLACK
61394 Subciety (サブサエティ) Kesagiri SWEAT BLACK
61396 Subciety (サブサエティ) HALF ZIP SWEAT BLACK
61399 Subciety (サブサエティ) PAISLEY PARKA BLACK
61462 Subciety (サブサエティ) HAORI CARDIGAN BLACK
61466 Subciety (サブサエティ) SWING TOP BLACK
61469 Subciety (サブサエティ) BALLOON PANTS BLACK
61508 Subciety (サブサエティ) PARKA-PROVIDENCE- BLACK/WHITE
61698 Subciety (サブサエティ) VELOUR RUGGER SHIRT BLACK
61700 Subciety (サブサエティ) BOOTLEG BRAND S/S BLACK