page view macro sql

SELECT TAB2.pageid, TAB1.title ,TAB3.spacename
FROM content TAB1,
(SELECT pageid FROM content
WHERE pageid IN (select cast(right(bandanacontext,8) as integer) as contentcode from public.Bandana where  bandanacontext like 'net.kentcom.PageViewTracker.Daily.%' and LEFT(bandanakey,4) || '/' || SUBSTRING(bandanakey,5,2) || '/' || RIGHT(bandanakey,2) between '2018/01/01' and '2018/01/24') and pageid is not null) TAB2,spaces TAB3 
WHERE TAB2.pageid =  TAB1.contentid and TAB1.spaceid = TAB3.spaceid