[oller]

Tror det räcker med att du lägger tracks "bredvid" left outer join enligt nedan.

$query = "SELECT t.name,t.id,t.songlink,dc.dl_url,fc.trackid,fc.finishedcartid,fc.download_bitrate
 FROM transactions tn,finishedcart fc,tracks t
 LEFT OUTER JOIN downloadcount dc ON dc.trackid=t.id
 AND dc.memberid=".$_SESSION['memberid']." 
 WHERE (dc.dlcount<$dlcount OR dc.dlcount IS NULL)
 AND tn.memberid=".$_SESSION['memberid']."
 AND (tn.status='Completed' or tn.status='CHARGED')
 AND tn.txn_id=fc.txn_id
 AND CONCAT(',',fc.trackid,',') LIKE CONCAT('%,',t.id,',%')
 AND t.id='".$id."'
 AND download_bitrate LIKE '%".$GET_bitrate."%'";

Mvh