'SELECT SQL_CALC_FOUND_ROWS b.*, s.urlname AS state_urlname, s.name AS state_name, '.
'i.urlname AS industry_urlname, i.name AS industry_name, '.
'l.urlname AS location_urlname, l.name AS location_name, '.
'MATCH (b.name,b.contact,b.description,b.classification,b.sub_classification) AGAINST (?) AS relevance '.
'FROM businesses b '.
'RIGHT JOIN states AS s ON ( b.state = s.id ) '.
'RIGHT JOIN industries AS i ON ( b.industry = i.id ) '.
'RIGHT JOIN locations AS l ON ( b.location = l.id ) '.
'WHERE b.state=? '.
($this->login['admin'] ? '': 'AND b.publish=1 ').
'AND MATCH (b.name,b.contact,b.description,b.classification,b.sub_classification) AGAINST (?) ';