Something

$results = db_query_range(db_rewrite_sql("SELECT casetracker_case.nid,casetracker_case.pid,node.title, node.created from casetracker_case,node WHERE casetracker_case.nid = node.nid AND pid=%d ORDER BY node.created DESC", $project_id), 0, variable_get('casetracker_block_latest_cases_count', 3));