Profiler Sales & Service Pty Ltd.

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_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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/profilerparts.com.au/httpdocs/include/func.php on line 102
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, 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 5
Profiler Sales & Service Pty Ltd.


	Home


	Profiler For Sale


	Shopping Cart


	Contact Us

Australian Free Call Number: 1800 106 456 Mobile: 0433307300

International: +61 433307300 Email: getparts@profilerparts.com.au

Search:

Advanced search

Welcome to Profiler Sales & Service Pty Ltd.

If you cannot find the parts you require please do not hesitate to contact us directly.

Use the "Contact Us" link at left or phone 1800 106 456 for prompt service.

Profiler Sales & Service Pty Ltd (PSS) was incorporated primarily to offer New Used & Reconditioned parts for all types of Profiling machines in Australia.

“A One Stop Shop “.

As time progresses, PSS will wreck & strip older machines that will provide the Industry with a ready to go part that maybe used or reconditioned but in good order, that is in stock, ready to go as apposed to waiting for parts to be ordered in.

We understand that “Downtime” is very costly and wish to make getting your machine back working, a fast & cost effective process. We can also arrange to deliver in Sydney Metro to ensure your fitter remains with the machine doing what you pay him for.

PSS can also provide New Wirtgen Parts directly to you at no greater than current price & sometimes cheaper with our special offers. We hope to extend this across all machines in the future.

We wish to offer a personalised service, to save time, therefore you can call Maree directly on her mobile with what you need & let her do the resourcing & come back to you, with spare part options available & pricing accordingly.

Thankyou for visiting our site & we look forward to helping you save money and time in your business.

To discuss Terms, Conditions & Warranty please call Maree or email us.

Product Specials

Product Specials will be listed here as available.

Your cart

	Cart is empty

View cart
Checkout

Authentication

Username

Password

New User

Recover password

If Javascript is disabled in your browser click here

Site by Softcom Web Solutions