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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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:26:14')
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
ORDER BY p.update_date
LIMIT 0, 120
18453 Subciety THE BASE S/S - BLACK/PINK
18457 Subciety SALOON S/S - BLACK/RED
23085 Subciety(サブサエティ) GLORIOUS S/S-MELT- BLACK/GREEN
23133 Subciety BREAK DOWN WALLS S/S BLACK
23142 Subciety GLORIOUS S/S-ALOHA- BLACK
23144 Subciety V-NECK TEE S/S-Praha- BLACK
23184 Subciety ALOHA POCKET TEE S/S BLACK
25797 Subciety PRAYING HANDS V-NECK S/S BLACK
25803 Subciety EMOTION V-NECK S/S BLACK
29288 Subciety (サブサエティ) LONG LENGTH TEE S/S-Fab four- BLACK
32653 Subciety (サブサエティ) DROP SHOULDER S/S BLACK
32666 Subciety (サブサエティ) SALOON S/S BLACK
32699 Subciety (サブサエティ) LONG LENGTH TEE S/S-Sub Wolrd- BLACK
34697 Subciety (サブサエティ) David brick S/S BLACK
34699 Subciety (サブサエティ) BURN S/S BLACK
34704 Subciety (サブサエティ) PLAIN TEE S/S BLACK
34706 Subciety (サブサエティ) HEMP GLORIOUS S/S BLACK
34709 Subciety (サブサエティ) V NECK TEE S/S-STOMP- BLACK
38014 Subciety (サブサエティ) INSANE TEE S/S BLACK
38019 Subciety (サブサエティ) MACHINE S/S BLACK
38027 Subciety (サブサエティ) ザ・ベース S/S BLACK
38030 Subciety (サブサエティ) Statement S/S BLACK/WHITE
39135 Subciety 2018 福袋 -NEW YEAR BAG-
39596 Subciety Hofmann S/S BLACK
39600 Subciety MINE S/S BLACK
39602 Subciety Episode 2 S/S BLACK
39608 Subciety SUBY S/S BLACK
41430 Subciety (サブサエティ) CLASS TEE BLACK
41432 Subciety (サブサエティ) WARPED TEE BLACK
41442 Subciety (サブサエティ) 基地 S/S BLACK
45693 Subciety (サブサエティ) RATIO S/S BLACK
47435 Subciety SIDE GLORIOUS S/S BLACK
47436 Subciety (サブサエティ) RATIO S/S BLACK/WHITE
47825 Subciety STENCIL THE BASE S/S BLACK
47864 Subciety (サブサエティ) VINYL S/S BLACK
47869 Subciety (サブサエティ) X-RATIO S/S BLACK
47872 Subciety (サブサエティ) HOLOGRAM THE BASE S/S BLACK
48372 【Subciety x RADIO EVA】 RADIO EVA TOUR S/S BLACK/WHITE
48374 【Subciety x RADIO EVA】 DAMEGED RATIO S/S BLACK/BLUE
49814 Subciety (サブサエティ) elements S/S BLACK
49920 Subciety (サブサエティ) TAG S/S BLACK/GREEN
18464 Subciety 15th GLORIOUS S/S - BLACK/WHITE
18448 Subciety GLORIOUS S/S - BLACK/GOLD
23056 Subciety GI S/S BLACK
39621 Subciety LADY S/S BLACK
39616 Subciety Beach S/S BLACK
34687 Subciety (サブサエティ) TAG S/S BLACK
25771 Subciety STANDARD S/S BLACK
45739 Subciety (サブサエティ) Dear president S/S BLACK
45737 Subciety (サブサエティ) BABYLON TEE BLACK
41436 Subciety (サブサエティ) BRAND S/S BLACK
49811 Subciety (サブサエティ) LABEL SS BLACK
49738 Subciety (サブサエティ) BigB S/S BLACK
48289 Subciety (サブサエティ) SUKA SOUVENIR S/S BLACK
50955 Subciety (サブサエティ) EMBROIDERY TEE BLACK/RED
50953 Subciety (サブサエティ) EMBROIDERY TEE BK/WHT
50952 Subciety (サブサエティ) DROP SHOULDER TEE-TAG- BLACK
53027 Subciety RATIO S/S BLACK
53025 Subciety Guadalupe S/S BLACK
53023 Subciety EMOTION S/S BLACK
52798 Subciety EMBROIDERY THE BASE TEE BLACK
53021 Subciety Daisy S/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
18452 Subciety THE BASE S/S - BLACK/WHITE
55834 Subciety liquid S/S BLACK
56423 Subciety (サブサエティ) LABO. S/S - BLACK
57324 Subciety×仮面ライダードライブ DRIVE S/S BLACK
57884 Subciety (サブサエティ) WEEKENDER S/S- BLACK
57913 Subciety (サブサエティ) DRUNKER S/S- BLACK
58464 NARUTO-ナルト- 疾風伝 ×Subciety SASUKE S/S BLACK
59065 Subciety (サブサエティ) cardinal S/S - BLACK
56409 Subciety POCKET TEE-crew- BLACK
57899 Subciety AMBITION S/S - BLACK
60067 Subciety (サブサエティ) CLASSIC S/S BLACK
57893 Subciety (サブサエティ) Robin S/S- BLACK
61243 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive TEE BLACK
63116 Subciety (サブサエティ) PEPPER TEE BLACK
63113 Subciety (サブサエティ) INVOICE TEE BLACK
63110 Subciety (サブサエティ) SCOUT TEE BLACK
63107 Subciety (サブサエティ) NOUGAT TEE BLACK
63206 Subciety (サブサエティ) TAG S/S BLACK/ORANGE
63205 Subciety (サブサエティ) TAG S/S BLACK/PURPLE
63208 Subciety (サブサエティ) CAN TEE BLACK
63203 Subciety (サブサエティ) DOUGH BOY TEE BLACK
63744 Subciety (サブサエティ) BARBER S/S BLACK
63810 Subciety(サブサエティ) FIVE LIGHTS TEE BLACK
64062 Subciety (サブサエティ) HALF SLEEVE SWEAT BLACK
64200 Subciety (サブサエティ) MARIA TEE BLACK
64223 Subciety (サブサエティ) CROWD S/S BLACK/YELLOW
64310 Subciety (サブサエティ) LEAGUE TEE BLACK/YELLOW
64316 Subciety (サブサエティ) SUPPORTER TEE BLACK
65335 Subciety (サブサエティ) LIBIDOS TEE BLACK
60561 Subciety 2022 福袋 -NEW YEAR BAG-
64194 Subciety (サブサエティ) THE BASE S/S BLACK
64224 Subciety (サブサエティ) CROWD S/S BLACK/BLACK
61700 Subciety (サブサエティ) BOOTLEG BRAND S/S BLACK
64201 Subciety (サブサエティ) MARIA TEE BLACK/GOLD
68284 Subciety (サブサエティ) WIDE BORDER TEE BLACK
68113 Subciety (サブサエティ) DRY TEE S/S-BOX MARIA- BLACK
68448 Subciety (サブサエティ) PROVIDENCE TEE BLACK/GOLD
67922 【BanG Dream! ×ゲキクロ 2023 ver.】氷川紗夜×Subciety コラボ Tシャツ
70749 攻殻機動隊 STAND ALONE COMPLEX x Subciety episodes TEE BLACK
70742 攻殻機動隊 STAND ALONE COMPLEX x Subciety SECTION9 TEE BLACK
67447 Subciety (サブサエティ) COFFEE SHOP TEE BLACK
70741 攻殻機動隊 STAND ALONE COMPLEX x Subciety GALLERY TEE BLACK
70752 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident TEE BLACK
64313 Subciety (サブサエティ) Monogram TEE BLACK
67445 Subciety (サブサエティ) FRUITS STAND TEE BLACK
67450 Subciety (サブサエティ) ATLAS TEE BLACK
68115 Subciety (サブサエティ) CREST TEE BLACK
68168 Subciety (サブサエティ) Cereal TEE BLACK
68165 Subciety (サブサエティ)Butterfly TEE BLACK
70733 Subciety (サブサエティ) Pinup TEE BLACK
70731 Subciety (サブサエティ) GARGOYLE TEE BLACK
70729 Subciety (サブサエティ) GRACE TEE BLACK
70726 Subciety (サブサエティ) SKULL FLOWER TEE BLACK
70723 Subciety (サブサエティ) Hard Days TEE BLACK
63341 Subciety (サブサエティ) BLACK PANTHER TEE BLACK