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 =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-05-02 09:26:17')
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 360, 120
57112 TOY MACHINE CLAIRVOYANT LONG TEE WHITE
57092 RUDIE'S (ルーディーズ) RUDIE'S x BYRD / LOOK SLICK LS-T WHITE
54865 PUNK DRUNKERS 唐揚げおじさんロンTEE - ASH
56495 DI:VISION HE-X-EN LS TEE WHITE
55906 MISHKA MAW200002 L/S T-SHIRTS WHITE
56172 HEDWiNG HD-012 Pierrot Mask Longsleeve T-shirt White
56048 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Wht)
56101 TRiDENT×DI:VISION×GEKIROCK CLOTHING SPECIALコラボロンT TYPE.A WHT
56104 TRiDENT×DI:VISION×GEKIROCK CLOTHING SPECIALコラボロンT TYPE.B WHT
56603 acOlaSia INSANE L/S WHITE
56601 acOlaSia HOMINIDAE L/S WHITE
56791 GALFY 神YABAI Tee WHITE
56017 ドラマストア×GEKIROCK CLOTHING 限定コラボ・ロンT WHITE
56515 ANIMALIA AN20A-TE06 “SWAGGER CLOTHINGS Poster” L/S TEE WHITE
56291 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (WHITE)
55022 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - WHITE
56195 NOT COMMON SENSE BRAIN LAYERED L/S TEE WHITE
56056 TRAVAS TOKYO Blindfold L/S tee White
56154 TRAVAS TOKYO Spacesuit Bear L/S tee White
56150 MAGICAL MOSH MISFITS MxMxM FLAME LONG TEE WHITE
56124 N.B.O. FLOWER PRINT T
56125 N.B.O. SPHERE PRINT T
54326 Subciety Purgatory L/S WHITE
55869 GoneR GR26LS003 Mexican Goods Skull L/S T-Shirts White
56094 RUDIE'S GUESTPASS LS-T WHITE
55852 GoneR × 大内慶 Collaboration L/S T-Shirts White
55865 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts White
55599 SABBAT13 GHOSTLY L/S T ホワイト
55539 HEDWiNG “JYOCHO” Crosscut Longsleeve T-shirt White
55541 HEDWiNG Garment Dyed Longsleeve T-shirt White
55987 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- WHITE
55664 DI:VISION SHELTER LS TEE WHITE
55668 ゲキクロ限定 DI:VISION UMBRELLA LS TEE PINK
55666 DI:VISION UMBRELLA LS TEE WHITE
54306 Subciety FIVE LIGHTS L/S WHITE
55959 火寺企画 完全無敵のロングスリーブTシャツ WHITE
55953 Gluttonous Slaughter (グラトナス・スローター) Infernal Cat Long Sleeve White
55954 Gluttonous Slaughter (グラトナス・スローター) Infernal Cat Long Sleeve Purple
55947 TOY MACHINE FIST EMBROIDERY LONG TEE - WHITE
55949 TOY MACHINE MONSTER MARKED EMBROIDERY LONG TEE - WHITE
54586 アマツカミ 病/Sick Long T-Shirts White
54578 アマツカミ 蛇薔薇/Rose Snake Long T-Shirts White
54580 アマツカミ 死文字 Long T-Shirt White
54582 アマツカミ 棘薔薇 Long T-shirt White
54584 アマツカミ 花 L/S WHITE
55712 RIPNDIP Embroidered Logo L/S (Multi)
54183 Subcietyx攻殻機動隊SAC_2045 GHOST HACK L/S WHITE
53010 DI:VISION RIPPER CUTSEW Type-B WHITE
24698 MEMPHIS MAY FIRE Love Truth Long Sleeve White - T-Shirt
24749 WHITECHAPEL Sacrifice Black/White - Baseball T-Shirt
24770 NORTHLANE Prism White - Long Sleeve Shirt
36502 【ゲキクロ限定】 a crowd of rebellion Gingerol Longsleeve White
39254 ヒステリックパニック ロングスリーブT ホワイト
41073 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / RED
41074 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / PURPLE
41075 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / BLUE
41585 MOTORHEAD×LAKAI War Pig Long Sleeve Tee White
49723 Survive Said The Prophet NEW SCHOOL CROP TOP
52519 TRAVAS TOKYO Armed Hedgehog2 L/S Tee WHITE
52520 RUDIE’S 2020 NEWYEAR PACK
52932 TOY MACHINE TMP20LT19 L/S T-Shirt WHITE
53008 DI:VISION XXXX LS TEE WHITE
53057 【ゲキクロ限定】GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts WHITE/PURPLE
53065 RIP DESIGN WORXX RIPDW アイコンシルエット L/S Tシャツ WHITE
53067 RIP DESIGN WORXX RIPDW アイコンシルエット L/S Tシャツ UNICORN
53103 PUNK DRUNKERS PDS×仮面ライダー]滅亡迅雷.net ロンTEE WHITE
53105 PUNK DRUNKERS あいつピエロンTEE WHITE
53119 LILWHITE(dot) LW-20SS-LS01 CHARLY LS TEE WHT
53172 RIP DESIGN WORXX ブラサードロングスリーブTシャツ WHITE
53895 PARADOX PX17-LS01 FAKE LAYERED L/S TEE [metaphor] WHITE
53898 PARADOX PX17-LS02 FAKE LAYERED L/S TEE [NOBLE DISEASE] WHITE
53943 Bentham longsleeve T-shirt WHITE
53950 NOT COMMON SENSE ”SWAG” L/S TEE WHITE
53954 NOT COMMON SENSE ”ANCIENT” L/S TEE WHITE
54057 FILA F9818 BORDER L/S TEE PINK
54058 FILA F9818 BORDER L/S TEE ORANGE
54059 FILA F9835 L/S TEE WHITE
54069 SILLENT FROM ME TRAGEDY -Long Sleeve- WHITE
54081 ROLLING CRADLE ICEE LONG SLEEVE / WHITE
54099 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE WHITE
54101 PSYCHOLOGICAL METAMORPHOSIS EXPANTION L/S TEE WHITE/BLUE
54620 Survive Said The Prophet MONO TONE L/S TEE
54621 Survive Said The Prophet PROPHET L/S TEE
54622 Survive Said The Prophet ARCHETYPE L/S TEE
54670 FILA FFM9801 ユニセックス クルーネックシャツ WHITE