No products in your cart.
View Shopping Cart
TR
EN
|
TL
EUR
USD
0 (850) 808 83 31
info@pianoluce.com
MEN'S CLOTHING
MEN'S CLOTHING
Sportswear
MEN'S CLOTHING | Sportswear
Capri
Track Suits
Velvet Tracksuit
WOMAN
MEN'S CLOTHING | WOMAN
Tulum
Şort Takım
Trousers
Şort
Tunic
Jacket
Blouse
Dress
Poncho
Coat
Cardigan
Vest
Knitwear
Shirt
Jeans
PİJAMA TAKIM
ERKEK
MEN'S CLOTHING | ERKEK
Erkek Mont
Erkek Ceket
Erkek Pantolon
Erkek Takım Elbise
ELEKTRONİK
ELEKTRONİK
Tansiyon Aleti
Küçük Ev Aletleri
Shoes
Shoes
Genuine Leather
Design Shoes
Stiletto
Platform Shoes
Accesories&Bags
Accesories&Bags
Bags
Accesories
Gemstone Bracelet
Gemstone Necklace
Trend Bracelets & Necklaces
Ofis Teknolojileri
Best Sellers
New Products
Sipariş Takibi
Be a Member
Login
Be Our Dealer
Contact Us
TR
EN
|
TL
EUR
USD
My Account Information
|
My Orders
En çok arananlar:
0
Favorite
Order Tracking
My Account
Be Our Dealer
0
My Cart
MEN'S CLOTHING
CLOSE
Sportswear
Capri
Track Suits
Velvet Tracksuit
WOMAN
Tulum
Şort Takım
Trousers
Şort
Tunic
Jacket
Blouse
Dress
Poncho
Coat
Cardigan
Vest
Knitwear
Shirt
Jeans
PİJAMA TAKIM
ERKEK
Erkek Mont
Erkek Ceket
Erkek Pantolon
Erkek Takım Elbise
ELEKTRONİK
CLOSE
Tansiyon Aleti
Küçük Ev Aletleri
Shoes
CLOSE
Genuine Leather
Design Shoes
Stiletto
Platform Shoes
Accesories&Bags
CLOSE
Bags
Accesories
Gemstone Bracelet
Gemstone Necklace
Trend Bracelets & Necklaces
Ofis Teknolojileri
Best Sellers
New Products
Pianoluce
Men'S Clothıng
Woman
WOMAN
Plus Size Woman Wear
Filter
Price
0-50
(9)
50-100
(68)
100-150
(89)
150-200
(60)
200-250
(6)
250-350
(22)
350-3500
(4)
Brand
Lir
(12)
My Style
(18)
Pianoluce
(44)
Schık
(18)
Sorting
Pahallıdan Ucuza
Ucuzdan Pahallıya
Schık Kadın Büyük Beden Kolsuz Elbise A.Haki SCKWM21EL01
$ 14,81
Schık Kadın Büyük Beden Elbise Haki 1569
$ 17,78
My Style Kadın Çiçek Desenli Viskon Gömlek Bej MYS2548
$ 11,85
My Style Kadın Çiçek Desenli Viskon Gömlek Mint MYS2548
$ 11,85
My Style Kadın Oversize Yarasa Kol Saten Gömlek Beyaz MYS9134
$ 25,93
My Style Kadın Oversize Yarasa Kol Saten Gömlek Siyah MYS9134
$ 25,93
My Style Kadın Oversize Yarasa Kol Saten Gömlek Krem MYS9134
$ 25,93
My Style Kadın Belden Bağlamalı Viskon Gömlek Sarı MYS2587
$ 13,33
My Style Kadın Belden Bağlamalı Viskon Gömlek Siyah MYS2587
$ 13,33
My Style Kadın Belden Bağlamalı Viskon Gömlek Fuşya MYS2587
$ 13,33
My Style Kadın Belden Bağlamalı Viskon Gömlek Yeşil MYS2587
$ 13,33
KADIN DESENLİ KUŞAKLI VİSKON TULUM MAVİ MYS26074
$ 26,67
KADIN DESENLİ KUŞAKLI VİSKON TULUM SARI MYS26074
$ 26,67
KADIN DESENLİ KUŞAKLI VİSKON TULUM SİYAH MYS26074
$ 26,67
KADIN DESENLİ KUŞAKLI VİSKON TULUM FUŞYA MYS26074
$ 26,67
KADIN DESENLİ KUŞAKLI VİSKON TULUM TURUNCU MYS26074
$ 25,93
KADIN ÇİÇEK DESENLİ KİMONO ŞORT TAKIM MAVİ MYS26069
$ 22,22
KADIN ÇİÇEK DESENLİ KİMONO ŞORT TAKIM SİYAH MERCAN MYS26069
$ 22,22
KADIN ÇİÇEK DESENLİ KİMONO ŞORT TAKIM SİYAH-SARI MYS26069
$ 22,22
KADIN ÇİÇEK DESENLİ KİMONO ŞORT TAKIM SİYAH-MÜRDÜM MYS26069
$ 22,22
Pianoluce Kadın Büyük Beden Şort Yeşil PLWM22SRT01
$ 11,11
Pianoluce Kadın Büyük Beden Şort Tarçın PLWM22SRT01
$ 11,11
Pianoluce Kadın Büyük Beden Şort Haki PLWM22SRT01
$ 11,11
Pianoluce Kadın Büyük Beden Şort Cobalt PLWM22SRT01
$ 11,11
Lir Kadın Büyük Beden Leopar Desen Truvakar Kol Tunik Siyah LRWM22TNK01
$ 14,81
Lir Kadın Büyük Beden Brodeli Volan Kol Düğmeli Bluz Bordo LRWM22BLZ01
$ 22,22
Lir Kadın Büyük Beden Brodeli Volan Kol Düğmeli Bluz Haki LRWM22BLZ01
$ 22,22
Lir Kadın Büyük Beden Brodeli Volan Kol Düğmeli Bluz Hardal LRWM22BLZ01
$ 22,22
Schık Women's Plus Size Embroidered Half Sleeve Dress Black SCKWM22EL03
$ 25,93
Schık Women's Plus Size Embroidered Half Sleeve Dress Khaki SCKWM22EL03
$ 25,93
Schık Women's Plus Size Embroidered Half Sleeve Dress Claret Red SCKWM22EL03
$ 25,93
Lir Women Plus Size Striped Blouse Beige L2328
$ 12,59
Lir Women's Plus Size Floral Patterned Blouse Black L2329
$ 12,59
Schık Women's Plus Size Embroidered Dress Black SCKWM22EL02
$ 22,22
Schık Women's Plus Size Embroidered Dress Black SCKWM22EL01
$ 25,93
Schık Women's Plus Size Embroidered Dress Khaki SCKWM22EL01
$ 25,93
Schık Women's Plus Size Embroidered Dress Claret Red SCKWM22EL01
$ 25,93
Women's Volan Sleeve Dress Patterned VLN001
$ 7,41
Women's Laopar Viscose Short Sleeve Dress Patterned KRP42
$ 14,81
Women's Floral Patterned Viscose Short Sleeve Dress
$ 14,81
Women's Butterfly Patterned Short Sleeve Dress KRP036
$ 11,85
Women's Floral Patterned Short Sleeve Dress KRP034
$ 11,85
Pianoluce Women's Plus Size Pockets Zipper Closure Lined Coat Khaki PLWM22MO001
$ 22,22
Schık Women's Sleeveless Ruffle Dress Red SCKWM21EL03
$ 6,67
Lyre Women's Large Size Flounce Sleeve Blouse Lilac L2319
$ 11,11
Lyre Women's Large Size Flounce Sleeve Blouse Green L2319
$ 11,11
Schık Women's Plus Size Half Sleeve Dress Navy SCKWM21EL02
$ 9,63
Schık Women Plus Size Power Lycra Fabric Trousers Khaki SCKWM21PNT005
$ 14,81
Schık Women Plus Size Power Lycra Fabric Trousers Gray SCKWM21PNT005
$ 14,81
Schık Women Plus Size Power Lycra Fabric Trousers Navy SCKWM21PNT005
$ 14,81
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS012
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS012
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS011
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS011
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS010
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS010
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS009
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS009
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS008
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Light Burgundy PLWM21TS008
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS007
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Light Burgundy PLWM21TS007
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Light Burgundy PLWM21TS006
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS005
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Light Burgundy PLWM21TS005
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS004
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS004
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Light Burgundy PLWM21TS004
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS003
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS003
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS002
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS002
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Light Burgundy PLWM21TS002
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Black PLWM21TS001
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Indigo PLWM21TS001
$ 8,89
PianoLuce Women's Large Size Printed Half Sleeve T-shirt Light Burgundy PLWM21TS001
$ 8,89
Lir Women Large Size Half Sleeve Dress Navy Blue L1621
$ 9,63
Schık Women Plus Size Sleeveless Dress Green SCKWM21EL01
$ 14,81
Schık Women Plus Size Sleeveless Dress Khaki SCKWM21EL01
$ 14,81
Schık Women Plus Size Sleeveless Dress Mink SCKWM21EL01
$ 14,81
Schık Women Plus Size Sleeveless Dress Black SCKWM21EL01
$ 14,81
Schık Women Plus Size Sleeveless Dress Purple SCKWM21EL01
$ 14,81
Schık Women's Large Size Power Lycra Fabric Leggings Trousers Black-Smoke SCKWM21PNT002
$ 14,81
Schık Women Plus Size Power Lycra Fabric Leggings Trousers Black SCKWM21PNT002
$ 14,81
Schık Women's Large Size Full Lycra Fabric Trousers Navy SCKWM21PNT001
$ 14,81
Schık Women Plus Size Power Lycra Fabric Trousers Black SCKWM21PNT005
$ 14,81
Pianoluce Women's Plus Size Front Zippered Cap with Pocket Zipper Jacket Navy Blue P5109
$ 14,81
Pianoluce Women's Plus Size Front Zippered Hooded Pocket Zipper Jacket P5109
$ 14,81
Pianoluce Women's Plus Size Front Zippered Hooded Pocket Zipper Jacket Anthracite P5109
$ 14,81
Pianoluce Yıkanabilir 3 Katlı Pamuklu 5' lı Maske Siyah P10012
$ 8,89
Pianoluce Washable 3-Layer Cotton 5-layer Mask Red P10012
$ 5,93
Pianoluce Washable 3-Layer Cotton 5-layer Mask Indigo P10012
$ 8,89
Pianoluce Washable 3-Layer Cotton 5-layer Mask Khaki P10012
$ 8,89
Pianoluce Washable 3-Layer Cotton 5-layer Mask Patterned P10012
$ 8,89
Pianoluce Women Stone Embroidered Jeans Black 49122
$ 8,15
Lyre Women Large Size Tights Black L2325
$ 7,41
Lyre Women Big Size Tights Claret Red L2325
$ 7,41
Pianoluce Washable 3-Layer Cotton Mask Patterned P10002
$ 2,96
Pianoluce Washable 3 Layer Cotton Mask Khaki P10002
$ 2,96
Pianoluce Washable 3 Layer Cotton Mask Red P10002
$ 2,96
Pianoluce Washable 3 Layer Cotton Mask Black P10002
$ 2,96
Pianoluce Washable 3 Layer Cotton Mask Indigo P10002
$ 2,96
Pianoluce Women's Plus Size Front Zippered Hooded Pocket Zipper Jacket Anthracite P5106
$ 14,81
Pianoluce Women's Plus Size Front Zippered Hooded Pocket Zipper Jacket P5106
$ 14,81
Pianoluce Women's Plus Size Front Zippered Cap with Pocket Zipper Jacket Navy Blue P5106
$ 14,81
Lir Women Plus Size Long Sleeve Buttoned Blouse Green L2323
$ 7,41
Lyre Women Plus Size Long Sleeve Button Blouse Cinnamon L2323
$ 7,41
Lir Women Plus Size Long Sleeve Buttoned Blouse Black L2323
$ 7,41
Lir Women Plus Size Long Sleeve Buttoned Blouse Claret Red L2323
$ 7,41
Lyre Women Plus Size Skirt Ruffle Long Sleeve Dress Black L1632
$ 13,33
Lyre Women Plus Size Skirt Ruffle Long Sleeve Dress Gray L1632
$ 13,33
Lyre Women Plus Size Long Sleeve Connected V-Neck Blouse Mink L2324
$ 7,41
Lyre Women Plus Size Long Sleeve Connecting V Neck Blouse Green L2324
$ 7,41
Lyre Women Plus Size Belt Three Quarter Sleeve Office Dress Black 1630
$ 14,07
Lyre Women Plus Size Belt Three Quarter Sleeve Office Dress Black 1629
$ 14,07
Lyre Women Plus Size Belt Three Quarter Sleeve Office Dress Black 1627
$ 14,07
Lyre Women Plus Size Skirt Gathered Front Buttoned and Belted Three-Quarter Sleeve Dress Black 1626
$ 20,00
Lyre Women Plus Size Skirt Gathered Front Buttoned Belt Three Quarter Sleeve Dress Khaki 1626
$ 20,00
Lyre Women Plus Size Skirt Gathered Front Buttoned and Belted Three-Quarter Sleeve Dress Indigo 1626
$ 20,00
Lyre Women Plus Size Long Sleeve V Neck Sequin Detail Blouse Claret Red L2316
$ 11,11
Lyre Women Plus Size Frilly Buttoned Three Quarter Sleeve Dress Navy Blue L1623
$ 10,37
Lir Kadın Tulum Siyah 7006
$ 11,11
Lyre Women Plus Size Ruffle Folded Half Sleeve Dress Cinnamon L1625
$ 10,37
Lyre Women Plus Size Pocket Buttoned Dress Claret Red L1624
$ 11,85
Pianoluce Women's Large Size O Neck Printed Half Sleeve Knitted T-Shirt Black P29019
$ 8,89
Lir Women Large Size Half Sleeve Dress Gray L1621
$ 9,63
Lir Women Large Size Half Sleeve Dress Mink L1621
$ 9,63
Lir Women Plus Size Pocket Buttoned Dress Black L1624
$ 11,85
Lyre Women Plus Size Collar Bird Eye Dress Black L1622
$ 9,63
Lir Women Large Size Half Sleeve Dress Red L1621
$ 9,63
Lir Women Plus Size Half Sleeve Dress Black L1621
$ 9,63
Lyre Women Large Size Ruffle Sleeve Blouse Black L2319
$ 11,11
Lyre Women Large Size Ruffle Sleeve Blouse Navy Blue L2319
$ 11,11
Lyre Women Large Size Ruffle Sleeve Blouse Cobalt L2319
$ 11,11
Lyre Women Large Size Ruffle Sleeve Blouse Claret Red L2319
$ 11,11
Schık Women's Large Size Skirt Ruffle Dress Purple 1569
$ 17,78
Lyre Women Large Size Yoke Ruffle Layered Dress Cinnamon L1611
$ 9,63
Lir Women Long Sleeve Lace Detail Hooded Sweatshirt Black L2317
$ 10,37
$ 7,40
Lyre Women Plus Size Long Sleeve V Neck Sequin Detail Blouse Black L2316
$ 11,11
Schık Women Large Size Skirt Ruffle Dress Cobalt 1569
$ 17,78
Lyre Women Plus Size Three Quarter Sleeve Skirt End Lace Detail Dress Black L1608
$ 10,37
Lir Women Plus Size Long Sleeve Leopard Binding Dress Black L1605
$ 10,37
$ 10,37
Lyre Women Plus Size Laopar Patterned Double Breasted Dress Black L1604
$ 9,63
Schık Kadın Büyük Beden Çizgili Bluz Siyah 2308
$ 6,67
Schık Kadın Büyük Beden Elbise Siyah 1597
$ 13,33
Schık Women Plus Size Long Sleeve Dress Claret Red 1597
$ 13,33
Schık Women Large Size Tulle Detailed Dress Black 1595
$ 11,11
Schık Women's Large Size Flower Pattern Dress Green 1587
$ 9,62
$ 6,67
Schık Women Plus Size Dress Navy Blue 1569
$ 17,78
Schık Kadın Cepli Tunik Elbise Siyah 3282
$ 8,89
Schık Women Plus Size Dress Black 1569
$ 17,78
Schık Women Plus Size Dress Claret Red 1569
$ 17,78
Schık Women Pocket Tunic Dress Multicolor 3263
$ 6,67
Schık Kadın Cepli Tunik Elbise Renkli 3262
$ 8,15
Lyre Women Plus Size Blouse Navy Blue 2299
$ 6,67
Lir Women Pareo Black 2298
$ 5,93
Pianoluce Women's Plastered Evening Dress Portfolio Bag Black PLC276
$ 10,36
$ 10,37
Schık Women's Big Size Dress Black 1479
$ 22,21
$ 7,40
Pianoluce Bayan Pelerin Siyah 8028
$ 7,41
Lir Kadın Triko Cepli Tunik Siyah 3257
$ 6,67
Lir Women Knitwear Pocket Tunic Powder 3257
$ 6,67
Lir Kadın Triko Cepli Tunik Hardal 3257
$ 6,67
Schık Women's Large Size Sleeve Lace Dress Black 1478
$ 6,66
Lyre Women Plus Size Sleeveless Dress Brown 0010
$ 7,40
$ 3,70
Lyre Women Plus Size Sleeveless Dress Smoked 0010
$ 7,40
$ 3,70
Schık Women Plus Size Collar Stone Detailed Dress Black 0008
$ 8,88
$ 4,44
Schık Women's Large Size Robes Rose Detailed Dress Navy 0007
$ 10,36
$ 5,18
Schık Women Sleeve Detailed Knitwear Blouse Powder 2279
$ 7,40
$ 5,93
Schık Women Plus Size Patterned Chiffon Dress Green 1466
$ 6,67
Schık Women Plus Size Patterned Chiffon Dress Coral 1466
$ 6,67
Schık Women Large Size Patterned Chiffon Dress Brown 1466
$ 6,67
Pianoluce Bayan Büyük Beden Gül Desenli Ceket Siyah 5084
$ 13,33
Pianoluce Bayan Büyük Beden Tunik Siyah 3237
$ 6,66
Pianoluce Women Skirt Colorful 9010
$ 3,70
Pianoluce Women's Zippered Boot Black suede PLA54
$ 7,41
Pianoluce Women's Zippered Boot Skin Claret Red PLA54
$ 7,41
Pianoluce Women's Zippered Boot Claret Red PLA50
$ 7,41
Lir Bayan Yarım Kollu Baskılı Elbise Desenli 1439
$ 7,41
Pianoluce Women's Denim Back Robes Lace Shirt Navy Blue 4030
$ 19,25
$ 6,67
Pianoluce Women's Denim Sleeve Lace Detailed Dress Navy Blue 1385
$ 8,89
Pianoluce Genuine Leather Summer Laser Cut Women's Shoes Black PLA49-523
$ 14,81
Pianoluce Genuine Leather Summer Laser Cut Women's Shoes Mink PLA49-523
$ 14,81
Pianoluce Plus Size Women Jeans Blue 49108
$ 9,62
$ 7,41
Pianoluce Ladies Linen Trousers Navy 49116
$ 8,15
Lir Ladies Set Strap Dress Navy Blue 1354
$ 11,84
$ 8,15
Pianoluce Woman Skirt 9011 Black
$ 10,37
Pianoluce Genuine Leather Women Shoes Black PLA48-519
$ 14,81
Pianoluce Plus Size Women Jeans Blue 49111
$ 17,77
$ 8,88
Pianoluce Women Laser Cut Bag Brown PLC1003
$ 6,66
Pianoluce Genuine Leather Women Shoes Mink PLA45-512
$ 14,81
Lyre Women Plus Size Dress Navy Blue 1329
$ 7,41
Lyre Women Plus Size Dress Claret Red 1329
$ 7,41
Lyre Women Plus Size Dress Green 1329
$ 7,41
Pianoluce Ladies Bag Brown PLC1002
$ 17,77
$ 5,92
Pianoluce Genuine Leather Women Shoes Black PLA48-519
$ 14,81
Pianoluce Genuine Leather Women Shoes White PLA48-519
$ 14,81
Pianoluce Women Floral Bag Brown PLC1001
$ 20,73
$ 6,66
Pianoluce Women's Thick Heeled Shoes Siyahçınar PLA47-400
$ 9,63
Pianoluce Women's Thick Heeled Shoes Sedefçınar PLA47-400
$ 9,63
Pianoluce Genuine Leather Women Shoes Green PLA46-511
$ 14,81
«
»
1
2
Tulum
Şort Takım
Trousers
Şort
Tunic
Jacket
Blouse
Dress
Poncho
Coat
Cardigan
Vest
Knitwear
Shirt
Jeans
PİJAMA TAKIM
SELECT sira,barkod, kuryesel, resALT,urunler.resID2,urunler.res_uzanti2,urunler.url as urlana, urunler.id, urunler.IsDesigned, urunler.pageview, urunler.FabricIdentityKey, CASE WHEN urunler.stok_sanal>0 THEN 0 ELSE 1 END AS stokgosterim , urunler.aciklama_ozet, urunler.aciklama_on, CASE WHEN dil_ceviriler.urunad IS NULL or dil_ceviriler.urunad='' THEN case when urunler.tedarikci='pikap@pikapflowerdesign.com' or urunler.tedarikci='pianoluce@pianoluce.com' then urunler.meta_title else urunler.ad end ELSE dil_ceviriler.urunad END as ad, CASE WHEN dil_ceviriler.url IS NULL or dil_ceviriler.url='' THEN urunler.url ELSE dil_ceviriler.url END as url, urunler.IsCalendar, urunler.StoreId, urunler.tarih, urunler.satis, urunler.etiketler, urunler.fiyat, urunler.fiyatindirimsiz, urunler.InStock, urunler.ArrivalInfo, urunler.stok_sanal as stok_sanal, urunler.[Status], urunler.[bidahagelmez], urunler.resID, urunler.res_uzanti, urunler.kisiyeozel, urunler.bestsell, urunler.cesit_sayisi, urunler.parabirimi ,ufu.fiyat as ulkefiyat, ufu.fiyatindirimsiz as ulkefiyatindirimsiz, ufu.parabirimi as ulkeparabirimi FROM urunler with(nolock) LEFT JOIN dil_ceviriler WITH(NOLOCK) ON urunler.id=dil_ceviriler.pid and dil_ceviriler.dil='EN' LEFT JOIN urun_fiyat_ulke ufu WITH(NOLOCK) ON urunler.id=ufu.pid and ufu.ulke='United States' INNER JOIN hediyebulucu_map WITH(NOLOCK) on urunler.id=hediyebulucu_map.prID WHERE hedID='24' and Status=1 and not resID is null and urunler.stok_sanal>0 order by id desc