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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-21 10:53:19')
AND pc.price02 > 2727
AND price02 <= 4545
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
65311 ZERO EVOKE Split EVOKE Tee 【BLACK】
65315 ZERO EVOKE Spider Tee 【BLACK】
12725 NEW BREED BACK PRINT T-Shirt BLACK
19854 DIAWOLF TIGER WITH WOLF T-Shirt - BLACK
20027 ARTEMA HORSE T-Shirt BLK/RED
22851 四星球 モンスターTシャツ(黒)
26428 モーモールルギャバン 【Tour2015】ロゴTシャツ 黒
30122 BAND-MAID ツアーTシャツ
30127 BAND-MAID ツアーファイナルTシャツ Red / Gray Japan Final
31741 Xmas Eileen ONLY THE BEGINNING ツアーTシャツ
32176 BAND-MAID Brand New MAID Tシャツ KagaMI Design A Pink / Cream
32207 限定カラー BAND-MAID KAgaMIデザインTシャツ RED×PINK
32208 限定カラー BAND-MAID KAgaMIデザインTシャツ GREEN×YELLOW
33905 BAND-MAID KAgaMI Design SKULL T-SHIRT
33907 BAND-MAID KAgaMI Design MAID T-SHIRT
15171 フクザワ 知らん女の自撮りTシャツ
36971 フクザワ 【まったり】 Tシャツ
43297 ヒステリックパニック キラーT BLACK/PINK
43298 ヒステリックパニック キラーT BLACK/PURPLE
59065 Subciety (サブサエティ) cardinal S/S - BLACK
59115 MAGICAL MOSH MISFITS ポちゃんバーガー TEE BLUE
29950 amazarashi new logo T-shirt BLACK
47280 PassCode T.Y.O.T Tour 刺繍 T-shirt
57393 FILA FS3021 T-Shirt BLACK
20162 AA= #1 LOGO TEE BLK
20166 AA= SETAGAYA TOUR TEE
21086 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT BLK
21472 アーバンギャルド 爆発する鬱Tシャツ
24434 【限定カラー】あゆみくりかまき MATAGI IN DA HOUSE Tシャツ
24435 【限定デザイン】あゆみくりかまき ヴィレッジヴァンガード×ゲキクロ限定Tシャツ
26156 AA= #5 LOGO TEE (BK)
26157 AA= PIG TEE (BK)
26522 Hi-STANDARD LIVE AT AIR JAM 2011 TEE BLACK
26523 Hi-STANDARD AMGRY FIST TEE SILVER
26525 Hi-STANDARD NO NUKES TEE BLACK
27829 UNDEAD CORPORATION Flash Back Tシャツ
32227 ヒステリックパニック ハツT 赤
32228 ヒステリックパニック ハツT 緑
32229 ヒステリックパニック マーダーT
32231 ヒステリックパニック おしゃんT 黒
32232 ヒステリックパニック 地獄のぬこT
32504 【ヒステリックパニック×PassCode】 Hysteric Devil T-Shirt - BK(ゲキクロ限定カラー)
34422 AA= CATTLE MUTILATION TEE (BK/OR)
41754 Survive Said The Prophet WABI SABI TEE (BLACK)
42626 KEYTALK シンプルロゴ刺繍Tシャツ ブラック
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
43301 ヒステリックパニック 悪魔のぬこT BLACK
43307 ヒステリックパニック バフォメッT
46179 Survive Said The Prophet SAMA TEE
49717 Survive Said The Prophet 3AM TEE
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
50371 MODERN DAY BABYLON Indian T-shirt
54614 Survive Said The Prophet INSIDE YOUR HEAD TEE BLACK
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
54617 Survive Said The Prophet STANDARD TEE
56211 Anti Social Social Club California Black Tee
58429 Survive Said The Prophet REDEFINE TEE BLACK
58767 SILLENT FROM ME FILLM -Pocket- BLACK
60271 MISHKA M61000053 T-SHIRT BLACK
62238 Zephyren(ゼファレン) SWITCHING TEE FLOWER
64930 MISHKA (ミシカ) M21100064 T-SHIRT BLACK
64989 over print(オーバープリント) E.T. Tee 2 (black)
63306 GoneR (ゴナー) GR33CT002 Panther Tiger T-Sirts Black
23643 amazarashi sekai syusoku T-shirt
29952 amazarashi kyomubyo T-shirt typeB
60715 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / BLACK
62777 ROLLING CRADLE CNS TEE / BLACK
60163 Anti Social Social Club I SEE GREEN BLACK TEE
60164 Anti Social Social Club I SEE GRAPE BLACK TEE
65011 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BK)
47292 PassCode TONIGHT T-shirt
595 CHILDREN OF BODOM-Bloody Reaper
912 BRING ME THE HORIZON BELANGER T-Shirt
2246 BRING ME THE HORIZON LADY OF LIFE T-Shirt
2251 SLIPKNOT 9 FRAMES T-shirt
3156 AVENGED SEVENFOLD SWEET SCREAM T-shirt
3160 CHILDREN OF BODOM REAPER LIGHTNING T-shirt
3410 UNEARTH RIBS T-Shirt
3465 DEFTONES WHITE PONY T-Shirt
5601 CHELSEA GRIN CROW T-Shirt
6022 OF MICE & MEN Ice Age Black
6023 WOE IS ME - Number[s] Stack Black
6581 A DAY TO REMEMBER BROKEN RECORD T-Shirt
6585 GREEN DAY SPIRAL T-Shirt
7445 MAYDAY PARADE All I Do Black
7466 MEMPHIS MAY FIRE Richer Black
7477 ISSUES These Colors Don't Bleed Black
8336 PARKWAY DRIVE Deep Blue Skyline T-Shirt BLACK
8354 PENNYWISE All or Nothing T-Shirt BLACK
8377 ALESANA Skeleton Heart T-Shirt BLACK
9173 MOTIONLESS IN WHITE America Black T-Shirt
9175 MOTIONLESS IN WHITE Chris Photo Black
9179 MOTIONLESS IN WHITE London In Terror Black
9372 BLESS THE FALL Lyric Black T-Shirt
9386 CHELSEA GRIN Evolve Black T-Shirt
9404 SHADOWS FALL Wasteland Black T-Shirt
9424 WHITECHAPEL Riot Black T-Shirt
9427 FACELESS Casting The Darkness Black T-Shirt
9692 SUICIDAL TENDENCIES ST TS 28 Possessed BLK
10228 ASKING ALEXANDRIA RIDE FOR DEATH T-Shirt
10229 AVENGED SEVENFOLD END OF DAYS T-Shirt
10254 NOFX BUZZ T-Shirt
10257 GUNS N' ROSES APPETITE TOUR T-Shirt
10260 RANCID 40 oz T-Shirt
10264 FIVE FINGER DEATH PUNCH WOTF NINJA T-Shirt
10271 GREEN DAY PATCHWORK T-Shirt
11243 ENTER SHIKARI Blue Tour Navy
11250 ESKIMO CALLBOY Hairy Black T-Shirt
11254 BLESS THE FALL We Are The Saints Black
11256 MAYDAY PARADE Photo Collage Black
11295 SECRETS Floral Skull Black
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11305 ENTER SHIKARI Band Charcoal
11308 MOTIONLESS IN WHITE Grim Reaper Black
11419 CAPTURE THE CROWN Doggie Black
11438 LIKE MOTHS TO FLAMES Snakes & Heart Black T-Shirt
11443 CROWN THE EMPIRE Skull Book Green Black
11451 TEXAS IN JULY Without A Head! Black
11901 ASKING ALEXANDRIA EAGLE T-Shirt
11936 AMON AMARTH FIRE HORSES T-Shirt