SELECT 	  TMP2				AS [Keyword]
	, COUNT(TMP1)			AS [Visits]
	, CASE WHEN ISNUMERIC(TMP3) = 1 
	       THEN TMP3 ELSE '0.00' 
	  END 				AS [Revenue]
	, CAST(CASE WHEN ISNUMERIC(TMP3) = 1 
		    THEN (CAST(TMP3 AS numeric)/COUNT(TMPsessionid) * 100/1) 
		    ELSE 0 
	  END AS numeric) AS [% Conv]
  FROM (
	    SELECT a.sessionid, b.[key], c.value 
	      FROM tb_session_ref a
	INNER JOIN tb_trackings c
		ON a.sessionid = c.sessionid
	INNER JOIN (    SELECT DISTINCT l.OriginalRef_url AS EngineName 
			  FROM Table1 l
		    INNER JOIN tblengines r
			    ON l.OriginalRef_url = r.enginename
			 WHERE l.hostid = @Hostid) As ReplaceCursor
		ON c.originalref_url = ReplaceCursor.EngineName
	INNER JOIN tb_session_pages d 
		ON a.sessionid = d.sessionid
	INNER JOIN tb_hostdetails b
		ON c.hostid = b.hostid 
	     WHERE c.hostid = @HostId 
	       AND a.[key] = 'q' 
	       AND AbsTimeStamp >= convert(varchar(12),@StartDate,120) AND AbsTimeStamp <= convert(varchar(12),@EndDate,120) 
	) AS XXX
GROUP BY TMP2,TMP1, TMP3