My Account  |  Cart Contents  |  Checkout
HomePage » General Merchandise Catalog » Specials	Search        Advanced Search
Please Login to See Inventory And Pricing - Currently not logged in     Many more items are available in the member catalog

Online Application Member sign In Categories AIR SOFT GUNS (3) BANDZMANIA (6) BLANKETS (93) CANDLE WARMERS (22) CANDLES/OILS (193) CLOSEOUTS (2) CONSUMER PRODUCTS (6) DOLLS (28) FIREWORKS (1) FOUNTAIN (3) GLASS (16) HOME DECOR (76) HUMIDIFIERS (2) INDIAN/COWBOY (8) KNIVES/SWORDS (52) LICENSED PRODUCTS (87) MISC (54) MOTION PICTURE (2) OIL WARMERS (46) POLYRESIN (194) POLYRESIN LAMPS (6) SEASONAL (12) SEEN ON TV (12) SPORTING GOODS (5) TOOLS (45) TOYS (27) TUFTED RUGS (30) ZIPPO LIGHTERS (222) What's New? CIS228 COW METAL STAR 9.5INCH Information Store Policies Privacy Notice Contact Us

Get Them While They're Hot! 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 '-9, 9' at line 1 select p.products_id, pd.products_name, p.products_model, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -9, 9 [TEP STOP]