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-19 18:37:10')
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
LIMIT 0, 120
2869 THRASHER TH95130 FLAME MAG LOGO 3C HOODIE BLK/YEL
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
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
8926 THRASHER (スラッシャー) TH8501 MAG LOGO HOODIE BK/GRY
10222 THRASHER TIGER STRIPE SNAPBACK CAP
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
10433 THRASHER TH8201 MAG LOGO 3/4 BASE BALL T-SHIRT WH/BK/BK
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
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
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
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
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
18926 THRASHER Marvel SPIDERMAN MAG LOGO T-SHIRTS GRY
18950 THRASHER Marvel SPIDERMAN MAG LOGO NVY
18951 THRASHER Marvel SPIDERMAN MAG LOGO T-SHIRTS WHT
18955 THRASHER TEE TH91160 BLK/WHT
19906 ROLLING CRADLE RC×THRASHER SHORTS / Beige
20038 THRASHER SKATE MAG TIE DYE TEE TH8101RTD BLUE
20039 THRASHER SKATE MAG TIE DYE TEE TH8101RTD BLK
20040 THRASHER SKATE MAG TIE DYE TEE TH8101RTD WHT
20042 THRASHER SKATEGOAT COACH JACKET CAMO
20043 THRASHER SKATE AND DESTROY SATURN BLK
20044 THRASHER SKATE AND DESTROY BLUE OCEAN
20045 THRASHER SKATE AND DESTROY SATURN WHT
20048 THRASHER MAG LOGO TIE-DYE TEE PUP/GRN
20049 THRASHER MAG LOGO TIE-DYE TEE ORG/GRN
20052 THRASHER SKATE AND DESTROY RINGER SHIRT RED
20055 THRASHER THE FLAME LOGO RINGER
20057 THRASHER BOMB SQUAD SNAPBACK CAP
20058 THRASHER FLAME SNAPBACK CAP
20059 THRASHER ROPE SNAPBACK CAP CAMO
20061 THRASHER PATCH BEANIE ORANGE
20197 THRASHER Skategoat CLAMP BELT
20198 THRASHER MAG LOGO BACKPACK
20359 THRASHER GONZ FUCK TEE BLACK
20360 THRASHER GONZ FUCK TEE GRAY
20361 THRASHER BBQ MAG RAGLAN GRY/BLK/BLU
20362 THRASHER BBQ MAG RAGLAN WHT/RED
20363 THRASHER BBQ MAG RAGLAN GRY/RED
20364 THRASHER BBQ MAG RAGLAN WHT/BLU
20365 THRASHER MAG LOGO L/S T-SHIRT BLK/CHA
20366 THRASHER (スラッシャー) TH8301 MAG LOGO L/S T-SHIRT WHT
20367 THRASHER BBQ Mag Logo L/S Tee NVY
20368 THRASHER BBQ Mag Logo L/S Tee BGN
20369 THRASHER BBQ Mag Logo L/S Tee BLK/RED
20370 THRASHER BBQ Mag Logo L/S Tee BLK/BLU
20371 THRASHER COMICS TEE BLACK
20372 THRASHER COMICS TEE WHITE
20373 THRASHER SPLATTER GOAT WHT
20374 THRASHER SPLATTER GOAT BLK
20501 THRASHER SPLATTER GOAT BLK/WHT
21328 THRASHER BUCKET HAT THBHT-002