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-17 14:05:53')
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 11)
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
1581 Subciety EMBLEM SHIRT S/S-Plain- BLACK
3039 Subciety EMBLEM SHIRT L/S-Plain- BLACK
14639 Subciety PARKA-GLORIOUS- BLACK/WHITE
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18447 Subciety GLORIOUS S/S - BLACK/WHITE
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
53021 Subciety Daisy S/S BLACK
53023 Subciety EMOTION S/S BLACK
53025 Subciety Guadalupe S/S BLACK
53027 Subciety RATIO S/S 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
55834 Subciety liquid S/S BLACK
56020 Subciety (サブサエティ) HALF ZIP BOA PARKA BLACK
56403 Subciety (サブサエティ) PAISLEY SLACKS- BLACK
56409 Subciety POCKET TEE-crew- BLACK
56423 Subciety (サブサエティ) LABO. S/S - BLACK
56425 Subciety (サブサエティ) SERVER L/S - BLACK
56428 Subciety VANDALIZE L/S - 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
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
57324 Subciety×仮面ライダードライブ DRIVE S/S BLACK
57327 Subciety×仮面ライダードライブ MACH L/S BLACK
57333 Subciety×仮面ライダードライブ MACH PARKA 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
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
58949 Subciety (サブサエティ) M-65 FIELD JKT - BLACK
58958 Subciety (サブサエティ) SOUVENIR JKT - BLACK
58975 Subciety (サブサエティ) WESTERN SHIRT - BLACK/GRAY
58976 Subciety (サブサエティ) WESTERN SHIRT - BLACK/BEIGE
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
59304 Subciety (サブサエティ) CROWD S/S BLACK
60067 Subciety (サブサエティ) CLASSIC S/S BLACK
60498 Subciety (サブサエティ) SUEDE SWITCHED L/S BLACK
60501 Subciety (サブサエティ) Layered PARKA BLACK
60504 Subciety (サブサエティ) SEA OTTER PARKA BLACK
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
61837 Subciety (サブサエティ) EMBROIDERY PARKA BLACK
61838 Subciety (サブサエティ) EMBROIDERY PARKA BLACK/BLACK
61840 Subciety (サブサエティ) SLUGGER SWEAT BLACK
62152 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLACK
62155 Subciety (サブサエティ) BAKER BAGGY PANTS BLACK
63104 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLACK
63107 Subciety (サブサエティ) NOUGAT TEE BLACK
63110 Subciety (サブサエティ) SCOUT TEE BLACK
63113 Subciety (サブサエティ) INVOICE TEE BLACK
63116 Subciety (サブサエティ) PEPPER TEE BLACK
63203 Subciety (サブサエティ) DOUGH BOY TEE BLACK
63205 Subciety (サブサエティ) TAG S/S BLACK/PURPLE
63206 Subciety (サブサエティ) TAG S/S BLACK/ORANGE
63208 Subciety (サブサエティ) CAN TEE BLACK
63341 Subciety (サブサエティ) BLACK PANTHER TEE BLACK
63744 Subciety (サブサエティ) BARBER S/S BLACK
63810 Subciety(サブサエティ) FIVE LIGHTS TEE BLACK
63812 Subciety(サブサエティ) PAISLEY COACH SHIRT BLACK
63814 Subciety(サブサエティ) PAISLEY COACH SHORTS BLACK