ALTER TABLE phone_geographic_code_10 ADD INDEX (dest_id);

SELECT c.id, c.title, c.comment, ls.session_start, ls.session_time, ls.round_session_time, ls.from_number, ls.from_number_164, ls.to_number, ls.to_number_164, pc.code, pd.title
FROM log_session_10_201407 AS ls
LEFT JOIN contract AS c ON c.id = ls.cid
LEFT JOIN phone_dest_10 AS pd ON pd.id = ls.dest_id
LEFT JOIN phone_geographic_code_10 AS pc ON pc.dest_id = pd.id
ORDER BY ls.session_start

String    query = " SELECT ls.cdr_id, ls.hour " +
                  " FROM log_session_10_201406 AS ls " +
                  " ORDER BY ls.session_start ";
      
PreparedStatement ps = con.prepareStatement( query );
ResultSet rs = ps.executeQuery();
            
while( rs.next() )
   {
   int cdrId = rs.getInt( "ls.cdr_id" );
   Date cdrHour = rs.getDate( "ls.hour" );
   
   String tableName = TimeUtils.format(cdrHour, "yyyyMMdd");
         
   String    cdrQuery = " SELECT from_port, to_port FROM data_log_10_" + tableName + " WHERE id = " + cdrId;
   PreparedStatement psCdr = con.prepareStatement( cdrQuery );
   ResultSet rsCdr = psCdr.executeQuery();
   while( rsCdr.next() )
      {
         int from_port = rsCdr.getInt("from_port");
         int to_port = rsCdr.getInt("to_port");
      }
   rsCdr.close();
   psCdr.close();
   }
rs.close();
ps.close();