What
Where

with one as (SELECT TOP 4 4 AS totalSponsored, 0 AS total, ref, title, salary, description, city, category, FT_TBL.ID, FT_TBL.date, company, client, url, companyID, cpc, uniqueID, 0 AS RowNo, COALESCE(totalReviews,0) AS totalReviews, COALESCE(rating,0) AS rating, COALESCE(companyName,'') AS companyName FROM [ZigoZAJobs] AS FT_TBL left JOIN [companynames] on [companynames].ID=FT_TBL.companyID INNER JOIN CONTAINSTABLE ([ZigoZAJobs], (title, description, ref, company, client), '"It Support" OR "Support Specialist" OR ("It" AND "Support" AND "Specialist" )') AS KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY] WHERE cpc>0 AND ((FT_TBL.latitude= -33.96333 AND FT_TBL.longitude=18.47639) OR (( (6371 * acos (cos ( radians(-33.96333) ) * cos( radians(FT_TBL.latitude ) ) * cos( radians(FT_TBL.longitude ) - radians(18.47639) ) + sin ( radians(-33.96333) ) * sin( radians(FT_TBL.latitude ) )))<25))) order by cpc desc, date desc), JobSearch AS (SELECT 0 AS totalSponsored, COUNT(*) OVER() AS Total, ref, title, salary, description, city, category, ID, date, company, client, url, companyID, 0 AS cpc, uniqueID, ROW_NUMBER() OVER (ORDER BY date DESC) AS 'RowNo' FROM [ZigoZAJobs] AS FT_TBL INNER JOIN CONTAINSTABLE ([ZigoZAJobs], (title, description, ref, company, client), '"It Support" OR "Support Specialist" OR ("It" AND "Support" AND "Specialist" )') AS KEY_TBL ON FT_TBL.ID = KEY_TBL.[KEY] WHERE ((FT_TBL.latitude= -33.96333 AND FT_TBL.longitude=18.47639) OR (( (6371 * acos (cos ( radians(-33.96333) ) * cos( radians(FT_TBL.latitude ) ) * cos( radians(FT_TBL.longitude ) - radians(18.47639) ) + sin ( radians(-33.96333) ) * sin( radians(FT_TBL.latitude ) )))<25)))) select * from one union all SELECT totalSponsored, total, ref, title, salary, description, city, category, JobSearch.ID, JobSearch.date AS date, company, client, url, companyID, cpc, uniqueID, RowNo, COALESCE(totalReviews,0) AS totalReviews, COALESCE(rating,0) AS rating, COALESCE(companyName,'') AS companyName FROM JobSearch left JOIN [companynames] on [companynames].ID=[jobsearch].companyID WHERE RowNo BETWEEN 1 AND 10