Featured Products v1.3 Assitance Please

[JMcCutcheon]

When I have this set to true:

 

  define('MAX_DISPLAY_FEATURED_PRODUCTS', '6');

 define('MAX_DISPLAY_FEATURED_PRODUCTS_LISTING', '10');

 define('FEATURED_PRODUCTS_DISPLAY', false);

 

I get the following error where the Featured Products should appear on the default.php page:

 

1064 - You have an error in your SQL syntax near 'rand() DESC limit 6' at line 1



select p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id left join featured f on p.products_id = f.products_id where p.products_status = '1' and f.status = '1' order by rand() DESC limit 3



[TEP STOP]

 

The URL is http://www.briqsholidayspecialties.com/cat...log/default.php. I have the default.php set to false as this is a live shop.

 

Does anyone know what is causing this error? I appreciate any assistance.

 

Jackie