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 =17
)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-26 10:08:46')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 75
63293 Anti Social Social Club Kkoch Black Cap
55640 【予約商品】Anti Social Social Club WEIRD CAP BLACK
56215 Anti Social Social Club Headrush Cap
55641 Anti Social Social Club ASHTON BLACK CAP
11110 REBEL8 STANDARD ISSUE LOGO NEW ERA
11117 REBEL8 STANDARD ISSUE LOGO SNAPBACK
13742 REBEL8 SCHOLARS SNAPBACK
13745 REBEL8 S.I. LOGO W UNDERBRIM SNAPBACK BLACK
15302 REBEL8 VNDERGROVND SNAPBACK
15934 BLACK CRAFT Believe In Yourself - Snapback Hat
15935 BLACK CRAFT Unholy - Snapback Hat
15936 BLACK CRAFT One Nation No God - Snapback Hat
16829 REBEL8 ALPINE RUST BEANIESPRING LOGO SNAPBACK
17596 REBEL8 SPRING NEON LOGO SNAPBACK CAP BLACK
20290 REBEL8 GR8FUL REVERSIBLE BUCKET HAT
20295 REBEL8 SPREAD THE 8 HOPS SNAPBACK
20621 REBEL8 COVER THE 8 SNAPBACK CAP
21180 BLACK CRAFT No Gods - Snapback Hat
21581 REBEL8 ANGEL SNAPBACK
21607 REBEL8 HELLAWEEN 5-PANEL
22089 REBEL8 TOP GUNNER SNAPBACK
22090 REBEL8 NIGHT WATCH SNAPBACK
23279 REBEL8 TAP THE ROCKIES GREY SNAPBACK
23280 REBEL8 APPLIC8 BURGUNDY SNAPBACK
23281 REBEL8 LOGO HANDSTYLE GREY SNAPBACK
23282 REBEL8 GRID IRON CHARCOAL SNAPBACK
23283 REBEL8 GO FUCK YOURSELF BLACK SNAPBACK
23284 REBEL8 PROPERTY OF BLACK SNAPBACK
23965 REBEL8 CIRCLE 8 SNAPBACK
24163 REBEL8 NATIONAL STRIKER SNAPBACK
24164 REBEL8 SPECIAL OPERATIONS SNAPBACK
24990 REBEL8 SCOUTS MESH CAP
25012 REBEL8 PREMIUM BLEND SNAPBACK
25013 REBEL8 SLEEZE SNAPBACK
28209 REBEL8 NOWHERE FAST SNAPBACK
28210 REBEL8 BOMB SQUAD SNAPBACK
28384 REBEL8 SCRIPT SNAP BACK
28888 REBEL8 STANDING STRONG SNAPBACK
29856 REBEL8 DIE SLOW SNAPBACK
29872 REBEL8 HIT THE WALLS SNAPBACK
29873 REBEL8 CENTIFOLIA SNAPBACK
29874 REBEL8 TWO FACED SNAPBACK
29875 REBEL8 88 WATTS SNAPBACK
29876 REBEL8 BEAT IT SNAPBACK
32364 REBEL8 TOAST TO THE WORST SNAPBACK
32378 REBEL8 PROPER FUCKED SNAPBACK
32380 REBEL8 ROSE AND DAGGERS SNAPBACK
32381 REBEL8 EIGHT OR DIE SNAPBACK
32382 REBEL8 WORLDWIDE DISTRO SNAPBACK
33489 REBEL8 UNDER THE WING SNAPBACK
33490 REBEL8 BREWED AND SCREWED SNAPBACK
33492 REBEL8 REFLECTIVE 8 SNPABACK
33493 REBEL8 PREMIUM SCRIPT SNAPBACK
34003 REBEL8 MEDITATE SNAPBACK
34464 REBEL8 BOGEY STRAPBACK KHAKI
34465 REBEL8 BOGEY STRAPBACK BLACK
34466 REBEL8 BOGEY STRAPBACK WHITE
34467 REBEL8 BOGEY STRAPBACK PINK
35074 REBEL8 Lakeview Snapback
35075 REBEL8 Water Hazard Strapback
35080 REBEL8 Olde Strapback BLACK
35081 REBEL8 Olde Strapback WHITE
35082 REBEL8 Olde Strapback PINK
35083 REBEL8 Woes Strapback WHITE
35087 REBEL8 Woes Strapback BLACK
35540 REBEL8 Half Moon Bay Snapback
35541 REBEL8 Discarded Paradise Snapback
36230 REBEL8 Regiment Snapback
36231 REBEL8 Dusty Snapback
36717 REBEL8 Foretold Snapback
36723 REBEL8 Floret Strapback
36724 REBEL8 Floret Dad Hat Black
36725 REBEL8 Floret Dad Hat Khaki
37002 REBEL8 Drudge Snap Back
37717 REBEL8 Scriptum Snapback