CREATE Procedure sp_adm_getSoldPerDayFVH
As
	set nocount on
	SELECT Date, COUNT(*) AS no, SUM(Price) AS totsum
	FROM Booking
	WHERE amadeus<>'' AND [name] NOT LIKE '%test%' AND amadeus In 
		(
			SELECT logExtrainfo
			FROM travelstartver1.dbo.crm_logging
			WHERE (logCategoryID = 6) AND (logValue = 'flygvaruhuset')
			UNION
			SELECT logExtrainfo
			FROM travelstartver1.dbo.crm_loggingOld
			WHERE (logCategoryID = 6) AND (logValue = 'flygvaruhuset')
		)
	GROUP BY Date
	ORDER BY Date Asc
	return