INVALID SQL: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT COUNT(xcart_products.productid), MIN(xcart_pricing.price) as price , xcart_feature_classes.fclassid, 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_product_features ON xcart_product_features.productid = xcart_products.productid LEFT JOIN xcart_feature_classes ON xcart_feature_classes.fclassid = xcart_product_features.fclassid AND xcart_feature_classes.avail = 'Y' 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.product_type <> '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: 1054 : Unknown column 'xcart_products.productid' in 'on clause'
SQL QUERY FAILURE: SELECT xcart_products.productid, xcart_products.product, xcart_products.productcode, xcart_products.avail, MIN(xcart_pricing.price) AS price, xcart_product_features.fclassid, IF(xcart_product_features.fclassid IS NULL || xcart_product_features.productid IN ('0'),'','Y') as is_clist, 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_product_features ON xcart_product_features.productid = xcart_products.productid 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.product_type <> '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 3
Home Theatre, Projectors, Plasma TV at Australia's Audio Visual Online Shop

Phone: 61-2-9998-2600


	Advanced search


	Categories Projectors Projection Screens LCD TV Electronic Whiteboard Plasma TV Televisions Document Cameras Public Address Overhead Projectors Trolleys Whiteboards Special - packages

Log in

Username

Password

Recover password

If Javascript is disabled in your browser click here


	Help FAQ Contact us About our site Return policy Freight & Charges Hire equipment Privacy statement Terms & Conditions Government Contract No. 058/278 Full product list Glossary Related links Sitemap

DirectAV

We welcome you to the DirectAV store your Government and Corporate specialists.

** DirectAV.com.au is now a wholly owned subsidiary of VISIONEXT Pty Ltd**

This is a store that caters for all your Audio Visual requirements. Our products include: Multimedia Projector, Plasma TV, LCD TV, Projection Screens, Overhead Projector, Lecterns, Trolleys, Televisions, DVD/VCR, Interactive Whiteboards, Electronic Whiteboards, Public Address Systems, Installation and other Accessories, and related products. Brand names like Panasonic, Epson, Hitachi, Mitsubishi, Toshiba, NEC, Draper, Image, BENQ, Gilkon and Screen Technics are available. We stock most common items and can organise prompt delivery, especially if you need your items urgently.

All of our branded products come with the full manufacturer's warranty and are locally supported by the manufacturer or official Australian Agent.

Audio Visual specialists since 1998.

DirectAV is an 100% Australian owned family business, since early 1998 and has been operating in the Audio Visual business selling a wide variety of products including the now popular Multimedia Projector, Plasma and LCD TV systems. We can advise on the best solution and can organize installation of all your equipment, especially cable concealment and wall plates, if required.

Customer Guarantee and Service Support.

The dedication to our customers is second to none, as we strive to give you the best possible product at the best possible price, with the best service. We can advise on the best solution and can organize installation if required.

Please feel free to call us on 02 9998 2600 between the hours of 9am and 5pm Monday to Friday (AET), or drop us an email if you would like to know more.


	Recommended products There are no available featured products...