SELECT
`Project1`.`C5` AS `C1`, 
`Project1`.`job_type_specific`, 
`Project1`.`C1` AS `C2`, 
`Project1`.`C2` AS `C3`, 
`Project1`.`C3` AS `C4`, 
`Project1`.`C4` AS `C5`
FROM (SELECT
`GroupBy4`.`A1` AS `C1`, 
`GroupBy4`.`A2` AS `C2`, 
`GroupBy4`.`A3` AS `C3`, 
`GroupBy4`.`A4` AS `C4`, 
`GroupBy4`.`K1` AS `job_type_specific`, 
1 AS `C5`
FROM (SELECT
`GroupBy1`.`K2` AS `K1`, 
COUNT(1) AS `A1`, 
AVG(`GroupBy1`.`A1`) AS `A2`, 
AVG((SELECT
SUM(CASE WHEN (@gp1 = `Extent7`.`measurement_category`) THEN (`Extent4`.`number_of_minutes`)  ELSE (0) END) AS `A1`
FROM `fact_time_and_motion` AS `Extent4` INNER JOIN `dim_date` AS `Extent5` ON `Extent4`.`study_date_id` = `Extent5`.`date_id` INNER JOIN `dim_time_and_motion_junk` AS `Extent6` ON `Extent4`.`time_in_motion_junk_id` = `Extent6`.`id` INNER JOIN `dim_time_and_motion_measure` AS `Extent7` ON `Extent4`.`time_and_motion_measure_id` = `Extent7`.`id`
 WHERE ((`Extent5`.`date` >= @p__linq__0) AND (`Extent5`.`date` <= @p__linq__1)) AND ((`GroupBy1`.`K1` = `Extent4`.`form_key`) AND ((`GroupBy1`.`K2` = `Extent6`.`job_type_specific`) OR ((`GroupBy1`.`K2` IS  NULL) AND (`Extent6`.`job_type_specific` IS  NULL)))))) AS `A3`, 
AVG((SELECT
SUM(CASE WHEN (NOT ((@gp2 = `Extent11`.`measurement_category`) AND (`Extent11`.`measurement_category` IS NOT NULL))) THEN (`Extent8`.`number_of_minutes`)  ELSE (0) END) AS `A1`
FROM `fact_time_and_motion` AS `Extent8` INNER JOIN `dim_date` AS `Extent9` ON `Extent8`.`study_date_id` = `Extent9`.`date_id` INNER JOIN `dim_time_and_motion_junk` AS `Extent10` ON `Extent8`.`time_in_motion_junk_id` = `Extent10`.`id` INNER JOIN `dim_time_and_motion_measure` AS `Extent11` ON `Extent8`.`time_and_motion_measure_id` = `Extent11`.`id`
 WHERE ((`Extent9`.`date` >= @p__linq__0) AND (`Extent9`.`date` <= @p__linq__1)) AND ((`GroupBy1`.`K1` = `Extent8`.`form_key`) AND ((`GroupBy1`.`K2` = `Extent10`.`job_type_specific`) OR ((`GroupBy1`.`K2` IS  NULL) AND (`Extent10`.`job_type_specific` IS  NULL)))))) AS `A4`
FROM (SELECT
`Extent1`.`form_key` AS `K1`, 
`Extent3`.`job_type_specific` AS `K2`, 
SUM(`Extent1`.`number_of_minutes`) AS `A1`
FROM `fact_time_and_motion` AS `Extent1` INNER JOIN `dim_date` AS `Extent2` ON `Extent1`.`study_date_id` = `Extent2`.`date_id` INNER JOIN `dim_time_and_motion_junk` AS `Extent3` ON `Extent1`.`time_in_motion_junk_id` = `Extent3`.`id`
 WHERE (`Extent2`.`date` >= @p__linq__0) AND (`Extent2`.`date` <= @p__linq__1)
 GROUP BY 
`Extent1`.`form_key`, 
`Extent3`.`job_type_specific`) AS `GroupBy1`
 GROUP BY 
`GroupBy1`.`K2`) AS `GroupBy4`) AS `Project1`
 ORDER BY 
`Project1`.`C2` DESC