OTI Computers

Cautare avansata
Vezi toate produsele
Telefon:
0231 584 105
0744 266 196
Cosul de cumparaturi
 Contine: 0 produse
 Valoare: 0LEI
trimite comanda
   
Promotie la calculatoare, laptop-uri, componente laptop, componente calculator, tablete PC, camere foto, camere video, sisteme de supraveghere video, sisteme de alarma, control acces, automatizari porti Tehnologie de ultima generatie . Acum pe stoc la oticomputers.ro! Castiga bani porin programul de afiliere. Click pentru detalii. Tichete Cadou consultanta clienti Prezentare Contact
  Intrare Cont Lista dorinte
Produse
Accesorii
Audio, Foto, Video
Automatizari
Birotica
Calculatoare
Consumabile
Electrocasnice
Electronice Auto
Imprimante
Laptop, Accesorii
Monitoare
Periferice
Servicii
Sisteme antiefractie
Sisteme antiincendiu
Sisteme de control acces
Sisteme TVCI (supraveghere video)
Software
Telecomunicatii
Telefoane mobile
Televizoare
Videointefon
 Profit Online
Info Profit Online
Logare partener
 Noutati mai mult
X96 Amlogic S905W Quad Core Smart TV BOX HD 4K WIFI 2GB/16GB Android 7.1 Set-top
X96 Amlogic S905W Quad Core Smart TV BOX HD 4K WIFI 2GB/16GB Android 7.1 Set-top
 300LEI 
 Producatori
 Informatii
OTI Computers
Transport si livrare
Tichete Cadou
Confidentialitate
Termeni si conditii
Afiliere Pofit Online
Servicii
ANPC
Solutii IT si servicii informatice
Solutii IT
Politica de returnare - OTIcomputers.ro
Catalog printabil
Harta site
 Cele mai vandute
01.Tastatura USB Serioux Lightkey 9200EL, multimedia, iluminata, 105 taste (12 hotkeys), black, color box
02.Calculator PC OTI INTEL PROFESSIONAL - CPU Intel i5 -2120 3.3 Ghz, 4Gb RAM, 1Tb HDD, DVD+-RW, Video GTX650
03.Centrala Telefonica HOMEVOX UNIVERSAL 3-8
04.Kit Tastatura + Mouse Wireless nJoy CM410 Black USB
05.Boxe 5.1 Genius SW-HF5.1 4500 Wood, 125W(Subwoofer 45W+5 sateliti*16W), Telecomanda
06.Comutator inteligent cu control internet wireless WiFi
07.Comutator inteligent cu monitorizarea temperaturii si umiditatii, control internet wireless WiFi
08.DDR 1GB PC3200 400 MHz Kingmax
09.Detector autonom de fum ADR-20N
10.GEANTA NOTEBOOK 15.6" NYLON IMPERMEABIL BLACK&RED SNC-T4RD-15
Produse care indeplinesc criteriile de cautare  
Afisez 1 pana la 20 (din 353 produse)
Rezultate/Pagina:
View as ListVizualizare lista
View as GridVizualizare grila
Pagina: 1 2 3 4 5 ... Urmator 
Ordine sortare:
1054 - Unknown column 'pd.extra_value_ms21' in 'field list'

select distinct p.products_model, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, p.products_ordered, m.manufacturers_id, p.products_quantity, p.products_featured, p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, if(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, if(s.status, s.specials_new_products_price, p.products_price) as final_price , pd.extra_value_id10 , pd.extra_value_id11 , pd.extra_value_id12 , pd.extra_value_id13 , pd.extra_value_id14 , pd.extra_value_id17 , pd.extra_value_id18 , pd.extra_value_id19 , pd.extra_value_ms21 , SUM(tr.tax_rate) as tax_rate from products p left join manufacturers m using(manufacturers_id) left join specials_retail_prices s on p.products_id = s.products_id left join tax_rates tr on p.products_tax_class_id = tr.tax_class_id left join zones_to_geo_zones gz on tr.tax_zone_id = gz.geo_zone_id and (gz.zone_country_id is null or gz.zone_country_id = '0' or gz.zone_country_id = '175') and (gz.zone_id is null or gz.zone_id = '0' or gz.zone_id = '3139'), products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '6' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and (IF(s.status AND s.customers_group_id = '0', s.specials_new_products_price, p.products_price) * if(gz.geo_zone_id is null, 1, 1 + (tr.tax_rate / 100) ) <= 10000) and find_in_set('0', products_hide_from_groups) = 0 and find_in_set('0', categories_hide_from_groups) = 0 group by p.products_id, tr.tax_priority order by final_price , pd.products_name limit 0, 20

[TEP STOP]