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-29 03:12:19')
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 300, 100
42390 LILWHITE(dot) (リルホワイトドット) LW-18AW-S03 -TWISTED- FRONT ZIP HOODIE BLACK
42391 LILWHITE(dot) (リルホワイトドット) LW-18AW-S03 -TWISTED- FRONT ZIP HOODIE WHITE
42392 LILWHITE(dot) (リルホワイトドット) LW-18AW-S03 -TWISTED- FRONT ZIP HOODIE RED
42393 LILWHITE(dot) LW-18AU-LT01 -CONFESSION- MOCKNECK L/S TEE BLACK
42394 LILWHITE(dot) LW-18AU-LT01 -CONFESSION- MOCKNECK L/S TEE BORDER
42395 LILWHITE(dot) (リルホワイトドット) LW-18AU-LT02 -REFLECTED- L/S TEE BLACK
42396 LILWHITE(dot) (リルホワイトドット) LW-18AU-LT02 -REFLECTED- L/S TEE WHITE
42397 LILWHITE(dot) (リルホワイトドット) LW-18AU-LT02 -REFLECTED- L/S TEE RED
42398 LILWHITE(dot) (リルホワイトドット) LW-18AU-LT02 -REFLECTED- L/S TEE ORANGE
42399 LILWHITE(dot) (リルホワイトドット) LW-18AU-LT03 -LOVE- L/S TEE BLACK
42400 LILWHITE(dot) (リルホワイトドット) LW-18AU-LT03 -LOVE- L/S TEE WHITE
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
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
42409 LILWHITE(dot) (リルホワイトドット) LW-18AU-T03 -REPLICA- TEE BLACK
42410 LILWHITE(dot) (リルホワイトドット) LW-18AU-T03 -REPLICA- TEE WHITE
42411 LILWHITE(dot) LW-18AU-B01 -STATEMENT- SIDE LINE SWEAT PANTS BLACK
42412 LILWHITE(dot) LW-18AU-B01 -STATEMENT- SIDE LINE SWEAT PANTS RED
42413 LILWHITE(dot) (リルホワイトドット) LW-18AU-B01 -TWISTED- SWEAT PANTS BLACK
42414 LILWHITE(dot) (リルホワイトドット) LW-18AU-B01 -TWISTED- SWEAT PANTS WHITE
42415 LILWHITE(dot) (リルホワイトドット) LW-18AU-B01 -TWISTED- SWEAT PANTS RED
42416 LILWHITE(dot) (リルホワイトドット) LW-18AU-H01 -ANOMALY- BUCKET HAT BLACK
42417 LILWHITE(dot) (リルホワイトドット) LW-18AU-H01 -ANOMALY- BUCKET HAT WHITE
42418 LILWHITE(dot) (リルホワイトドット) LW-18AU-H01 -ANOMALY- BUCKET HAT RED
42419 LILWHITE(dot) (リルホワイトドット) LW-18AW-H02 -STATEMENT- KNIT CAP BLACK
42420 LILWHITE(dot) (リルホワイトドット) LW-18AW-H02 -STATEMENT- KNIT CAP BURGUNDY
42421 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT BLACK
42422 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT WHITE
42423 LILWHITE(dot) (リルホワイトドット) LW-18AU-A01 -ATTRACTED- EXTRA LONG BELT ORANGE
42911 LILWHITE(dot) (リルホワイトドット) LW-4TH-LT01 -NEW HEAVEN- L/S TEE BLACK
42912 LILWHITE(dot) (リルホワイトドット) LW-4TH-LT01 -NEW HEAVEN- L/S TEE ORANGE
42913 LILWHITE(dot) (リルホワイトドット) LW-4TH-T01 -NEW HEAVEN- TEE BLACK
42914 LILWHITE(dot) (リルホワイトドット) LW-4TH-T01 -NEW HEAVEN- TEE WHITE
43774 LILWHITE(dot) LW-19SS-S01 "PLATE LOGO" HOODIE BLACK
43782 LILWHITE(dot) LW-19SS-LT02 "PSY-BOY" L/S TEE BLACK
44944 LILWHITE(dot) (リルホワイトドット) -DROME- COACH JKT BLK[B]
44968 【限定アイテム】BAYCAMP×ゲキクロ×LILWHITE. トリプルコラボTシャツ WHT[B]
45062 LILWHITE(dot) (リルホワイトドット) -PROVE- HOODIE BLK[B]
45717 LILWHITE(dot) LW-19SS-J02 "PLAY" COACH JKT BLACK
45718 LILWHITE(dot) LW-19SS-S01 "PLATE LOGO" HOODIE WHITE
45721 LILWHITE(dot) LW-19SS-S02 "NIGHTHEAD" HOODIE BLACK
45722 LILWHITE(dot) LW-19SS-S02 "NIGHTHEAD" HOODIE WHITE
45723 LILWHITE(dot) LW-19SS-S03 "SWEETDREAMS" HOODIE BLACK
45724 LILWHITE(dot) LW-19SS-S03 "SWEETDREAMS" HOODIE PURPLE
45726 LILWHITE(dot) LW-19SS-B01 "INFERIOR" SWEAT PANTS BLACK
45825 LILWHITE(dot) LW-19SS-J01 "X-RAY" MESH TRACK JKT BLACK
45826 LILWHITE(dot) LW-19SS-J01 "X-RAY" MESH TRACK JKT ORANGE
45894 LILWHITE(dot) LW-19SS-LT01 "PLATE LOGO" MOCKNECK L/S TEE BLACK
45895 LILWHITE(dot) LW-19SS-LT01 "PLETA LOGO" MOCKNECK L/S TEE BORDER
45896 LILWHITE(dot) LW-19SS-LT02 "PSY-BOY" L/S TEE ORANGE
45897 LILWHITE(dot) LW-19SS-B02 "TRANSFORM"BACK-ZIP CARGO PANTS WOOD-CAMO
45898 LILWHITE(dot) LW-19SS-B02 "TRANSFORM"BACK-ZIP CARGO PANTS ORANGE-CAMO
45899 LILWHITE(dot) LW-19SS-B02 "TRANSFORM"BACK-ZIP CARGO PANTS PURPLE-CAMO
46774 LILWHITE(dot) LW-19SS-T01 "PSY-BOY" TEE BLACK
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
46778 LILWHITE(dot) LW-19SS-T03 "TALENT" TEE PURPLE
46779 LILWHITE(dot) LW-19SS-T05 "PLAY"TEE BLACK
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
47437 LILWHITE(dot) LW-19SU-J01 “NOESCAPE" ANORAK PARKA BLACK
47439 LILWHITE(dot) LW-19SU-J01 “NOESCAPE" ANORAK PARKA CAMO
47440 LILWHITE(dot) LW-19SU-J02 “RETRIBUTION” TRACK JKT BLACK
47441 LILWHITE(dot) LW-19SU-S01 “THE END" EMBROIDERY HOODIE BLACK
47442 LILWHITE(dot) LW-19SU-S01 “THE END" EMBROIDERY HOODIE PURPLE
47502 LILWHITE(dot) LW-19SU-LT01 “PLANET” L/S TEE BLACK
47503 LILWHITE(dot) LW-19SU-LT01 “PLANET” L/S TEE WHITE
47504 LILWHITE(dot) LW-19SU-LT01 “PLANET” L/S TEE GOLD
47505 LILWHITE(dot) LW-19SU-LT02 “NOESCAPE” L/S TEE BLACK
47506 LILWHITE(dot) LW-19SU-LT02 “NOESCAPE” L/S TEE WHITE
47507 LILWHITE(dot) LW-19SU-LT03 “PAIN” L/S TEE BLACK
47508 LILWHITE(dot) LW-19SU-LT03 “PAIN” L/S TEE WHITE
47613 LILWHITE(dot) LW-19SU-BT01 “BARBED” EXTRA BIG TEE BLACK
47614 LILWHITE(dot) LW-19SU-BT01 “BARBED” EXTRA BIG 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
47620 LILWHITE(dot) LW-19SU-H01 “THE END” LOW CAP BLACKxMULTI
47621 LILWHITE(dot) LW-19SU-H01 “THE END” LOW CAP BLACKxWHITE
47622 LILWHITE(dot) LW-19SU-H02 “BARBED” LOW CAP BLACK
47623 LILWHITE(dot) LW-19SU-H03 “NOT A PSYCHIC” LOW CAP BLACK
47624 LILWHITE(dot) LW-19SU-H03 “NOT A PSYCHIC” LOW CAP WOOD-CAMO
47625 LILWHITE(dot) LW-19SU-H03 “NOT A PSYCHIC” LOW CAP ORANGE-CAMO
47626 LILWHITE(dot) LW-19SU-H03 “NOT A PSYCHIC” LOW CAP PURPLE-CAMO
48383 LILWHITE(dot) LW-19SU-A01 “CLARITY” CLEAR BAG CLEAR
50044 LILWHITE(dot) LW-19AW-T01 "TM" TEE (WHT)
50107 LILWHITE(dot) LW-19AW-T01 "TM" TEE (BLK)
50108 LILWHITE(dot) LW-19AW-T01 "TM" TEE (LIME)
50109 LILWHITE(dot) LW-19AW-T02 "THEME" TEE (BLK)
50110 LILWHITE(dot) LW-19AW-T02 "THEME" TEE (WHT)
50111 LILWHITE(dot) LW-19AW-T03 "TRASH" TEE (BLK)
50112 LILWHITE(dot) LW-19AW-T03 "TRASH" TEE (WHT)