ДХ
попробуйте вынести последний include в отдельный запрос и потом подставить в Where + in. должно работать
Хорошо спс попробую
Объект config я бинжу так, но надо еще и companyId забиндить, нигде не нахожу варианта
const query = `
SELECT r.building_id, r.company_id
FROM (
SELECT b.id building_id, c.id company_id,
ST_Distance_Sphere(POINT(CAST(b.longitude AS DECIMAL(10,7)), CAST(b.latitude AS DECIMAL(10,7))),
POINT(CAST(c.longitude AS DECIMAL(10,7)), CAST(c.latitude AS DECIMAL(10,7)))) / 1609.34 AS distance
FROM companies c, buildings b
WHERE (b.deleted_at IS NULL or b.deleted_at > NOW()) AND c.id = ${companyId} AND c.latitude IS NOT NULL AND c.longitude IS NOT NULL AND
b.latitude IS NOT NULL AND b.longitude IS NOT NULL
HAVING distance <= ${config.distance} ORDER BY distance
) as r
WHERE r.building_id
`;
const result = await this.sequelize.query(query, {
bind: config, type: Sequelize.QueryTypes.SELECT,
});
