Orgryte vs Hacken: Match Preview, Predictions and Betting Tips
Published on Thursday, 09 July 2026 by Steve
USE [CYBERTRAK]
GO
/****** Object: StoredProcedure [Core].[USP_AssetSelectATN] Script Date: 08/07/2026 09:55:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [Core].[USP_AssetSelectATN]
@Session_ID UNIQUEIDENTIFIER,
@SessionIsValid BIT = 0 OUTPUT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @SystemUser_ID INT;
DECLARE @Subscriber_ID INT;
DECLARE @Language_ID INT;
DECLARE @Timezone_StartDate DATETIME;
DECLARE @Timezone_EndDate DATETIME;
DECLARE @Timezone_Offset NVARCHAR(6);
EXEC Core.USP_SessionAuthenticate
@Session_ID = @Session_ID,
@SystemUser_ID = @SystemUser_ID OUTPUT,
@Subscriber_ID = @Subscriber_ID OUTPUT,
@Language_ID = @Language_ID OUTPUT,
@Timezone_StartDate = @Timezone_StartDate OUTPUT,
@Timezone_EndDate = @Timezone_EndDate OUTPUT,
@Timezone_Offset = @Timezone_Offset OUTPUT;
IF @SystemUser_ID IS NOT NULL
BEGIN
SET @SessionIsValid = 1;
SELECT
*
INTO
#Asset
FROM
(
SELECT DISTINCT
AssetGroup.AssetGroup_ID,
AssetGroup.AssetGroup_Name,
Asset.Asset_ID,
Asset.Asset_Name,
Asset.Asset_Subtitle,
Asset.Asset_IsVisible,
AssetType.AssetType_ID,
AssetType.AssetType_Name,
AssetIcon.AssetIcon_ID,
AssetIcon.AssetIcon_Name,
AssetIcon.AssetIcon_Path
--Unit.Unit_SerialID,
--Unit.Unit_Brand
FROM
Core.Asset AS Asset
INNER JOIN
Core.AssetType AS AssetType ON AssetType.AssetType_ID = Asset.AssetType_ID
INNER JOIN
Core.AssetIcon AS AssetIcon ON AssetIcon.AssetIcon_ID = Asset.AssetIcon_ID
INNER JOIN
Core.AssetGroupAsset AS AssetGroupAsset ON AssetGroupAsset.Asset_ID = Asset.Asset_ID
INNER JOIN
Core.AssetGroup AS AssetGroup ON AssetGroup.AssetGroup_ID = AssetGroupAsset.AssetGroup_ID
INNER JOIN
Core.SystemUserAssetGroup AS SystemUserAssetGroup ON SystemUserAssetGroup.AssetGroup_ID = AssetGroup.AssetGroup_ID
--INNER JOIN
--Core.UnitAsset AS UnitAsset ON UnitAsset.Asset_ID = Asset.Asset_ID
--INNER JOIN
-- Core.Unit AS Unit ON Unit.Unit_ID = UnitAsset.Unit_ID
WHERE
SystemUserAssetGroup.SystemUser_ID = @SystemUser_ID
AND Asset.Asset_IsVisible = 1
-- AND UnitAsset.UnitAsset_EndDate IS NULL --Active Unit
AND NOT EXISTS (SELECT Asset_ID FROM Insurance.AssetSubscription AssetSubscription WHERE Asset.Asset_ID = AssetSubscription.Asset_ID)
UNION ALL
SELECT DISTINCT
AssetGroup.AssetGroup_ID,
AssetGroup.AssetGroup_Name,
Asset.Asset_ID,
Asset.Asset_Name,
Asset.Asset_Subtitle,
Asset.Asset_IsVisible,
AssetType.AssetType_ID,
AssetType.AssetType_Name,
AssetIcon.AssetIcon_ID,
AssetIcon.AssetIcon_Name,
AssetIcon.AssetIcon_Path
--Unit.Unit_SerialID,
--Unit.Unit_Brand
FROM
Core.Asset AS Asset
INNER JOIN
Core.AssetType AS AssetType ON AssetType.AssetType_ID = Asset.AssetType_ID
INNER JOIN
Core.AssetIcon AS AssetIcon ON AssetIcon.AssetIcon_ID = Asset.AssetIcon_ID
INNER JOIN
Core.AssetGroupAsset AS AssetGroupAsset ON AssetGroupAsset.Asset_ID = Asset.Asset_ID
INNER JOIN
Core.AssetGroup AS AssetGroup ON AssetGroup.AssetGroup_ID = AssetGroupAsset.AssetGroup_ID
INNER JOIN
Core.SystemUserAssetGroup AS SystemUserAssetGroup ON SystemUserAssetGroup.AssetGroup_ID = AssetGroup.AssetGroup_ID
-- INNER JOIN
-- Core.UnitAsset AS UnitAsset ON UnitAsset.Asset_ID = Asset.Asset_ID
-- INNER JOIN
-- Core.Unit AS Unit ON Unit.Unit_ID = UnitAsset.Unit_ID
INNER JOIN
Insurance.AssetSubscription AS AssetSubscription ON Asset.Asset_ID = AssetSubscription.Asset_ID
WHERE
SystemUserAssetGroup.SystemUser_ID = @SystemUser_ID
AND Asset.Asset_IsVisible = 1
/*AND UnitAsset.UnitAsset_EndDate IS NULL AND
CONVERT(DATE, GETDATE()) BETWEEN AssetSubscription.AssetSubscription_StartDate AND AssetSubscription.AssetSubscription_EndDate*/
) AS Asset
ORDER BY
AssetGroup_Name,
Asset.Asset_Name;
SELECT
AssetVehicle.Asset_ID,
AssetVehicle.FuelType_ID,
AssetVehicle.AssetVehicle_FuelCapacity,
AssetVehicle.AssetVehicle_FuelConsumption,
ISNULL(CAST(FuelConsumption.FuelConsumption_KmLitre AS DECIMAL(18,2)), 0.00) AssetVehicle_FuelConsumptionKmLitre,
ISNULL(CAST(FuelConsumption.FuelConsumption_LitresPerHour AS DECIMAL(18,2)), 0.00) AssetVehicle_FuelConsumptionLitresPerHour,
ISNULL(CAST(AssetVehicle.AssetVehicle_CarbonDioxide AS DECIMAL(18,2)), 0.00) AssetVehicle_CarbonDioxide
INTO
#AssetVehicle
FROM
Core.AssetVehicle AS AssetVehicle
OUTER APPLY
(
SELECT
AVG(FuelTop28.FuelConsumption_KmLitre) FuelConsumption_KmLitre,
AVG(FuelTop28.FuelConsumption_LitresPerHour) FuelConsumption_LitresPerHour
FROM
(
SELECT TOP 28
FuelConsumption.FuelConsumption_KmLitre,
FuelConsumption.FuelConsumption_LitresPerHour
FROM
Data.FuelConsumption FuelConsumption
WHERE
FuelConsumption.Tracker_ID =
(SELECT Tracker_ID FROM Core.Tracker WHERE Asset_ID = AssetVehicle.Asset_ID AND Tracker_Code = 'FUEL')
ORDER BY FuelConsumption.FuelConsumption_StartDateTime DESC
) FuelTop28
) FuelConsumption
WHERE EXISTS
(SELECT Asset_ID FROM #Asset WHERE AssetVehicle.Asset_ID = #Asset.Asset_ID);
--SELECT
-- AssetVehicle.Asset_ID,
-- AssetVehicle.FuelType_ID,
-- AssetVehicle.AssetVehicle_FuelCapacity,
-- AssetVehicle.AssetVehicle_FuelConsumption
--INTO
-- #AssetVehicle
--FROM
-- Core.AssetVehicle AS AssetVehicle
--WHERE EXISTS
-- (SELECT Asset_ID FROM #Asset WHERE AssetVehicle.Asset_ID = #Asset.Asset_ID);
SELECT
Tracker.Asset_ID,
Tracker.Tracker_ID,
Tracker.Tracker_Code,
Tracker.Tracker_Name,
Tracker.Tracker_IsVisible,
TrackerType.TrackerType_ID,
TrackerType.TrackerType_Name
INTO
#Tracker
FROM
Core.[Tracker] AS Tracker
INNER JOIN
Core.[TrackerType] AS TrackerType ON TrackerType.TrackerType_ID = Tracker.TrackerType_ID
WHERE EXISTS
(SELECT Asset_ID FROM #Asset WHERE Tracker.Asset_ID = #Asset.Asset_ID) AND
Tracker.Tracker_IsVisible = 1;
SELECT
TrackerDigital.Tracker_ID,
TrackerDigital.TrackerDigital_InputID,
TrackerDigital.TrackerDigital_CaptionOn,
TrackerDigital.TrackerDigital_CaptionOff
INTO
#TrackerDigital
FROM
Core.[TrackerDigital] AS TrackerDigital
WHERE EXISTS
(SELECT Tracker_ID FROM #Tracker WHERE TrackerDigital.Tracker_ID = #Tracker.Tracker_ID);
SELECT
TrackerAnalogue.Tracker_ID,
TrackerAnalogue.TrackerAnalogue_InputID,
TrackerAnalogue.TrackerAnalogue_Accuracy,
TrackerAnalogue.TrackerAnalogue_Precision,
TrackerAnalogue.TrackerAnalogue_MinValue,
TrackerAnalogue.TrackerAnalogue_MaxValue,
TrackerAnalogue.TrackerAnalogue_RedFrom,
TrackerAnalogue.TrackerAnalogue_RedTo,
TrackerAnalogue.TrackerAnalogue_RedRGB,
TrackerAnalogue.TrackerAnalogue_YellowFrom,
TrackerAnalogue.TrackerAnalogue_YellowTo,
TrackerAnalogue.TrackerAnalogue_YellowRGB,
TrackerAnalogue.TrackerAnalogue_GreenFrom,
TrackerAnalogue.TrackerAnalogue_GreenTo,
TrackerAnalogue.TrackerAnalogue_GreenRGB
INTO
#TrackerAnalogue
FROM
Core.[TrackerAnalogue] AS TrackerAnalogue
WHERE EXISTS
(SELECT Tracker_ID FROM #Tracker WHERE TrackerAnalogue.Tracker_ID = #Tracker.Tracker_ID);
SELECT
TrackerAnalogueCalibration.Tracker_ID,
TrackerAnalogueCalibration.TrackerAnalogueCalibration_Timestamp,
TrackerAnalogueCalibration.TrackerAnalogueCalibration_Value
INTO
#TrackerAnalogueCalibration
FROM
Core.[TrackerAnalogueCalibration] AS TrackerAnalogueCalibration
WHERE EXISTS
(SELECT Tracker_ID FROM #Tracker WHERE TrackerAnalogueCalibration.Tracker_ID = #Tracker.Tracker_ID);
SELECT
TrackerIdentity.Tracker_ID,
TrackerIdentity.EntityList_ID
INTO
#TrackerIdentity
FROM
Core.[TrackerIdentity] AS TrackerIdentity
WHERE EXISTS
(SELECT Tracker_ID FROM #Tracker WHERE TrackerIdentity.Tracker_ID = #Tracker.Tracker_ID);
SELECT
AssetSubscription.Asset_ID,
MAX(AssetSubscription.AssetSubscription_ClientName) AssetSubscription_ClientName,
MAX(AssetSubscription.AssetSubscription_StartDate) AssetSubscription_StartDate,
MAX(AssetSubscription.AssetSubscription_EndDate) AssetSubscription_EndDate,
MAX(SubsDistance.AssetSubscription_DistanceAllowed) AssetSubscription_DistanceAllowed,
MAX(AssetSubscription.AssetSubscription_ScoreAllowed) AssetSubscription_ScoreAllowed
INTO
#AssetSubscription
FROM
Insurance.AssetSubscription AS AssetSubscription
INNER JOIN
(
SELECT Asset_ID, MAX(AssetSubscription_EndDate) AS AssetSubscription_EndDate
FROM Insurance.AssetSubscription
WHERE AssetSubscription.AssetSubscription_StartDate < GETDATE()
GROUP BY Asset_ID
) AS SubsDate
ON AssetSubscription.AssetSubscription_EndDate = SubsDate.AssetSubscription_EndDate AND AssetSubscription.Asset_ID = SubsDate.Asset_ID
OUTER APPLY
(
SELECT
SUM(AssetSubscription_DistanceAllowed) AS AssetSubscription_DistanceAllowed
FROM
Insurance.AssetSubscription Distance
WHERE
Distance.Asset_ID = AssetSubscription.Asset_ID AND Distance.AssetSubscription_EndDate = AssetSubscription.AssetSubscription_EndDate
) SubsDistance
WHERE EXISTS
(SELECT Asset_ID FROM #Asset WHERE AssetSubscription.Asset_ID = #Asset.Asset_ID)
GROUP BY AssetSubscription.Asset_ID;
SELECT
AssetGroup_ID,
AssetGroup_Name,
Asset_ID,
Asset_Name,
Asset_Subtitle,
Asset_IsVisible,
AssetType_ID,
AssetType_Name,
AssetIcon_ID,
AssetIcon_Name,
AssetIcon_Path
--Unit_SerialID,
--Unit_Brand
FROM #Asset;
SELECT
Asset_ID,
FuelType_ID,
AssetVehicle_FuelCapacity,
AssetVehicle_FuelConsumption,
AssetVehicle_FuelConsumptionKmLitre,
AssetVehicle_FuelConsumptionLitresPerHour,
AssetVehicle_CarbonDioxide
FROM #AssetVehicle;
DROP TABLE #AssetVehicle;
SELECT
Asset_ID,
Tracker_ID,
Tracker_Code,
Tracker_Name,
Tracker_IsVisible,
TrackerType_ID,
TrackerType_Name
FROM #Tracker
ORDER BY
Asset_ID, Tracker_Code DESC;
DROP TABLE #Tracker;
SELECT
Tracker_ID,
TrackerDigital_InputID,
TrackerDigital_CaptionOn,
TrackerDigital_CaptionOff
FROM #TrackerDigital;
DROP TABLE #TrackerDigital;
SELECT
Tracker_ID,
TrackerAnalogue_InputID,
ISNULL(TrackerAnalogue_Accuracy, 0.10) TrackerAnalogue_Accuracy,
ISNULL(TrackerAnalogue_Precision, 0.10) TrackerAnalogue_Precision,
ISNULL(TrackerAnalogue_MinValue, -40.00) TrackerAnalogue_MinValue,
ISNULL(TrackerAnalogue_MaxValue, 40.00) TrackerAnalogue_MaxValue,
ISNULL(TrackerAnalogue_RedFrom, 0) TrackerAnalogue_RedFrom,
ISNULL(TrackerAnalogue_RedTo, 0) TrackerAnalogue_RedTo,
ISNULL(TrackerAnalogue_RedRGB, '#FF0000') TrackerAnalogue_RedRGB,
ISNULL(TrackerAnalogue_YellowFrom, 20.00) TrackerAnalogue_YellowFrom,
ISNULL(TrackerAnalogue_YellowTo, 40.00) TrackerAnalogue_YellowTo,
ISNULL(TrackerAnalogue_YellowRGB, '#FFA500') TrackerAnalogue_YellowRGB,
ISNULL(TrackerAnalogue_GreenFrom, 0) TrackerAnalogue_GreenFrom,
ISNULL(TrackerAnalogue_GreenTo, 20) TrackerAnalogue_GreenTo,
ISNULL(TrackerAnalogue_GreenRGB, '#90EE90') TrackerAnalogue_GreenRGB
FROM #TrackerAnalogue;
DROP TABLE #TrackerAnalogue;
SELECT
Tracker_ID,
TrackerAnalogueCalibration_Timestamp,
TrackerAnalogueCalibration_Value
FROM #TrackerAnalogueCalibration;
DROP TABLE #TrackerAnalogueCalibration;
SELECT
Tracker_ID,
EntityList_ID
FROM #TrackerIdentity;
DROP TABLE #TrackerIdentity;
SELECT
Asset_ID,
AssetSubscription_ClientName,
AssetSubscription_StartDate,
AssetSubscription_EndDate,
AssetSubscription_DistanceAllowed,
AssetSubscription_ScoreAllowed
FROM
#AssetSubscription;
DROP TABLE #AssetSubscription;
SELECT
UnitAsset.Asset_ID,
Unit.Unit_SerialID,
Unit.Unit_Brand,
Unit.Ping_Mobile
FROM
Core.UnitAsset UnitAsset
INNER JOIN
Core.Unit Unit ON UnitAsset.Unit_ID = Unit.Unit_ID
WHERE EXISTS
(SELECT Asset_ID FROM #Asset WHERE UnitAsset.Asset_ID = #Asset.Asset_ID) AND
UnitAsset.UnitAsset_EndDate IS NULL;
--asset_temperature notification
SELECT
atn.Asset_ID,
atn.Tracker_ID,
atn.AssetNotification_ID,
ISNULL(atn.AssetNotification_IsActive, 0) AS AssetNotification_IsActive,
ISNULL(atn.AssetNotification_IntervalMins, 0) AS AssetNotification_IntervalMins
FROM
Scheduler.AssetTemperatureNotification atn
WHERE
atn.Asset_ID IN (SELECT Asset_ID FROM #Asset)
--asset_temperature notification Mobiles
SELECT
atn.Asset_ID,
atn.AssetNotification_ID,
[Scheduler].[AssetNotificationNumber].AssetNotification_MobileNo
FROM
Scheduler.AssetTemperatureNotification atn
Inner Join
[Scheduler].[AssetNotificationNumber] on [Scheduler].[AssetNotificationNumber].AssetNotification_ID = atn.AssetNotification_ID
WHERE
atn.Asset_ID IN (SELECT Asset_ID FROM #Asset)
--Asset Humidity Notification
SELECT AHN.Asset_ID,
AHN.AssetHumidityNotification_ID,
ISNULL(AHN.AssetHumidityNotification_IsActive, 0) AS AssetHumidityNotification_IsActive,
ISNULL(AHN.AssetHumidityNotification_IntervalMins, 0) AS AssetHumidityNotification_IntervalMins
FROM Scheduler.AssetHumidityNotification AHN
WHERE AHN.Asset_ID IN (SELECT Asset_ID FROM #Asset)
--Asset Humidity Notification Mobiles
SELECT AHN.Asset_ID,
AHN.AssetHumidityNotification_ID,
ANN.AssetNotification_MobileNo
FROM Scheduler.AssetHumidityNotification AHN INNER JOIN
Scheduler.AssetNotificationNumber ANN ON ANN.AssetHumidityNotification_ID = AHN.AssetHumidityNotification_ID
WHERE AHN.Asset_ID IN (SELECT Asset_ID FROM #Asset)
DROP TABLE #Asset;
END
END