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 dtb_products AS p
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-27 22:04:25')
AND pc.price02 > 2727
AND price02 <= 4545
AND FIND_IN_SET(12, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
68454 RUDIE'S (ルーディーズ) PHAT POUCH OLIVE
71126 ビビビビット‼︎ オリジナル麻雀牌アクセサリー(透明牌) ピアス (ビーズ上) 緑色
71121 ビビビビット‼︎ オリジナル麻雀牌アクセサリー(透明牌) ピアス (ビーズ下) 緑色
69110 PUNK DRUNKERS(パンクドランカーズ)般若スケボーTEE'23 / REVIVAL D.GREEN
68884 DI:VISION (ディヴィジョン) 666 CAP BLKxGRN
69088 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / MELON
68223 DXMOUVE(ドゥモーヴェ) 臓器看板柄カシュクールチャイナトップス GREEN
68288 MISHKA (ミシカ) RAINBOW KEEP WATCH TRUCKER CAP
68103 over print(オーバープリント) Circle Tee (mint)
65003 over print(オーバープリント) Velbed emblem Tee (dark green)
64998 over print(オーバープリント) Velbed emblem Tee (light mint)
64185 over print(オーバープリント) back pennant Tee (dark green)
64189 over print(オーバープリント) back pile shorts (mint)
67499 HEDWiNG (ヘドウィグ) Re: Warning Tape Belt / Apple green
64117 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ CREW SWEAT ] GREEN
62703 PUNK DRUNKERS (パンクドランカーズ) とびすぎちゅういTEE - M.GREEN
62656 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - D.GREEN
65606 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (GR)
65454 RIPNDIP(リップッディップ) Peek A Nermal Boxers (Pine)
62864 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 06 - E.GREEN
65170 Subciety (サブサエティ) NOVEL GLORIOUS TEE-WHITE/GREEN
64983 over print(オーバープリント) hair band green
64506 SABBAT13(サバトサーティーン) OUT GRAVE PURCE (OL)
62934 PSYCHOLOGICAL METAMORPHOSIS PLMP CIRCLE NECKLACE - GREEN
62159 Subciety (サブサエティ) NYLON CARGO SHORTS OLIVE
64177 over print (オーバープリント) white stich CAP (smoky mint)
58174 PUNK DRUNKERS [PDSxぷよぷよ]あいつぷよショーツ - A.GREEN
60969 PUNK DRUNKERS 切断アイツTEE - A.GREEN
62855 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 05 - MT.GREEN
63158 over print (オーバープリント) plane LS Tee (dark green)
62545 over print (オーバープリント) SHADOWS LS Tee (dark green)
61510 ANIMALIA AN22SP-JK01 ECWCS LEVEL-4 JACKET OLIVE
61632 PSYCHOLOGICAL METAMORPHOSIS OLD FUTERE CAP GREEN
61565 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - GREEN
61470 Subciety (サブサエティ) BALLOON PANTS KHAKI
61144 SABBAT13 SPOOK CHECK SHIRTS GREEN
59961 PUNK DRUNKERS ギザロゴミニショルダーBAG - MINT
60700 RUDIE'S (ルーディーズ) BLANK KNITCAP NEON GREEN
60641 RIPNDIP Scribble Face Mask (Green)
59553 Zephyren(ゼファレン) JACQUARD CUT L/S GREEN / MIX
60364 RUDIE'S SLICK HAIRBAND NEON GREEN
59135 PUNK DRUNKERS 鮫人パジャマTEE - A.GREEN
59295 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Pistachio
59367 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE GREEN
59856 PANTERA Pot Leaf Logo on Neon Green T-shirt
59261 Jimi Hendrix Unisex Tee: Let Me Live
58575 MISHKA(ミシカ) M21000067 T-Shirt GREEN
58130 MISHKA M21000007 T-Shirt Green
58021 THRASHER (スラッシャー) TH91292 T-Shirt GREEN
55866 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Forest
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
56008 Subciety (サブサエティ) NEON SOCKS GREEN
55554 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE KHAKI
55677 RIP DESIGN WORXX ディスグースマスクTシャツ GREEN
48519 GoneR GR21CT002 Grave Rose T-Shirts Lime
54683 MAGICAL MOSH MISFITS MxMxM ZOMBIES TEE DOKU
54686 MAGICAL MOSH MISFITS MxMxM どろどろ BB CAP GREEN
54687 MAGICAL MOSH MISFITS MxMxM どろどろ BB CAP DOKU
5546 ROLLING CRADLE DOT×DOT NECK WARMER Turquoise
8222 VANS APPAREL Elite Beanie Classic BLUE
8354 PENNYWISE All or Nothing T-Shirt BLACK
9139 CREATURE FU LONG SHOREMAN BEANIE GRN/BLK
9333 MISHKA (ミシカ) NEW ERA: OVERSIZE ADDER DARK GREEN
9335 MISHKA (ミシカ) NEW ERA: LAMOUR KEEP WATCH MAGENTA
13877 FAMOUS STARS AND STRAPS PACK-ONE Stickerx12
14794 RUDIE'S SPARK BORDER KNIT CAP GREEN
14795 RUDIE'S SPARK BORDER KNIT CAP GREEN BLUE
15152 ROLLING CRADLE ROUGHLY KNIT CAP/ Green
15543 RIP DESIGN WORXX スナップバックキャップ emerald
19091 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ GREEN
19698 ZEPHYREN (ゼファレン) BON BON KNIT - DARK GREEN
21137 BEFORE MY LIFE FAILS Deep Green Wool Snapback Cap
21758 ICECREAM SMALL LOGO BEANIE GREEN
22298 PUNK DRUNKERS ワンワンパーカ IVY GREEN
23714 THRASHER MAG emb Oxford L/S SHIRTS ICEGRN
23849 BACK LIFT BUCKET HAT バケットハット総柄 BLUE
23867 MISHKA (ミシカ) SICK SAD KEEP WATCH L/S TIE DYE TEE Lime/Kelly Tie Dye
24890 ROLLING CRADLE GOOD MORNING NASTY / Green
25186 IWRESTLEDABEARONCE Camo Print Camo - T-Shirt
26113 NineMicrophones BEANIE-Bronx- GRN
26292 DROPKICK MURPHYS Boot
26354 Zephyren (ゼファレン) B.B.CAP -BEYOND- GREEN
26430 モーモールルギャバン x Pretty Monkey 限定コラボTシャツ(トライアングル) グリーン
26746 Zephyren (ゼファレン) S/S TEE -VISIONARY- DARK.GREEN
27304 Zephyren (ゼファレン) JACQUARD BON BON KNIT GREEN PAISLEY
27450 MISHKA (ミシカ) LAMOUR KEEP WATCH WAVE TIE DYE TEE Lime Tiger Stripe Tie Dye
28034 SPITFIRE Bighead Fill T-Shirt - Kelly Green/Black
28346 フクザワ アウター女子 手帳型スマホカバー
28893 ROLLING CRADLE BELL HAT / Green
28952 GREEN DAY DOOKIE LOGO T
29066 ANIMALIA AN16A-AC17 BLACK Snood #001 OLIVE
30009 MISHKA (ミシカ) MELTDOWN L/S SHIRT CELADON
32595 RIP DESIGN WORXX ロゴプルオーバーパーカー2017【グリーン】
33631 MISHKA (ミシカ) Adored Longsleeves Celadon
34150 DOCAN! 雀 T-shirt(四暗刻単騎待ち) GREEN
34855 NineMicrophones INDIGO CHECK SHIRT L/S KHAKI
35680 NIRVANA Insecticide Album Cover T-Shirt
35696 RED HOT CHILI PEPPERS Tonal Asterisk-TriBlend Army Green t-shirt
35703 RED HOT CHILI PEPPERS Sketch Asterisk t-shirt Green
36157 PUNK DRUNKERS ピープルパーカ - IVY.GREEN
36259 MISHKA (ミシカ) SM171107TD TEE
36285 HOLDTUBE HT-0173 BLACKxLIME
36660 GREEN DAY GREEN DAY LOGO Beanie
36836 INCUBUS Washout Photo Soft T-Shirt
37432 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Orange
37433 ROLLING CRADLE CYCLOPS SHOUT MINI POUCH / Green
37604 ROLLING CRADLE THE UFO BEAM NECK WARMER / Green
38131 Gluttonous Slaughter(グラトナス・スローター) The Defleshed BLK/GRN
38675 REBEL8 Bite It Beanie Green
39191 STAY SICK CLOTHING Anchor Tie Dye Pullover[B]
40525 PUNK DRUNKERS 手帳型スマホケース(PKDSS)
40622 RIP DESIGN WORXX UNLUCK CANDYパーカー ミント
40638 RUDIE'S PHAT 2TONE PANELCAP GREEN/BLUE
40926 ROLLING CRADLE RC-A1557 RC SMARTPHONE CASE VAGABOND HOOP Multi
41162 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Mint
41331 ANIMALIA AN18U-CP03 KSKUN LOW CAP GREEN
41568 RUDIE'S 85012 ROCKFES HOLIC-T MINT
41784 FILA FM9487 GRAPHIC T-SHIRT NEON YELLOW
41797 ROLLING CRADLE CARGO CAMO SHORTS Green
41897 ROLLING CRADLE RC VULGAR SHIRT Green