Top »Catalog »2. Senior corps (1120)

My Account  |  Cart Contents  |  Checkout

Categories 1. Junior corps (3036) 2. Senior corps (1120) 3. International corps (81) 4. Armed services (51) 5. Sets (3) Search engine   Use keywords to find the product you are looking for. Advanced Search

Historic drum corps music Displaying 501 to 550 (of 1005 products) Result Pages: [<< Prev]  ... 11  12  13  14  15 ...  [Next >>]  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 500, 50' at line 1 select m.manufacturers_name, pd.products_name, p.products_model, 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 = '1' and p2c.categories_id = '25' order by limit 500, 50 [TEP STOP]