Meu carrinho
  0 produtos
 
Busca Rápida
 
Use palavras-chave para achar o que procura.
Busca Avançada
Categorias
Categorias
        Touch Screen
        Notebook
        TABLET
        Ultrabook
        Computadores
        Impressora
        Monitor TV LCD
        VIDEO WALL
        Projetores
        Scanner HP
        Switch
        Xbox 360
        Smartphone
        IPOD
        Nobreaks
        Acessórios
        Automação Comercial
        Servidor
        Software
Fabricantes
Atendimento On-Line
Resultado de sua pesquisa.
Mostrando1 para 41 (de 41 produtos) Páginas de Resultados:  1 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 100' at line 1

select distinct p.products_image, p.products_model, m.manufacturers_id, 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 from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, 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 = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%elo%' or p.products_model like '%elo%' or m.manufacturers_name like '%elo%') and (pd.products_name like '%tyco%' or p.products_model like '%tyco%' or m.manufacturers_name like '%tyco%') ) order by limit 0, 100

[TEP STOP]