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

Gürşah Mobilya Firma Detayları

Gürşah Mobilya

Masko Adres:
Masko Mobilya Kenti 4A Blok No: 42 İkitelli - Başakşehir İSTANBUL
Tel: +90 212 675 03 07
Fax:

Web: http://www.sah1mobilya.com

E-mail: info@sah1mobilya.com

Ümraniye Merkez
Adres: Modoko San.Sitesi 2.Cd. No:260/A Y.Dudullu Ümraniye - İSTANBUL / TR
Telefon: +90 (216) 420 69 40
Fax:
E-Posta: info@sah1mobilya.com
Merkez
Adres: Masko Mob. Kenti 4A-42 İkitelli - İSTANBUL / TR
Telefon: +90.212.6750307 /
Fax:
E-Posta: info@sah1mobilya.com

Gürşah Mobilya (Bu kategoride 0 ürün kaydı var.)


KAYITLI ÜRÜN YOK

Gürşah Mobilya firmasına ait ürünler veritabanımızda yeralmamaktadır.

Gürşah Mobilya 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 81 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`31316
2DESCRIBE `productcategories`992
3DESCRIBE `productcategory_users`331
4DESCRIBE `addresses`772
5DESCRIBE `products`14143
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` 48480
12SELECT `Advertise`.`code`, `Advertise`.`id` FROM `advertises` AS `Advertise` where `Advertise`.`field`=0 ORDER BY rand() ASC LIMIT 1111
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 1111
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 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 5095090
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` = 'gursah_mob' 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` = 221 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 881
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`=221 and `Product`.`productcategory_id`=15 0044
24SELECT `Usercategory`.`title`, `Usercategory`.`id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=221 001
25SELECT `Address`.`id`, `Address`.`user_id`, `Address`.`title`, `Address`.`address`, `Address`.`phone`, `Address`.`fax`, `Address`.`email` FROM `addresses` AS `Address` where `Address`.`user_id`=221 222