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 21:02:58')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
23847 BACK LIFT タイダイTシャツ TROPICAL
23928 a flood of circle AFOC LOGO TEE WHT
23929 a flood of circle AFOC LOGO TEE BLUE
26419 モーモールルギャバン 復活ツアーTシャツ ウーマン ピンク
26420 モーモールルギャバン 復活ツアーTシャツ ロゴ ピンク
26426 モーモールルギャバン 【Tour2015】ハンドTシャツ ピンク
26427 モーモールルギャバン 【Tour2015】ハンドTシャツ ネイビー
26430 モーモールルギャバン x Pretty Monkey 限定コラボTシャツ(トライアングル) グリーン
28546 【限定アイテム】ササノマリイ M(OTHER) Tシャツ
39858 PassCode YACHI Pouch Special Edition
15171 フクザワ 知らん女の自撮りTシャツ
15886 フクザワ 飼われ男 Tシャツ
21083 フクザワ あの日のこと Tシャツ
28349 フクザワ 白昼夢 Tシャツ
36971 フクザワ 【まったり】 Tシャツ
64076 AFFECTER (アフェクター) COLLEGE LOGO CAP ORANGE
64077 AFFECTER (アフェクター) COLLEGE LOGO CAP GRAY
64078 AFFECTER (アフェクター) COLLEGE LOGO CAP BLACK
23944 amazarashi higashizm tour T-shirts【ピンク】
26442 【ゲキクロ限定】amazarashi sekaibuki T-shirt L.V edition typeB
42513 RIP DESIGN WORXX BEACH SANDAL LADIES
60857 TRAVAS TOKYO【トラバストーキョー】Frill spare collar Black
67988 over print(オーバープリント) knit tie (green)
64092 Meltyglow (メルティグロウ) 裾レース付きパンプキンパンツ
18604 Subciety (サブサエティ) METAL NECKLACE-JESUS- BLACK
20193 KEYTALK ボーダーTシャツ赤
21086 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT BLK
21087 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT WHT
23856 FOUR GET ME A NOTS Chie Tシャツ
24434 【限定カラー】あゆみくりかまき MATAGI IN DA HOUSE Tシャツ
36284 HOLDTUBE HT-0172 REGULAR GO CAMP
37234 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ ライトピンク
37235 魔法少女になり隊×ハジメ☆ファンタジーコラボTシャツ スカイ
42629 KEYTALK シンプルロゴ刺繍Tシャツ バナナ
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
49824 KILL STAR CLOTHING Kyra Ring
51191 SLIPKNOT TURNTABLE SLIPMAT SET: THE GRAY CHAPTER
53930 KEYTALK 繋がるKEYTALKロゴTシャツ WHITE
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
58435 Survive Said The Prophet SIDE TAG BEANIE GRAY
58436 Survive Said The Prophet SIDE TAG BEANIE BLACK
58437 Survive Said The Prophet REDEFINE TYBEK BAG BLACK
60641 RIPNDIP Scribble Face Mask (Green)
62572 Survive Said The Prophet TRADITIONAL TEE
62573 Survive Said The Prophet "INFINI" TEE NATURAL
62992 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 折りたたみ傘
68245 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG NATURAL
68246 TOY MACHINE (トイマシーン) W MOUSEKATER CANVAS TOTE-BAG GRAY
68785 美園 礼音 × LONELY論理 コラボ限定ソックス
69232 パラッパラッパー ワンポイントロゴ刺繍ニットCAP BLACK
69310 高木美佑×DI:VISION×GEKIROCK CLOTHINGスペシャル・コラボ・ソックス
70453 瀬戸リカ×GoneR コラボ限定サコッシュ
70456 月見山 渚×アマツカミ コラボ限定ソックス
71451 【予約商品】 椎名 立希×AILE VIVANTES コラボ限定ドッグタグ
68206 バンドじゃないもん!MAXX NAKAYOSHI×GEKIROCK CLOTHING×KAVANE Clothingコラボ・ドッグタグ
919 The Devil Wears Prada Virus Allover Print T-Shirt
4349 ENTER SHIKARI Destabilize Tour Black
9415 WE CAME AS ROMANS Sideways Black Tank Top
9424 WHITECHAPEL Riot Black T-Shirt
9433 OH SLEEPER Endseekers T-Shirt
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
11236 WOE IS ME Circus Revenge Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11261 CHUNK!NO,CAPTAIN CHUNK! Bats Navy
11284 ENTER SHIKARI Stealth Black
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11311 ENTER SHIKARI Return To Black
11419 CAPTURE THE CROWN Doggie Black
11436 ATTILA Reaper Navy/Heather Tank Top
11440 TEXAS IN JULY Bed Of Nails Black
11451 TEXAS IN JULY Without A Head! Black
11939 AMON AMARTH LOGO RUNE T-Shirt
12026 MEGADETH EXPLODING VIC T-Shirt
12067 PANTERA HOSTILE SKULL T-Shirt
17973 UNEARTH SKATE RAGE
19096 ATTILA Bad Reputation Black
19134 SLEEPING WITH SIRENS Tough As Nails Silver T-Shirt
19836 MAYDAY PARADE Upstage White Tank Top
21123 ATTILA Rage Tomahawk Royal Blue
21124 ATTILA Dirty Black
21125 BEARTOOTH Generation Of Disorder Black
21220 ATTILA RageAholics Red - T-Shirt
22588 WATCHOUT! THERES GHOSTS MONSTER TEE
24541 ATTILA Fuck Your Shit Camo Black - T-Shirt
24662 ISSUES I Have Issues Black - T-Shirt
24672 SLEEPING WITH SIRENS Floral Black - T-Shirt
24679 SLEEPING WITH SIRENS Sealed Lips Black - T-Shirt
24680 SLEEPING WITH SIRENS Punk Patch Black - Girls/JRS t-shirt
24704 MEMPHIS MAY FIRE Smokey Black - T-Shirt
24748 WHITECHAPEL Pyro Black - T-Shirt
24755 WHITECHAPEL Crate Black - T-Shirt
24756 WHITECHAPEL Sawblade Maroon on Charcoal - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24758 WHITECHAPEL Sawblade Camo on Black - T-Shirt
24762 NORTHLANE Glitch Navy - T-Shirt
24892 NORTHLANE Terence White - T-Shirt
25009 THE STORY SO FAR Snake Girl White - T-Shirt
25127 THE STORY SO FAR Snakes Black - T-Shirt
25132 SEAWAY Colour Blind Logo Black - T-Shirt
25134 SEAWAY Colour Blind TV Logo Yellow - T-Shirt
25137 SEAWAY Crystal Ball Black - T-Shirt
25158 WE CAME AS ROMANS TROY White - T-Shirt
25166 WE CAME AS ROMANS Conquer Maroon - T-Shirt
25193 IWRESTLEDABEARONCE Witch Black - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
25230 LIKE MOTHS TO FLAMES Pizza Black - T-Shirt
25232 LIKE MOTHS TO FLAMES Baseball Black - T-Shirt
25248 CAPTURE THE CROWN Banners Red - T-Shirt
25257 CAPTURE THE CROWN We Are All Royalty Black - T-Shirt
25264 A SKYLIT DRIVE Hangin' So Loose White - T-Shirt
25302 BEFORE THEIR EYES Cross Black - T-Shirt
25307 CHIODOS This is Love CRAIG Black - T-Shirt
25308 CHIODOS Snowman Black - T-Shirt
25415 I SEE STARS Old Dude
25443 MAYDAY PARADE Dying To Meet You Black - T-Shirt