You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND files.file != AND files.file_status = 1 AND files.file_community = HAVING ' at line 1

query : (SELECT 1 as query,MATCH(files.file_title,files.file_description) AGAINST ("") AS score,MATCH(files.file_title,files.file_description) AGAINST ("" IN BOOLEAN MODE) AS amount,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = HAVING score > 0 ORDER BY score DESC,amount DESC LIMIT 5) UNION DISTINCT (SELECT 2,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = ORDER BY RAND() LIMIT 5) UNION (SELECT 3,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_user = ORDER BY RAND() LIMIT 10) ORDER BY query ASC, score DESC, amount DESC LIMIT 20 #0 MySQL->errors( (SELECT 1 as query,MATCH(files.file_title,files.file_description) AGAINST ("") AS score,MATCH(files.file_title,files.file_description) AGAINST ("" IN BOOLEAN MODE) AS amount,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = HAVING score > 0 ORDER BY score DESC,amount DESC LIMIT 5) UNION DISTINCT (SELECT 2,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = ORDER BY RAND() LIMIT 5) UNION (SELECT 3,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_user = ORDER BY RAND() LIMIT 10) ORDER BY query ASC, score DESC, amount DESC LIMIT 20 ) called at [/home/bfamus/domains/bfamus.com/public_html/global/classes/mysql.php:109] #1 MySQL->query( (SELECT 1 as query,MATCH(files.file_title,files.file_description) AGAINST ("") AS score,MATCH(files.file_title,files.file_description) AGAINST ("" IN BOOLEAN MODE) AS amount,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = HAVING score > 0 ORDER BY score DESC,amount DESC LIMIT 5) UNION DISTINCT (SELECT 2,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = ORDER BY RAND() LIMIT 5) UNION (SELECT 3,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_user = ORDER BY RAND() LIMIT 10) ORDER BY query ASC, score DESC, amount DESC LIMIT 20 ) called at [/home/bfamus/domains/bfamus.com/public_html/global/classes/mysql.php:223] #2 MySQL->results( (SELECT 1 as query,MATCH(files.file_title,files.file_description) AGAINST ("") AS score,MATCH(files.file_title,files.file_description) AGAINST ("" IN BOOLEAN MODE) AS amount,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = HAVING score > 0 ORDER BY score DESC,amount DESC LIMIT 5) UNION DISTINCT (SELECT 2,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_community = ORDER BY RAND() LIMIT 5) UNION (SELECT 3,0,0,files.*,communities.*,users.*,files_votes.* FROM (files) INNER JOIN communities ON files.file_community = communities.community INNER JOIN users ON files.file_user = users.user LEFT JOIN files_votes ON files.file = files_votes.vote_file AND files_votes.vote_user = 0 WHERE files.file_type = AND files.file != AND files.file_status = 1 AND files.file_user = ORDER BY RAND() LIMIT 10) ORDER BY query ASC, score DESC, amount DESC LIMIT 20 ) called at [/home/bfamus/domains/bfamus.com/public_html/files/classes/files.php:392] #3 Files->__construct(Array ([related] => File Object ([] => ,[voted] => ,[vote] => 0,[self] => Array ([added] => 31/12/1969,[icon] => http://www.bfamus.com/global/icons/flickr.png,[url] => http://www.bfamus.com///,[path] => http://files.bfamus.tv///.,[gif] => ,[file_size] => 0 B),[locked] => ,[user] => Profile Object ([] => ,[] => ,[] => ,[self] => ),[community] => Community Object ([startQuery] => 1268425059.74,[self] => Array ([url] => http://www.bfamus.com/communautes//,[thumb] => http://www.bfamus.com/communities/images/.jpg),[parents] => Array (),[communities] => Array (),[liked] => )))) called at [/home/bfamus/domains/bfamus.com/public_html/files/classes/files.php:129] #4 File->Related() called at [/home/bfamus/domains/bfamus.com/public_html/files/file/process.php:132] #5 require(/home/bfamus/domains/bfamus.com/public_html/files/file/process.php) called at [/home/bfamus/domains/bfamus.com/public_html/files/process.php:7] #6 require(/home/bfamus/domains/bfamus.com/public_html/files/process.php) called at [/home/bfamus/domains/bfamus.com/public_html/global/process.php:12] #7 require(/home/bfamus/domains/bfamus.com/public_html/global/process.php) called at [/home/bfamus/domains/bfamus.com/public_html/index.php:6]