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 12:54:12')
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
ORDER BY p.update_date
LIMIT 0, 120
46151 Subciety (サブサエティ) WORK SHIRT-Primal- BLACK
54330 Subciety (サブサエティ) SKINNY PANTS BLACK
1464 Subciety TANK TOP-GLORIOUS- BLK/GLD
1465 Subciety TANK TOP-GLORIOUS- BLK/WHT
2131 Subciety EMBLEM SHIRT 7/S DOT
5070 Subciety PRAYING HANDS R-L/S BK/WH
5846 Subciety EMBROIDERY ZIP PARKA Riot Angels
6036 Subciety EMBROIDERY JKT Riot Angels
6521 Subciety EMBROIDERY POLO S/S BLACKII Riot ANGELS
7982 Subciety COIN CASE BLACK
9226 Subciety B.B.CAP -GLORIOUS- BLACK/GOLD
9231 Subciety MESH CAP -OMG- BLACK/WHITE
10976 Subciety WORK PANTS -CLASSIC- FULL EMBROIDERY BLK
11784 Subciety PAISLEY TANK TOP BLACK
11893 Subciety PAISLEY TANK TOP BLACK
13945 Subciety ZIP PARKA-WELL MADE-BLACK/WHITE
14120 subciety HERRINGBONE SHIRTS L/S -VIDALOCA- BLACK
14130 Subciety PATTERNED ZIP PARKA-GLORIOUS- BLK/MUS
14236 Subciety EMBROIDERY ZIP PARKA BLACK/TRIBE CROSS
14256 Subciety PAISLEY POCKET SHIRTS L/S-praha- BLK
14549 Subciety 7UNION × Subciety BEANIE -SALOON- BLACK
14642 Subciety TRIBAL ZIP PARKA BLACK
14712 Subciety SWING TOP-BABYLON- BLACK
14887 Subciety PAISLEY SHIRTS L/S BLACK
15750 Subciety EMBLEM SHIRT L/S 15th Anniversary BLK
15797 Subciety Subciety SWING TOP-El Subciety- BLACK
15851 Subciety MOUNTAIN PARKA BLACK
15853 Subciety EMBLEM CARDIGAN BLK
16037 Subciety PAISLEY TEE-Parantica sita- BLACK
16128 Subciety DENIM TYPE Ⅳ-ReBorn-HW - BLACK/HARD WASH
16178 Subciety SNAP BACK CAP-GLORIOUS- BLACK/WHITE
16194 Subciety SNAP BACK CAP-New Jack- BLACK/WHITE
16504 Subciety ZIP PARKA-LARGE GLORIOUS- BLACK
16508 Subciety PARKA-LARGE GLORIOUS- BLACK
16687 Subciety ZIP PARKA-PATTERNED ALL OVER- SOUNDSYSTEM
16756 Subciety X eyedy. SUBEYEDY T BLACK
18339 Subciety STADIUM JKT-NX- - BURGUNDY
18340 Subciety V NECK KNIT-New Jack- - BLACK
18349 Subciety CARDIGAN-Conductor- - BLACK
18356 Subciety DENIM SHIRT L/S-NX- BLACK
18360 Subciety EMBLEM SHIRT L/S - BLACK.STAR
18373 Subciety EMBROIDERY SHIRT L/S-GLORIOUS- - BLACK
18401 Subciety SWEAT-SALOON- - BLACK
18405 Subciety SWEAT-New Jack- BLACK/WHITE
18412 Subciety ZIP PARKA-NX- - BLACK
18429 Subciety PARKA-SALOON- - BLACK/RED
18433 Subciety PARKA-New Jack- BLACK/WHITE
18453 Subciety THE BASE S/S - BLACK/PINK
18457 Subciety SALOON S/S - BLACK/RED
18492 Subciety LARGE GLORIOUS L/S - BLACK
18495 Subciety SALOON L/S-CAMOUFLAGE- - BLACK
18499 Subciety New Jack L/S - BLACK/WHITE
18521 Subciety DENIM TYPE Ⅳ-ReBorn- - BLACK/NON WASH
18522 Subciety DENIM TYPE Ⅳ-ReBorn- - BLACK/ONE WASH
18526 Subciety DENIM TYPE 81 - BLACK
18536 Subciety UTILITY PANTS - CAMOUFLAGE
18548 Subciety MESH CAP-GLORIOUS- - BLACK/BURGUNDY
18555 Subciety MESH CAP-EL Subciety- BLACK/WHITE
18648 Subciety GYM SOCKS - BLACK
20636 Subciety (サブサエティ) SHOP COAT-GLORIOUS- BLACK
20638 Subciety SWING TOP-GLORIOUS- BLACK
20658 Subciety EMBLEM SHIRT L/S CAMOUFLAGE
20665 Subciety CRAZY CHECK SHIRT L/S-Praha- BLACK
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
20699 Subciety SWEAT-CAMOUFLAGE SALOON- BLACK
20701 Subciety SWEAT-PAISLEY GLORIOUS- BLACK
20716 Subciety PARKA-CAMOUFLAGE SALOON- BLACK
20718 Subciety PARKA-PAISLEY GLORIOUS- BLACK
20721 Subciety (サブサエティ) PARKA-COLLEGE- BLACK/ORANGE
20728 Subciety (サブサエティ) ZIP PARKA-Praha- BLACK
20880 Subciety 7UNION×Subciety SNAP BACK CAP-SYMBOL- BLACK/KHAKI
20935 Subciety PEN-THE BASE- BLACK
22147 Subciety HEAVY FLANNEL SHIRT-GLORIOUS- WHITE
22148 Subciety EMBLEM HEAVY FLANNEL SHIRT BLACK
22985 Subciety MESH CAP-SYMBOL- BLACK
22991 Subciety(サブサエティ) R.I.P. S/S BLACK
23003 Subciety ALOHA SHIRT S/S BLACK
23005 Subciety ALOHA SHORTS BLACK
23011 Subciety ALOHA BUCKET HAT BLACK
23034 Subciety POLO SHIRT-New Jack- BLACK
23048 Subciety TAPERED WORK PANTS-PAISLEY- BLACK
23053 Subciety SNAP BACK CAP-GLORIOUS- BLACK/GREEN
23070 Subciety(サブサエティ) S to Y S/S BLACK
23084 Subciety(サブサエティ) GLORIOUS S/S-MELT- BLACK/WHITE
23085 Subciety(サブサエティ) GLORIOUS S/S-MELT- BLACK/GREEN
23092 Subciety LONG LENGTH NO SLEEVE-GLORIOUS- BLACK
23104 Subciety THE BASE S/S BLACK/TARQUOISE
23115 Subciety FLAG S/S BLACK
23133 Subciety BREAK DOWN WALLS S/S BLACK
23142 Subciety GLORIOUS S/S-ALOHA- BLACK
23144 Subciety V-NECK TEE S/S-Praha- BLACK
23157 Subciety TANK TOP-SYMBOL- BLACK
23161 Subciety GLORIOUS TANK TOP BLACK/TARQUOISE
23174 Subciety ALOHA SNAP BACK CAP-NOVEL- BLACK
23184 Subciety ALOHA POCKET TEE S/S BLACK
23187 Subciety GLORIOUS TANK TOP-ALOHA- BLACK
23200 Subciety NECK STRAP-THE BASE- BLACK
23205 Subciety PILE HAT-SYMBOL- BLACK
23211 Subciety SYMBOL RING BLACK
23244 Subciety PAISLEY RING BLACK
23256 Subciety STAINLESS TUMBLER-PAISLEY- PAISLEY
24625 Subciety SE GUADALUPE CAP BLACK
24961 Subciety (サブサエティ) SE GUADALUPE TEE BLACK
24965 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- BLACK
25088 Subciety (サブサエティ) SNAP BACK CAP-SYMBOL- BLACK
25221 Subciety(サブサエティ) HENRY&HENRY SANDALS FLIPPER
25575 Subciety COACH JACKET-GLORIOUS- BLACK-WHITE
25576 Subciety COACH JACKET-GLORIOUS- BLACK-GOLD
25580 Subciety (サブサエティ) COACH JACKET-THE BASE- BLACK
25581 Subciety (サブサエティ) COACH JACKET-ZIPANG- BLACK
25585 Subciety SWING TOP-GLORIOUS- BLACK
25596 Subciety STADIUM JACKET-THRON- BLACK
25598 Subciety LEATHER HOODY-Praha- BLACK
25600 Subciety WOOL STADIUM JACKET-Reborn- BLACK
25603 Subciety (サブサエティ) LINE SWEATER-GLORIOUS- BLACK
25606 Subciety PAISLEY PATTERNED SWEATER CHARCOAL
25609 Subciety (サブサエティ) EMBLEM CARDIGAN BLACK
25623 Subciety EMBLEM SHIRT L/S-CAMOUFLAGE- BLACK