View difference between Paste ID: RqpzqWrK and esJUAuxq

 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;