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-04-29 02:01:23')
AND FIND_IN_SET(12, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
63264 GALFY (ガルフィー) わんわん大学 SETUP あの夏 GREEN
63377 Anti Social Social Club Passing Fad Mint Tee
56213 Anti Social Social Club Headrush All Over White Tee
52417 Zephyren 2020 NEW YEAR BAG
11735 SLIP&Co. 13 FOOTBALL TOP Green/Yellow
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
49286 Dezzn IN91207S Institute T-Shirt GRN
59280 ROLLING CRADLE BORDER TURTLE NECK / GREEN
67588 GALFY (ガルフィー)ピカピカ注射器ラグラン Tee EMERALD
58389 GALFY (ガルフィー) 半分カラーギャング BIG Tee おピンク × 黄緑
58392 GALFY (ガルフィー) 二代目カラーギャング BIG Tee 黄緑 × おピンク
67562 GALFY (ガルフィー)染め染めわんちゃんボロボロ Tee GREIGE
68152 GALFY (ガルフィー) モクモク Tee GREEN
68161 GALFY (ガルフィー) 90’ s 暗号 Tee SAX
71151 GALFY(ガルフィー) ぷくぷくGALFY Tee L.GREEN
41899 ROLLING CRADLE RC VULGAR BIG T-SHIRT Green
65009 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/GREEN
66901 PLEASURES(プレジャーズ)REALITY T-SHIRT GREEN
59348 あいにょん. × GALFY × GEKIROCK CLOTHING JUST"CHILL"ING TEE WHITE
59349 あいにょん. × GALFY × GEKIROCK CLOTHING JUST"CHILL"ING TEE BLACK
59861 SUPPLIER (サプライヤー) TINPLATE CAMO TEE
68170 Subciety (サブサエティ) Cereal TEE GREEN
68920 EMPATHY×over print Tシャツ MINT
63275 GALFY (ガルフィー) 落書きTシャツ BLACK
63276 GALFY (ガルフィー) 落書きTシャツ L.GREEN
67557 GALFY (ガルフィー) 草野球 Tee GREEN
68149 GALFY (ガルフィー) STAR DOGS Tee EMERALD
40916 ROLLING CRADLE RC-T1502 SWEET FOOTBALL TOP Green-Blue
53137 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type A
53138 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt BLK×MINT type B
56655 PUNK DRUNKERS [PDSxLAND by MILKBOY]ブラザーズTEE - LT.GREEN
61766 MISHKA (ミシカ) M21100001 T-SHIRT L.GREEN
68283 Subciety (サブサエティ) WIDE BORDER TEE GREEN
45768 RIPNDIP Peek A Nermal Knit Tee (Hunter Green / Fuchsia)
71345 over print (オーバープリント) GHOST BUSTERS Tee 7 dark green
50943 Subciety (サブサエティ) FLAVOR S/S LEMON
58204 PUNK DRUNKERS タイダイマッポTEE - GREEN/YELLOW
63018 GALFY (ガルフィー) お花畑Tee L.GREEN
63274 GALFY (ガルフィー) GAL之Hearts Tシャツ 再 L.GREEN
63392 TRAVAS TOKYO【トラバストーキョー】Furry bear BIG Tee ライトグリーン
28046 SPITFIRE Speed Kills T-Shirt - Camo/White
39594 Subciety paranoid S/S GREEN
49237 MAISON EMERALD SPRAY-PRINTED TEE
45763 RIPNDIP Lord Nermal Camo Pocket Tee (Army camo)
47648 RIPNDIP Color Block Multi Panel Tee (Multi)
54700 MISHKA(ミシカ) MSS200032 T-SHIRTS GREEN
54703 MISHKA MSS200005 T-SHIRTS GREEN
58824 MISHKA(ミシカ) M21000021 T-SHIRTS
61244 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション Compac Drive TEE GREEN
62670 PUNK DRUNKERS (パンクドランカーズ) タイダイきのこTEE - GREEN
50695 RIPNDIP MNB JACQUARD RIB TEE TEAL
65512 財部亮治 × over print × GEKIROCK CLOTHING Sing Tee GREEN
71240 TOY MACHINE (トイマシーン) TRANSMISSIONATOR EMBROIDERY SS TEE F.GREEN
71353 over print (オーバープリント) GHOST BUSTERS Tee 10 lime
47654 RIPNDIP Herb Eater Tee (Green Mineral Wash)
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
63120 HEDWiNG (ヘドウィグ) Back to laughter Tie-dye T-shirt Light green
39606 Subciety ASTRONAUT S/S GREEN
61784 MISHKA (ミシカ) M21100032 T-SHIRT L.GREEN
71046 over print (オーバープリント) PARADICE Tee dark green
71061 over print (オーバープリント) ANTI HEART Tee dark green
71186 over print (オーバープリント) AIN’T Tee dark green
71256 SCENE TOKYO (シーントウキョウ) togetoge KNIGHT Tee (pigment olive)
71257 SCENE TOKYO (シーントウキョウ) Maria Tee (pigment olive)
71269 SCENE TOKYO (シーントウキョウ) ice girl Tee (melon)
71319 over print (オーバープリント) EAT A PIZZA Tee dark green
53981 GALFY かませ犬Tee(革命児Tee) エメラルドプロージョン
55807 SUBLIME×SULLEN RUCA NEPTUNE PREMIUM Tee
60072 GALFY (ガルフィー) エチエチ体操着 ぐりーん
41039 RIPNDIP HANG IN THERE POCKET TEE HUNTER GREEN
23078 Subciety(サブサエティ) GLORIOUS S/S-BRIGHT- GREEN
24019 ANIMALIA AN16U-TE08 LONG HORN OLIVE
31647 ANIMALIA AN17S-TE05 RUSTICLOTHES DEPT. olive
39612 Subciety Hollyhock S/S GREEN
44255 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / Green
49728 ANIMALIA AN19M-TE06 No More Shot MINT
64443 PUNK DRUNKERS × TOY MACHINE 組体操TEE - D.GREEN
48338 RIPNDIP Skate Nerm Tee (Safety Green)
64215 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - MINT
25428 SQUARE (スクエア) D.F.T.L. Ts LIME
26238 Zephyren (ゼファレン) S/S TEE -Zion- DARK.GREEN
41717 SQUARE ROYAL VANITY T-Shirts LIME
41725 SQUARE LOGO POCKET T-Shirts LIME GREEN
42425 SQUARE BIAS LOGO T-Shirts LIME GREEN
47049 Subciety 【WOMENS】BIG TEE-Junior- GREEN
54739 PUNK DRUNKERS [PDSxKUDAN]PUNKUDAN式 ベアTEE GREEN
57360 MISHKA M21000013 T-Shirt GREEN
68824 SCENE TOKYO (シーントウキョウ) Coffee S/S GREEN
41618 RIPNDIP Inferno Tee (Olive)
36758 SANTA CRUZ SKINNER HAND GREEN
46327 SANTA CRUZ SCREAMING HAND TEE WILD SPIDER
23098 Subciety GLORIOUS S/S OLIVE
23099 Subciety GLORIOUS S/S BLUE
23526 NineMicrophones 9MICS Crew S/S - GREEN/YELLOW
41219 REBEL8 Drift Away Tee Mint
41700 ROLLING CRADLE DISNEY T-SHIRT "Peter Pan" / Lime
58625 MISHKA OPTIC KEEP WATCH TEE GREEN
63314 GoneR (ゴナー) GR33CT004 Mexican Pattern T-Sirts Army Green
63721 over print (オーバープリント) planet Tee (green)
63734 over print (オーバープリント) EMB logo Tee 1 (light mint)
63738 over print (オーバープリント) EMB logo Tee 1 (dark green)
68029 GoneR(ゴナー) GR36CT002 Cheart T-Shirts Dark Green
68236 TheBackOfBoys(ザバックオブボーイズ) CUTE GIRL TYPE1 TEE BILLIARD GREEN
68237 TheBackOfBoys(ザバックオブボーイズ) CUTE GIRL TYPE2 TEE MILITARY GREEN
68313 over print (オーバープリント) Distortion Tee (light mint)
68315 over print (オーバープリント) Distortion Tee (dark green)
68317 over print (オーバープリント) DRINK Tee (mint)
40470 TOY MACHINE TMS18ST3 colin provost secxt attack ss Lime
45442 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE LIME
16623 DEADHEARTZ BUG TEES TIE DIE
46974 PUNK DRUNKERS [PDSxSWITCH BOMB]PDSB.TEE D.GREEN
54114 SABBAT13 BLESSING T TURQUOISE
56664 PUNK DRUNKERS グレイトフルマッポ刺繍TEE - GREEN
57137 SABBAT13 SPOOK INSIDE T TURQUOISE
57143 SABBAT13 HIDE&SEEK T MINT