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 (
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-28 12:43:46')
AND FIND_IN_SET(7, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
59223 LONELY論理 LIMP CAP RED
43281 RIP DESIGN WORXX イビルロゴローキャップ BURGUNDY
21960 THRASHER 14TH-C50T SNAPBACK WIN
48484 GALFY (ガルフィー) ジェットCAP RED
23918 THRASHER MAG LOGO SNAP BACK 17TH-C50 BRG/WHT
28122 Xmas Eileen 『WORLD COUNTDOWN』メッシュキャップ RED
21356 THRASHER SNAP BACK 17TH-C65 BURG
21357 THRASHER SNAP BACK 17TH-C64 BURG
29502 THRASHER 16TH-C27 BGN
17230 Zephyren MESH CAP -BEYOND- - BURGUNDY
17256 Zephyren MESH CAP -VISIONARY- - BURGUNDY
20494 MISHKA (ミシカ) KEEP WATCH SNAPBACK RED
24186 MISHKA (ミシカ) DEATH ADDER SPORT 7P SNAPBACK Red
24190 MISHKA (ミシカ) LAMOUR DEATH ADDER SNAPBACK Red
36384 MISHKA (ミシカ) EXSP1727 BOMB KW RED
42723 SQUARE SPORTY JET CAP RED
29934 PUNK DRUNKERS PDSxKNAVE タグロゴCAP NAVY
21796 MISHKA (ミシカ) Snuffy Emotional Snapback
37087 MISHKA(ミシカ) MAW173203 RED
41891 MISHKA (ミシカ) MAW183227 CAP Red
41906 MISHKA MAW183203 CAP Red
45849 MISHKA MSS193201 CAP RED
17233 ZEPHYREN (ゼファレン) B.B.CAP -BEYOND- BURGUNDY
19654 ZEPHYREN (ゼファレン) B.B.CAP -VISIONARY - BURGUNDY
43009 PUNK DRUNKERS あいつになれるCAP RED
21138 BEFORE MY LIFE FAILS Deep Red Wool Snapback Cap
27546 RideMe R LOGO SNAP BACK CAP #5
17450 DEADHEARTZ MESH CAP RED
29670 GoneR 6 Panel Cap Red
36645 GoneR New Logo 6 Panel Cap BLACK/RED
49100 FILA FLH-P01 RED
34542 MUSIC SAVED MY LIFE (MSML) CAP RED
36430 ALIVE AGAIN HAT
37115 RUDIE'S HEAD GEAR DRAWING PANELCAP RED
41311 PSYCHOLOGICAL METAMORPHOSIS PLMP CORDY CAP BURGUNDY
41313 PSYCHOLOGICAL METAMORPHOSIS PLMP JET CAP RED
45084 MUSIC SAVED MY LIFE (MSML) M1H5T-CP01 DAD CAP RED
45792 RUDIE'S DRAWING PANELCAP RED
27669 ANIMALIA AN16A-CP07 Low cap #001 WHITExRED
38977 SPITFIRE BIGHEAD SNAPBACK RED/BLACK
21565 DEADHEARTZ "BLOOD" SNAPBACK BURGUNDY
50414 RUDIE'S PHAT CORDUROY PANELCAP BURGUNDY
68883 DI:VISION (ディヴィジョン) 666 CAP BLKxRED
24050 ANIMALIA AN16U-CP04 GRIZZLY Cap BLACKxRED
38981 SPITFIRE STEADY ROCKIN' BIGHEAD SNAPBACK
28554 RUDIE'S HEAD GEAR SPARK SNAPBACK CAP NAVY/RED
35494 RUDIE'S SPARK SNAPBACK CAP RED/BLK
41572 RUDIE'S HD0658 SPARK SNAPBACKCAP BLACK/RED
25401 SQUARE (スクエア) 6PANEL CAP"BANANA" RED
27772 ANIMALIA AN15SP-CP01 WHTxNVxRED BLK
27774 ANIMALIA AN15SP-CP01 GRAYxBURGUNDY BLK
27775 ANIMALIA AN15SP-CP01 REDxBLACK BLK
37602 ROLLING CRADLE RCxMU MU CAP / Black-Red
45746 ROLLING CRADLE ARIZONA CAP / Red
47849 ROLLING CRADLE HANDWRITING LOGO CAP / Red
68564 ANIMALIA (アニマリア) SIX PANELS MESH CAP-LOGO BLACK&RED
41243 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP RED
45142 TOY MACHINE TMP19HW12 PYLAMID SECT EBRO CAP RED
24862 RUDIE'S PHAT SNAPBACKCAP RED
26634 RUDIE'S HEAD GEAR VICE SNAPBACKCAP RED/BLACK