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-05-01 16:11:10')
AND FIND_IN_SET(7, p.color)
AND pc.classcategory_id1 IN( 159)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
38134 Gluttonous Slaughter(グラトナス・スローター) The Defleshed BGD
59865 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BURGANDY
58522 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボTシャツ 如月 愛海 (きさらぎ めぐみ)
39297 REBEL8 MYERS EMBROIDERED TEE BURGUNDY
47369 RUDIE'S (ルーディーズ) MONSTER-T BURGUNDY
44266 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Red
34071 Zephyren(ゼファレン) S/S TEE -melt hand- BURGUNDY
49709 RIP DESIGN WORXX サマーロゴT2019 GHOST
42542 Zephyren(ゼファレン) S/S TEE 京都大作戦2018×Zephyren 鵺 RED
57323 Subciety×仮面ライダードライブ DRIVE S/S RED
55555 PSYCHOLOGICAL METAMORPHOSIS WIRE SS TE BURGANDY
41658 PUNK DRUNKERS 【復刻シリーズ】般若TEE RED
43117 RIP DESIGN WORXX 謎袋2018夏
41076 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 BLACK / RED
60697 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT RED
36874 THRASHER TH8301-S MAG LOGO SLEEVE PRINT LONGSLEEVE TEE RED
47429 MISHKA MSS190012 T-SHIRT RED
45631 MISHKA MSS190001F75 T-SHIRT
29568 Aldious LIVE 2016 Tシャツ ブラック x ピンク
26310 Zephyren (ゼファレン) TIE DYE S/S TEE -VISIONARY- BURGUNDY
62669 PUNK DRUNKERS (パンクドランカーズ) タイダイきのこTEE - RED
22114 THRASHER TH8401 MAG LOGO SWEAT BURGUNDY/WHITE
45680 MISHKA x MISFITS Halloween L/S Tee BLACK
59230 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLACK×RED
52443 STAPLE Neo Sport Nylon Hoodie
41592 RIP DESIGN WORXX サークルロゴTシャツ RED/WHITE
28395 THRASHER (スラッシャー) TH8101 MAG LOGO TEE BURGUNDY
48520 GoneR GR21CT002 Grave Rose T-Shirts Red
61543 ZERO EVOKE Logo Second PARKA RED
41287 PSYCHOLOGICAL METAMORPHOSIS PLMP TEE RED
41290 PSYCHOLOGICAL METAMORPHOSIS PLMP LOGO 2 BURGUNDY
49863 PSYCHOLOGICAL METAMORPHOSIS PLMP CARD TEE RED
49865 PSYCHOLOGICAL METAMORPHOSIS PLMP MARK 3 RED
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
58361 KILL STAR CLOTHING Mika Knit Sweater
59366 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE RED
41070 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 BLACK / RED
41073 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / RED
53134 RUDIE'S DRAWING-T BURGUNDY
53184 ALL TIME LOW UNISEX TEE: DA BOMB
60167 MISHKA X DENNIS THE MENACE TROUBLE MAKER HOODIE RED
67977 YUNGBLUD UNISEX T-SHIRT: R-U-OK?
70950 RED HOT CHILI PEPPERS UNISEX T-SHIRT: RED CIRCLE ASTERISK (ECO-FRIENDLY)
28968 PUNK DRUNKERS DQNトレーナー BURGUNDY
41161 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Red
41280 PSYCHOLOGICAL METAMORPHOSIS PLMP HEAVY CIRCLE BURGUNDY
43376 PUNK DRUNKERS SNSトレーナー ENJI
47840 ROLLING CRADLE ZOMBIE LAND ROLICLE / Red
49874 PSYCHOLOGICAL METAMORPHOSIS PLMP FLOWER TEE BURGANDY
50333 GoneR GR22LS002 Rose Sleeve L/S T-Shirts Red
54680 MAGICAL MOSH MISFITS SANTA CRUZ x MxMxM “MAGICAL SCREAMING HAND” TEE WHITE
65778 アマツカミ 悲嘆/grief Hoodie
67664 PUNK DRUNKERS(パンクドランカーズ)アイツ大佐TEE - RED
69106 PUNK DRUNKERS(パンクドランカーズ)NEKOCATS.TEE'23 / REVIVAL BURGUNDY
69086 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / RED
47072 GoneR (ゴナー) GR20LS003 Rose Logo L/S T-Shirts Red
47081 GoneR (ゴナー) GR20LS001 Color Maria Logo L/S T-Shirts Red
53041 SABBAT13 PARADISE T BURGANDY
41703 ROLLING CRADLE DISNEY T-SHIRT "Snow White and the Seven Dwarfs" / Red
50142 SLEEPING TABLET SLEEPY [ POCKET TEE ] RED
63719 over print (オーバープリント) planet Tee (azuki)
69211 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Red
69214 GoneR(ゴナー) GR37CT003 Mix Design T-Shirt Black/Red
46753 FILA FM9546 Jacket Flame red
50549 RIP DESIGN WORXX グラフィティロゴロングスリーブTシャツ WINE
58777 Non Stop Rabbit×GEKIROCK CLOTHING コラボ・ロンT RED
41889 MISHKA (ミシカ) MAW180466 HOOD Red
43826 REBEL8 LAURELS TEE BURGUNDY
49876 PSYCHOLOGICAL METAMORPHOSIS PLMP L/S LOGO 2(NEW COLOR) RED
54098 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO L/S TEE RED
57197 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE RED
62791 GoneR (ゴナー) GR32LS003 Tie-dye One Point Logo L/S T-Sirts Red
52894 ANIMALIA AN20SP-TE06 SLANT-L/S Tee RED
68012 【BanG Dream! ×ゲキクロ 2023 ver.】今井リサ×RIP DESIGN WORXX コラボ Tシャツ
46237 RUDIE'S MIGHTY LS-T BURGUNDY
63289 【ゲキクロ限定】RIP DESIGN WORXX SxMxHコラボ・ロンT RED
63811 Subciety(サブサエティ) FIVE LIGHTS TEE BURGUNDY
70724 Subciety (サブサエティ) Hard Days TEE BURGUNDY
71533 NineMicrophones (ナインマイクロフォンズ) Pray with the microphone TEE BURGUNDY
38872 LILWHITE(dot) (リルホワイトドット) -VICTIM- L/S TEE RED
42171 Zephyren(ゼファレン) PARKA -DOOR- BURGUNDY
47594 FILA FM9618 Graphic LS T-shirt RED
68869 DI:VISION (ディヴィジョン) DIVI LS Tee RED
28459 Gluttonous Slaughter (グラトナス・スローター) Gluttonous Creatures HOODIE BURGUNDY
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
52671 REBEL8×SLAYER Black Magic Tee
38876 LILWHITE(dot) (リルホワイトドット) -REQUIEM- L/S TEE RED
57269 BRING ME THE HORIZON UNISEX LONG SLEEVED TEE: PARANOID (BACK PRINT)
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
69374 西本りみ×GEKRIOCK CLOTHING×acOlaSia 限定コラボ・ロンT RED
43244 RUDIE'S SPOIL HOOD SWEAT BURGUNDY
61748 RIP DESIGN WORXX ハイドジップパーカー BURGUNDY
55632 Anti Social Social Club FRANTIC RED FLANNEL
55878 GoneR GR26ZP001 Rose Photo Zip Parka Burgundy
58514 ぜんぶ君のせいだ。×GEKIROCK CLOTHING×UNUSUAL コラボパーカー 如月 愛海 (きさらぎ めぐみ)
56276 RUDIE'S SLICK HOOD SWEAT BURGUNDY
61821 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT RED
65180 Subciety (サブサエティ) RUGGER SHIRT-BURGUNDY
67978 over print(オーバープリント) Pullover Jersey (redorange)
42811 SLEEPING TABLET MOON ZIPHOOD MAROON
44230 FILA FM9513 L/S CN TEE NAVY
44995 FILA FM9537 PULLOVER HOODIE FLAME RED
51217 TOY MACHINE TMF19SW16 BRAINWASH SLEEVE PRINT SWEAT PARKA BURGANDY
52520 RUDIE’S 2020 NEWYEAR PACK
53918 PSYCHOLOGICAL METAMORPHOSIS PLMP WALL PARKA RED
58413 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE PARKA BLK-RED
45919 ROLLING CRADLE CYCLOPS HOLIDAY-WORLD TOUR- / Maroon
51176 SABBAT13 IGOR HOODIE(レッド)
55625 SABBAT13 PENNYWISE HOODIE レッド
42165 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
52447 STAPLE Neo Sport Nylon Crew
56204 Anti Social Social Club Headrush All Over White Hoodie
43362 ROLLING CRADLE BONBON VNECK SHIRT / Gray
51955 Zephyren(ゼファレン) PARKA -PROVE- BURGUNDY
56213 Anti Social Social Club Headrush All Over White Tee
37166 ROLLING CRADLE RAKURAI NEL / Red
44352 Civil Regime 18CV-HL840J ENERGY TECHNO JACKET RED
52667 REBEL8×SLAYER South Of Heaven Pullover Hoodie
61287 LONELY論理 KAMIKAZE CREWNECK BURGUNDY
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-