Reklam Yükleniyor...
Reklam Yükleniyor...
Reklam Yükleniyor...
Reklam Yükleniyor...
Reklam Yükleniyor...

Zafer Mobilya Firma Detayları

Zafer Mobilya
Masko Adres:
Masko Mobilya Kenti 3B2 Blok No: 45
İkitelli - Başakşehir İSTANBUL
Tel: +90 212 675 09 18
Fax:
E-Mail: zafer@zafermobilya.com
Web: http://www.zafermobilya.com.tr
mep

Zafer Mobilya

Merkez
Masko Mob. Kenti 3B2-45 İkitelli - İSTANBUL / TR
Telefon: +90.212.6750996-6750918 Fax:+90.216.3240577
E-Posta: info@zafermobilya.com
Web: http://www.zafermobilya.com.tr

Merkez
Masko Mob.Kenti3B2-45 İkitelli-İSTANBUL/TR
Telefon: +90.212.6750918 Fax:+90.212.6750996-97
E-Posta: ustundemir@superonline.com
Web: http://www.zafermobilya.com.tr

Zafer Mobilya İletişim Formu

Ad

Soyad

E-Mail

Cep Telefonu

Telefon

Fax

Konu

Mesajınız talep detaylarınızı ayrıntılarıyla yazınız.

Firma Ürünlerinden Bazıları


Kayıtlı Ürün Yok


البحث عن منتجH

تحميل...
تحميل...
تحميل...
(default) 25 queries took 141 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`31315
2DESCRIBE `productcategories`993
3DESCRIBE `productcategory_users`332
4DESCRIBE `addresses`773
5DESCRIBE `products`14143
6DESCRIBE `usercategories`552
7DESCRIBE `productimages`442
8DESCRIBE `demands`14144
9DESCRIBE `demandresponses`442
10DESCRIBE `advertises`11113
11SELECT `Advertise`.`id`, `Advertise`.`title`, `Advertise`.`user_id`, `Advertise`.`type`, `Advertise`.`field`, `Advertise`.`code`, `Advertise`.`link`, `Advertise`.`view`, `Advertise`.`hit`, `Advertise`.`created`, `Advertise`.`modified` FROM `advertises` AS `Advertise` where `Advertise`.`field` 48480
12SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=0 ORDER BY rand() ASC LIMIT 1112
13SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=1 ORDER BY rand() ASC LIMIT 1111
14SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=2 ORDER BY rand() ASC LIMIT 1111
15SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=3 ORDER BY `Advertise`.`id` ASC 000
16SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=4 ORDER BY rand() ASC LIMIT 1112
17SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=5 ORDER BY rand() ASC LIMIT 1111
18SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=6 ORDER BY rand() ASC LIMIT 1112
19SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=7 ORDER BY rand() ASC LIMIT 1111
20SELECT `User`.`title`, `User`.`url` FROM `users` AS `User` where `User`.`group_id`=3 ORDER BY `User`.`url` ASC 5095091
21SELECT `User`.`id`, `User`.`group_id`, `User`.`active`, `User`.`mep`, `User`.`active_ad`, `User`.`active_live`, `User`.`active_product`, `User`.`active_drect_link`, `User`.`active_screen`, `User`.`email`, `User`.`username`, `User`.`password`, `User`.`code`, `User`.`last_login`, `User`.`first_name`, `User`.`last_name`, `User`.`title`, `User`.`phone`, `User`.`fax`, `User`.`ada`, `User`.`no`, `User`.`description`, `User`.`web`, `User`.`url`, `User`.`logo`, `User`.`image`, `User`.`product`, `User`.`live_code`, `User`.`keywords`, `User`.`priority`, `User`.`theme_id` FROM `users` AS `User` WHERE `User`.`url` = 'zafer_mobilya' LIMIT 1111
22SELECT `Productcategory`.`title`, `Productcategory`.`url`, `Productcategory`.`id`, `ProductcategoryUser`.`id`, `ProductcategoryUser`.`productcategory_id`, `ProductcategoryUser`.`user_id` FROM `productcategories` AS `Productcategory` JOIN `productcategory_users` AS `ProductcategoryUser` ON (`ProductcategoryUser`.`user_id` = 14 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 8844
23SELECT `Usercategory`.`id`, `Usercategory`.`title`, `Usercategory`.`keywords`, `Usercategory`.`user_id`, `Usercategory`.`productcategory_id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=14 001
24SELECT `Address`.`id`, `Address`.`user_id`, `Address`.`title`, `Address`.`address`, `Address`.`phone`, `Address`.`fax`, `Address`.`email` FROM `addresses` AS `Address` where `Address`.`user_id`=14 222
25SELECT `Product`.`title`, `Product`.`url`, `Product`.`image` FROM `products` AS `Product` LEFT JOIN `productcategories` AS `Productcategory` ON (`Product`.`productcategory_id` = `Productcategory`.`id`) where `Product`.`user_id`=14 LIMIT 120053