BiTel

SELECT DISTINCT CLIENTS.TITLE AS 'dogovor', CLIENTS.ID AS 'id', PORT.VAL AS 'port', IP.VAL AS 'ip', SL.from_number AS 'mac' FROM contract AS CLIENTS JOIN user_login_1 AS ULOGIN ON ULOGIN.CID=CLIENTS.ID LEFT JOIN ( SELECT VAL, CID FROM contract_parameter_type_1 AS CPT WHERE (CPT.PID=5) ) AS PORT ON PORT.CID=CLIENTS.ID LEFT JOIN ( SELECT VAL, CID FROM contract_parameter_type_1 AS CPT WHERE (CPT.PID=7) ) AS IP ON IP.CID=CLIENTS.ID INNER JOIN log_session_1_201005 AS SL ON ULOGIN.ID=SL.lid GROUP BY CLIENTS.TITLE, CLIENTS.ID, PORT.VAL, IP.VAL, SL.from_number ORDER BY CLIENTS.TITLE

<?
$con = mysql_connect("server_host",'user_name','password');
if(!$con)
   die('db not connected');
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link)
{
    die('Not connected : ' . mysql_error($con));
}

$db_selected = mysql_select_db('database_name', $con);
if (!$db_selected)
{
    die ('cant select database ' . mysql_error($con));
}
$res = mysql_query("SELECT DISTINCT CLIENTS.TITLE AS 'dogovor', CLIENTS.ID AS 'id', PORT.VAL AS 'port', IP.VAL AS 'ip', SL.from_number AS 'mac' FROM contract AS CLIENTS JOIN user_login_1 AS ULOGIN ON ULOGIN.CID=CLIENTS.ID LEFT JOIN ( SELECT VAL, CID FROM contract_parameter_type_1 AS CPT WHERE (CPT.PID=5) ) AS PORT ON PORT.CID=CLIENTS.ID LEFT JOIN ( SELECT VAL, CID FROM contract_parameter_type_1 AS CPT WHERE (CPT.PID=7) ) AS IP ON IP.CID=CLIENTS.ID INNER JOIN log_session_1_201005 AS SL ON ULOGIN.ID=SL.lid GROUP BY CLIENTS.TITLE, CLIENTS.ID, PORT.VAL, IP.VAL, SL.from_number ORDER BY CLIENTS.TITLE",$con);

//while($record = mysql_fetch_assoc())
//{
$record = mysql_fetch_assoc();
print_r($record); // выводим каждую строку в цикле в виде асоциативного массива
//}

mysql_close($con);
?>

-- экспортируемые поля:
-- Договор,ФИО,Адрес

SELECT
    title AS dogovor,
    (SELECT val FROM contract_parameter_type_1 cpt1 WHERE pid = 2 AND cpt1.cid = c.id) AS 'ФИО',
    (SELECT address FROM contract_parameter_type_2 cpt2 WHERE pid = 1 AND cpt2.cid = c.id) AS 'Адрес'
FROM
    contract AS c
ORDER BY dogovor
INTO OUTFILE '/path/to/file.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n';