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

METAŞ MOBİLYA & DEKORASYON - KONFOR Firma Detayları

METAŞ MOBİLYA & DEKORASYON - KONFOR
Masko Adres:
Masko Mobilya Kenti 10-A Blok No: 1
İkitelli - Başakşehir İSTANBUL
Tel: 0212 675 03 99
Fax: 0212 675 01 49
E-Mail:
Web: http://www.metas.ticaretimiz.com
mep

Yatak odası takımlarında şok fiyatlar... Modellerimizi görmek için sitemize girebilirsiniz.Daha fazla model görmek ve bu fırsatı kaçırmamanız içinse sizleri mağazamıza bekliyoruz. Kendi imalatımız vardır. Modern ve dömiklasik tarzda çalışmaktayız. Haftanın 7 günü açığız. Kredi kartı geçerlidir.

Showroom
Masko Mobilya Kenti 10A-1 İkitelli-İSTANBUL
Telefon: 0212 675 03 99 Fax:0212 675 01 49
E-Posta:
Web: http://www.metas.ticaretimiz.com

İmalathane
Keçecipiri Mahallesi Okmeydanı Caddesi No:50 Hasköy-İSTANBUL
Telefon: 0212 250 52 08 Fax:
E-Posta:
Web: http://www.metas.ticaretimiz.com

METAŞ MOBİLYA & DEKORASYON - KONFOR İ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.

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

تحميل...
تحميل...
تحميل...
(default) 25 queries took 101 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`31316
2DESCRIBE `productcategories`993
3DESCRIBE `productcategory_users`332
4DESCRIBE `addresses`772
5DESCRIBE `products`14143
6DESCRIBE `usercategories`553
7DESCRIBE `productimages`443
8DESCRIBE `demands`14144
9DESCRIBE `demandresponses`443
10DESCRIBE `advertises`11114
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 1113
13SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=1 ORDER BY rand() ASC LIMIT 1113
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 1113
18SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=6 ORDER BY rand() ASC LIMIT 1113
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` = 'metas' 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` = 445 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 661
23SELECT `Usercategory`.`id`, `Usercategory`.`title`, `Usercategory`.`keywords`, `Usercategory`.`user_id`, `Usercategory`.`productcategory_id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=445 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`=445 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`=445 LIMIT 126643