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 17:08:40')
AND FIND_IN_SET(1, p.color)
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 491)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
28104 PARADOX GRAPHIC BIG TEE HORIZON
28106 PARADOX GRAPHIC BIG TEE GLITCH
28626 PARADOX - GRAPHIC BIG TEE NEWWORLD
28628 PARADOX - GRAPHIC BIG TEE BIRTH
28630 PARADOX - SKINNY PANTS BLACK
28631 PARADOX - BORDER L/S TEE (BLACK)
28632 PARADOX - BORDER L/S TEE (RED)
28945 PARADOX - CACHECOEUR (BLACK)
28946 PARADOX - MINIMAL MA1 (BLK)
29104 PARADOX - GRAPHIC WIDE ZIP PARKA (BANDANNA)
29105 PARADOX - WIDE ZIP PARKA (BLACK)
29857 PARADOX PILE SOCKS (LAZOR)
29858 PARADOX SUPER BIG MA1 (BLACK)
29865 PARADOX MINIMAL BIG TEE BLACK
32415 PARADOX - GRAPHIC BIG PARKA (EXPLOSION)
32417 PARADOX - CLEAR GRAPHIC BLOUSON (TORRID ZONE)
32457 PARADOX - GRAPHIC BLOUSON (EXPLOSION)
32540 PARADOX BIG TEE EXPLOSION
33979 PARADOX - WIDE SWEAT (BLACK)
33980 PARADOX - BIG TEE (DEEP-FOREST)
33982 PARADOX - BIG TEE (MIRAGE)
33983 PARADOX - BIG TEE (ESCHATOLOGY)
33986 PARADOX - LAYERED L/S TEE (BLACK)
33988 PARADOX - LONG SHIRTS (BLACK)
34239 PARADOX - PONCHO BIG TEE (TEAR)
34242 PARADOX - BIG TEE (NYX-HMR)
34243 PARADOX - BIG TEE (UNION)
34405 PARADOX - SMART PHONE CASE(NYX-HMR)
34926 PARADOX GRAPHIC BIG TEE COMMUNITY
34928 PARADOX GRAPHIC BIG TEE RITUAL
36328 PARADOX PX12-BD01 BANDANNA BLACK
36400 PARADOX BIG TEE VENUS
36402 PARADOX BIG TEE LOOPHOLE
36403 PARADOX BIG TEE PROTECTION
36731 PARADOX BIG TEE PRICKLE
36733 PARADOX BIG TEE AKASHIC
36736 PARADOX SUPER BIG TEE CHLORIS
36737 PARADOX SUPER BIG TEE(REVERIE)
36999 PARADOX LONG SHIRTS BLACK
37000 PARADOX LONG SHIRTS TWOTONE
37161 【ゲキクロ限定】 PARADOX SPHERE BIG TEE T-Shirt
37386 PARADOX - V NECK SWEAT (BLACK)
37555 PARADOX GRAPHIC BLOUSON (BONE)
37556 PARADOX GRAPHIC BLOUSON (GEOBOTANICAL)
38553 PARADOX - EMBROIDERY MA-1(BLACK)
38946 PARADOX - MUSULIN TOP(BLACK)
38947 PARADOX - LAYERED LONG TEE (BLACK)
38948 PARADOX × halon - BIG BERET (BLACK-WHT)
38949 PARADOX × halon - BIG BERET (BLACK-BLACK)
38950 PARADOX × halon - BIG BERET (BLACK-GRN
38951 PARADOX - PULL PARKA (BLACK)
38953 PARADOX - HIGH NECK SWEAT (BLACK)
38954 PARADOX - GRAPHIC PARKA(NOISE)
38955 PARADOX - SWITCH PARKA(MORASS)
38992 PARADOX BIG TEE JUDGEMENT
39001 PARADOX-STADIUM JAMPER(BLK×BLK)
39456 PARADOX - BELT PANTS(BLK-SCARLET)
39457 PARADOX - PULLOVER PARKA (BLACK)
39559 PARADOX ORACLE L/S TEE (BLACK)
39823 PARADOX - GRAPHIC BIG TEE (ASTEROID)
39825 PARADOX - GRAPHIC BIG TEE (ONENESS)
39829 PARADOX - GRAPHIC OVER BLOUSON (ELEMENTS)
39830 PARADOX - GRAPHIC OVER BLOUSON (ELEMENTS)
39876 PARADOX - GRAPHIC ZIP PARKA(AZOIC)
39877 PARADOX - GRAPHIC ZIP PARKA(VIAVILITY)
39880 PARADOX GRAPHIC SOCKS BLACK
39891 PARADOX - CAIT SITH BIG SHIRTS
39892 PARADOX - CAIT SITH COACH JACKET
39893 PARADOX - CAIT SITH TOTE BAG
39972 PARADOX - STRING SHOULDER SWEAT (BLACK)
40500 PARADOX ALL GRAPHIC TEE HOLY GROUND
41003 PARADOX PX13-BA002 WAIST POUCH ONENESS
41684 PARADOX ROSE L/S TEE BLK
41686 PARADOX URA L/S TEE (BLACK)
41687 PARADOX PAJAMAS SHIRTS(LEOPARD)
42960 PARADOX LACEUP PANTS
42961 PARADOX FAKE LEATHER SHORTS
42962 PARADOX BOTTOLENECK L/S TEE BLACK
42964 PARADOX - GRAPHIC BIG TEE CAUTION
42965 PARADOX - GRAPHIC BIG TEE HOLE
42966 PARADOX - GRAPHIC BIG TEE BLAZE
42967 PARADOX - GRAPHIC BIG TEE PASHT
42968 PARADOX - GRAPHIC BIG TEE TRACKLINE
43135 PARADOX GRAPHIC BIG TEE U+2642
43136 PARADOX - GRAPHIC BIG TEE STRUCTURE
43140 PARADOX - BUMFLAP PANTS CAUTION
43141 PARADOX - BUMFLAP PANTS BLACK
43170 PARADOX - LONG PARKA BLACK
43172 PARADOX - GRAPHIC BLOUSON MULTIVERSE
43173 PARADOX - GRAPHIC BLOUSON FACTOR
43174 PARADOX - GAUCHO PANTS BLACK
43511 PARADOX PX14-SW01 WIDE SWEAT TWOTONE
43512 PARADOX PX14-SW01 WIDE SWEAT BLK
43513 PARADOX PX14-PK01 ZIP PARKA BLK
43522 PARADOX - SUPER BIG SHIRTS (BLK-CHECK)
43526 PARADOX - ZIP SHIRTS (BLK-CHECK)
43633 PARADOX - JERSEY RIDERS JACKET BLACK
43634 PARADOX - JERSEY RIDERS JACKET JOCK
43742 PARADOX - HOODED MUFFLER BLACK-WHITE
43743 PARADOX - HOODED MUFFLER BLACK-VIOLET
43748 PARADOX PX14-CP01 TROOPER CAP
43749 PARADOX PX14-PT03 JERSEY SLACKS (BLACK)
43750 PARADOX PX14-PT03 JERSEY SLACKS (JOCK)
44201 PARADOX - FUR ZIP PARKA BLACK
44204 PARADOX - SUPER BIG MA-1 BLACK
44206 PARADOX - ANORAK JACKET BLACK
44207 PARADOX - ANORAK JACKET FIELD
44208 PARADOX - MA-1 PANTS BLACK
44209 PARADOX - LONG SHIRTS (BLACK)
45382 PARADOX - WIDE SWEAT BLACK
45384 PARADOX - SWITCH PARKA BLACK-WHITE
45689 PARADOX PX15-HA01 BIG BERET BLK-BLK
45690 PARADOX PX15-HA01 BIG BERET BLK-WHT
45691 PARADOX PX15-HA01 BIG BERET BLK-NEOYELLOW
45876 PARADOX PX15-SH03 HIGHNECK SHIRTS BLACK
45878 PARADOX PX15-PK02 INSIDE OUT PULLPARKA BLACK
45880 PARADOX PX15-TJ01 TRACK JACKET BLACK
45882 PARADOX PX15-PT04 LINE JERSEY PANTS BLACK
46365 PARADOX PX15-SH04 ZIP SHIRTS (BLACK)
46370 PARADOX PX15-SH02 GRAPHIC SHIRTS (STRIPE)