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-30 21:44:05')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 65)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 100, 100
57417 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT WHITE
57418 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT GRAY
57419 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT RED
57420 THRASHER (スラッシャー) TH8401PL MAG LOGO SWEAT NAVY
57421 THRASHER (スラッシャー) TH8428PLGONZ SWEAT BLACK
57422 THRASHER (スラッシャー) TH8428PLGONZ SWEAT WHITE
57423 THRASHER (スラッシャー) TH8428PLGONZ SWEAT GRAY
57424 THRASHER (スラッシャー) TH8328 GONZ L/S T-SHIRT BLACK
57425 THRASHER (スラッシャー) TH8328 GONZ L/S T-SHIRT WHITE
57426 THRASHER (スラッシャー) TH8201 MAG LOGO 3/4 BASE BALL T-SHIRT GR/BK/BK
57427 THRASHER (スラッシャー) TH8228 GONZ 3/4 BASE BALL T-SHIRT WH/BK/BK
57429 THRASHER (スラッシャー) TH93130 FLAME LOGO L/S T-SHIRT WHITE
57430 THRASHER (スラッシャー) TH8928C GONZ COACH JKT BLACK
57431 THRASHER (スラッシャー) TH8928C GONZ COACH JKT RED
57432 THRASHER (スラッシャー) TH8928C GONZ COACH JKT NAVY
55649 THRASHER TH5179 S/S WORK SHIRT BLACK
55647 THRASHER TH5178 SKATE AND DESTROY S/S Shirt BLACK
55650 THRASHER TH8101 Mag LogoTee PURPLE/YELLOW
54433 THRASHER OUTLINED CRACK S/S T-SHIRTS BLACK
54431 THRASHER GONZ PRINT S/S T-SHIRTS
35268 THRASHER TH8881 BLACK×WHITE
36868 THRASHER (スラッシャー) TH8101 MAG LOGO TEE PURPLE
55648 THRASHER (スラッシャー) TH5179 S/S WORK SHIRT WHITE
55651 THRASHER (スラッシャー) TH8101 Mag LogoTee NAVY/SEA GREEN
55652 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS WHITE/YELLOW
55653 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS BLACK/YELLOW
2869 THRASHER TH95130 FLAME MAG LOGO 3C HOODIE BLK/YEL
4573 THRASHER WAIST BAG SKATE ROCK BLACK
6755 THRASHER WAIST BAG PINK ANIMAL-Velours-
6762 THRASHER DAY-BACKPACK SKATE ROCK BLACK
6848 THRASHER DRUM BAG BLACK
10222 THRASHER TIGER STRIPE SNAPBACK CAP
10498 THRASHER LOGO BEANIE 13TH-N62 BLK/WHT
10499 THRASHER LOGO BEANIE 13TH-N62 PINK
10501 THRASHER LOGO BEANIE 13TH-N62 GLD
10502 THRASHER LOGO BEANIE 13TH-N62 MLT
10509 THRASHER LOGO Patch BEANIE OLV
10630 THRASHER TH8201 MAG LOGO 3/4 BASE BALL T-SHIRT GR/BK/BK
11693 THRASHER x GHOSTBUSTERS MARSHMALLOW MAN TSHIRTS BK
12146 THRASHER MAG LOGO WORK SHIRTS BLACK
12396 Subciety THRASHER SHIRT S/S -Baphomet-BLACK
12401 Subciety THRASHER SHIRT S/S -Baphomet-STRIPE
12571 THRASHER SILVER FLAME LOGO PULLOVER HOODIE GRAY
12574 THRASHER Jay Adamus PULLOVER HOODIE PINK
12800 THRASHER BADGE BLK/RED/BL
12806 THRASHER BIG BADGE FLAME BLACK/YELLOW
12808 THRASHER BIG BADGE LOGO BLACK/WHITE
13135 THRASHER BACKPACK PINK ANIMAL
13138 THRASHER WAIST BAG SKATE ROCK BROWN
13140 THRASHER WAIST BAG SKATE ROCK PURPLE
13143 THRASHER BACKPACK SKATE ROCK PURPLE
13263 THRASHER INFERNO Tee
13264 THRASHER RADIO TEE
13265 THRASHER JAY ADAMS
13828 THRASHER SK8 GOAT T-SHIRTS WT
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
14287 ROLLING CRADLE BiG CYCLOPS-SB HOODIE / Gray
14617 THRASHER BTD HOODIE BLACK
14618 THRASHER BTD HOODIE GRAY
14681 THRASHER x KEITH HARING TEE BLACK
14690 THRASHER x KEITH HARING HOODIEBLACK
14800 THRASHER Mag LogoTee FO/WH
14804 THRASHER PATCH BEANIEBLACK
14805 THRASHER PATCH BEANI WHITE
14806 THRASHER PATCH BEANIE GREEN
14811 THRASHER SKATE AND DESTROY JACKET BLACK
14898 THRASHER OG Diamond LOGO TEE
14971 THRASHER Felt Mag Logo Tee GRY
14973 THRASHER Felt Mag Logo Tee BUR
14974 THRASHER Felt Mag Logo Tee BLK
14975 THRASHER Felt Mag Logo Tee WHT
15881 THRASHER x GHOSTBUSTERS GHOST SNAPBACK BLK/GRY
15882 THRASHER x GHOSTBUSTERS GHOST SNAPBACK BLK/AQA
15883 THRASHER x GHOSTBUSTERS LOGO SNAPBACK BLK/BLK
15884 THRASHER x GHOSTBUSTERS LOGO SNAPBACK BLK/GRY
15885 THRASHER x GHOSTBUSTERS LOGO SNAPBACK NAVY
16737 THRASHER HOOPER WHITE BIG LOGO
16739 THRASHER DECKER BLACK/WHITE CHECKER
17813 THRASHER MARVEL CAPTAIN AMERICA TEE WHITE
17826 THRASHER MINI MESSENGER BAG RED
17827 THRASHER MINI MESSENGER BAG GRAY
17828 THRASHER MINI MESSENGER BAG EMERALD
17854 THRASHER WOOL CAP WIN
17855 THRASHER WOOL CAP NVY
17856 THRASHER WOOL CAP BLK
18154 THRASHER LOGO BACKPACK THRPC 500 EMERALD
18155 THRASHER LOGO BACKPACK THRPC 500 GRY
18275 THRASHER ROLL BOSTON BAG 601 CAMO
18277 THRASHER ROLL BOSTON BAG 601 RED
18280 THRASHER ROLL BOSTON BAG 601 BLUE
18283 THRASHER MAG LOGO IN FLAME BLUE/RANGE
18284 THRASHER MAG LOGO IN FLAME RED/YELLOW
18287 THRASHER MAG LOGO CHARCOAL
18898 THRASHER GALAXY SNAP BACK GRN
18901 THRASHER BACKET HAT NVY
18909 THRASHER THRPN 503 BLACK
18913 THRASHER THRPC 200 BLACK
18915 THRASHER THRPC 200 RED
18923 THRASHER Marvel SPIDERMAN MAG LOGO BLK
18925 THRASHER Marvel SPIDERMAN MAG LOGO T-SHIRTS BLK