SQL Server 2016

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table locs
(
	id int primary key clustered,
	title varchar(50) not null
);

create table locs_clicks
(
    id int identity(1,1),	
    locId int ,
    clickCol varchar(50) null
);
create table locs_views
(
    id int identity(1,1),	
	locID int ,
    viewkCol varchar(50) null
);	

insert into locs(id, title)
values(17231289,'Mertz'),(1,'Dacia');

Insert into locs_clicks(locId)
values(17231289),(17231289),(1),(1),(1),(1),(1);


Insert into locs_views(locId)
values(17231289),(17231289),(17231289),(17231289),(17231289),(17231289),(17231289),(17231289),(17231289),(17231289),
        (1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1),(1);
49 rows affected

SELECT *
FROM
(
    SELECT title,vws,clicks,id,  
         ROW_NUMBER() OVER (ORDER BY vws ASC) AS RowNum
    FROM (
    
       SELECT distinct(title) as title,    
            SUM(vws) as vws,
            SUM(clicks) as clicks,
            id 
        FROM(
            SELECT l.id,l.title,0 as vws, COUNT(lc.id) as clicks
            FROM locs l
            INNER JOIN locs_clicks lc on l.id=lc.locid
            GROUP BY l.title,l.id
            UNION
            SELECT l.id,l.title,COUNT(lv.id) as vws,0 as clicks
            FROM locs l
            INNER JOIN locs_views lv on l.id=lv.locid
            GROUP BY l.title,l.id
            )t
            GROUP BY title,id
    
      ) as info
)as info
WHERE RowNum > 0 AND RowNum <= 100


title
vws
clicks
id
RowNum


Mertz
10
2
17231289
1

Dacia
30
5
1
2