INSERT INTO resource_placement (_name,_category,_level,_joinDate,_primaryResource,_supportResource,_seniorResource,_activeXCelerate,_resourceGroup,_totalCapacityCommitment,_progressLevel,_capacityGroup,_remarks,_enterBench,_exitBench,_check) VALUES ('','','','','','','','','','','','','','','',1) ON DUPLICATE KEY UPDATE _name = VALUES(_name),_category = VALUES(_category),_level = VALUES(_level),_joinDate = VALUES(_joinDate),_primaryResource = VALUES(_primaryResource),_supportResource = VALUES(_supportResource),_seniorResource = VALUES(_seniorResource),_activeXCelerate = VALUES(_activeXCelerate),_resourceGroup = VALUES(_resourceGroup),_totalCapacityCommitment = VALUES(_totalCapacityCommitment),_progressLevel = VALUES(_progressLevel),_capacityGroup = VALUES(_capacityGroup),_remarks = VALUES(_remarks),_enterBench = VALUES(_enterBench),_exitBench = VALUES(_exitBench),_check = VALUES(_check)<BR>INSERT INTO resource_placement (_name,_category,_level,_joinDate,_primaryResource,_supportResource,_seniorResource,_activeXCelerate,_resourceGroup,_totalCapacityCommitment,_progressLevel,_capacityGroup,_remarks,_enterBench,_exitBench,_check) VALUES ('','','','','','','','','','','','','','','',1) ON DUPLICATE KEY UPDATE _name = VALUES(_name),_category = VALUES(_category),_level = VALUES(_level),_joinDate = VALUES(_joinDate),_primaryResource = VALUES(_primaryResource),_supportResource = VALUES(_supportResource),_seniorResource = VALUES(_seniorResource),_activeXCelerate = VALUES(_activeXCelerate),_resourceGroup = VALUES(_resourceGroup),_totalCapacityCommitment = VALUES(_totalCapacityCommitment),_progressLevel = VALUES(_progressLevel),_capacityGroup = VALUES(_capacityGroup),_remarks = VALUES(_remarks),_enterBench = VALUES(_enterBench),_exitBench = VALUES(_exitBench),_check = VALUES(_check)<BR>UPDATE hiring_bench_dashboard d
INNER JOIN
(
SELECT COUNT(_id) AS '_ct' FROM current_training_bench WHERE _category IN ('Marketing Ops','Developer') AND LENGTH(_clientPlacement)=0
) o
SET d._trainingBench = o._ct
WHERE d._category = 'Marketing Ops'<BR>UPDATE hiring_bench_dashboard d
INNER JOIN
(
SELECT COUNT(_id) AS '_ct' FROM current_training_bench WHERE _category IN ('Campaigns','SEO') AND LENGTH(_clientPlacement)=0
) o
SET d._trainingBench = o._ct
WHERE d._category = 'Campaigns'<BR>UPDATE hiring_bench_dashboard d
INNER JOIN
(
SELECT COUNT(_id) AS '_ct' FROM current_training_bench WHERE _category IN ('Design','UX Design','Video Design') AND LENGTH(_clientPlacement)=0
) o
SET d._trainingBench = o._ct
WHERE d._category = 'Design'<BR>UPDATE hiring_bench_dashboard d
INNER JOIN
(
SELECT COUNT(_id) AS '_ct' FROM current_training_bench WHERE _category IN ('Analytics') AND LENGTH(_clientPlacement)=0
) o
SET d._trainingBench = o._ct
WHERE d._category = 'Analytics'<BR>UPDATE hiring_bench_dashboard d
INNER JOIN
(
SELECT COUNT(_id) AS '_ct' FROM current_training_bench WHERE _category IN ('Content') AND LENGTH(_clientPlacement)=0
) o
SET d._trainingBench = o._ct
WHERE d._category = 'Content'<BR>UPDATE hiring_bench_dashboard d
INNER JOIN
(
SELECT COUNT(_id) AS '_ct' FROM current_training_bench WHERE _category IN ('Governance') AND LENGTH(_clientPlacement)=0
) o
SET d._trainingBench = o._ct
WHERE d._category = 'Governance'<BR>UPDATE hiring_bench_dashboard d
INNER JOIN
(
SELECT COUNT(_id) AS '_ct' FROM current_training_bench WHERE _category IN ('Coordinator') AND LENGTH(_clientPlacement)=0
) o
SET d._trainingBench = o._ct
WHERE d._category = 'Coordinator'<BR>