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

CASTAMO MOBİLYA Firma Detayları

CASTAMO MOBİLYA

Masko Adres:
Masko Mobilya Kenti 11-A Blok Blok No: NO:33 İkitelli - Başakşehir İSTANBUL
Tel: +90 212 675 23 01
Fax:

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

E-mail: info@castamo.com.tr

MODESA 1
Adres: Modesa Mobilyacılar Sitesi Otakçılar cad. No:56 EYÜP
Telefon: +90 212 565 40 40
Fax:0212 616 1181
E-Posta: modesa1@castamo.com.tr
Masko 1
Adres: Masko Mob. Kenti 19B-9 İkitelli - İSTANBUL / TR
Telefon: +90 212 675 23 00
Fax:0212 616 1181
E-Posta: masko1@castamo.com.tr
Masko 2
Adres: Masko Mob.Kenti 11/A Blok No:33 İkitelli İSTANBUL
Telefon: +90 212 675 23 01
Fax:0212 616 1181
E-Posta: masko2@castamo.com.tr
MODESA 2
Adres: Modesa Mobilyacılar Sitesi Mobilyacılar Sk. No:36 EYÜP / İstanbul
Telefon: +90 212 565 40 40
Fax:0212 616 1181
E-Posta: modesa2@castamo.com.tr
Castamo Outlet
Adres: Modesa Mobilyacılar Sit. Otakcılar Cad. No:21 EYÜP/İstanbul
Telefon: +90 212 565 40 40
Fax:0212 616 1181
E-Posta: outlet@castamo.com.tr
Castamo Genç
Adres: Modesa Mobilyacılar Sit. Alptekin Sk. No:32 EYÜP/İstanbul
Telefon: +90 212 565 40 40
Fax:0212 616 1181
E-Posta: info@castamo.com.tr
Bahçeşehir
Adres: Bahçeşehir Mobilyacılar Sitesi E1 Blok No:1-5 Bahçeşehir Başakşehir
Telefon: 0 212 672 27 55
Fax:0212 616 1181
E-Posta: bahcesehir@castamo.com.tr

mep

CASTAMO MOBİLYA (Bu kategoride 0 ürün kaydı var.)

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

تحميل...
تحميل...
تحميل...
(default) 25 queries took 96 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`31316
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`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` 48480
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 1111
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 1111
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 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` = 'castamo_collection' 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` = 105 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 15150
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`=105 and `Product`.`productcategory_id`=9 0055
24SELECT `Usercategory`.`title`, `Usercategory`.`id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=105 10100
25SELECT `Address`.`id`, `Address`.`user_id`, `Address`.`title`, `Address`.`address`, `Address`.`phone`, `Address`.`fax`, `Address`.`email` FROM `addresses` AS `Address` where `Address`.`user_id`=105 770