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-28 16:24:07')
AND FIND_IN_SET(12, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
34390 PUNK DRUNKERS 【PDSxTREST】TPU iPhone case(花の妖精)
50906 Subciety (サブサエティ) CHECK SHIRT -TAG- GREEN
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
5546 ROLLING CRADLE DOT×DOT NECK WARMER Turquoise
7979 Subciety COIN CASE GREEN
8222 VANS APPAREL Elite Beanie Classic BLUE
8354 PENNYWISE All or Nothing T-Shirt BLACK
9139 CREATURE FU LONG SHOREMAN BEANIE GRN/BLK
9234 Subciety MESH CAP -OMG- DARK GREEN
9333 MISHKA (ミシカ) NEW ERA: OVERSIZE ADDER DARK GREEN
9335 MISHKA (ミシカ) NEW ERA: LAMOUR KEEP WATCH MAGENTA
10360 RUDIE'S SPARK BADGE GREEN/PINK
10773 MISHKA (ミシカ) D.A. SNAKEBITE POM BEANIE GREEN
11621 KILL STAR CLOTHING GET HIGH CREW [MULTI]
11735 SLIP&Co. 13 FOOTBALL TOP Green/Yellow
11909 MISHKA (ミシカ) D.A. SNAKE BITE POM BEANIE GREEN
12491 STANCE SOCKS PALMS OUT
12502 STANCE SOCKS PLAYA DE PALM
13259 LOWLIFE Thrash Digtal print
13368 IRON FIST CLOTHING SPINELESS PETER PAN COLLAR BLOU
13383 IRON FIST CLOTHING SKIN CRAWLER PEEP TOE PLATFORM
13482 MISHKA (ミシカ) LAMOUR CYCO BOOTLEG POM BEANIE
13506 MISHKA (ミシカ) KIRBY CAMO SNIPER JACKET
13801 Subciety TIE DYE PARKA-GLORIOUS- GREEN
13859 RUDIE'S BRICKS ACRYLIC KEYHOLDER GREEN/CLEAR
13877 FAMOUS STARS AND STRAPS PACK-ONE Stickerx12
13880 FAMOUS STARS AND STRAPS OG BOH Sticker MINT/BLACK
14273 Subciety BON BON KNIT-SALOON- GREEN
14527 PUNK DRUNKERS にっとっとカーデ MINT
14576 SO SO HAPPY Tribe Hoodie In Green
14626 MISHKA (ミシカ) KEEP WATCH SAFARI POM BEANIE GREEN
14790 RUDIE'S SPARK KEYHOLDER GREEN
14794 RUDIE'S SPARK BORDER KNIT CAP GREEN
14795 RUDIE'S SPARK BORDER KNIT CAP GREEN BLUE
14806 THRASHER PATCH BEANIE GREEN
14847 ICECREAM CONES&BONES SWET GREEN
14869 SO SO HAPPY Tribe Mini Plush
15152 ROLLING CRADLE ROUGHLY KNIT CAP/ Green
15172 フクザワ 腹白ちゃんあいぽんけーしゅ
15264 ZEPHYREN (ゼファレン) COIN CASE -BEYOND- GRN
15543 RIP DESIGN WORXX スナップバックキャップ emerald
15949 DROP DEAD CLOTHING Snow Parka Green Ladies
15950 DROP DEAD CLOTHING Snow Parka Green
15988 DROP DEAD CLOTHING Bad Luck Keyring
16451 NineMicrophones CARGO SHORTS BLK
16604 Subciety TIE DYE ZIP PARKA-EMOTION- GRN
16623 DEADHEARTZ BUG TEES TIE DIE
16663 ROLLING CRADLE POP-ART CRAZY SHIRT / BigCrazy
16664 ROLLING CRADLE POP-ART CRAZY SHIRT / SmallCrazy
16740 バックドロップシンデレラ よのっしー缶バッヂ(小) 緑
17255 Zephyren MESH CAP -VISIONARY- - DARK.GREEN
17608 RUDIE'S TUSK CHECK SHIRTS GREEN
17795 Hi-STANDARD HS BIG STICKER 03
17805 Hi-STANDARD METAL KEYHOLDER GREEN/ORANGE
19091 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ GREEN
19185 ANGRY FROG REBIRTH 缶バッジ イラスト
19698 ZEPHYREN (ゼファレン) BON BON KNIT - DARK GREEN
20072 VANS APPAREL SPICOLI 4 SHADES PEACH
20201 BLACK HOLE BUNNY 缶バッジ guiltless
20650 Subciety (サブサエティ) EMBROIDERY SHIRT L/S-GLORIOUS- OD
20666 Subciety CRAZY CHECK SHIRT L/S-Praha- GREEN
20671 Subciety GINGHAM CHECK SHIRT L/S-GLORIOUS- GREEN
21131 BEFORE MY LIFE FAILS BMLFCULT Color Tee Light
21133 BEFORE MY LIFE FAILS Sunglasses - Solaris
21136 BEFORE MY LIFE FAILS Sunglasses - Fires
21137 BEFORE MY LIFE FAILS Deep Green Wool Snapback Cap
21196 ZOX STRAPS FRESH HEADBAND
21248 ZOX STRAPS LABYRINTH
21267 激ロック Rubber Key holder PUR/GRN
21269 激ロック Rubber Key holder PNK/GRN
21429 ZOX STRAPS MONA
21433 ZOX STRAPS CANARY
21438 RUDIE'S BRISTLE CHECK HOOD SHIRTS GREEN
21456 THRASHER LOGO KINTTED GREEN
21758 ICECREAM SMALL LOGO BEANIE GREEN
22298 PUNK DRUNKERS ワンワンパーカ IVY GREEN
22314 PUNK DRUNKERS クマさんステッカー
22592 【ゲキクロ限定カラー】打首獄門同好会 プリンパンクTシャツ
22623 Bentham 折りたたみボールペン GREEN
22629 Bentham マフラータオル ミント
22675 THRASHER MAG LOGO SNAPBACK 17TH-C50 NVY/LIM
22842 PUNK DRUNKERS O.F.TEE08.2016 EMERALD
23099 Subciety GLORIOUS S/S BLUE
23526 NineMicrophones 9MICS Crew S/S - GREEN/YELLOW
23622 PUNK DRUNKERS 【PDSxこびとづかん】こびとどらんかーずTEE P.GREEN
23626 PUNK DRUNKERS 89ボールロンTEE IVY.GREEN
23673 SPITFIRE Bighead Green/Heather Grey
23714 THRASHER MAG emb Oxford L/S SHIRTS ICEGRN
23764 9mm Parabellum Bullet ロゴタオル エメラルドグリーン
23768 9mm Parabellum Bullet ワッペン ホワイト×エメラルドグリーン
23849 BACK LIFT BUCKET HAT バケットハット総柄 BLUE
23855 BACK LIFT RUBBER KEYHOLDER GREEN
23867 MISHKA (ミシカ) SICK SAD KEEP WATCH L/S TIE DYE TEE Lime/Kelly Tie Dye
24019 ANIMALIA AN16U-TE08 LONG HORN OLIVE
24133 グッドモーニングアメリカ ジャンプミラー
24140 【限定デザイン】グッドモーニングアメリカ 缶バッジセットA
24147 グッドモーニングアメリカ たなしんサングラス グリーン
24233 SpecialThanks missaタオル LIME
24234 SpecialThanks MOVE ONタオル
24246 SpecialThanks 折りたたみボールペン GRN
24312 キバオブアキバ KOA ラバーキーホルダー GRN
24505 RIP DESIGN WORXX 666 SWASH LOGO RUBBER KEY HOLDER EMERALD×ORG
24561 PROTEST THE HERO Crest Logo Forest Green - Snapback Hat
24751 WHITECHAPEL Strike Through Army Green - 5 Panel
24890 ROLLING CRADLE GOOD MORNING NASTY / Green
24984 PUNK DRUNKERS ベスト30パッカブルパーカ LIME
25049 ROLLING CRADLE WAIKIKI SHORTS / Tropical
25186 IWRESTLEDABEARONCE Camo Print Camo - T-Shirt
25226 MISS FORTUNE Logo Green (Glow In The Dark) - Wristband
25274 DOCAN! KAMINARI BANDANA Green
25292 PUNK DRUNKERS カメさん靴下 BLUE
25294 PUNK DRUNKERS カメさん靴下 RED
25396 SQUARE (スクエア) i-PHONE CASE PINUP ALOHA GREEN iPhone6/6s case
25397 SQUARE (スクエア) i-PHONE CASE PINUP ALOHA GREEN iPhone5/5s case
25428 SQUARE (スクエア) D.F.T.L. Ts LIME
25497 ROLLING CRADLE OVER GROW SHIRT / Green
25499 ROLLING CRADLE OVER GROW SHORTS / Green
25595 Subciety REVERSIBLE WOOL MA-1 BLACK-OD GREEN
25602 Subciety WOOL STADIUM JACKET-Reborn- GREEN
25734 Subciety SWEAT-MELT GLORIOUS- BLACK-GREEN