let db = "sql.0";
let database = "iobroker";
let field = "ems-esp.0.recordings.heatSources.actualPower._Months";

main();

async function main() {
    const id = await getid(field,db);
    console.log("ID: " + id);
    let query = "select * from " + database + '.ts_number where id = "' + id + '";';
    sendTo(db, "query", query, function (result,reject) {
        console.log(result.result);
    });
}

async function getid(field,db) {
	return new Promise(function(resolve) {
		const query = "select id from " + database + '.datapoints where name = "' + field + '";';
		sendTo(db, "query", query, function (result,reject) {
			if (result.error || result.result[0] == null)
			{
				resolve(0);
			} else {
				resolve(result.result[0].id);
			}
		});
	});
}