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-26 12:29:15')
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
LIMIT 0, 120
25351 PARADOX SHINTO COAT BLACK
27511 PARADOX GRAPHIC BIG TEE VORTEX
27513 PARADOX - GRAPHIC BIG TEE VISION
27785 【予約商品】PARADOX GRAPHIC BIG TEE BASTARD
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
28630 PARADOX - SKINNY PANTS BLACK
28631 PARADOX - BORDER L/S TEE (BLACK)
28632 PARADOX - BORDER L/S TEE (RED)
28633 PARADOX - BORDER L/S TEE (WHITE)
28945 PARADOX - CACHECOEUR (BLACK)
28946 PARADOX - MINIMAL MA1 (BLK)
29022 PARADOX - GRAPHIC BIG TEE BANDANNA
29102 PARADOX - PILE SOCKS (LAZOR)
29103 PARADOX - GRAPHIC WIDE ZIP PARKA (MAGIC)
29104 PARADOX - GRAPHIC WIDE ZIP PARKA (BANDANNA)
29105 PARADOX - WIDE ZIP PARKA (BLACK)
29857 PARADOX PILE SOCKS (LAZOR)
29858 PARADOX SUPER BIG MA1 (BLACK)
29859 PARADOX SUPER BIG MA1 (KHAKI)
29864 PARADOX MINIMAL BIG TEE WHITE
29865 PARADOX MINIMAL BIG TEE BLACK
32415 PARADOX - GRAPHIC BIG PARKA (EXPLOSION)
32416 PARADOX - GRAPHIC BIG PARKA (NEO-MAGIC)
32417 PARADOX - CLEAR GRAPHIC BLOUSON (TORRID ZONE)
32457 PARADOX - GRAPHIC BLOUSON (EXPLOSION)
32458 PARADOX - GRAPHIC BLOUSON (NEO-MAGIC)
32540 PARADOX BIG TEE EXPLOSION
32541 PARADOX BIG TEE VOID
33978 PARADOX - WIDE SWEAT (WHITE)
33979 PARADOX - WIDE SWEAT (BLACK)
33980 PARADOX - BIG TEE (DEEP-FOREST)
33982 PARADOX - BIG TEE (MIRAGE)
33983 PARADOX - BIG TEE (ESCHATOLOGY)
33985 PARADOX - LAYERED L/S TEE (WHITE)
33986 PARADOX - LAYERED L/S TEE (BLACK)
33987 PARADOX - LONG SHIRTS (TWOTONE)
33988 PARADOX - LONG SHIRTS (BLACK)
33989 PARADOX - BIG STOLE (TORRID ZONE)
34239 PARADOX - PONCHO BIG TEE (TEAR)
34240 PARADOX - BIG TEE (DIVINE)
34241 PARADOX - BIG TEE (SPIRIT)
34242 PARADOX - BIG TEE (NYX-HMR)
34243 PARADOX - BIG TEE (UNION)
34244 PARADOX - N/S ZIP PARKA (BLACK)
34404 PARADOX - SMART PHONE CASE(SPIRIT)
34405 PARADOX - SMART PHONE CASE(NYX-HMR)
34406 PARADOX - SMART PHONE CASE(NEO-MAGIC)
34925 PARADOX GRAPHIC BIG TEE TWO FACE
34926 PARADOX GRAPHIC BIG TEE COMMUNITY
34927 PARADOX GRAPHIC BIG TEE NEO-MAGIC
34928 PARADOX GRAPHIC BIG TEE RITUAL
35552 PARADOX N/S ZIP PARKA BLACK
35553 PARADOX N/S ZIP PARKA BLACK/WHITE
36328 PARADOX PX12-BD01 BANDANNA BLACK
36329 PARADOX PX12-BD01 BANDANNA RED
36400 PARADOX BIG TEE VENUS
36401 PARADOX BIG TEE HEART
36402 PARADOX BIG TEE LOOPHOLE
36403 PARADOX BIG TEE PROTECTION
36731 PARADOX BIG TEE PRICKLE
36732 PARADOX BIG TEE PETAL
36733 PARADOX BIG TEE AKASHIC
36734 PARADOX BIG TEE ATOM
36735 PARADOX BIG TEE MEDAL
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
37162 【ゲキクロ限定】 PARADOX SPHERE Smartphone Case
37163 【ゲキクロ限定】 PARADOX SPHERE Necklace
37386 PARADOX - V NECK SWEAT (BLACK)
37475 PARADOX - V NECK SWEAT (GRAY)
37555 PARADOX GRAPHIC BLOUSON (BONE)
37556 PARADOX GRAPHIC BLOUSON (GEOBOTANICAL)
38552 PARADOX - EMBROIDERY MA-1(KHAKI)
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)
38952 PARADOX - PULL PARKA (RED)
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)
39136 PARADOX - LONG TEE (RED)
39137 PARADOX - LONG TEE (PURPLE)
39456 PARADOX - BELT PANTS(BLK-SCARLET)
39457 PARADOX - PULLOVER PARKA (BLACK)
39458 PARADOX - LONG TEE (SAVAGE)
39459 PARADOX - LONG TEE (FENRIR)
39460 PARADOX - LONG TEE (PLUTO)
39461 PARADOX – SWITCHING PULLOVER BLOUSON WHITE
39462 PARADOX – SWITCHING PULLOVER BLOUSON SCARLET
39558 PARADOX ORACLE L/S TEE (YELLOW)
39559 PARADOX ORACLE L/S TEE (BLACK)
39560 PARADOX - MEDITATION L/S TEE (WHITE)
39561 PARADOX - MEDITATION L/S TEE (YELLOW)
39823 PARADOX - GRAPHIC BIG TEE (ASTEROID)
39824 PARADOX - GRAPHIC BIG TEE (RISE)
39825 PARADOX - GRAPHIC BIG TEE (ONENESS)
39826 PARADOX - GRAPHIC BIG TEE (COMPLEX)
39827 PARADOX - GRAPHIC BIG TEE (ICEBOUND)
39828 PARADOX - GRAPHIC BIG TEE (INFRARED)
39829 PARADOX - GRAPHIC OVER BLOUSON (ELEMENTS)
39830 PARADOX - GRAPHIC OVER BLOUSON (ELEMENTS)
39831 PARADOX - STRING SHOULDER SWEAT (BLACK)
39832 PARADOX - STRING SHOULDER SWEAT (GRAY)