osCommerce
      
   » Main Menu » ● AIRGUNNING, Pellets, Targets, Parts »
RIFLE SUPPORT, SANDBAGS
 |  My Account  |  My Shopping Cart  |  Proceed to Checkout | 

Languages
Nederlands english

Product Search
 
______________________________

Use a Keyword or Item Number


Manufacturers

Log In

E-mail Address

Password




Password Forgotten?
- CLICK HERE -


Informatie
● QUESTIONS & ANSWERS

● SHIPPING & ORDERING

● CONDITIONS of USE

Overige Info
● WET WAPENS & MUNITIE

● PRIVACY NOTICE

● CONTACT US

Select:  
Displaying on this Page: PRODUCT 1 to 15
(There are a total of 18 products)

NUMBER of PAGES:
 1  2  >> NEXT PAGE >> 
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, 15' at line 1

select p.products_image, pd.products_name, 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, products_to_categories p2c) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '5' and p2c.categories_id = '3148' order by limit 0, 15

[TEP STOP]