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

Dervişoğlu Teks.San.Tic.Ltd. Firma Detayları

Dervişoğlu Teks.San.Tic.Ltd.

Masko Adres:
Masko Mobilya Kenti 4A Blok No: 2 İkitelli - Başakşehir İSTANBUL
Tel: +90 212 675 05 51
Fax: +90 212 675 05 50

Web: http://www.dervisoglutekstil.com

E-mail: info@dervisoglutekstil.com

Dervişoğlu Teks.San.Tic.Ltd. (Bu kategoride 0 ürün kaydı var.)


KAYITLI ÜRÜN YOK

Dervişoğlu Teks.San.Tic.Ltd. firmasına ait ürünler veritabanımızda yeralmamaktadır.

Dervişoğlu Teks.San.Tic.Ltd. 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 88 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `users`31315
2DESCRIBE `productcategories`993
3DESCRIBE `productcategory_users`332
4DESCRIBE `addresses`773
5DESCRIBE `products`14143
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 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 1112
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` = 'dervisoglu_teks_san_tic_ltd' 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` = 832 AND `ProductcategoryUser`.`productcategory_id` = `Productcategory`.`id`) ORDER BY `Productcategory`.`url` DESC 111
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`=832 and `Product`.`productcategory_id`=16 0043
24SELECT `Usercategory`.`title`, `Usercategory`.`id` FROM `usercategories` AS `Usercategory` where `Usercategory`.`user_id`=832 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`=832 002