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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-18 20:11:42')
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 0, 120
69236 THRASHER (スラッシャー) Inferno S/S T-Shirt BLACK
58321 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT WHITE
58323 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT PINK
58324 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT YELLOW
58322 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BLACK
68805 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT BURGUNDY/WHITE
54043 THRASHER (スラッシャー) FLAME LOGO S/S TEE WHITE
54042 THRASHER (スラッシャー) FLAME LOGO S/S TEE BLACK
68804 THRASHER TH91130 FLAME MAG LOGO TEE BURGUNDY
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
28396 THRASHER (スラッシャー) TH8101 MAG LOGO TEE NAV/WHT
28395 THRASHER (スラッシャー) TH8101 MAG LOGO TEE BURGUNDY
4449 THRASHER (スラッシャー) TH8101 Mag LogoTee BK/WH
68546 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS WHITE
68545 THRASHER (スラッシャー) Gonz Thumbs Up S/S T-SHIRTS BLACK
68544 THRASHER (スラッシャー) Devils Music S/S T-SHIRTS WHITE
68543 THRASHER (スラッシャー) Devils Music S/S T-SHIRTS BLACK
64911 THRASHER (スラッシャー)×TURTLES T-shirt WHITE
64912 THRASHER (スラッシャー)×TURTLES T-shirt BLUE
63177 THRASHER (スラッシャー) Godzilla Flame T-shirt Black
64913 THRASHER (スラッシャー)×TURTLES T-shirt BLACK
63178 THRASHER (スラッシャー) Mexico Revista T-shirt Black
63179 THRASHER (スラッシャー) Fortune Logo T-shirt Black
58326 THRASHER TH91291 40TH T-SHIRT WHITE
58508 THRASHER TH8101 MAG LOGO S/S TEE PINK/WHITE
58509 THRASHER (スラッシャー) TH8101 MAG LOGO S/S TEE KHARKI/BLACK
58325 THRASHER (スラッシャー) TH91291 40TH T-SHIRT BEIGE
58018 THRASHER TH91292 T-Shirt BLACK
58019 THRASHER TH91292 T-Shirt WHITE
58020 THRASHER (スラッシャー) TH91292 T-Shirt PINK
58021 THRASHER (スラッシャー) TH91292 T-Shirt GREEN
55650 THRASHER TH8101 Mag LogoTee PURPLE/YELLOW
54433 THRASHER OUTLINED CRACK S/S T-SHIRTS BLACK
54431 THRASHER GONZ PRINT S/S T-SHIRTS
36868 THRASHER (スラッシャー) TH8101 MAG LOGO TEE PURPLE
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
11693 THRASHER x GHOSTBUSTERS MARSHMALLOW MAN TSHIRTS BK
13263 THRASHER INFERNO Tee
13264 THRASHER RADIO TEE
13265 THRASHER JAY ADAMS
13828 THRASHER SK8 GOAT T-SHIRTS WT
14681 THRASHER x KEITH HARING TEE BLACK
14800 THRASHER Mag LogoTee FO/WH
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
17813 THRASHER MARVEL CAPTAIN AMERICA TEE WHITE
18283 THRASHER MAG LOGO IN FLAME BLUE/RANGE
18284 THRASHER MAG LOGO IN FLAME RED/YELLOW
18287 THRASHER MAG LOGO CHARCOAL
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
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
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
20359 THRASHER GONZ FUCK TEE BLACK
20360 THRASHER GONZ FUCK TEE GRAY
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
22115 THRASHER MAG LOGO TEE GRAY
22318 THRASHER BLACKOUT S/S TEE BLK/RED
22319 THRASHER BLACKOUT S/S TEE BLK/WHT
22320 THRASHER SCARRED S/S BLK
22321 THRASHER KING OF DIAMONDS S/S BGN
22322 THRASHER CIRCUIT GOAT S/S
22893 Zephyren (ゼファレン) THRASHER x Zephyren S/S TEE -PENETRATE- BURGUNDY
23462 THRASHER TH93130 FLAME LOGO LONG TEE WHT/BLU
24314 THRASHER TH91130 FLAME MAG LOGO TEE WHITE/BLUE
24315 THRASHER TH91130 FLAME MAG LOGO TEE BLACK/BLUE
24316 THRASHER TH91130 FLAME MAG LOGO TEE RED
24317 THRASHER TH91130 FLAME MAG LOGO TEE WHITE/BLACK
24318 THRASHER TH91171 NECKFACE TEE WHT
24321 THRASHER 8188PBT WHITE
24322 THRASHER 8188PBT BLACK
24323 THRASHER 8102PBT WHITE
24324 THRASHER 8102PBT NAVY
24609 THRASHER STICKER T-shirt BLK
24610 THRASHER STICKER T-Shirt WHT
24611 THRASHER ANTI LOGO PRINT S/S T-SHIRT RAINBOW
24612 THRASHER ANTI LOGO PRINT S/S T-SHIRT BLUE OCEAN
24613 THRASHER SKATE MAG TIE DYE TEE TH8101RTD SATURN
25939 THRASHER GX1000 T-SHIRTS BLK
25940 THRASHER GX1000 T-SHIRTS WHT
27396 THRASHER TH8101RTD SATURN/WHT
27397 THRASHER Patriot Flame T-Shirt Ash Gray
27398 THRASHER RESURRECTION T-SHIRT Natural
27399 THRASHER RESURRECTION T-SHIRT Black
27400 THRASHER OUTLINED T-SHIRT BLACK
27401 THRASHER OUTLINED T-SHIRT RED
27410 THRASHER 13WOLVES T-SHIRT
27411 THRASHER MAGZINE LOGO T-SHRT PINK
27412 THRASHER MAGZINE LOGO T-SHRT BLUE
28239 ROLLING CRADLE RCxTHRASHER THRASHE'M ALL!! TEE WHT
28392 THRASHER TH8101 MAG LOGO TEE IVY
28393 THRASHER TH8101 MAG LOGO TEE DAISY/BLK
28394 THRASHER TH8101 MAG LOGO TEE GRN/BLK
28397 THRASHER TH8103 SKATE AND DESTROY TEE NAV/YEL
28398 THRASHER TH8103 SKATE AND DESTROY TEE BLK/BLE
28399 THRASHER TH8103 SKATE AND DESTROY TEE BLK/RED
28401 THRASHER TH8103 SKATE AND DESTROY TEE WHT/BLK
28402 THRASHER TH8103 SKATE AND DESTROY TEE BLK/WHT
28404 THRASHER TH8103 SKATE AND DESTROY TEE RED/BLK