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:58:54')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.point_rate >1
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
45714 KILL STAR CLOTHING Feri Doll Dress
48233 Zephyren(ゼファレン)PONCHO HOODY S/S WHITE / 如意宝珠
49746 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 戸山香澄ver.
49748 【ゲキクロ限定】Poppin'Party "NO GIRL NO CRY" Sweat Designed by RIPDW 牛込りみver.
49763 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" Sweat Designed by RIPDW GREEN
50445 LIGHTWEIGHT FLY HOODIE BOLT
50818 CHORD NUMBER EIGHT CH01-01K5-AC07 JACQUARD TAPE NECKLACE BLACK&BLACK
50819 CHORD NUMBER EIGHT CH01-01K5-AC07 JACQUARD TAPE NECKLACE ORANGE&BLACK
53888 FILA F0494-1092 DISRUPTOR2 ICE ORANGE
57815 四星球×ゲキクロ 限定コラボ・パーカー ブラック
57817 四星球×ゲキクロ 限定コラボ・パーカー ピンク
57818 四星球×ゲキクロ 限定コラボ・パーカー ライトブルー
58003 RUDIE'S (ルーディーズ) GOOD VIBRATION HOOD SWEAT PINK
59869 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 YELLOW
59870 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 ORIVE
59871 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 GRAY
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
60330 LONELY論理 KAZAGURUMA HEARTS LONG SLEEVE WHITE
60331 LONELY論理 KAZAGURUMA HEARTS LONG SLEEVE BLACK
60339 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT WHITE
60371 GoneR GR30PK001 Chalice Parka Sand Beige
60372 GoneR GR30PK001 Chalice Parka White
62603 HYPER CORE HERE COMES THE PAINフーディー BLACK/BLUE
62625 LONELY論理 LONELISM6 LONG SLEEVE WHITE
62627 LONELY論理 LONELISM6 LONG SLEEVE PINK
62629 LONELY論理 OROCHI TAIJI LONG SLEEVE WHITE
62908 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - BLACK
62909 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - BLUE
62910 PSYCHOLOGICAL METAMORPHOSIS CG SWEAT PANTS - GRAY
64061 Subciety (サブサエティ) HALF SLEEVE SWEAT KHAKI
64063 Subciety (サブサエティ) SWEAT SHORTS GRAY
64065 Subciety (サブサエティ) SWEAT SHORTS BLACK
64284 RIPNDIP (リップンディップ) Aloha Nerm Sweatshorts (Lavender)
65161 BAD BOY (バッドボーイ) AMECOMI LOGO JQD P/O KNIT O.WHITE
65163 BAD BOY (バッドボーイ) AMECOMI LOGO JQD P/O KNIT GREEN
57397 FILA FS3025 HOODIE NAVY
52906 ROLLING CRADLE COMBI VEST / YELLOW
53068 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE WHITE
54046 NOT COMMON SENSE ”KC ALTERNATIVE SOUND” TEE 03
55876 GoneR GR26ZP001 Rose Photo Zip Parka Heather gray
59162 VIRGO TY MOCK NECK WHITE
59844 HYPER CORE T-367 承認欲求がぁる2 -I need your Reply, Retweet & いいね- Tシャツ ブルー×パープル
61853 A FEW GOOD KIDS ICECREAM TEE WHITE
61854 A FEW GOOD KIDS ICECREAM TEE BLACK
61855 A FEW GOOD KIDS ICECREAM TEE BLUE
63773 TOY MACHINE (トイマシーン) TRIPLE PEPPER SECT EMBROIDERY LOOSE FIT CARGO SHORTS - BLAC
63989 VIRGO(ヴァルゴ)BIG HIND BLACK
63990 VIRGO(ヴァルゴ)BIG HIND WHITE
64863 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE WHITE
64864 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE LIGHT BLUE
64865 SUPPLIER (サプライヤー) PYTHON IRON LOGO TEE GRAY
64875 HYPER CORE(ハイパーコア) DISTORTION -The multiverse of HYPERCORE- ジップTシャツ BLACK
64876 HYPER CORE(ハイパーコア) DISTORTION -The multiverse of HYPERCORE- ジップTシャツ PURPLE
64877 HYPER CORE(ハイパーコア) MELON PAIN ジップTシャツ
65009 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/GREEN
60841 GoneR Ska Sweat Parka Sand Beige
60842 GoneR Ska Sweat Parka Mix Grey
61748 RIP DESIGN WORXX ハイドジップパーカー BURGUNDY
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
56293 Subciety (サブサエティ) TROOPER HAT ORANGE
56839 Subcietyx攻殻機動隊 Cyberbrain L/S PURPLE
58453 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S WHITE
58456 Subciety×NARUTO-ナルト- 疾風伝 KAKASHI&GUY L/S BLACK
61525 ANIMALIA AN22SP-PT02 EASY PANTS - Sanskrit Logo BEIGE
61601 HYPER CORE BOOSTスウェット KHAKI
62606 HYPER CORE SICKS MUTE BEARスウェット
63092 HYPER CORE Swallowスウェット WHITE
63601 glamb (グラム) Behind Mosaic Long Sleeve T - Black
63602 glamb (グラム) Behind Mosaic Long Sleeve T - White
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
60645 RIPNDIP Marker Slip On Shoes
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
64115 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ CREW SWEAT ] BLACK
44826 KILL STAR CLOTHING Spook N Destroy Knit Sweater [B]
49213 KILL STAR CLOTHING Omen Kimono Dress [B]
57312 【ゲキクロ限定】 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt White
58092 WASTED PARIS T-shirt Longsleeve Columbia Bridge Yellow
58285 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW BLACK
58286 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW WHITE
58467 HEDWiNG Tie-dye Halfpants Purple
60101 LONELY論理 COTTON FRINGE HIPPIE HAT SAND
60404 GoneR -La Neta- GRL05PK001New York Logo Parka Red
60406 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Red
60407 GoneR -La Neta- GRL05PK001New York Logo Parka Black/Orange
62933 PSYCHOLOGICAL METAMORPHOSIS PLMP CIRCLE NECKLACE - GOLD
62935 PSYCHOLOGICAL METAMORPHOSIS PLMP CIRCLE NECKLACE - PURPLE
63710 NieR (ニーア) 3WAY猫耳付きメイド服風ワンピース【エプロン付き】
64287 RIPNDIP (リップンディップ) Aloha Nerm Swim Shorts (Black)
64962 ROLLING CRADLE RC x KUDAN LOGO TEE / BLACK
64963 ROLLING CRADLE RC x KUDAN LOGO TEE / WHITE
47103 NOT COMMON SENSE FUXX THE POLICE SEAM TEE BLACK
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
61547 ZERO EVOKE ZENON Graphic Logo SWEAT WHITE
63979 VIRGO(ヴァルゴ)SQUARE BLACK
63980 VIRGO(ヴァルゴ)SQUARE WHITE
62587 ROLLING CRADLE BURNED LOGO LONG SLEEVE / YELLOW
62588 ROLLING CRADLE BURNED LOGO LONG SLEEVE / BLACK
37272 KILL STAR CLOTHING(キルスター・クロージング) Obscura Fuzzy Knit Sweater [B]
56424 Subciety (サブサエティ) SERVER L/S - WHITE
58301 KILL STAR CLOTHING Judgement Kimono Tunic
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
61472 NineMicrophones Description L/S BLACK
54071 FILA DISRUPTOR SD WHITE
61149 AFFECTER (アフェクター) NESS HOODIE BLACK
61150 AFFECTER (アフェクター) NESS HOODIE GREEN
61205 XrossOver XOver K logo LongT (White)
44814 KILL STAR CLOTHING Ceremony Flat [B]
52285 あゆみくりかまき×ゲキクロ×ripdw AKM STAR HOODIE
61711 HEDWiNG College logo C/C Longsleeve T-shirt White
64895 acOlaSia (アコレイジア) GAMING ERROR tee WHITE
64898 acOlaSia (アコレイジア) GAMING ERROR tee BLACK
44832 KILL STAR CLOTHING Keiko Kitty Flats [B]
56219 Anti Social Social Club 7734
56220 Anti Social Social Club Sadness Is Happiness
57806 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / A-TYPE
57807 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / B-TYPE
57808 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / A-TYPE