SELECT SQL_CALC_FOUND_ROWS 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-04-25 08:28:07')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 673)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
68786 曙 涼×NOT COMMON SENSE コラボ限定トラックジャケット
68787 曙 涼×NOT COMMON SENSEコラボ限定Tシャツ
68789 曙 涼×NOT COMMON SENSEコラボ限定サコッシュ
69986 紡木吏佐×NOT COMMON SENSE×GEKIROCK CLOTHINGコラボ・パーカー
69994 紡木吏佐×NOT COMMON SENSE×GEKIROCK CLOTHINGコラボ・ロンT
69995 紡木吏佐×NOT COMMON SENSE×GEKIROCK CLOTHINGコラボ・トートバッグ
68336 倉知玲鳳×NOT COMMON SENSE×GEKIROCK CLOTHINGスペシャル・コラボ・ジップアップパーカー
68335 倉知玲鳳×NOT COMMON SENSE×GEKIROCK CLOTHINGスペシャル・コラボ・ロンT
68334 倉知玲鳳×NOT COMMON SENSE×GEKIROCK CLOTHINGスペシャル・コラボ・トートバッグ
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
59957 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA MEZAME NO ANIME GIRL TEE WHITE
59982 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA MEZAME NO ANIME GIRL TEE BLACK
59985 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA 黄緑 繭子 炎上 TEE BLACK
59983 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA 大久保トマト 炎上 TEE BLACK
59984 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA 紫 幸 炎上 TEE BLACK
59986 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA 桜ヶ丘 蒼葉 炎上 TEE BLACK
59956 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE PEPPER BLACK
58160 NOT COMMON SENSE FLAME L/S TEE BLACK
58161 NOT COMMON SENSE FLAME L/S TEE WHITE
58162 NOT COMMON SENSE HARD CORE TEE WHITE
58163 NOT COMMON SENSE HARD CORE TEE BLACK
58164 NOT COMMON SENSE DEAD TUDE TEE BLACK
58165 NOT COMMON SENSE DEAD TUDE TEE WHITE
58166 NOT COMMON SENSE PALM HOODIE
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
56970 NOT COMMON SENSE LIGHTNING HOODED SWEATSHIRT
56971 NOT COMMON SENSE CIRCLELOGO C/N RIPSTOP OZONE WASHINGJACKET BLACK
56972 NOT COMMON SENSE CIRCLELOGO C/N RIPSTOP OZONE WASHINGJACKET OLIVE
56194 NOT COMMON SENSE BRAIN LAYERED L/S TEE BLACK
56195 NOT COMMON SENSE BRAIN LAYERED L/S TEE WHITE
56196 NOT COMMON SENSE BUTTERFLY FLEECE THREE QUARTER SLEEVE BLACK
56197 NOT COMMON SENSE BUTTERFLY FLEECE THREE QUARTER SLEEVE WHITE
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
54044 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 01
54045 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 02
54046 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 03
54050 NOT COMMON SENSE ”Blaze” Tee BLACK
55896 NOT COMMON SENSE BRAIN TEE BLACK
55897 NOT COMMON SENSE BRAIN TEE WHITE
42874 NOT COMMON SENSE LOOK AT TEE WHITE
42875 NOT COMMON SENSE LOOK AT TEE BLACK
42876 NOT COMMON SENSE LOOK AT TEE YELLOW
42877 NOT COMMON SENSE N.C.S.C.N TEE BLACK
42878 NOT COMMON SENSE N.C.S.C.N TEE WHITE
42879 NOT COMMON SENSE N.C.S.C.N TEE PURPLE
42880 NOT COMMON SENSE NCS 1 SACOCHE BEIGE
42881 NOT COMMON SENSE NCS 1 SACOCHE BLACK
42884 NOT COMMON SENSE ReMAKE TEE
42885 NOT COMMON SENSE "NCS"ReMAKE TEE
42886 NOT COMMON SENSE "NCS"ReMAKE TEE 3
42887 NOT COMMON SENSE "NCS"ReMAKE CAP
42888 NOT COMMON SENSE "NCS"ReMAKE CAP
42889 NOT COMMON SENSE "NCS"ReMAKE CAP
43077 NOT COMMON SENSE "SABOTAGE" LAYARD SLEEVE TEE BLACK
43078 NOT COMMON SENSE "SABOTAGE" LAYARD SLEEVE TEE WHITE
43079 NOT COMMON SENSE "SABOTAGE" LAYARD SLEEVE TEE YELLOW
43080 NOT COMMON SENSE "FREEDOM" LAYARD SLEEVE TEE WHITE
43081 NOT COMMON SENSE "DUST REAPER" LAYARD SLEEVE TEE BLACK
43082 NOT COMMON SENSE "DUST REAPER" LAYARD SLEEVE TEE PURPLE
43083 NOT COMMON SENSE "DUST REAPER" LAYARD SLEEVE TEE WHITE
43084 NOT COMMON SENSE Punk Layard Sleeve Tee BLACK
43085 NOT COMMON SENSE "FREEDOM" SEAM HOODIE BLACK
43086 NOT COMMON SENSE "FREEDOM" SEAM HOODIE YELLOW
43087 NOT COMMON SENSE "FLAME" CUT OFF HOODIE BLACK
43088 NOT COMMON SENSE "SYNDICATE" CUT OFF HOODIE PURPLE
43089 NOT COMMON SENSE "PUNK ART" BLOCK CHECK SHIRTS GRAY CK
43090 NOT COMMON SENSE "PUNK ART" BLOCK CHECK SHIRTS RED CK
43091 NOT COMMON SENSE VELCRO DENIM PANTS INDIGO
43092 NOT COMMON SENSE "NCS 2" SACOCHE BLACK
43093 NOT COMMON SENSE "NCS 2" SACOCHE PURPLE
43498 NOT COMMON SENSE FRANKEN HOODIE BLACK
43499 NOT COMMON SENSE FRANKEN 2 L/S TEE WHITE
43500 NOT COMMON SENSE FRANKEN 2 L/S TEE BLACK
43501 NOT COMMON SENSE FRANKEN 2 L/S TEE S/GREEN
44192 NOT COMMON SENSE VELCRO NYLON JKT BLACK / BROWN
44193 NOT COMMON SENSE NCS BOAFURISU BLACK
44194 NOT COMMON SENSE PUNK ART LONG COAT JKT BLACK / BROWN
44195 NOT COMMON SENSE NS NYLON PANTS BLACK / RED
44197 NOT COMMON SENSE SYNDICATE MA-1 JKT BLACK
44198 NOT COMMON SENSE "DOWN NETWORK" CUT OFF HOODIE
44199 NOT COMMON SENSE NCS SPECIAL SEAM HOODIE MULTI
44200 NOT COMMON SENSE "PUNK ART" SEAM HOODIE BLACK
45937 NOT COMMON SENSE 2TONE WASHER ANORAK JKT BLACKxKHAKI
45938 NOT COMMON SENSE 2TONE WASHER ANORAK JKT PURPLExGREEN
45939 NOT COMMON SENSE DOBBY CHECK PANTS D/GREEN CK
45940 NOT COMMON SENSE DOBBY CHECK PANTS PURPLE CK
45941 NOT COMMON SENSE FUXX THE POLICE SEAM HOODIE BLACK
45942 NOT COMMON SENSE FUXX THE POLICE SEAM HOODIE RED
45943 NOT COMMON SENSE FUXX THE POLICE SEAM HOODIE L/GREEN
45944 NOT COMMON SENSE GENESIS SEAM HOODIE BLACK
45945 NOT COMMON SENSE GENESIS SEAM HOODIE RED
45946 NOT COMMON SENSE GENESIS SEAM HOODIE L/GREEN
46185 NOT COMMON SENSE MAD DOG LAYERED L/S TEE WHITE×RED
46186 NOT COMMON SENSE MAD DOG LAYERED L/S TEE BLACK×GREEN
46187 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 3
46188 NOT COMMON SENSE "NCS" Remake SHIRTS GREEN CK×BEIGE CK×RED CK
46189 NOT COMMON SENSE "HARD CORE"L/S TEE WHITE
46190 NOT COMMON SENSE "HARD CORE"L/S TEE BLACK
46210 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 2
46211 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 1
46212 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 4
46213 NOT COMMON SENSE "NCS" Special Seam HOODIE MULTI 5
46329 NOT COMMON SENSE FUXX THE POLICE LAYERED L/S TEE WHITE
46330 NOT COMMON SENSE FUXX THE POLICE LAYERED L/S TEE BLACK
46331 NOT COMMON SENSE GENESIS LAYERED L/S TEE WHITE
46332 NOT COMMON SENSE GENESIS LAYERED L/S TEE BLACK
46333 NOT COMMON SENSE NCS REMAKE LAYERED L/S TEE BLACK
46334 NOT COMMON SENSE "CAPTURE"L/S TEE WHITE
46335 NOT COMMON SENSE "CAPTURE"L/S TEE BLACK
46337 NOT COMMON SENSE "NCS"LAYERED L/S TEE BLACK
46338 NOT COMMON SENSE "NCS"LAYERED L/S TEE WHITE
47101 NOT COMMON SENSE PLAIN WEAVE SHORT PANTS BLACK
47102 NOT COMMON SENSE FUXX THE POLICE SEAM TEE WHITE
47103 NOT COMMON SENSE FUXX THE POLICE SEAM TEE BLACK
47104 NOT COMMON SENSE FUXX THE POLICE SEAM TEE RED
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
47106 NOT COMMON SENSE GENESIS SEAM TEE BLACK
47107 NOT COMMON SENSE ESCAPE BIG TEE BLACK