Query 2

SELECT
    d.id,
    d.document_revision_id,
    d.document_name,
    d.description,
    d.date_modified,
    d.active_date,
    d.exp_date,
    dc.clientstatus_c,
    dc.land_c,
    dc.priority_c,
    dc.documents_web_visibility_c,
    dc.documents_web_category_c,
    dc.documents_web_language_cc,
    dr.filename,
    dr.date_modified,
    (LENGTH(CONCAT(d.document_name, d.description)) - LENGTH(REPLACE(CONCAT(d.document_name, d.description), '".$keywords."', ''))) / LENGTH('".$keywords."') AS `relevance`
FROM
    documents d
INNER JOIN
    documents_cstm dc
    ON d.id = dc.id_c
INNER JOIN
    document_revisions dr
    ON d.id = dr.document_id
WHERE
(documents_web_visibility_c LIKE '%Downloads%' OR documents_web_visibility_c LIKE '%Info%')
AND
    d.deleted = 0
        AND
    dc.active_c = 1
        AND
    (exp_date IS NULL OR NOW() BETWEEN active_date AND exp_date)
AND
    documents_web_language_cc LIKE '%".$language."%'
AND
    (d.document_name LIKE '%" . $keywords . "%'
OR
d.description LIKE '%" . $keywords . "%')
AND
    (clientstatus_c LIKE  '%^NEU^%'
";
if ($status) $sql .= $status;
$sql .= ")";
if ($cat) $sql .= "AND documents_web_category_c LIKE '%" . $cat . "%'";
$sql .= "
ORDER BY
  relevance DESC";
if ($limit) $sql .= "LIMIT ".$limit;