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 14:16:27')
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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 MAX(price02) DESC
LIMIT 0, 120
45384 PARADOX - SWITCH PARKA BLACK-WHITE
37386 PARADOX - V NECK SWEAT (BLACK)
29858 PARADOX SUPER BIG MA1 (BLACK)
29859 PARADOX SUPER BIG MA1 (KHAKI)
40500 PARADOX ALL GRAPHIC TEE HOLY GROUND
47380 PARADOX PX15-CS04 LONG T-SHIRTS(ORANGE)
47381 PARADOX PX15-CS04 LONG T-SHIRTS(GRAY)
53889 PARADOX PX17-SP-PK01 HALF ZIP PARKA 「Never tear us apart」 BLACK
53890 PARADOX PX17-SP-PK01 HALF ZIP PARKA 「Never tear us apart」 VIOLE
53891 PARADOX PX17-SP-PK01 HALF ZIP PARKA 「Never tear us apart」 WHITE
53892 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 BLACK
53893 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 VIOLET
53894 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 GRAY
50032 PARADOX PX16-LS04 BORDER L/S TEE(BLACK)
50033 PARADOX PX16-LS04 BORDER L/S TEE(RED)
50030 PARADOX PX16-LS03 GRAPHIC L/S TEE(BLACK)
50031 PARADOX PX16-LS03 GRAPHIC L/S TEE(WHITE)
39137 PARADOX - LONG TEE (PURPLE)
47374 PARADOX PX15-A-LS01 SWITCH L/S TEE (BLACK-WHITE)
47375 PARADOX PX15-A-LS01 SWITCH L/S TEE (ANTIMATTER-BLK)
47377 PARADOX PX15-A-LS01 SWITCH L/S TEE (WHITE-BLACK)
47379 PARADOX PX15-A-LS01 SWITCH L/S TEE (HEXAGRAM-WHT)
43139 PARADOX - STARTER GRAPHIC BIG TEE VIOLET
43742 PARADOX - HOODED MUFFLER BLACK-WHITE
43743 PARADOX - HOODED MUFFLER BLACK-VIOLET
53895 PARADOX PX17-LS01 FAKE LAYERED L/S TEE [metaphor] WHITE
53896 PARADOX PX17-LS01 FAKE LAYERED L/S TEE [metaphor] WHITE
53897 PARADOX PX17-LS02 FAKE LAYERED L/S TEE [NOBLE DISEASE] BLACK
53898 PARADOX PX17-LS02 FAKE LAYERED L/S TEE [NOBLE DISEASE] WHITE
53899 PARADOX PX17-LS02 FAKE LAYERED L/S TEE [NOBLE DISEASE] VIOLET
54595 PARADOX PX17-CS03 BIG WIDE TEE WHITE
28945 PARADOX - CACHECOEUR (BLACK)
28946 PARADOX - MINIMAL MA1 (BLK)
38951 PARADOX - PULL PARKA (BLACK)
38952 PARADOX - PULL PARKA (RED)
29103 PARADOX - GRAPHIC WIDE ZIP PARKA (MAGIC)
29104 PARADOX - GRAPHIC WIDE ZIP PARKA (BANDANNA)
32415 PARADOX - GRAPHIC BIG PARKA (EXPLOSION)
32416 PARADOX - GRAPHIC BIG PARKA (NEO-MAGIC)
37475 PARADOX - V NECK SWEAT (GRAY)
38953 PARADOX - HIGH NECK SWEAT (BLACK)
38954 PARADOX - GRAPHIC PARKA(NOISE)
38955 PARADOX - SWITCH PARKA(MORASS)
39558 PARADOX ORACLE L/S TEE (YELLOW)
45382 PARADOX - WIDE SWEAT BLACK
27785 【予約商品】PARADOX GRAPHIC BIG TEE BASTARD
33978 PARADOX - WIDE SWEAT (WHITE)
33979 PARADOX - WIDE SWEAT (BLACK)
36736 PARADOX SUPER BIG TEE CHLORIS
36737 PARADOX SUPER BIG TEE(REVERIE)
47478 PARADOX×EVERLAST PX15-EL-BT01 GRAPHIC BIG TEE
48206 PARADOX×kureino - GRAPHIC BIG TEE(BLACK)
29105 PARADOX - WIDE ZIP PARKA (BLACK)
34244 PARADOX - N/S ZIP PARKA (BLACK)
35552 PARADOX N/S ZIP PARKA BLACK
35553 PARADOX N/S ZIP PARKA BLACK/WHITE
39892 PARADOX - CAIT SITH COACH JACKET
40455 PARADOX - SUPER LONG L/S TEE (BLACK)
40456 【予約商品】 PARADOX - N/S ZIP PARKA(BLACK)
40498 PARADOX ALL GRAPHIC TEE HALO
40499 PARADOX ALL GRAPHIC TEE SAMSARA
47382 PARADOX PX15-CS04 LONG T-SHIRTS(BLACK)
33989 PARADOX - BIG STOLE (TORRID ZONE)
38947 PARADOX - LAYERED LONG TEE (BLACK)
39891 PARADOX - CAIT SITH BIG SHIRTS
47383 PARADOX PX15-CS05 ZIP T-SHIRTS(BLACK)
47384 PARADOX PX15-CS05 ZIP T-SHIRTS(GRAY)
46930 PARADOX - SEE-THROUGH BIG T (EBM)
33985 PARADOX - LAYERED L/S TEE (WHITE)
33986 PARADOX - LAYERED L/S TEE (BLACK)
34239 PARADOX - PONCHO BIG TEE (TEAR)
39136 PARADOX - LONG TEE (RED)
40823 PARADOX - PONCHO TEE (BLACK)
40825 PARADOX - PONCHO TEE (TWOTONE)
41004 PARADOX PX13-CS002 SWITCHING RELAX TEE BLACK
41005 PARADOX PX13-CS002 SWITCHING RELAX TEE WHITE
47376 PARADOX PX15-A-LS01 SWITCH L/S TEE (HEXAGRAM-BLK)
47378 PARADOX PX15-A-LS01 SWITCH L/S TEE (ANTIMATTER-WHT)
41684 PARADOX ROSE L/S TEE BLK
41685 PARADOX ROSE L/S TEE WHT
42962 PARADOX BOTTOLENECK L/S TEE BLACK
42963 PARADOX BOTTOLENECK L/S TEE VIOLET
43748 PARADOX PX14-CP01 TROOPER CAP
47479 PARADOX×EVERLAST PX15-EL-CS01 LACEUP DOLMAN TEE(ORANGE)
47480 PARADOX×EVERLAST PX15-EL-CS01 LACEUP DOLMAN TEE(BLACK)
47481 PARADOX×EVERLAST PX15-EL-CS01 LACEUP DOLMAN TEE(WHITE)
28631 PARADOX - BORDER L/S TEE (BLACK)
28632 PARADOX - BORDER L/S TEE (RED)
28633 PARADOX - BORDER L/S TEE (WHITE)
39559 PARADOX ORACLE L/S TEE (BLACK)
39560 PARADOX - MEDITATION L/S TEE (WHITE)
39561 PARADOX - MEDITATION L/S TEE (YELLOW)
41002 PARADOX PX13-BA002 WAIST POUCH BLACK
41003 PARADOX PX13-BA002 WAIST POUCH ONENESS
42968 PARADOX - GRAPHIC BIG TEE TRACKLINE
42969 PARADOX - GRAPHIC BIG TEE SNIPING
48324 PARADOX PX15-AL-BT01 GRAPHIC BIG TEE H.R.G
27511 PARADOX GRAPHIC BIG TEE VORTEX
27513 PARADOX - GRAPHIC BIG TEE VISION
28100 PARADOX GRAPHIC BIG TEE HIDEOUT
28101 PARADOX GRAPHIC BIG TEE MAD
28103 PARADOX GRAPHIC BIG TEE STELLA
28104 PARADOX GRAPHIC BIG TEE HORIZON
28105 PARADOX GRAPHIC BIG TEE PUNK
28106 PARADOX GRAPHIC BIG TEE GLITCH
28107 PARADOX GRAPHIC BIG TEE ARTEMIS
28626 PARADOX - GRAPHIC BIG TEE NEWWORLD
28628 PARADOX - GRAPHIC BIG TEE BIRTH
29022 PARADOX - GRAPHIC BIG TEE BANDANNA
32540 PARADOX BIG TEE EXPLOSION
32541 PARADOX BIG TEE VOID
33980 PARADOX - BIG TEE (DEEP-FOREST)
33982 PARADOX - BIG TEE (MIRAGE)
33983 PARADOX - BIG TEE (ESCHATOLOGY)
34240 PARADOX - BIG TEE (DIVINE)
34241 PARADOX - BIG TEE (SPIRIT)
34242 PARADOX - BIG TEE (NYX-HMR)
34243 PARADOX - BIG TEE (UNION)
34925 PARADOX GRAPHIC BIG TEE TWO FACE
34926 PARADOX GRAPHIC BIG TEE COMMUNITY