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 02:15:19')
AND pc.price02 > 4545
AND price02 <= 9090
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 454)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 75
16681 LILWHITE. -REVERSE CROSS- CHAMPION GUM SHORTS
17908 LILWHITE. -WHITELOGO-SNAP BACK BLACK
17912 LILWHITE. PAISLEY BUCKET HAT BLACK
18919 LILWHITE. HDL TANK BLACK
18921 LILWHITE. HDL SHORTS GRAY
21542 LILWHITE. STUDS Tee WHT
21543 LILWHITE. STUDS Tee BLK
21549 LILWHITE. WRATH Tee
21550 LILWHITE. BELIEF Tee WHT
21551 LILWHITE. BELIEF Tee BLK
21735 LILWHITE. 3D LOGO TEE BLACK
21736 LILWHITE. 3D LOGO TEE WHITE
21845 LILWHITE. 3D CAP BLK
21846 LILWHITE. 3D CAP WHT
21847 LILWHITE. HDL CAP BLK
21848 LILWHITE. HDL CAP WHT
23957 LILWHITE. -STAY FRESH-L/S Tee BLK
23958 LILWHITE. -STAY FRESH-L/S Tee WHT
23959 LILWHITE. -REVERSE CROSS-L/S Tee BLK
23960 LILWHITE. -REVERSE CROSS-L/S Tee WHT
23963 LILWHITE. Reincarnation BLK
23964 LILWHITE. Reincarnation WHT
24350 LILWHITE. (リルホワイト) LIL ARCH Tee BLK
24351 LILWHITE. (リルホワイト) LIL ARCH Tee WHT
24352 LILWHITE. CRUEL BLK
24353 LILWHITE. CRUEL WHT
24354 LILWHITE. CURSIVE-Tee WHT
24355 LILWHITE. CURSIVE-Tee BLK
26386 LILWHITE. (リルホワイト) FLORAL Tee WHT
26387 LILWHITE. (リルホワイト) FLORAL Tee BLK
26388 LILWHITE. (リルホワイト) FLORAL Tee GRY
26389 LILWHITE. (リルホワイト) DOT Shorts BLK
26390 LILWHITE. (リルホワイト) DOT Shorts GRY
26393 LILWHITE. (リルホワイト) CROSS MESH Shorts BLK
26394 LILWHITE. (リルホワイト) CROSS MESH Shorts RED
27897 LILWHITE. (リルホワイト) -ELEMENT- Tee WHT
27898 LILWHITE. (リルホワイト) -F/B-Tee BLK
27899 LILWHITE. (リルホワイト) -ARCH- SNAPBACK CAP WHITE
27900 LILWHITE. (リルホワイト) -ARCH- SNAPBACK CAP GRAY
27901 LILWHITE. (リルホワイト) -ARCH- SNAPBACK CAP BLACK
27902 LILWHITE. (リルホワイト) -F/B-Tee WHT
27903 LILWHITE. (リルホワイト) -FRAME-Tee BLK
27904 LILWHITE. (リルホワイト) -FRAME-Tee WHT
27905 LILWHITE. (リルホワイト) -WTML- Pocket Tee BLK
27906 LILWHITE. (リルホワイト) -SYMPATHIZER- SNAPBACK CAP BLACK
27907 LILWHITE. (リルホワイト) -WTML- Pocket Tee WHT
27908 LILWHITE. (リルホワイト) -SYMPATHIZER- SNAPBACK CAP WHITE
27909 LILWHITE. (リルホワイト) -SYMPATHIZER- SNAPBACK CAP GRAY
27914 LILWHITE. (リルホワイト) -ARCH- JET CAP CAMO
27916 LILWHITE. (リルホワイト) -ARCH- JET CAP BLACK
27919 LILWHITE. (リルホワイト) -SYMPATHIZER- JET CAP BLACK
27920 LILWHITE. (リルホワイト) -SYMPATHIZER- JET CAP CAMO
27924 LILWHITE. (リルホワイト) -ARCH- LOW CAP BLACK
27926 LILWHITE. (リルホワイト) -ARCH- LOW CAP BLUE
27927 LILWHITE. (リルホワイト) -ARCH- LOW CAP WHITE
27933 LILWHITE. (リルホワイト) -DAMAGE-L/S Tee BLK
27934 LILWHITE. (リルホワイト) -DAMAGE-L/S Tee WHT
27935 LILWHITE. (リルホワイト) -F/B- L/S Tee WHITE
27936 LILWHITE. (リルホワイト) -F/B- L/S Tee BLACK
28370 ALL OFF×LILWHITE. UNITE Hoodie
28891 LILWHITE. (リルホワイト) 2nd ANIV TEE - BLACK
28892 LILWHITE. (リルホワイト) 2nd ANIV TEE - WHITE
28992 LILWHITE. (リルホワイト) 2nd ANIV L./S TEE - WHITE
28993 LILWHITE. (リルホワイト) 2nd ANIV L/S TEE - BLACK
31864 LILWHITE(dot) (リルホワイトドット) -RISE- LS Tee WHITE
31865 LILWHITE(dot) (リルホワイトドット) -RISE- LS Tee BLACK
31868 LILWHITE(dot) (リルホワイトドット) -FUTURE- LS Tee WHITE
31869 LILWHITE(dot) (リルホワイトドット) -FUTURE- LS Tee BLACK
31871 LILWHITE(dot) (リルホワイトドット) -FLAG- LS Tee ORANGE
31872 LILWHITE(dot) (リルホワイトドット) -FLAG- LS Tee WHITE
31873 LILWHITE(dot) (リルホワイトドット) -FLAG- LS Tee BLACK
31875 LILWHITE(dot) (リルホワイトドット) -REWRITE- Tee BLACK
31876 LILWHITE(dot) (リルホワイトドット) -REWRITE- Tee WHITE
31878 LILWHITE(dot) (リルホワイトドット) -NAMED- BORDER TANK TOP GRAY
31879 LILWHITE(dot) (リルホワイトドット) -NAMED- BORDER TANK TOP BLACK