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

Yataş Firma Detayları

Yataş

Masko Adres:
Masko Mobilya Kenti 6B Blok No: 8-10 İkitelli - Başakşehir İSTANBUL
Tel: +90 212 675 01 93
Fax: +90 212 675 04 71

Web: http://www.yatas.com.tr

E-mail: info@yatas.com.tr

Merkez
Adres: Masko Mob. Kenti 6B-8.10 İkitelli - İSTANBUL / TR
Telefon: +90.212.6750193-2 Hat
Fax:
E-Posta:
Merkez
Adres: Masko Mob. Kenti 6B-8.10 İkitelli - İSTANBUL / TR
Telefon: +90.212.6750193-94
Fax:+90.212.6750471
E-Posta: yatas@masko.com.tr

mep

Yataş (Bu kategoride 0 ürün kaydı var.)


KAYITLI ÜRÜN YOK

Yataş firmasına ait ürünler veritabanımızda yeralmamaktadır.

Yataş firmasına ait ürünleri görmek için yukarıda adres bilgileri olan mağaza yada mağzalarına gidebilir ürünleri yerinde görebilirsiniz. Ya da telefon numarasından ulaşarak yetkilerinden bilgi alabilirsiniz.

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

تحميل...
تحميل...
تحميل...
(default) 25 queries took 98 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`31319
2DESCRIBE `productcategories`993
3DESCRIBE `productcategory_users`332
4DESCRIBE `addresses`772
5DESCRIBE `products`14144
6DESCRIBE `usercategories`552
7DESCRIBE `productimages`442
8DESCRIBE `demands`14143
9DESCRIBE `demandresponses`442
10DESCRIBE `advertises`11112
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 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 1112
18SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=6 ORDER BY rand() ASC LIMIT 1111
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` = 'yatas' LIMIT 1110
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` = 224 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 550
23SELECT `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`=224 and `Product`.`productcategory_id`=15 0053
24SELECT `Usercategory`.`title`, `Usercategory`.`id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=224 000
25SELECT `Address`.`id`, `Address`.`user_id`, `Address`.`title`, `Address`.`address`, `Address`.`phone`, `Address`.`fax`, `Address`.`email` FROM `addresses` AS `Address` where `Address`.`user_id`=224 221