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 =97
)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 12:29:54')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(10, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70322 GALFY (ガルフィー) モクモクロンTee YELLOW
69858 PUNK DRUNKERS(パンクドランカーズ) [PDSxたまごっち]あいつっちロンTEE - D.YELLOW
69208 TOY MACHINE (トイマシーン) NEW CHARACTERS LONG TEE GOLD
68204 バンドじゃないもん!MAXX NAKAYOSHI×GEKIROCK CLOTHING×KAVANE Clothingコラボ・ロンT YELLOW
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
60687 DI:VISION BUTTERFLY LS TEE LIME
62587 ROLLING CRADLE BURNED LOGO LONG SLEEVE / YELLOW
61713 HEDWiNG One stroke owl Longsleeve T-shirt Mustard
62569 Survive Said The Prophet NEW STANDARD L/S TEE SAFETY YELLOW
62191 TRAVAS TOKYO【トラヴァストーキョー】Furry bear L/S Tee 2022ver. LIGHT YELLOW
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
60720 MISHKA M61000010 L/S T-Shirt
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
59344 SLEEPING TABLET FORMULA [ LONG SLEEVE ] YELLOW
59231 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLUE×ORANGE
58776 Non Stop Rabbit×GEKIROCK CLOTHING コラボ・ロンT YELLOW
58804 HYPER CORE CROISSANT ロングスリーブTシャツ YELLOW
58092 WASTED PARIS T-shirt Longsleeve Columbia Bridge Yellow
57113 TOY MACHINE CLAIRVOYANT LONG TEE NEON YELLOW
54858 PUNK DRUNKERS [PDSxPAC-MAN]逃げロンTEE - N.YELLOW
55025 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - MUSTARD
55667 ゲキクロ限定 DI:VISION UMBRELLA LS TEE YELLOW
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
23867 MISHKA (ミシカ) SICK SAD KEEP WATCH L/S TIE DYE TEE Lime/Kelly Tie Dye
28868 ROLLING CRADLE (ロリクレ) HEXAGON CHANGER / Navy
37353 ROLLING CRADLE SAMURAI BOP LONG T-SHIRT / Yellow
37992 Subciety (サブサエティ) Lithium L/S YELLOW
38873 LILWHITE(dot) (リルホワイトドット) -VICTIM- L/S TEE YEL
38884 LILWHITE(dot) (リルホワイトドット) -THE BOX- L/S TEE ORG
39558 PARADOX ORACLE L/S TEE (YELLOW)
39561 PARADOX - MEDITATION L/S TEE (YELLOW)
39869 Civil Regime (シビル・レジーム) Sound Wave LS Tee in Gold
41417 Subciety (サブサエティ) SECTION L/S GREEN
41419 Subciety (サブサエティ) RE:BASE L/S YELLOW
42398 LILWHITE(dot) (リルホワイトドット) LW-18AU-LT02 -REFLECTED- L/S TEE ORANGE
42738 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts Orang/Yellow
42739 GoneR (ゴナー) GR18LS002 Rose Long Pocket Long T-Shirts Yellow/White
42789 SLEEPING TABLET NOTICE LOOSE BORDER CUTSEW YELLOW
43005 GALFY 普通にロンTEE YELLOW
43036 FILA FM9426 CREW NECK SHIRT CITRUS
43079 NOT COMMON SENSE "SABOTAGE" LAYARD SLEEVE TEE YELLOW
43117 RIP DESIGN WORXX 謎袋2018夏
43337 ROLLING CRADLE BORDER LONG T-SHIRT / Yellow
43464 【ゲキクロ限定】GoneR (ゴナー) Rose Long Pocket Long T-Shirts White/Yellow
43501 NOT COMMON SENSE FRANKEN 2 L/S TEE S/GREEN
44262 ROLLING CRADLE RCxDr.スランプ アラレちゃん LONG SLEEVE SHIRT / Yellow
45114 PUNK DRUNKERS [PDSxLAND BY MILKBOY]MBPDロンTEE N.YELLOW
45358 Subciety (サブサエティ) Daisy L/S YELLOW
46274 SABBAT13 SBT-LT-023 G.F.G L/S T(ゴールド)
46304 SANTA CRUZ SPILL HAND LS TEE GOLD
46323 SANTA CRUZ WAVE SLASHER LS TEE YELLOW
46888 RIP DESIGN WORXX モザイクロゴ L/SポケットTシャツ NEON YELLOW
47329 RIPNDIP RIPNTAIL L/S (Safety Green)
47504 LILWHITE(dot) LW-19SU-LT01 “PLANET” L/S TEE GOLD
47595 FILA FM9618 Graphic LS T-shirt GOLD
49471 SANTA CRUZ CLASSIC DOT L/S REGULAR T-SHIRT GOLD
49769 MISHKA MAW190037 L/S TEE GREEN
49877 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2(NEW COLOR) YELLOW
50029 FILA FM9688 CREW YELLOW
50290 HEDWiNG Chinese Zombie Longsleeve T-shirt Lime
50320 LILWHITE(dot) LW-19AW-LT03 "85" L/S TEE (LIME)
50812 MUSIC SAVED MY LIFE M101-01K5-CL01 LONG SLEEVE TEE ORANGE
50814 MUSIC SAVED MY LIFE M101-01K5-CL01 LONG SLEEVE TEE YELLOW
51153 VIRGO VG-CUT-398 CRUST LINKS YELLOW
51231 TOY MACHINE×PUNK DRUNKERS * FIST LONG TEE - GOLD
51501 MISHKA MSS200057F99 L/S TEE BLACK
52584 REBEL8 Your Enemies Are Mine Longsleeve Tee
52613 MISHKA MSS200036M21 L/S TEE BLACK
52684 MISHKA Crack the Crust Longsleeve Safety Green
52730 SABBAT13 YOKAI TRUMP L/S T (GD)
54056 FILA FM9787 L/S TEE YELLOW
51510 MISHKA MSS200055F12 L/S TEE SAFTY GREEN