0 : SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_products_lng.product as product_lng, xcart_products_lng.descr as descr_lng, xcart_products_lng.full_descr as fulldescr_lng, IF(xcart_variants.variantid IS NOT NULL,'Y','') as is_variant, IF(xcart_classes.classid IS NOT NULL,'Y','') as is_product_options, MIN(v_pricing.price) as v_price FROM xcart_products, xcart_pricing , xcart_featured_products, xcart_products_categories, xcart_categories LEFT JOIN xcart_products_lng ON xcart_products_lng.productid = xcart_products.productid AND xcart_products_lng.code = 'US' LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid LEFT JOIN xcart_pricing as v_pricing ON v_pricing.variantid = xcart_variants.variantid AND v_pricing.quantity = 1 AND v_pricing.membership IN ('','') WHERE xcart_products.productid=xcart_featured_products.productid AND xcart_featured_products.avail='Y' AND xcart_featured_products.categoryid='0' AND xcart_pricing.productid=xcart_products.productid AND xcart_pricing.quantity=1 AND xcart_pricing.membership IN ('','') AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_pricing.variantid = 0 AND xcart_products_categories.productid=xcart_products.productid AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.membership IN ('','') AND xcart_categories.avail = 'Y' AND xcart_products.forsale='Y' GROUP BY xcart_products.productid INVALID SQL: 0 : SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, SUM(IF(xcart_classes.classid IS NULL,0,1)) as product_options, IF (xcart_classes.classid IS NULL,'','Y') as is_product_options, IF(xcart_variants.variantid IS NULL,'','Y') as is_variant FROM xcart_products, xcart_categories, xcart_products_categories, xcart_pricing LEFT JOIN xcart_classes ON xcart_classes.productid = xcart_products.productid LEFT JOIN xcart_variants ON xcart_variants.productid = xcart_products.productid WHERE xcart_products.productid=xcart_products_categories.productid AND xcart_products_categories.categoryid=xcart_categories.categoryid AND xcart_products.productid=xcart_pricing.productid AND xcart_pricing.quantity=1 AND (xcart_pricing.membership='' OR xcart_pricing.membership='') AND (xcart_categories.membership='' OR xcart_categories.membership='') AND xcart_products.forsale='Y' AND xcart_pricing.variantid = 0 AND xcart_products.product_type <> 'C' AND xcart_products.forsale <> 'B' AND xcart_products.sales_stats>0 GROUP BY xcart_products.productid ORDER BY xcart_products.sales_stats DESC, xcart_products.views_stats DESC LIMIT 2
Welcome to WagonWood Ltd - The Wagon Company. International Distributor for Liontouch, Italtrike, Uniwood, Janoschik and Redtoys, We sell traditional toys B2B. Our aim is to bring back the traditional type of toy that provides childhood memories through play, not only for todays children but for the whole family. Helping to create memories they can all laugh and enjoy for many years to come.
Having sold toys since 1989 we have watched our own and many other children enjoy our products year in year out, and understand how a 3yr old playing differs from a 14yr old who although a teenager still wants to just play.
During that time we have sold as International Distributor's America's Little Red Wagon, Radio Flyer, Uniwood and Janoschik wooden toys and now moving forward Italtrike, Redtoys, Tiny Bikes, Indy and Liontouch fancy dress, imaginary play with the wonderfully colourful and decorated swords and shields, toys & gifts to thrill.
Our products sell best when the customer can see them. The new brand Liontouch provides a retailer the chance to include the brand in activity days and our package includes pos, displays and templates for your Liontouch day. A great way to increase sales and footfall.
We are looking for more retailers be it toy, gift or any type of shop who feel their customers will be interested in what we supply. We sell through mail order, flower, bike, Castles, Children's tourist attractions - and even furniture shops so don't be put off if you have a shop or business with a difference as we never know where our next account will come from. Please Contact Us and give us a bit of information about yourselves. We will normally come back to you, almost straight away but definitely within 5 working days if not please just call in.
There are no available featured products...
Romford 9th August, 2013 11am - 3pm - view our products with special promotional offers.
All retailers welcome, light refreshments available.
See our new wooden toy and nursery range.
Place your Christmas orders on all products including Italtrike trikes and ride on toys and Liontouch fancy dress.
Contact us for details. Call 01256 473546 or email us - The more the merrier all retailers welcome!