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-04-28 11:39:46')
AND FIND_IN_SET(3, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
63296 Anti Social Social Club Playboy x ASSC Bunny White Socks
63300 Anti Social Social Club Down The Tube Black/White Socks
63388 Anti Social Social Club Down The Tube Blue/White Socks
63387 Anti Social Social Club Down The Tube Pink/White Socks
63302 Anti Social Social Club Collapse White Socks
60156 Anti Social Social Club WOODY WHITE BUTTON UP
60165 Anti Social Social Club THE REAL ME WHITE TEE
60207 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Battle Tシャツ
60208 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Partners Tシャツ
56215 Anti Social Social Club Headrush Cap
55645 Anti Social Social Club BROKEN ANKLE WHITE SOCKS
57812 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×WHITE
57810 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×BLACK
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
55893 SALUTE FLOWER ANARCHY BRACELET
45120 FOG ESSENTIALS Pullover Hoodie B/CREAM
56768 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts WHITE
45116 FOG ESSENTIALS Boxy Graphic Long Sleeve T-Shirt B/CREAM
54608 FOG ESSENTIALS Essentials Boxy Photo Series T-Shirt White
55801 FOG ESSENTIALS "LA"Limit Tee White
56892 SALUTE DESERT SHIRT
56204 Anti Social Social Club Headrush All Over White Hoodie
56208 Anti Social Social Club Read Receipts White Tee
56210 Anti Social Social Club Enrique White Vneck Tee
56212 Anti Social Social Club Arkansas White Tee
56213 Anti Social Social Club Headrush All Over White Tee
56220 Anti Social Social Club Sadness Is Happiness
56124 N.B.O. FLOWER PRINT T
56125 N.B.O. SPHERE PRINT T
55898 PARADOX HALF SLEEVE T-SHIRTS-FARCE WHITE
55630 Anti Social Social Club BAT EMOJI WHITE HOODIE
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
55642 Anti Social Social Club SOCAL WHITE SOCKS
55528 PARADOX PX17-HST01 HALF SLEEVE T-SHIRTS LOST WEEKEND WHITE
55530 PARADOX PX17-MNT01 MOCK-NECK EMBROIDERY T-SHIRTS NO PROBLEM WHITE
11122 REBEL8 WHITE LOGO SOCKS
11128 REBEL8 RUBBER LOGO KEYCHAIN
12992 REBEL8 STANDARD ISSUE LOGO WHITE TEE
13768 REBEL8 WOMENS WHITE LOGO TEE
14855 REBEL8 WHITE/MAROON LOGO SOCKS
15559 FAR★STAR 六芒星 BIG T WHT
15572 FAR★STAR 百目 BIG WHT
18005 FAR★STAR 六Bone星 BIG T WHT
20261 PARADOX GRAPHIC BIG TEE MAGIC
20482 FAR★STAR 練乳 目苺 BIG T オーバーサイズ
20491 FAR★STAR 六芒星チェーン Dera BIG T WHT
20515 FAR★STAR ツノペンタグラム BIG T WHT
20524 FAR★STAR MAGIC FAR★STARロゴ BIG T WHT
21163 BLACK CRAFT Planchette - White Hooded Pullover
21707 PARADOX - PILE SOCKS BLACK
21708 PARADOX - PILE SOCKS WHITE
21843 PARADOX - GRAPHIC MA1 MAGIC
22070 REBEL8 MASS DISRUPTION WHITE TEE
22077 REBEL8 STRIKE FIRST WHITE TEE
22079 REBEL8 AVI8TOR WHITE TEE
22813 REBEL8 PROWLER SOCKS
22917 REBEL8 PROPERTY OF WHITE TEE
22923 REBEL8 GO FUCK YOURSELF WHITE TEE
22928 REBEL8 RUINERS WHITE TEE
22938 REBEL8 BLOCK COLLAGE WHITE TEE
22940 REBEL8 STANDARD ISSUE WHITE TANK
23266 REBEL8 ACADEMIC PROBATION WHITE TEE
23279 REBEL8 TAP THE ROCKIES GREY SNAPBACK
24167 REBEL8 GOOD CRIMES WHITE TEE
24174 REBEL8 TRAIL BUMS WHITE TEE
24817 REBEL8 REBEL8 X IRONLAK WHITE TEE
25008 REBEL8 PREMIUM BLEND RAGLAN
25025 REBEL8 BASIC S/S TEE WHITE
25028 REBEL8 TRUSTED LEADERS PATCH
25031 REBEL8 DOMINATION PATCH
25043 REBEL8 HOOD WATCH S/S TEE WHITE
25139 REBEL8 FLIP PATCH
25140 REBEL8 MANIA PATCH
25195 REBEL8 CIRCLE 8 PATCH
25340 PARADOX LONG TEE WHITE
25345 PARADOX SOUVENIR PULLOVER PINK
25346 PARADOX PONCHO TEE W-B
25349 PARADOX PONCHO TEE WHITE
27831 DOGTOWN Gonz Art T-SHIRTS WH
28190 REBEL8 NOWHERE FAST WHITE TEE
28191 REBEL8 SILENCE RAGLAN
28193 REBEL8 CONTAMIN8 WHITE TEE
28198 REBEL8 BOMB SQUAD BLACK TEE
28201 REBEL8 CALIFORNIA CENTRAL WHITE TEE
28355 REBEL8 FLIP WHITE SOCKS
28844 FAR★STAR XXX BAT dera BIG T WHITE
28885 REBEL8 DRAFT WHITE TEE
29860 REBEL8 WHITE LOGO SOCKS
29866 REBEL8 WOMENS BEAT IT RAGLAN
29868 REBEL8 WOMENS OWL MOCK NECK
29871 REBEL8 WOMENS DESCANSO ETERNO RAGLAN
29882 REBEL8 CONJURING WHITE TEE
29884 REBEL8 HIT THE WALLS WHITE TEE
29886 REBEL8 HIT THE WALLS GREY CREWNECK
29891 REBEL8 ORNATE BADGE WHITE TEE
29893 REBEL8 DESCANSO ETERNO WHITE TEE
29906 REBEL8 MAKERS AND BREAKERS WHITE TEE
29912 REBEL8 DIE SLOW WHITE TEE
29914 REBEL8 BEAT IT WHITE TEE
29916 REBEL8 TWO FACED WHITE TEE
29917 REBEL8 88 WATTS RAGLAN
32336 REBEL8 PROPER FUCKED WHITE TEE
32342 REBEL8 SLOW DEATH WHITE TEE
32350 REBEL8 HELL BOUND WHITE TEE
32353 REBEL8 CURB RATS ASH GREY TEE
32360 REBEL8 WORLDWIDE DOMINATION WHITE TEE
32367 REBEL8 YOUNG TILL DEATH WHITE TEE
32369 REBEL8 WORLDWIDE DOMINATION RAGRAN
32372 REBEL8 LADY EIGHT WHTE TEE
32377 REBEL8 SKATE CORE WHITE TEE
32384 REBEL8 TOAST TO THE WORST POCKET WHITE TEE
33459 REBEL8 IMMORTALS HOODIE WHITE
33471 REBEL8 PARANOID TEE WHITE
33472 REBEL8 REFLECTIVE 8 TEE WHITE
33476 REBEL8 ANIMOSITY TEE WHITE
33478 REBEL8 BOTTLED VIOLENCE SOFT TEE WHITE
33484 REBEL8 FRUITS OF LABOR POCKET TEE WHITE
33600 REBEL8 PREMIUM SCRIPT TEE WHITE
33604 REBEL8 BULLPEN RAGLAN