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-24 18:19:58')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 447)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 1800, 120
42214 Zephyren(ゼファレン) SAROUEL SWEAT PANTS BLACK / GRAY
42215 Zephyren(ゼファレン) SAROUEL SWEAT PANTS MAXIM
42239 Zephyren(ゼファレン) LONG STRAP LO CAP -ENGRAVE- NAVY
42254 Zephyren(ゼファレン) BORDER BEANIE -Your Are Here- BLACK/WHITE
42256 Zephyren(ゼファレン) BORDER BEANIE -Your Are Here- BLACK/RED
42540 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 BLACK
42541 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 WHITE
42542 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 RED
42544 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 BLACK TIE DYE
42545 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 BLUE TIE DYE
42546 S/S TEE 京都大作戦2018×Zephyren FLAMES BLACK
42551 S/S TEE 京都大作戦2018×Zephyren FLAMES BLUE TIE DYE
45061 Zephyren(ゼファレン) PARKA -X-RAY SKULL- BIGSKULL[B]
45153 Zephyren(ゼファレン)PONCHO TEE L/S WHITE
45155 Zephyren(ゼファレン)BIG PARKA -PROVE- PURPLE
45156 Zephyren(ゼファレン)SLIPPON SUEDE
45397 Zephyren (ゼファレン) 2019 福袋 -NEW YEAR BAG-
45521 Zephyren(ゼファレン)COACH JACKET / Cut the world BLACK
45522 Zephyren(ゼファレン)COACH JACKET / Cut the world CAMO 1
45523 Zephyren(ゼファレン)COACH JACKET / Cut the world RED
45524 Zephyren(ゼファレン)COACH JACKET /alea iacta est/milestone - BLACK
45525 Zephyren(ゼファレン)COACH JACKET / alea iacta est/milestone - BURGUNDY
45526 Zephyren(ゼファレン)COACH JACKET / alea iacta est/milestone - WHITE
45527 Zephyren(ゼファレン)MOUNTAIN PARKA BLACK
45528 Zephyren(ゼファレン)MOUNTAIN PARKA NAVY
45529 Zephyren(ゼファレン)S/S TEE - BEYOND PAINTED - BLACK
45530 Zephyren(ゼファレン)S/S TEE - BEYOND PAINTED - WHITE
45531 Zephyren(ゼファレン)L/S TEE -BEYOND PAINTED- BLACK
45532 Zephyren(ゼファレン)L/S TEE -BEYOND PAINTED- WHITE
45533 Zephyren(ゼファレン)PARKA - BEYOND PAINTED - BLACK
45534 Zephyren(ゼファレン)PARKA - BEYOND PAINTED - BLACK / TIE DIE
45535 Zephyren(ゼファレン)PARKA -MONOLITH- BLACK
45536 Zephyren(ゼファレン)PARKA -MONOLITH- GRAY
45537 Zephyren(ゼファレン)PARKA -MONOLITH- WHITE
45538 Zephyren(ゼファレン)SWEAT -BEYOND PAINTED- BLACK
45539 Zephyren(ゼファレン)SWEAT -BEYOND PAINTED- WHITE
45541 Zephyren(ゼファレン)SWEAT -MONOLITH- BURGUNDY
45542 Zephyren(ゼファレン)SWEAT -MONOLITH- WHITE
45544 Zephyren(ゼファレン)MESH SHORTS BLACK / Cut the world
45545 Zephyren(ゼファレン)MESH SHORTS BLACK / LEVANTA LOS MANOS
45598 Zephyren(ゼファレン)DENIM JACKET HARD WASH / BANDANNA
45679 Zephyren(ゼファレン) BIG SHIRT L/S -Resolve- NAVY
45681 Zephyren(ゼファレン)SWITCHING TEE L/S BLACK
45682 Zephyren(ゼファレン)SWITCHING TEE L/S WHITE
45684 Zephyren(ゼファレン)CHECK SHIRT L/S -Resolve- GREEN
45685 Zephyren(ゼファレン)CHECK SHIRT L/S -Resolve- RED
45778 Zephyren(ゼファレン)EMBLEM SHIRT L/S BLACK / Cut the world
45783 Zephyren(ゼファレン)EMBLEM SHIRT S/S BLACK / Cut the world
45784 Zephyren(ゼファレン)EMBLEM SHIRT S/S WHITE / Cut the world
45785 Zephyren(ゼファレン)PONCHO TEE L/S BLACK / 如意宝珠
45786 Zephyren(ゼファレン)PONCHO TEE L/S MEXICAN
45788 Zephyren(ゼファレン)PONCHO TEE S/S BLACK / 如意宝珠
45789 Zephyren(ゼファレン)PONCHO TEE S/S MEXICAN
45790 Zephyren(ゼファレン)BANDANA MILITARY JACKET BLACK
45791 Zephyren(ゼファレン)BANDANA MILITARY JACKET CAMO
45794 Zephyren(ゼファレン)MA-1 BLACK
45795 Zephyren(ゼファレン)MA-1 CAMO
45796 Zephyren(ゼファレン)MA-1 MIX
45797 Zephyren(ゼファレン)SKA JUMPER PAISLEY
45798 Zephyren(ゼファレン)SKA JUMPER RED
45799 Zephyren(ゼファレン)BANDANA SHIRT S/S BLACK
45800 Zephyren(ゼファレン)BANDANA SHIRT S/S NAVY
45802 Zephyren(ゼファレン)BANDANA SHIRT S/S RED
45803 Zephyren(ゼファレン)DOLMAN BIG TEE S/S BLACK
45804 Zephyren(ゼファレン)DOLMAN BIG TEE S/S BLUE
45805 Zephyren(ゼファレン)DOLMAN BIG TEE S/S WHITE
45806 Zephyren(ゼファレン)HOCKEY SHIRT L/S BLACK
45807 Zephyren(ゼファレン)HOCKEY SHIRT L/S BLUE
45808 Zephyren(ゼファレン)HOCKEY SHIRT L/S WHITE
45809 Zephyren(ゼファレン)RAINBOW BIG PARKA BLACK
45810 Zephyren(ゼファレン)RAINBOW BIG PARKA WHITE
45811 Zephyren(ゼファレン)MIX BIG SWEAT GREEN / NAVY
45812 Zephyren(ゼファレン)MIX BIG SWEAT NAVY / MUSTARD
45813 Zephyren(ゼファレン)TAPE SWEAT BLACK
45814 Zephyren(ゼファレン)TAPE SWEAT WHITE
45815 Zephyren(ゼファレン)BACK PACK - VISIONARY - BLACK
45884 Zephyren(ゼファレン)LONG SHIRT L/S BLACK / 如意宝珠
45885 Zephyren(ゼファレン)LONG SHIRT L/S WHITE / 如意宝珠
45886 Zephyren(ゼファレン)SAROUEL SWEAT SHORTS BLACK / 如意宝珠
45887 Zephyren(ゼファレン)TAPE SHIRT S/S WHITE
45888 Zephyren(ゼファレン)BANDANA SHIRT L/S BLACK
45889 Zephyren(ゼファレン)BANDANA SHIRT L/S NAVY
45890 Zephyren(ゼファレン)PAISLEY CAMO SHORTS CAMO 1
45891 Zephyren(ゼファレン)BANDANA SHORTS BLACK
45892 Zephyren(ゼファレン)BACK PRINT SAROUEL SHORTS BLACK / alea iacta est
45893 Zephyren(ゼファレン)BACK PRINT SAROUEL SHORTS BLACK / BEYOND
45971 Zephyren(ゼファレン)BANDANA SHIRT L/S RED
45972 Zephyren(ゼファレン)L/S TEE - alea iacta est / milestone - BLACK
45973 Zephyren(ゼファレン)L/S TEE - alea iacta est / milestone - GRAY
45974 Zephyren(ゼファレン)L/S TEE - alea iacta est / milestone - NAVY
45975 Zephyren(ゼファレン)L/S TEE - alea iacta est / milestone - WHITE
45976 Zephyren(ゼファレン)ZIP PARKA -alea iacta est / milestone- BLACK
45977 Zephyren(ゼファレン)ZIP PARKA -alea iacta est / milestone- GRAY
45978 Zephyren(ゼファレン)PARKA -PROVE- BLUE
45980 Zephyren(ゼファレン)PARKA -PROVE- CAMO 2
45981 Zephyren(ゼファレン)PARKA -PROVE- YELLOW
45983 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- BLACK
45985 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- BURGUNDY
45986 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- GRAY
45987 Zephyren(ゼファレン)PARKA -alea iacta est / milestone- YELLOW
46183 Zephyren(ゼファレン)MODS COAT BLACK
46184 Zephyren(ゼファレン)MODS COAT KHAKI
46206 Zephyren(ゼファレン)BIG TEE - Cut The World - BLACK
46208 Zephyren(ゼファレン)BIG TEE - Cut The World - NAVY
46209 Zephyren(ゼファレン)BIG TEE - Cut The World - WHITE
46339 Zephyren(ゼファレン)PONCHO TEE S/S WHITE / 如意宝珠
46340 Zephyren(ゼファレン)TAPE SHIRT S/S BLACK
46343 Zephyren(ゼファレン)S/S TEE - MONOLITH - BLACK
46940 Zephyren(ゼファレン) LONG CHECK SHIRT L/S BLACK
47432 Zephyren (ゼファレン) NYLON STUDIUM JKT -PORTAL- BLACK
47433 Zephyren (ゼファレン) NYLON STUDIUM JKT -PORTAL- BURGUNDY
47494 Zephyren(ゼファレン)EMBLEM SHIRT L/S BLACK / WHITE
47562 Zephyren(ゼファレン)FLIP iPhone CASE - MOON - iPHONE X
47564 Zephyren(ゼファレン)TANKTOP -LEVANTA LOS MANOS- BLACK
47565 Zephyren(ゼファレン)TANKTOP -LEVANTA LOS MANOS- WHITE
47566 Zephyren(ゼファレン)S/S TEE - INGRAIN - BLACK
47567 Zephyren(ゼファレン)S/S TEE - INGRAIN - WHITE
47568 Zephyren(ゼファレン)S/S TEE - GIRL TATTOO - BLACK
47569 Zephyren(ゼファレン)S/S TEE - GIRL TATTOO - BLACK / TIE DIE
47570 Zephyren(ゼファレン)S/S TEE - GIRL TATTOO - WHITE