Tickers Watches - Wholeale Watch and Mini-Clock Suppliers
Wholesale Watches, Wholesale Mini-Clocks, Wholesale Men's Watches, Wholesale Ladies Watches, Wholesale Calculators, Wholesale Necklaces, Wholesale Keychains Watches, Wholesale Novelty Watches, Wholesale Children's Watches
Categories
Digital Watches (6)
Mens Watches-> (143)
Ladies Watches-> (193)
Unisex Watches-> (41)
Childrens Watches (3)
Mini Clocks-> (378)
  Animal (63)
  Canada (3)
  Food (29)
  Licensed (9)
  Music (29)
  Novelty (124)
  Sport (41)
  Transportation (80)
Keychains-> (112)
Necklaces-> (22)
Novelty-> (99)
Licensed/Collectible-> (63)
Boxed Items (1)
Watch Accessories (4)
Specials
What's New?
Search Products
 
Type keywords to search for products.
Advanced Search
Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Currency Converter
Open Calculator



Baby Carriage Miniature Clock (Blue)
[CK412]		 $21.99USD

At a glance info

  • Intricate metal construction with enamel finish
  • Accordian hood
  • Wheels that actually roll
  • White face and black markings

    		•
    This product was added to our catalog on Wednesday 26 March, 2008.
    1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

    select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p where opa.products_id = '1852' and opa.orders_id = opb.orders_id and opb.products_id != '1852' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

    [TEP STOP]