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 07:01:57')
AND pc.classcategory_id1 IN( 12,44)
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 MAX(price02)
LIMIT 0, 120
42913 LILWHITE(dot) (リルホワイトドット) LW-4TH-T01 -NEW HEAVEN- TEE BLACK
47508 LILWHITE(dot) LW-19SU-LT03 “PAIN” L/S TEE WHITE
46778 LILWHITE(dot) LW-19SS-T03 "TALENT" TEE PURPLE
46779 LILWHITE(dot) LW-19SS-T05 "PLAY"TEE BLACK
50108 LILWHITE(dot) LW-19AW-T01 "TM" TEE (LIME)
50111 LILWHITE(dot) LW-19AW-T03 "TRASH" TEE (BLK)
28369 ALL OFF×LILWHITE. UNITE T-shirt Black
28549 【限定アイテム】BAYCAMP×ゲキクロ×LILWHITE. トリプルコラボTシャツ WHT
28550 【限定アイテム】BAYCAMP×ゲキクロ×LILWHITE. トリプルコラボTシャツ BLK
28368 ALL OFF×LILWHITE. UNITE T-shirt White
29560 【限定アイテム】KITAZAWA TYPHOON×ゲキクロ×LILWHITE. トリプルコラボTシャツ BLK
29561 【限定アイテム】KITAZAWA TYPHOON×ゲキクロ×LILWHITE. トリプルコラボTシャツ WHT
27921 LILWHITE. (リルホワイト) -ELEMENT-VARSTY JKT
42385 LILWHITE(dot) (リルホワイトドット) LW-18AW-S01 -STATEMENT- HOODIE BLACK
21542 LILWHITE. STUDS Tee WHT
21543 LILWHITE. STUDS Tee BLK
21550 LILWHITE. BELIEF Tee WHT
21551 LILWHITE. BELIEF Tee BLK
21735 LILWHITE. 3D LOGO TEE BLACK
21736 LILWHITE. 3D LOGO TEE WHITE
23963 LILWHITE. Reincarnation BLK
23964 LILWHITE. Reincarnation WHT
24350 LILWHITE. (リルホワイト) LIL ARCH Tee BLK
24351 LILWHITE. (リルホワイト) LIL ARCH Tee WHT
24354 LILWHITE. CURSIVE-Tee WHT
24355 LILWHITE. CURSIVE-Tee BLK
27897 LILWHITE. (リルホワイト) -ELEMENT- Tee WHT
27898 LILWHITE. (リルホワイト) -F/B-Tee BLK
27902 LILWHITE. (リルホワイト) -F/B-Tee WHT
27903 LILWHITE. (リルホワイト) -FRAME-Tee BLK
27904 LILWHITE. (リルホワイト) -FRAME-Tee WHT
27905 LILWHITE. (リルホワイト) -WTML- Pocket Tee BLK
27907 LILWHITE. (リルホワイト) -WTML- Pocket Tee WHT
28891 LILWHITE. (リルホワイト) 2nd ANIV TEE - BLACK
28892 LILWHITE. (リルホワイト) 2nd ANIV TEE - WHITE
31875 LILWHITE(dot) (リルホワイトドット) -REWRITE- Tee BLACK
31876 LILWHITE(dot) (リルホワイトドット) -REWRITE- Tee WHITE
18919 LILWHITE. HDL TANK BLACK
42401 LILWHITE(dot) (リルホワイトドット) LW-18AU-T01 -STATEMENT- TEE BLACK
42403 LILWHITE(dot) (リルホワイトドット) LW-18AU-T01 -STATEMENT- TEE RED
42404 LILWHITE(dot) (リルホワイトドット) LW-18AU-T01 -STATEMENT- TEE ORANGE
52926 LILWHITE(dot) LW-20SS-SW02 "LOSER" DAMAGED HOODIE (GRN)
26386 LILWHITE. (リルホワイト) FLORAL Tee WHT
26387 LILWHITE. (リルホワイト) FLORAL Tee BLK
26388 LILWHITE. (リルホワイト) FLORAL Tee GRY
24352 LILWHITE. CRUEL BLK
24353 LILWHITE. CRUEL WHT
36330 LILWHITE(dot) -DEVITION- TEE BLACK
36331 LILWHITE(dot) -DEVITION- TEE WHITE
36332 LILWHITE(dot) -RUSTYNAIL- TEE BLACK
36333 LILWHITE(dot) -RUSTYNAIL- TEE WHITE
41955 LILWHITE. (リルホワイト) LW-18SU-T03 -VR- TEE BLACK
41956 LILWHITE. (リルホワイト) LW-18SU-T03 -VR- TEE WHITE
41957 LILWHITE. (リルホワイト) LW-18SU-T04 -APP- TEE BLACK
41958 LILWHITE. (リルホワイト) LW-18SU-T04 -APP- TEE ORANGE
53120 LILWHITE(dot) LW-20SS-T01 ANGERL TEE BLK
53121 LILWHITE(dot) LW-20SS-T01 ANGERL TEE WHT
38898 LILWHITE(dot) (リルホワイトドット) -DILEMMA- TEE BLK
38899 LILWHITE(dot) (リルホワイトドット) -DILEMMA- TEE WHT
38902 LILWHITE(dot) (リルホワイトドット) -NEW CHAPTER- TEE BLK
38903 LILWHITE(dot) (リルホワイトドット) -NEW CHAPTER- TEE YEL
41593 LILWHITE(dot) (リルホワイトドット) LW-18SU-T01 -DIVIDED- TEE BLK
41594 LILWHITE(dot) (リルホワイトドット) LW-18SU-T01 -DIVIDED- TEE WHT
42409 LILWHITE(dot) (リルホワイトドット) LW-18AU-T03 -REPLICA- TEE BLACK
42410 LILWHITE(dot) (リルホワイトドット) LW-18AU-T03 -REPLICA- TEE WHITE
42914 LILWHITE(dot) (リルホワイトドット) LW-4TH-T01 -NEW HEAVEN- TEE WHITE
46775 LILWHITE(dot) LW-19SS-T02 "NIGHTHEAD" TEE BLACK
46776 LILWHITE(dot) LW-19SS-T02 "NIGHTHEAD" TEE GOLD
46777 LILWHITE(dot) LW-19SS-T03 "TALENT" TEE WHITE
46780 LILWHITE(dot) LW-19SS-T05 "PLAY"TEE WHITE
46781 LILWHITE(dot) LW-19SS-T06 "WORLD"TEE BLACK
46782 LILWHITE(dot) LW-19SS-T06 "WORLD"TEE WHITE
47615 LILWHITE(dot) LW-19SU-T01 “PLANET” TEE BLACK
47616 LILWHITE(dot) LW-19SU-T01 “PLANET” TEE WHITE
47617 LILWHITE(dot) LW-19SU-T01 “PLANET” TEE GOLD
47618 LILWHITE(dot) LW-19SU-T04 “THE END” EMBROIDERY TEE BLACK
47619 LILWHITE(dot) LW-19SU-T04 “THE END” EMBROIDERY TEE WHITE
50044 LILWHITE(dot) LW-19AW-T01 "TM" TEE (WHT)
50107 LILWHITE(dot) LW-19AW-T01 "TM" TEE (BLK)
50109 LILWHITE(dot) LW-19AW-T02 "THEME" TEE (BLK)
50110 LILWHITE(dot) LW-19AW-T02 "THEME" TEE (WHT)
50112 LILWHITE(dot) LW-19AW-T03 "TRASH" TEE (WHT)
28370 ALL OFF×LILWHITE. UNITE Hoodie
33075 ALL OFF×LILWHITE(dot) SEEKER ZIP HOODIE
21549 LILWHITE. WRATH Tee
26389 LILWHITE. (リルホワイト) DOT Shorts BLK
26390 LILWHITE. (リルホワイト) DOT Shorts GRY
38866 LILWHITE(dot) (リルホワイトドット) -ANGULAR- L/S TEE BLK
38867 LILWHITE(dot) (リルホワイトドット) -ANGULAR- L/S TEE WHT
38868 LILWHITE(dot) (リルホワイトドット) -ANGULAR- L/S TEE RED
38869 LILWHITE(dot) (リルホワイトドット) -ANGULAR- L/S TEE ORG
42405 LILWHITE(dot) (リルホワイトドット) LW-18AU-T02 -TWISTED- TEE BLACK
42406 LILWHITE(dot) (リルホワイトドット) LW-18AU-T02 -TWISTED- TEE WHITE
42407 LILWHITE(dot) (リルホワイトドット) LW-18AU-T02 -TWISTED- TEE RED
42408 LILWHITE(dot) (リルホワイトドット) LW-18AU-T02 -TWISTED- TEE ORANGE
46774 LILWHITE(dot) LW-19SS-T01 "PSY-BOY" TEE BLACK
47442 LILWHITE(dot) LW-19SU-S01 “THE END" EMBROIDERY HOODIE PURPLE
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
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
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
31885 LILWHITE(dot) (リルホワイトドット) -NAMED- BORDER BIG Tee GREY
31886 LILWHITE(dot) (リルホワイトドット) -NAMED- BORDER BIG Tee BLACK
31893 LILWHITE(dot) (リルホワイトドット) -INFERIOR- BIG Tee BLACK
31894 LILWHITE(dot) (リルホワイトドット) -INFERIOR- BIG Tee WHITE
31895 LILWHITE(dot) (リルホワイトドット) -INFERIOR- BIG Tee DARK PINK
31896 LILWHITE(dot) (リルホワイトドット) -INFERIOR- BIG Tee LIGHT BROWN