Query 1

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
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
    (clientstatus_c LIKE  '%^NEU^%'
";
if ($status) $sql .= $status;
$sql .= ")";
if ($cat) $sql .= "AND documents_web_category_c LIKE '%" . $cat . "%'";
$sql .= "
ORDER BY
  dc.priority_c ASC,
  d.document_name ASC ";
if ($limit) $sql .= "LIMIT ".$limit;