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

Yataş (Enza Mobilya) Firma Detayları

Yataş (Enza Mobilya)
Masko Adres:
Masko Mobilya Kenti 11A Blok No: 9-11
İkitelli - Başakşehir İSTANBUL
Tel: +90 212 675 25 30
Fax: +90 212 675 25 60
E-Mail: donmezcenter@superonline.com
Web: http://www.yatas.com.tr

Yataş Home Masko Şubesi

Masko
Masko Mobilya Kenti 11ABlok No:9.11 İkitelli Başakşehir İSTANBUL
Telefon: 0212 675 2530 Fax:0212 675 2560
E-Posta:
Web: http://www.yatas.com.tr

Yataş (Enza 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 138 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`31317
2DESCRIBE `productcategories`993
3DESCRIBE `productcategory_users`332
4DESCRIBE `addresses`773
5DESCRIBE `products`14144
6DESCRIBE `usercategories`553
7DESCRIBE `productimages`443
8DESCRIBE `demands`14145
9DESCRIBE `demandresponses`443
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` 48481
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 1112
14SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=2 ORDER BY rand() ASC LIMIT 1112
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 1112
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 1112
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` = 'yatas_home_mobilya' LIMIT 1112
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` = 809 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 6637
23SELECT `Usercategory`.`id`, `Usercategory`.`title`, `Usercategory`.`keywords`, `Usercategory`.`user_id`, `Usercategory`.`productcategory_id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=809 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`=809 112
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`=809 LIMIT 120044