SQL QUERY [SELECT *, MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants, MATCH name AGAINST ('+sony' IN BOOLEAN MODE) AS relevance FROM `products` WHERE MATCH name AGAINST ('+sony' IN BOOLEAN MODE) GROUP BY name ORDER BY counts.views DESC LIMIT 20,10] FAILED [Unknown table 'counts' in order clause]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/pricebee/public_html/includes/database.php on line 25
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/pricebee/public_html/includes/database.php on line 30
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/pricebee/public_html/includes/database.php:20) in /home/pricebee/public_html/html/header.php on line 2
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/pricebee/public_html/includes/database.php:20) in /home/pricebee/public_html/html/header.php on line 2