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 =1
)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-27 11:44:05')
AND pc.price03 IS NOT NULL
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
31957 Bentham 視力検査Tシャツ WHITE
39267 HER NAME IN BLOOD DECADENCE Tシャツ
52950 Survive Said The Prophet UNBALANCE TEE WHITE
50614 PassCode In the Rain TEE(WHITE)
50620 PassCode BEACH TEE(WHITE)
56777 KEYTALK×GEKIROCK CLOTHING 限定コラボ・Tシャツ WHITE
60121 HYPER CORE MF-01 mistFES2021 × HYPER COREコラボレーションTシャツ White
58658 MAGICAL MOSH MISFITS おすし TEE 中トロ
59293 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts White/Red
60068 Subciety (サブサエティ) CLASSIC S/S WHITE
63414 ZERO EVOKE (ゼロイヴォーク) Expansion fuchi logo S/S big tee WHITE
57980 GoneR GR28CT001 Rose Hand T-Shirts White
50624 PassCode PROJECTION TEE(WHITE)
37708 SUICIDAL TENDENCIES Possessed To Skate TEE WHT
53192 MISS MAY I UNISEX TEE: BULL DOG (BACK PRINT)
60345 RUDIE'S (ルーディーズ) SAFARI PHAT-T WHITE
63182 RUDIE'S (ルーディーズ) HELLO-T WHITE
55950 Gluttonous Slaughter (グラトナス・スローター) Triple Six big T-shirt White
62690 PUNK DRUNKERS (パンクドランカーズ) アーポくんTEE - ASH
54636 FILA FFM9848 ユニセックス クルーネックシャツ WHITE
54637 FILA FFM9847 ユニセックス クルーネックシャツ WHITE
60253 ROLLING CRADLE OTAKU-SHOJO TEE / WHITE
54432 THRASHER (スラッシャー) OUTLINED CRACK S/S T-SHIRTS WHITE
58589 TOY MACHINE (トイマシーン) TOYMONSTER EMB SS TEE WHITE
63007 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - WHITE
58624 MISHKA OPTIC KEEP WATCH TEE WHITE
58627 MISHKA SPOOKY CREW TEE WHITE
60129 HYPER CORE HTC-370 HyperBearts Tシャツ WHITE
60350 HYPER CORE T-374 Continue? Tシャツ WHITE
63311 GoneR (ゴナー) GR33CT004 Mexican Pattern T-Sirts White
53870 MISHKA(ミシカ) MSS200085 T-SHIRTS WHITE
57892 Subciety (サブサエティ) Robin S/S- WHITE
62255 Zephyren(ゼファレン) S/S TEE - VISIONARY - WHITE
56240 MAGICAL MOSH MISFITS MxMxM TEE WH/BK
56244 MAGICAL MOSH MISFITS MAGICAL MOSH MISFITS TEE WHITE
65287 ハッピーハンバーグ ロゴプリント Tシャツ WHITE
56422 Subciety (サブサエティ) LABO. S/S - WHITE
58764 SILLENT FROM ME WORDS WHITE
63204 Subciety (サブサエティ) TAG S/S WHITE
63207 Subciety (サブサエティ) CAN TEE WHITE
35581 BRING ME THE HORIZON SHADOW MOSES
61718 HEDWiNG Crayon Flower Pocket T-shirt Oatmeal
60244 acOlaSia I DON'T GIVE A SHIT TEE WHITE
60248 acOlaSia NEXT IS YOU TEE WHITE
54186 Subcietyx攻殻機動隊SAC_2045 Major S/S WHITE
60172 MISHKA X DENNIS THE MENACE DENNIS TEE WHITE
65314 ZERO EVOKE Spider Tee 【WHITE】
59064 Subciety (サブサエティ) cardinal S/S - WHITE
63134 【予約商品】PSYCHOLOGICAL METAMORPHOSIS CS RINGER TEE - BLACK
64853 Wall Of Graphic(ウォールオブグラフィック)Ash Tシャツ
61919 glamb (グラム) Collaged Posters T - White
58411 RUDIE'S (ルーディーズ) PHAT BIGSILHOUETTE-T WHITE
59218 LONELY論理 BLUE EYEZ TEE white
60343 RUDIE'S (ルーディーズ) VITAMIN PHAT-T WHITE
61104 VIRGO PERFECTION 22(BIG) WHITE
58716 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts White
58722 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts White
62692 PUNK DRUNKERS (パンクドランカーズ) あいつ遊泳TEE - WHITE
57985 GoneR GR28CT002 Tie-dye Line T-Shirts White
58159 TOY MACHINE MONSTER T-Shirt WHITE
58700 GoneR GR29CT003 Rose Messege T-Shirts White
62875 PSYCHOLOGICAL METAMORPHOSIS 4 SEASONS TEE - WHITE
65605 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (WH)
62116 ROLLING CRADLE Mjolnir TEE / WHITE
62677 PUNK DRUNKERS (パンクドランカーズ) サスペンダーTEE - WHITE
57142 SABBAT13 HIDE&SEEK T WHITE
64911 THRASHER (スラッシャー)×TURTLES T-shirt WHITE
58155 TOY MACHINE (トイマシーン) TURTLEBOY T-Shirt WHITE
60596 RIPNDIP Not Today Tee White
63004 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - WHITE
58666 KILL STAR CLOTHING Stay Weird T-Shirt White
62613 NineMicrophones Chug S/S WHITE
62807 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN LOCALFEST TEE WHITE
63433 ZENON(ゼノン) Front embroidery S/S big tee WHITE
64199 Subciety (サブサエティ) MARIA TEE WHITE/GOLD
64355 DI:VISION (ディヴィジョン) UN-ARMED Tee WHITE
64867 HYPER CORE(ハイパーコア) MELON PAIN Tシャツ WHITE
69069 NieR (ニーア) BACK DESIGN CUTSEW【NIER VIAL】
64857 Wall Of Graphic(ウォールオブグラフィック)Four Tシャツ
59957 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA MEZAME NO ANIME GIRL TEE WHITE
63428 ZENON(ゼノン) Simple logo S/S big tee WHITE/BLACK
54198 MISHKA MSS200029M80 T-SHIRTS WHITE
57359 MISHKA M21000013 T-Shirt WHITE
57883 Subciety (サブサエティ) WEEKENDER S/S- WHITE
63078 MISHKA (ミシカ) M21100025 T-SHIRT WHITE
63743 Subciety (サブサエティ) BARBER S/S WHITE
64996 over print(オーバープリント) Velbed emblem Tee (white)
54769 KAVANE Clothing "WIELD"OVERSIZE CUTSEW(Wht)
64216 TOY MACHINE×PUNK DRUNKERS AITSU AND TOYMONSTER IN TURTLE HEAD SS TEE - WHITE
56044 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"OVERSIZE CUTSEW(Wht)
59119 ANIMALIA AN21U-TE10 DIVING WHITE
56208 Anti Social Social Club Read Receipts White Tee
58132 MISHKA M21000066 T-Shirt White
58766 SILLENT FROM ME FILLM -Pocket- WHITE
62609 TOY MACHINE (トイマシーン) ERIC FOUNTAIN HEAVY WEIGHT BIG SS TEE - WHITE
63106 Subciety (サブサエティ) NOUGAT TEE WHITE
63109 Subciety (サブサエティ) SCOUT TEE WHITE
63227 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - WHITE
63303 GoneR (ゴナー) GR33CT001 Rose Maria T-Sirts White
62775 ROLLING CRADLE CNS TEE / WHITE
58592 TOY MACHINE (トイマシーン) CHARACTERS SS TEE WHITE
63232 TOY MACHINE (トイマシーン) AXEL SS TEE - WHITE
65012 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (WH)
54196 MISHKA MSS200033F80 T-SHIRTS WHITE
58033 TOY MACHINE MONSTER 3/4 SLEEVE TEE-WHITE
63076 MISHKA (ミシカ) M21100039 T-SHIRT WHITE
65670 MISHKA (ミシカ) M61100008 "KEEP WATCH"Tee WHITE
57810 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×BLACK
57136 SABBAT13 SPOOK INSIDE T WHITE
53143 SAMURAI CORE 地震ー雷ー火事ーオヤジ TEE WHITE
56036 SAMURAI CORE SR-TE-002D 遠慮なく外出したいなぁ TEE WHITE
57898 Subciety (サブサエティ) AMBITION S/S - WHITE
63123 HEDWiNG (ヘドウィグ) Infection warning Tie-dye Big Silhouette T-shirt Surf blue
65434 RIPNDIP (リップンディップ) Dark Twisted Fantasy Short Sleeve Tee (Black/White)
58035 TOY MACHINE SECT MARK PRINT SS TEE - WHITE
58153 TOY MACHINE (トイマシーン) PYLAMID SECT T-Shirt WHITE
63016 GALFY (ガルフィー) お花畑Tee WHITE
63400 TRAVAS TOKYO【トラバストーキョー】Furry panda BIG Tee ホワイト
63842 TRAVAS TOKYO【トラバストーキョー】Furry bear BIG Tee ホワイト
58073 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN PEACE PKT-T WHITE