Sigue a LecySport en Facebook Sigue a LecySport en Twitter Visite nuestro blog de LecySport Sigue a LecySport en Google
Porterías
Inicio » Catálogo » Porterías

ANTES DE COMPRAR, COMPARA

Somos fabricantes de diversos modelos de porterías de fútbol sala (con canasta, antivandálica). Todos nuestros modelos son de base 80x40x2.

Especialmente diseñadas para su uso en instalaciones públicas y centros educativos, reforzando las partes más sensibles y buscando materiales que garanticen la máxima durabilidad.

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, 20' at line 1

select p.products_image, pd.products_name, p.products_quantity, pd.products_description_caja, p.products_id, p.manufacturers_id, 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_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '3' and p2c.categories_id = '69' order by limit 0, 20

[TEP STOP]