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 =588
)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 19:52:12')
AND FIND_IN_SET(13, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
69327 RIPNDIP (リップンディップ) RIPNDIP OG SHERPA HOODIE NAVY
69722 TOY MACHINE (トイマシーン) BLOOD HAND SWEAT PARKA NAVY
70582 over print (オーバープリント) Rebirth shirts etc A-2
57279 Subciety (サブサエティ) PARKA-PROVIDENCE- NAVY
69397 Subciety (サブサエティ) PIGMENT PARKA NAVY
69675 TheBackOfBoys(ザバックオブボーイズ) CITY GRAFFITI PULLOVER HOODIE NAVY
66858 RIPNDIP (リップンディップ) I Like Turtles Hoodie Navy
69359 DEFTONES UNISEX PULLOVER HOODIE: AROUND THE FUR NAVY BLUE
69238 THRASHER (スラッシャー) Inferno Hoodie NAVY BLUE
67817 MISHKA (ミシカ) CREAMY BICOLOR HOODIE MIJHO-01 NAVY
66693 over print(オーバープリント)Hoodie Hoodie *4th Anniversary limited (navy)
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
65431 RIPNDIP (リップンディップ) Super High Hoodie (Navy Mineral Wash)
63033 GALFY (ガルフィー) 炎上大学SETUP 夏 NAVY
61799 over print (オーバープリント) UNIFORM sweatshirt navy
60485 GALFY 燃えるわんわんパーカー NAVY
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61266 ANIMALIA 2022 福袋 -NEW YEAR BAG-
61400 Subciety (サブサエティ) PAISLEY PARKA NAVY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
61156 AFFECTER (アフェクター) AFF TM HOODIE NAVY
58328 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO L.BLUE
58327 ANIMALIA AN21S-SW02 INDIGO P/O HOODIE - LOGO INDIGO
57412 THRASHER (スラッシャー) TH8501PL MAG LOGO HOODIE NAVY
57397 FILA FS3025 HOODIE NAVY
56912 RUDIE'S 2021 NEW YEAR PACK
56923 SLEEPING TABLET PTSD [ HOODED SWEAT ] NAVY
56238 SLEEPING TABLET CHILDHOOD [ OVERSIZED HOODED SWEAT ] NAVY
54132 SLEEPING TABLET LEVITATE [ SUSPEND ANORAK ] NAVY
55016 Zephyren(ゼファレン)LINE PARKA - Resolve - NAVY
54843 PUNK DRUNKERS 宇宙人スケボーパーカ - NAVY
14156 DEADHEARTZ GOTHIC LOGO HOODIE NAVY
14741 NineMicrophones 9MC Loco PARKA NAVY
15974 ZEPHYREN (ゼファレン) PARKA -NEVER DESPAIR NAVY
18428 Subciety PARKA-GLORIOUS- - NAVY/WHITE
18432 Subciety PARKA-SALOON- - NAVY/RED
18732 NineMicrophones 9MC Loco PARKA NAVY
20427 PUNK DRUNKERS 【PDSxCASPER】キャスパーカ NAVY
21721 THRASHER Splatter Goat HOODED SWEAT NVY/RED
21761 ICECREAM INDIANS HOODIE NAVY
21775 SQUARE WASHED LOGO HOODIE BLUE
22211 RUDIE'S EDDY HOODSW NAVY
22546 Zephyren (ゼファレン) DENIM SWEAT -HIGHEST- DENIM PARKA
22566 Zephyren (ゼファレン) PARKA -PAISLEY- NVY
23297 ANIMALIA HOODIE-Logo#002 NAVY
23463 THRASHER TH8501PL MAG LOGO HOODIE NAVY/BUTTERCUP
23835 SAME LOGO HOODIE NAVY
24468 GLAMOUR KILLS FLOWER CHILD P/O
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
25484 PIERCE THE VEIL San Diego Navy - Pullover
25694 Subciety (サブサエティ) PARKA-Amploud- NAVY
28457 Gluttonous Slaughter (グラトナス・スローター) Gluttonous Creatures HOODIE NAVY
28461 Gluttonous Slaughter (グラトナス・スローター) Gluttonous Slaughter LOGO HOODIE NAVY
28764 VIRGO CARPE DIEM ZIP PARKA NAVY
28818 RIP DESIGN WORXX ロゴプルオーバーパーカー ネイビー
29070 PUNK DRUNKERS 【PDSxHAOMING】マスクあいつパーカ ONE-W
29077 Zephyren (ゼファレン) TIE DYE TRIBAL PARKA -Resolve- NAVY