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

Karademir Mobilya A.Ş. Firma Detayları

Karademir Mobilya A.Ş.

Masko Adres:
Masko Mobilya Kenti 4A Blok No: 40 İkitelli - Başakşehir İSTANBUL
Tel: +90 212 675 19 00
Fax:

Web: http://www.karademirmobilya.com

E-mail: bulent@karademirmobilya.com

Masko
Adres: Masko Mob.Kenti 4A-40 İkitelli-İSTANBUL/TR
Telefon: +90.212.6751900 /
Fax:
E-Posta: bulent@karademirmobilya.com

Karademir Mobilya A.Ş. (Bu kategoride 0 ürün kaydı var.)


KAYITLI ÜRÜN YOK

Karademir Mobilya A.Ş. firmasına ait ürünler veritabanımızda yeralmamaktadır.

Karademir Mobilya A.Ş. 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 132 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`313110
2DESCRIBE `productcategories`994
3DESCRIBE `productcategory_users`332
4DESCRIBE `addresses`777
5DESCRIBE `products`14144
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 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` = 'karademir_mobilya_a_s' 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` = 594 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 10102
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`=594 and `Product`.`productcategory_id`=15 0064
24SELECT `Usercategory`.`title`, `Usercategory`.`id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=594 002
25SELECT `Address`.`id`, `Address`.`user_id`, `Address`.`title`, `Address`.`address`, `Address`.`phone`, `Address`.`fax`, `Address`.`email` FROM `addresses` AS `Address` where `Address`.`user_id`=594 113