View difference between Paste ID: 3NY1s1gU and LRqrH4ya

 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;