const { GoogleSpreadsheet } = require('google-spreadsheet');
const apiKey = API_KEY; // Ключ для работы с Google SpreadSheet API
const findId = "234567"; // Искомый номер
const spreadSheetId = "1PWuqvPkqB7gFEe1l7vXOvWdFkqbNAN6IsbP_9gUM1mE"; // ID таблицы в гуглодоках
(async () => {
const doc = new GoogleSpreadsheet(spreadSheetId );
await doc.useApiKey(apiKey);
await doc.loadInfo();
const sheet = doc.sheetsByIndex[0];
const rows = await sheet.getRows();
const point = rows.find(row => row._rawData[0] == findId)._rawData[1];
console.log(point);
})();let arr = [
[2, 2, 2, 9, 7],
[7, 7, 2, 5, 8]
];
console.log(arr
.reduce((a, line) => [...a, ...line], [])
.reduce((a, val) => {
let key = a.indexOf(val);
if(key >= 0) {
a[key] += val;
} else {
a.push(val);
}
return a;
}, [])
);
// [4, 4, 9, 14, 7, 5, 8]SELECT *
FROM `posts`
WHERE (
SELECT COUNT(*)
FROM `users`
WHERE
`user_id` = 1919 AND
`registration_date` < DATE_ADD(NOW(), INTERVAL -2 DAY)
) > 0;