INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (384, 'Ainaa Apendi','FounderShield-Advertising (80), FounderShield-Advertising (80), Carenet-Campaigns (80)','FounderShield (54), Lumivero (84)','Carenet') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (383, 'Charles Peter','FuelCycle-Developer (40), Televerde-Developer (80), Ricoh-Developer (120), Assent-Developer (20), TheLogicFactory-Developer (80), Assent-Developer (20), FuelCycle-Developer (40), Ricoh-Developer (120), Televerde-Developer (80), TheLogicFactory-Developer (20), Ricoh-Developer (53)','AllStar (14), FuelCycle (7), Linnworks (8), LogicSource (9), Ricoh (20), Televerde (6), TheLogicFactory (33)','Assent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (383, 'Charles Peter','FuelCycle-Developer (40), Televerde-Developer (80), Ricoh-Developer (120), Assent-Developer (20), TheLogicFactory-Developer (80), Assent-Developer (20), FuelCycle-Developer (40), Ricoh-Developer (120), Televerde-Developer (80), TheLogicFactory-Developer (20), Ricoh-Developer (53)','AllStar (14), FuelCycle (7), Linnworks (8), LogicSource (9), Ricoh (20), Televerde (6), TheLogicFactory (33)','Assent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (382, 'Jia Yee Choo','TrueLearn-Designer (60), SparkHire-UI/UX (80), Televerde-Designer (160), Infor-DC - Designer (1760), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Infor-DC - Designer (1760), Televerde-Designer (160), TrueLearn-Designer (60)','Infor (48), Rackspace (14)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (382, 'Jia Yee Choo','TrueLearn-Designer (60), SparkHire-UI/UX (80), Televerde-Designer (160), Infor-DC - Designer (1760), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Infor-DC - Designer (1760), Televerde-Designer (160), TrueLearn-Designer (60)','Infor (48), Rackspace (14)','SparkHire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (382, 'Jia Yee Choo','TrueLearn-Designer (60), SparkHire-UI/UX (80), Televerde-Designer (160), Infor-DC - Designer (1760), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Infor-DC - Designer (1760), Televerde-Designer (160), TrueLearn-Designer (60)','Infor (48), Rackspace (14)','Televerde') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (382, 'Jia Yee Choo','TrueLearn-Designer (60), SparkHire-UI/UX (80), Televerde-Designer (160), Infor-DC - Designer (1760), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Infor-DC - Designer (1760), Televerde-Designer (160), TrueLearn-Designer (60)','Infor (48), Rackspace (14)','Employbridge') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (382, 'Jia Yee Choo','TrueLearn-Designer (60), SparkHire-UI/UX (80), Televerde-Designer (160), Infor-DC - Designer (1760), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Infor-DC - Designer (1760), Televerde-Designer (160), TrueLearn-Designer (60)','Infor (48), Rackspace (14)','Employbridge') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (382, 'Jia Yee Choo','TrueLearn-Designer (60), SparkHire-UI/UX (80), Televerde-Designer (160), Infor-DC - Designer (1760), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Infor-DC - Designer (1760), Televerde-Designer (160), TrueLearn-Designer (60)','Infor (48), Rackspace (14)','Televerde') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (382, 'Jia Yee Choo','TrueLearn-Designer (60), SparkHire-UI/UX (80), Televerde-Designer (160), Infor-DC - Designer (1760), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Infor-DC - Designer (1760), Televerde-Designer (160), TrueLearn-Designer (60)','Infor (48), Rackspace (14)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (379, 'Gerald Krishnan','Hyland-Revenue Advertising (1160), Vertex-Governance (53)','EROAD (18), Hp (30), Jll (3), MetLife (8.5), Tispayments (4.5)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (379, 'Gerald Krishnan','Hyland-Revenue Advertising (1160), Vertex-Governance (53)','EROAD (18), Hp (30), Jll (3), MetLife (8.5), Tispayments (4.5)','Vertex') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (373, 'Michael Lawrence','Hyland-Advertising (ABM) (400)','','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (371, 'Virginia Woodford','eOriginal-Coordinator (480), eOriginal-Coordinator (480)','Canon (31.5), Diligent (6), FARO (53.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (371, 'Virginia Woodford','eOriginal-Coordinator (480), eOriginal-Coordinator (480)','Canon (31.5), Diligent (6), FARO (53.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (361, 'Maslin Roslan','TheLogicFactory-Governance (40), TheLogicFactory-Governance (40), Equiteq-Governance (40)','6sense (96.5)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (361, 'Maslin Roslan','TheLogicFactory-Governance (40), TheLogicFactory-Governance (40), Equiteq-Governance (40)','6sense (96.5)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (361, 'Maslin Roslan','TheLogicFactory-Governance (40), TheLogicFactory-Governance (40), Equiteq-Governance (40)','6sense (96.5)','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','Terrasmart') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','Terrasmart') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (360, 'Jacky Lo','DuckCreek-Developer (80), Corcentric-Developer (80), Terrasmart-Design Services Bureau (130), GibraltarMAPS-Web Support Team (240), Corcentric-Developer (80), GibraltarMAPS-Web Support Team (240), Terrasmart-Design Services Bureau (200), Cellebrite-Web Development Manager (160)','Linnworks (54), MetLife (63), Plume (20.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (358, 'Jack Lim','Corcentric-Designer (160), SparkHire-UI/UX (80), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Qlik-Design Service Bureau (200), Corcentric-Designer (80), Corcentric-Designer (160)','IronMountain (26.5), MultiPlan (108.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (358, 'Jack Lim','Corcentric-Designer (160), SparkHire-UI/UX (80), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Qlik-Design Service Bureau (200), Corcentric-Designer (80), Corcentric-Designer (160)','IronMountain (26.5), MultiPlan (108.5)','SparkHire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (358, 'Jack Lim','Corcentric-Designer (160), SparkHire-UI/UX (80), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Qlik-Design Service Bureau (200), Corcentric-Designer (80), Corcentric-Designer (160)','IronMountain (26.5), MultiPlan (108.5)','Employbridge') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (358, 'Jack Lim','Corcentric-Designer (160), SparkHire-UI/UX (80), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Qlik-Design Service Bureau (200), Corcentric-Designer (80), Corcentric-Designer (160)','IronMountain (26.5), MultiPlan (108.5)','Employbridge') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (358, 'Jack Lim','Corcentric-Designer (160), SparkHire-UI/UX (80), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Qlik-Design Service Bureau (200), Corcentric-Designer (80), Corcentric-Designer (160)','IronMountain (26.5), MultiPlan (108.5)','Qlik') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (358, 'Jack Lim','Corcentric-Designer (160), SparkHire-UI/UX (80), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Qlik-Design Service Bureau (200), Corcentric-Designer (80), Corcentric-Designer (160)','IronMountain (26.5), MultiPlan (108.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (358, 'Jack Lim','Corcentric-Designer (160), SparkHire-UI/UX (80), Employbridge-Creative Services (80), Employbridge-Design Service Bureau (80), Qlik-Design Service Bureau (200), Corcentric-Designer (80), Corcentric-Designer (160)','IronMountain (26.5), MultiPlan (108.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (356, 'Thinesh Nagiah','SAP-Event Coordinator (320), Vertex-Coordinator (80), 6sense-Coordinator (320), SAP-Event Coordinator (480), 6sense-Coordinator (320), SAP-Event Coordinator (400), Vertex-Coordinator (80)','','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (356, 'Thinesh Nagiah','SAP-Event Coordinator (320), Vertex-Coordinator (80), 6sense-Coordinator (320), SAP-Event Coordinator (480), 6sense-Coordinator (320), SAP-Event Coordinator (400), Vertex-Coordinator (80)','','Vertex') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (356, 'Thinesh Nagiah','SAP-Event Coordinator (320), Vertex-Coordinator (80), 6sense-Coordinator (320), SAP-Event Coordinator (480), 6sense-Coordinator (320), SAP-Event Coordinator (400), Vertex-Coordinator (80)','','6sense') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (356, 'Thinesh Nagiah','SAP-Event Coordinator (320), Vertex-Coordinator (80), 6sense-Coordinator (320), SAP-Event Coordinator (480), 6sense-Coordinator (320), SAP-Event Coordinator (400), Vertex-Coordinator (80)','','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (356, 'Thinesh Nagiah','SAP-Event Coordinator (320), Vertex-Coordinator (80), 6sense-Coordinator (320), SAP-Event Coordinator (480), 6sense-Coordinator (320), SAP-Event Coordinator (400), Vertex-Coordinator (80)','','6sense') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (356, 'Thinesh Nagiah','SAP-Event Coordinator (320), Vertex-Coordinator (80), 6sense-Coordinator (320), SAP-Event Coordinator (480), 6sense-Coordinator (320), SAP-Event Coordinator (400), Vertex-Coordinator (80)','','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (356, 'Thinesh Nagiah','SAP-Event Coordinator (320), Vertex-Coordinator (80), 6sense-Coordinator (320), SAP-Event Coordinator (480), 6sense-Coordinator (320), SAP-Event Coordinator (400), Vertex-Coordinator (80)','','Vertex') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (345, 'Ji Hui Lim','FARO-Holobuilder - Marketing Ops (160), FARO-Holobuilder - Marketing Ops (160)','eSentire (47.5), Jaggaer (32), Ninjio (63)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (345, 'Ji Hui Lim','FARO-Holobuilder - Marketing Ops (160), FARO-Holobuilder - Marketing Ops (160)','eSentire (47.5), Jaggaer (32), Ninjio (63)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (334, 'Jack Lee','Cellebrite-Attribution Fix Project (400), Cellebrite-Attribution Fix Project (0)','MetLife (57.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (334, 'Jack Lee','Cellebrite-Attribution Fix Project (400), Cellebrite-Attribution Fix Project (0)','MetLife (57.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (332, 'Kar Yann Hor','TrueLearn-Developer (40), Blend360-Developer (40), Sandler-Developer (80), Blend360-Developer (40), Sandler-Developer (80), TrueLearn-Developer (40)','IQBackOffice (24), Perforce (6), Sandler (21)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (332, 'Kar Yann Hor','TrueLearn-Developer (40), Blend360-Developer (40), Sandler-Developer (80), Blend360-Developer (40), Sandler-Developer (80), TrueLearn-Developer (40)','IQBackOffice (24), Perforce (6), Sandler (21)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (332, 'Kar Yann Hor','TrueLearn-Developer (40), Blend360-Developer (40), Sandler-Developer (80), Blend360-Developer (40), Sandler-Developer (80), TrueLearn-Developer (40)','IQBackOffice (24), Perforce (6), Sandler (21)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (332, 'Kar Yann Hor','TrueLearn-Developer (40), Blend360-Developer (40), Sandler-Developer (80), Blend360-Developer (40), Sandler-Developer (80), TrueLearn-Developer (40)','IQBackOffice (24), Perforce (6), Sandler (21)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (316, 'Khairie Apirin','Code42-Writer (80), Infor-DC - Writer (1280), Code42-Writer (80), Infor-DC - Writer (1600)','Linnworks (104.5)','Code42') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (316, 'Khairie Apirin','Code42-Writer (80), Infor-DC - Writer (1280), Code42-Writer (80), Infor-DC - Writer (1600)','Linnworks (104.5)','Infor') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (316, 'Khairie Apirin','Code42-Writer (80), Infor-DC - Writer (1280), Code42-Writer (80), Infor-DC - Writer (1600)','Linnworks (104.5)','Code42') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (316, 'Khairie Apirin','Code42-Writer (80), Infor-DC - Writer (1280), Code42-Writer (80), Infor-DC - Writer (1600)','Linnworks (104.5)','Infor') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (314, 'Maran Narayanan','WKHLRP-Marketing Ops (320), Hyland-DPS (Ops) (1040), WKHLRP-Marketing Ops (320)','GoTo (98.5), Hyland (55.5)','WKHLRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (314, 'Maran Narayanan','WKHLRP-Marketing Ops (320), Hyland-DPS (Ops) (1040), WKHLRP-Marketing Ops (320)','GoTo (98.5), Hyland (55.5)','WKHLRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (319, 'Hari Gunasegaran','Assent-Marketing Ops (CMS) (53), Assent-Marketing Ops (CMS) (53)','GibraltarBA (13.5), Hyland (6), KomodoHealth (31)','Assent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (319, 'Hari Gunasegaran','Assent-Marketing Ops (CMS) (53), Assent-Marketing Ops (CMS) (53)','GibraltarBA (13.5), Hyland (6), KomodoHealth (31)','Assent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (303, 'Cherish Moy','DELMIA-Coordinator (40), TheLogicFactory-Email Marketing (80), WoltersKluwer-Governance (80), WKHLRP-Coordinator (80), DELMIA-Coordinator (40), WKHLRP-Coordinator (80), WoltersKluwer-Governance (80)','WKHLRP (54.5), WoltersKluwer (6)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (303, 'Cherish Moy','DELMIA-Coordinator (40), TheLogicFactory-Email Marketing (80), WoltersKluwer-Governance (80), WKHLRP-Coordinator (80), DELMIA-Coordinator (40), WKHLRP-Coordinator (80), WoltersKluwer-Governance (80)','WKHLRP (54.5), WoltersKluwer (6)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (303, 'Cherish Moy','DELMIA-Coordinator (40), TheLogicFactory-Email Marketing (80), WoltersKluwer-Governance (80), WKHLRP-Coordinator (80), DELMIA-Coordinator (40), WKHLRP-Coordinator (80), WoltersKluwer-Governance (80)','WKHLRP (54.5), WoltersKluwer (6)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (283, 'Amery Ho','Hyland-Digital Engagement (1800)','','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (256, 'Jasmine Sim','FARO-GDC - Marketing Ops - Pardot (160), FARO-GDC - Marketing Ops - Pardot (160), RCG-Marketing Ops (160)','Growtomation (18), IQBackOffice (11.5), Lytho (3), Orion (77.5), RCG (84.5)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (256, 'Jasmine Sim','FARO-GDC - Marketing Ops - Pardot (160), FARO-GDC - Marketing Ops - Pardot (160), RCG-Marketing Ops (160)','Growtomation (18), IQBackOffice (11.5), Lytho (3), Orion (77.5), RCG (84.5)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (248, 'Noel Foo','SBI-Writer (240), SBI-Writer (240), Qlik-Writer (240)','Equiteq (0.5), Jll (26.5), Qlik (20.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (248, 'Noel Foo','SBI-Writer (240), SBI-Writer (240), Qlik-Writer (240)','Equiteq (0.5), Jll (26.5), Qlik (20.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (240, 'Eijas Ariffin','Agiloft-Writer (80), Agiloft-Writer (80), Qlik-Writer (240)','Onec1 (83), Vizient (39.5)','Agiloft') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (240, 'Eijas Ariffin','Agiloft-Writer (80), Agiloft-Writer (80), Qlik-Writer (240)','Onec1 (83), Vizient (39.5)','Agiloft') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (240, 'Eijas Ariffin','Agiloft-Writer (80), Agiloft-Writer (80), Qlik-Writer (240)','Onec1 (83), Vizient (39.5)','Qlik') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (235, 'Amalina Amaladdin','Hyland-Digital Engagement (1800), Emburse-Creative Services (400)','Emburse (52), IntelligentDemand (1)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (225, 'Jun Shien Goh','3X-Marketing Ops (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), 3X-Marketing Ops (80), Hyland-Digital Engagement (1800)','3X (106.5), Cohesity (1), Hyland (5.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (225, 'Jun Shien Goh','3X-Marketing Ops (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), 3X-Marketing Ops (80), Hyland-Digital Engagement (1800)','3X (106.5), Cohesity (1), Hyland (5.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (129, 'Angeline Ng','Plume-Governance (53), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Plume-Governance (53)','Perforce (126.5), Vaco (9.5)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (129, 'Angeline Ng','Plume-Governance (53), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Plume-Governance (53)','Perforce (126.5), Vaco (9.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (129, 'Angeline Ng','Plume-Governance (53), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Plume-Governance (53)','Perforce (126.5), Vaco (9.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (129, 'Angeline Ng','Plume-Governance (53), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Plume-Governance (53)','Perforce (126.5), Vaco (9.5)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1048, 'Balqis Osman','Skysafe-ABM Campaign MRC (350), Skysafe-ABM Campaign MRC (500)','3X (127)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1048, 'Balqis Osman','Skysafe-ABM Campaign MRC (350), Skysafe-ABM Campaign MRC (500)','3X (127)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (960, 'Weijia Wong','3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (350), 3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (500), Qlik-Marketing Ops (240)','Qlik (29.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (960, 'Weijia Wong','3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (350), 3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (500), Qlik-Marketing Ops (240)','Qlik (29.5)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (960, 'Weijia Wong','3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (350), 3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (500), Qlik-Marketing Ops (240)','Qlik (29.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (960, 'Weijia Wong','3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (350), 3E-Marketing Support MRC (250), Skysafe-ABM Campaign MRC (500), Qlik-Marketing Ops (240)','Qlik (29.5)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1036, 'Nisha Kurup','3X-Coordinator (160), SBI-Coordinator (80), 3X-Coordinator (160), SBI-Coordinator (80)','Hyland (60), MetLife (43.5)','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1036, 'Nisha Kurup','3X-Coordinator (160), SBI-Coordinator (80), 3X-Coordinator (160), SBI-Coordinator (80)','Hyland (60), MetLife (43.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1036, 'Nisha Kurup','3X-Coordinator (160), SBI-Coordinator (80), 3X-Coordinator (160), SBI-Coordinator (80)','Hyland (60), MetLife (43.5)','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1036, 'Nisha Kurup','3X-Coordinator (160), SBI-Coordinator (80), 3X-Coordinator (160), SBI-Coordinator (80)','Hyland (60), MetLife (43.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1030, 'Maslinda Brown','SandlerNetwork-Coordinator (80), 6sense-Coordinator (320), 6sense-Coordinator (320), SandlerNetwork-Coordinator (80)','6sense (0.5), SAP (92.5)','SandlerNetwork') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1030, 'Maslinda Brown','SandlerNetwork-Coordinator (80), 6sense-Coordinator (320), 6sense-Coordinator (320), SandlerNetwork-Coordinator (80)','6sense (0.5), SAP (92.5)','SandlerNetwork') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (971, 'Thayalan Sundralingam','BRP-Marketing Ops (53), BRP-Marketing Ops (ABM) (53), Emburse-Marketing Ops (340)','HitachiDigital (44.5), Hyland (31)','BRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (971, 'Thayalan Sundralingam','BRP-Marketing Ops (53), BRP-Marketing Ops (ABM) (53), Emburse-Marketing Ops (340)','HitachiDigital (44.5), Hyland (31)','BRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (971, 'Thayalan Sundralingam','BRP-Marketing Ops (53), BRP-Marketing Ops (ABM) (53), Emburse-Marketing Ops (340)','HitachiDigital (44.5), Hyland (31)','Emburse') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1026, 'Veronica Wong','Influitive-Governance (53), KomodoHealth-Marketing Support MRC (500), Influitive-Governance (53), KomodoHealth-MRC (500)','KomodoHealth (41.5), ProcessUnity (45)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1026, 'Veronica Wong','Influitive-Governance (53), KomodoHealth-Marketing Support MRC (500), Influitive-Governance (53), KomodoHealth-MRC (500)','KomodoHealth (41.5), ProcessUnity (45)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1025, 'Nicoleta Tache','LogicSource-Governance (80), LogicSource-Governance (80)','','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1025, 'Nicoleta Tache','LogicSource-Governance (80), LogicSource-Governance (80)','','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1024, 'Khaleel Lewis','Novata-Developer (53), GibraltarMAPS-Web Support Team (240), GibraltarMAPS-Web Support Team (240), Novata-Developer (53)','Equiteq (1.5), Liongard (0.5), Lumivero (55), Novata (9.5)','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1024, 'Khaleel Lewis','Novata-Developer (53), GibraltarMAPS-Web Support Team (240), GibraltarMAPS-Web Support Team (240), Novata-Developer (53)','Equiteq (1.5), Liongard (0.5), Lumivero (55), Novata (9.5)','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1010, 'Carmen Chan','RetailStat-Governance (40), RetailStat-Governance (0), BestPass-MRC (375)','Bestpass (56), Certinia (77), Hp (53.5)','RetailStat') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1010, 'Carmen Chan','RetailStat-Governance (40), RetailStat-Governance (0), BestPass-MRC (375)','Bestpass (56), Certinia (77), Hp (53.5)','RetailStat') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1010, 'Carmen Chan','RetailStat-Governance (40), RetailStat-Governance (0), BestPass-MRC (375)','Bestpass (56), Certinia (77), Hp (53.5)','BestPass') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1015, 'Zoey Khoo','WKHLRP-Ad Hoc Support (80), WKHLRP-Ad Hoc Support (40)','Canon (133.5), Planful (0.5), WoltersKluwer (1.5)','WKHLRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1015, 'Zoey Khoo','WKHLRP-Ad Hoc Support (80), WKHLRP-Ad Hoc Support (40)','Canon (133.5), Planful (0.5), WoltersKluwer (1.5)','WKHLRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1014, 'Julian Choong','GibraltarBA-Email Marketing (53), GibraltarBA-Email Marketing (160)','GlobalAtlantic (117)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1014, 'Julian Choong','GibraltarBA-Email Marketing (53), GibraltarBA-Email Marketing (160)','GlobalAtlantic (117)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (995, 'Reshna Ganesan','Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), EDB-Writer (90)','Orion (156)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (995, 'Reshna Ganesan','Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), EDB-Writer (90)','Orion (156)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (995, 'Reshna Ganesan','Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), EDB-Writer (90)','Orion (156)','EDB') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1000, 'Jaling Sim','Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477)','Infor (24)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (1000, 'Jaling Sim','Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477)','Infor (24)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (990, 'Elaine Lau','Fastmarkets-Creative Services (160), KomodoHealth-Marketing Support MRC (500), Fastmarkets-Creative Services (160), KomodoHealth-MRC (500), EDB-Writer (90)','Abbyy (11), KomodoHealth (6), Perforce (62.5), RCG (36), Reorg (0.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (990, 'Elaine Lau','Fastmarkets-Creative Services (160), KomodoHealth-Marketing Support MRC (500), Fastmarkets-Creative Services (160), KomodoHealth-MRC (500), EDB-Writer (90)','Abbyy (11), KomodoHealth (6), Perforce (62.5), RCG (36), Reorg (0.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (990, 'Elaine Lau','Fastmarkets-Creative Services (160), KomodoHealth-Marketing Support MRC (500), Fastmarkets-Creative Services (160), KomodoHealth-MRC (500), EDB-Writer (90)','Abbyy (11), KomodoHealth (6), Perforce (62.5), RCG (36), Reorg (0.5)','EDB') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (974, 'Yasmine Sofian','Hyland-Hive9 Support (160), DPR-Marketing Ops and Analytics (320)','Hyland (60.5), MetLife (66.5)','DPR') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (939, 'Wayne Chew','Thunder-Advertising (80), DAS42-Advertising (80), DAS42-Advertising (80), Thunder-Advertising (80), Symplr-Digital Advertising (80), Carenet-Campaigns (80)','Hyland (89.5)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (939, 'Wayne Chew','Thunder-Advertising (80), DAS42-Advertising (80), DAS42-Advertising (80), Thunder-Advertising (80), Symplr-Digital Advertising (80), Carenet-Campaigns (80)','Hyland (89.5)','DAS42') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (939, 'Wayne Chew','Thunder-Advertising (80), DAS42-Advertising (80), DAS42-Advertising (80), Thunder-Advertising (80), Symplr-Digital Advertising (80), Carenet-Campaigns (80)','Hyland (89.5)','DAS42') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (939, 'Wayne Chew','Thunder-Advertising (80), DAS42-Advertising (80), DAS42-Advertising (80), Thunder-Advertising (80), Symplr-Digital Advertising (80), Carenet-Campaigns (80)','Hyland (89.5)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (939, 'Wayne Chew','Thunder-Advertising (80), DAS42-Advertising (80), DAS42-Advertising (80), Thunder-Advertising (80), Symplr-Digital Advertising (80), Carenet-Campaigns (80)','Hyland (89.5)','Symplr') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (939, 'Wayne Chew','Thunder-Advertising (80), DAS42-Advertising (80), DAS42-Advertising (80), Thunder-Advertising (80), Symplr-Digital Advertising (80), Carenet-Campaigns (80)','Hyland (89.5)','Carenet') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (940, 'Louise Yoong','Hyland-Revenue Advertising (1160)','ProcessUnity (82)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (975, 'Andrew Ong','Diligent-Campaign Management (160), Cellebrite-Program Manager (SaaS) (160), Cellebrite-Program Manager (SaaS) (160)','3X (113)','Diligent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (975, 'Andrew Ong','Diligent-Campaign Management (160), Cellebrite-Program Manager (SaaS) (160), Cellebrite-Program Manager (SaaS) (160)','3X (113)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (975, 'Andrew Ong','Diligent-Campaign Management (160), Cellebrite-Program Manager (SaaS) (160), Cellebrite-Program Manager (SaaS) (160)','3X (113)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (973, 'Faisalhaziq Rusman','GibraltarBA-Web Support Team (320), Exiger-Creative Services (120), Vertex-Developer (40), Exiger-Creative Services (120), "GibraltarBA-Design Bureau (Web, UIUX) (100)", GibraltarBA-Web Support Team (0)','3E (13), 7Rivers (36.5), DAS42 (21.5), GibraltarBA (18)','Exiger') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (973, 'Faisalhaziq Rusman','GibraltarBA-Web Support Team (320), Exiger-Creative Services (120), Vertex-Developer (40), Exiger-Creative Services (120), "GibraltarBA-Design Bureau (Web, UIUX) (100)", GibraltarBA-Web Support Team (0)','3E (13), 7Rivers (36.5), DAS42 (21.5), GibraltarBA (18)','Vertex') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (973, 'Faisalhaziq Rusman','GibraltarBA-Web Support Team (320), Exiger-Creative Services (120), Vertex-Developer (40), Exiger-Creative Services (120), "GibraltarBA-Design Bureau (Web, UIUX) (100)", GibraltarBA-Web Support Team (0)','3E (13), 7Rivers (36.5), DAS42 (21.5), GibraltarBA (18)','Exiger') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (973, 'Faisalhaziq Rusman','GibraltarBA-Web Support Team (320), Exiger-Creative Services (120), Vertex-Developer (40), Exiger-Creative Services (120), "GibraltarBA-Design Bureau (Web, UIUX) (100)", GibraltarBA-Web Support Team (0)','3E (13), 7Rivers (36.5), DAS42 (21.5), GibraltarBA (18)','"GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (973, 'Faisalhaziq Rusman','GibraltarBA-Web Support Team (320), Exiger-Creative Services (120), Vertex-Developer (40), Exiger-Creative Services (120), "GibraltarBA-Design Bureau (Web, UIUX) (100)", GibraltarBA-Web Support Team (0)','3E (13), 7Rivers (36.5), DAS42 (21.5), GibraltarBA (18)','UIUX) (100)"') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (965, 'Atikah Mahdzir','NoRedInk-Coordinator (40), 6sense-Coordinator (320), 6sense-Coordinator (320), NoRedInk-Coordinator (40), GoTo-Digital Activation Service Desk (1200), GoTo-Coordinator (160)','Diligent (49.5), RandstadSM (14.5), Recognize (59)','NoRedInk') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (965, 'Atikah Mahdzir','NoRedInk-Coordinator (40), 6sense-Coordinator (320), 6sense-Coordinator (320), NoRedInk-Coordinator (40), GoTo-Digital Activation Service Desk (1200), GoTo-Coordinator (160)','Diligent (49.5), RandstadSM (14.5), Recognize (59)','6sense') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (965, 'Atikah Mahdzir','NoRedInk-Coordinator (40), 6sense-Coordinator (320), 6sense-Coordinator (320), NoRedInk-Coordinator (40), GoTo-Digital Activation Service Desk (1200), GoTo-Coordinator (160)','Diligent (49.5), RandstadSM (14.5), Recognize (59)','6sense') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (965, 'Atikah Mahdzir','NoRedInk-Coordinator (40), 6sense-Coordinator (320), 6sense-Coordinator (320), NoRedInk-Coordinator (40), GoTo-Digital Activation Service Desk (1200), GoTo-Coordinator (160)','Diligent (49.5), RandstadSM (14.5), Recognize (59)','NoRedInk') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (965, 'Atikah Mahdzir','NoRedInk-Coordinator (40), 6sense-Coordinator (320), 6sense-Coordinator (320), NoRedInk-Coordinator (40), GoTo-Digital Activation Service Desk (1200), GoTo-Coordinator (160)','Diligent (49.5), RandstadSM (14.5), Recognize (59)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (965, 'Atikah Mahdzir','NoRedInk-Coordinator (40), 6sense-Coordinator (320), 6sense-Coordinator (320), NoRedInk-Coordinator (40), GoTo-Digital Activation Service Desk (1200), GoTo-Coordinator (160)','Diligent (49.5), RandstadSM (14.5), Recognize (59)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (958, 'Richard Ong','Fastmarkets-Creative Services (160), Fastmarkets-Creative Services (160), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (158.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (958, 'Richard Ong','Fastmarkets-Creative Services (160), Fastmarkets-Creative Services (160), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (158.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (944, 'Amira Aziz','SAP-Email (Studio) (640), SAP-Email (Studio) (560)','Abbyy (5), EPAM (13.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (944, 'Amira Aziz','SAP-Email (Studio) (640), SAP-Email (Studio) (560)','Abbyy (5), EPAM (13.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (948, 'Erjun Ooi','Integreon-Coordinator (40), SimpleTire-Email & Ops MRC (125), SimpleTire-Email & Ops MRC (125), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','Anteriad (49.5), eOriginal (50), FounderShield (5)','Integreon') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (948, 'Erjun Ooi','Integreon-Coordinator (40), SimpleTire-Email & Ops MRC (125), SimpleTire-Email & Ops MRC (125), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','Anteriad (49.5), eOriginal (50), FounderShield (5)','SimpleTire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (948, 'Erjun Ooi','Integreon-Coordinator (40), SimpleTire-Email & Ops MRC (125), SimpleTire-Email & Ops MRC (125), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','Anteriad (49.5), eOriginal (50), FounderShield (5)','SimpleTire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (948, 'Erjun Ooi','Integreon-Coordinator (40), SimpleTire-Email & Ops MRC (125), SimpleTire-Email & Ops MRC (125), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','Anteriad (49.5), eOriginal (50), FounderShield (5)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (948, 'Erjun Ooi','Integreon-Coordinator (40), SimpleTire-Email & Ops MRC (125), SimpleTire-Email & Ops MRC (125), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','Anteriad (49.5), eOriginal (50), FounderShield (5)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (945, 'Steven Wong','DuckCreek-Marketing Ops (80), Enverus-Marketing Ops (160), DuckCreek-Marketing Ops (120), Enverus-Marketing Ops (160)','Growtomation (4), MetLife (44), Seismic (19)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (945, 'Steven Wong','DuckCreek-Marketing Ops (80), Enverus-Marketing Ops (160), DuckCreek-Marketing Ops (120), Enverus-Marketing Ops (160)','Growtomation (4), MetLife (44), Seismic (19)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (945, 'Steven Wong','DuckCreek-Marketing Ops (80), Enverus-Marketing Ops (160), DuckCreek-Marketing Ops (120), Enverus-Marketing Ops (160)','Growtomation (4), MetLife (44), Seismic (19)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (945, 'Steven Wong','DuckCreek-Marketing Ops (80), Enverus-Marketing Ops (160), DuckCreek-Marketing Ops (120), Enverus-Marketing Ops (160)','Growtomation (4), MetLife (44), Seismic (19)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (922, 'Sujahn Shankar','EMS-Governance (80), Wavestone-Governance (20), EMS-Governance (80), Wavestone-Governance (20)','','EMS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (922, 'Sujahn Shankar','EMS-Governance (80), Wavestone-Governance (20), EMS-Governance (80), Wavestone-Governance (20)','','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (922, 'Sujahn Shankar','EMS-Governance (80), Wavestone-Governance (20), EMS-Governance (80), Wavestone-Governance (20)','','EMS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (922, 'Sujahn Shankar','EMS-Governance (80), Wavestone-Governance (20), EMS-Governance (80), Wavestone-Governance (20)','','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (927, 'Farah Zahid','TrueLearn-Designer (60), TrueLearn-Designer (60)','JellyVision (16.5), PCS (66.5), Syniti (9)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (927, 'Farah Zahid','TrueLearn-Designer (60), TrueLearn-Designer (60)','JellyVision (16.5), PCS (66.5), Syniti (9)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (911, 'Rajveer Singh','Prospiant-Analyst (160), Prospiant-Analyst (80), Prospiant-Analyst (32)','Hyland (73.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (911, 'Rajveer Singh','Prospiant-Analyst (160), Prospiant-Analyst (80), Prospiant-Analyst (32)','Hyland (73.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (911, 'Rajveer Singh','Prospiant-Analyst (160), Prospiant-Analyst (80), Prospiant-Analyst (32)','Hyland (73.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (923, 'Atiqah Azhar','TheLogicFactory-Email Marketing (80), TheLogicFactory-Email Marketing (40)','','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (923, 'Atiqah Azhar','TheLogicFactory-Email Marketing (80), TheLogicFactory-Email Marketing (40)','','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (933, 'Isaac Lim','FounderShield-Designer (80), VertexCM-UI/UX (40), FounderShield-Designer (80), Liferay-MRC (425)','FounderShield (23), QualiTest (30), SSCTech (30), Televerde (25)','VertexCM') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (933, 'Isaac Lim','FounderShield-Designer (80), VertexCM-UI/UX (40), FounderShield-Designer (80), Liferay-MRC (425)','FounderShield (23), QualiTest (30), SSCTech (30), Televerde (25)','Liferay') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (914, 'Akid Rusyaidi','TrueLearn-UI/UX (20), SBI-Designer (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), SBI-Designer (80), TrueLearn-UI/UX (20)','3E (12), Hp (14.5), IQBackOffice (18.5)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (914, 'Akid Rusyaidi','TrueLearn-UI/UX (20), SBI-Designer (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), SBI-Designer (80), TrueLearn-UI/UX (20)','3E (12), Hp (14.5), IQBackOffice (18.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (914, 'Akid Rusyaidi','TrueLearn-UI/UX (20), SBI-Designer (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), SBI-Designer (80), TrueLearn-UI/UX (20)','3E (12), Hp (14.5), IQBackOffice (18.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (914, 'Akid Rusyaidi','TrueLearn-UI/UX (20), SBI-Designer (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), SBI-Designer (80), TrueLearn-UI/UX (20)','3E (12), Hp (14.5), IQBackOffice (18.5)','TrueLearn') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (913, 'Najwa Adeela','Brightcove-Coordinator (53), Brightcove-Coordinator (0), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','SAP (145.5)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (913, 'Najwa Adeela','Brightcove-Coordinator (53), Brightcove-Coordinator (0), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','SAP (145.5)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (913, 'Najwa Adeela','Brightcove-Coordinator (53), Brightcove-Coordinator (0), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','SAP (145.5)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (913, 'Najwa Adeela','Brightcove-Coordinator (53), Brightcove-Coordinator (0), GoTo-Campaign Service Desk (480), GoTo-Program Manager (640)','SAP (145.5)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (903, 'Jim Koay','Cellebrite-Marketing Ops (DAM) (160), Carenet-Marketing Ops (80)','GlobalAtlantic (149.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (903, 'Jim Koay','Cellebrite-Marketing Ops (DAM) (160), Carenet-Marketing Ops (80)','GlobalAtlantic (149.5)','Carenet') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (905, 'Li Wei Tham','Diligent-Marketing Ops - Ringlead (160), EMS-Marketing Ops (80), KomodoHealth-Marketing Support MRC (500), EMS-Marketing Ops (80), KomodoHealth-MRC (500)','EMS (4), KomodoHealth (40), ULSolutions (34.5)','Diligent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (899, 'Pei Jean Ng','Terrasmart-Governance (53), SAP-Core Events Project (1120), Terrasmart-Governance (53), SAP-Governance (272)','GoTo (164), SAP (43.5), Syniti (0.5)','Terrasmart') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (899, 'Pei Jean Ng','Terrasmart-Governance (53), SAP-Core Events Project (1120), Terrasmart-Governance (53), SAP-Governance (272)','GoTo (164), SAP (43.5), Syniti (0.5)','Terrasmart') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (909, 'Fareez Poot','Diligent-Marketing Ops - Ringlead (160)','Hyland (63.5)','Diligent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (891, 'Sheng Jit Koo','EMS-Advertising (80), EMS-Advertising (80), Terrasmart-Digital Advertising (80)','Bestpass (4), Carenet (76.5), Welocalize (68)','EMS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (891, 'Sheng Jit Koo','EMS-Advertising (80), EMS-Advertising (80), Terrasmart-Digital Advertising (80)','Bestpass (4), Carenet (76.5), Welocalize (68)','EMS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (891, 'Sheng Jit Koo','EMS-Advertising (80), EMS-Advertising (80), Terrasmart-Digital Advertising (80)','Bestpass (4), Carenet (76.5), Welocalize (68)','Terrasmart') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (889, 'Alaina Lee','Corcentric-Writer (160), Corcentric-Writer (160)','BlueMantis (131)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (889, 'Alaina Lee','Corcentric-Writer (160), Corcentric-Writer (160)','BlueMantis (131)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (895, 'Cait Ng','Code42-Writer (80), TDS-Writer (160), Code42-Writer (80), TDS-Writer (160)','Ergotron (76.5), Jll (2)','Code42') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (895, 'Cait Ng','Code42-Writer (80), TDS-Writer (160), Code42-Writer (80), TDS-Writer (160)','Ergotron (76.5), Jll (2)','TDS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (895, 'Cait Ng','Code42-Writer (80), TDS-Writer (160), Code42-Writer (80), TDS-Writer (160)','Ergotron (76.5), Jll (2)','Code42') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (895, 'Cait Ng','Code42-Writer (80), TDS-Writer (160), Code42-Writer (80), TDS-Writer (160)','Ergotron (76.5), Jll (2)','TDS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (883, 'Zamillia Zainal','Terrasmart-Design Services Bureau (130), Equiteq-Designer (160), Equiteq-Designer (160), Terrasmart-Design Services Bureau (200), Recognize-MRC (188)','EROAD (126.5), Novata (3), Recognize (18.5), StarLims (8.5), Terrasmart (22.5)','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (883, 'Zamillia Zainal','Terrasmart-Design Services Bureau (130), Equiteq-Designer (160), Equiteq-Designer (160), Terrasmart-Design Services Bureau (200), Recognize-MRC (188)','EROAD (126.5), Novata (3), Recognize (18.5), StarLims (8.5), Terrasmart (22.5)','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (881, 'Jun Pei Tan','FARO-GDM - Advertising (160), Corcentric-Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (240), FARO-GDM - Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (160)','FARO (40), StarLims (55.5), Terrasmart (0.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (881, 'Jun Pei Tan','FARO-GDM - Advertising (160), Corcentric-Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (240), FARO-GDM - Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (160)','FARO (40), StarLims (55.5), Terrasmart (0.5)','Novata') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (881, 'Jun Pei Tan','FARO-GDM - Advertising (160), Corcentric-Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (240), FARO-GDM - Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (160)','FARO (40), StarLims (55.5), Terrasmart (0.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (881, 'Jun Pei Tan','FARO-GDM - Advertising (160), Corcentric-Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (240), FARO-GDM - Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (160)','FARO (40), StarLims (55.5), Terrasmart (0.5)','Novata') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (881, 'Jun Pei Tan','FARO-GDM - Advertising (160), Corcentric-Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (240), FARO-GDM - Advertising (240), Novata-Advertising (SEM) (53), Corcentric-Advertising (160)','FARO (40), StarLims (55.5), Terrasmart (0.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (888, 'Mei Yee Lee','SFEPartners-Creative Services (40), NoRedInk-Creative Services (60), NoRedInk-Creative Services (60), SFEPartners-Creative Services (40), Agiloft-Design (Short Term) (160), RCG-Creative Service Bureau (200)','GibraltarBA (41.5), LogicSource (14.5), Tispayments (73.5)','SFEPartners') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (888, 'Mei Yee Lee','SFEPartners-Creative Services (40), NoRedInk-Creative Services (60), NoRedInk-Creative Services (60), SFEPartners-Creative Services (40), Agiloft-Design (Short Term) (160), RCG-Creative Service Bureau (200)','GibraltarBA (41.5), LogicSource (14.5), Tispayments (73.5)','NoRedInk') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (888, 'Mei Yee Lee','SFEPartners-Creative Services (40), NoRedInk-Creative Services (60), NoRedInk-Creative Services (60), SFEPartners-Creative Services (40), Agiloft-Design (Short Term) (160), RCG-Creative Service Bureau (200)','GibraltarBA (41.5), LogicSource (14.5), Tispayments (73.5)','NoRedInk') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (888, 'Mei Yee Lee','SFEPartners-Creative Services (40), NoRedInk-Creative Services (60), NoRedInk-Creative Services (60), SFEPartners-Creative Services (40), Agiloft-Design (Short Term) (160), RCG-Creative Service Bureau (200)','GibraltarBA (41.5), LogicSource (14.5), Tispayments (73.5)','SFEPartners') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (888, 'Mei Yee Lee','SFEPartners-Creative Services (40), NoRedInk-Creative Services (60), NoRedInk-Creative Services (60), SFEPartners-Creative Services (40), Agiloft-Design (Short Term) (160), RCG-Creative Service Bureau (200)','GibraltarBA (41.5), LogicSource (14.5), Tispayments (73.5)','Agiloft') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (888, 'Mei Yee Lee','SFEPartners-Creative Services (40), NoRedInk-Creative Services (60), NoRedInk-Creative Services (60), SFEPartners-Creative Services (40), Agiloft-Design (Short Term) (160), RCG-Creative Service Bureau (200)','GibraltarBA (41.5), LogicSource (14.5), Tispayments (73.5)','RCG') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (882, 'Rachel Wibisana','SparkHire-Advertising (160), Influitive-Advertising (80), Influitive-Advertising (80), Jaggaer-Campaigns (30), Liferay-MRC (425)','Employ (70.5), Hyland (53.5)','SparkHire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (882, 'Rachel Wibisana','SparkHire-Advertising (160), Influitive-Advertising (80), Influitive-Advertising (80), Jaggaer-Campaigns (30), Liferay-MRC (425)','Employ (70.5), Hyland (53.5)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (882, 'Rachel Wibisana','SparkHire-Advertising (160), Influitive-Advertising (80), Influitive-Advertising (80), Jaggaer-Campaigns (30), Liferay-MRC (425)','Employ (70.5), Hyland (53.5)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (882, 'Rachel Wibisana','SparkHire-Advertising (160), Influitive-Advertising (80), Influitive-Advertising (80), Jaggaer-Campaigns (30), Liferay-MRC (425)','Employ (70.5), Hyland (53.5)','Jaggaer') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (882, 'Rachel Wibisana','SparkHire-Advertising (160), Influitive-Advertising (80), Influitive-Advertising (80), Jaggaer-Campaigns (30), Liferay-MRC (425)','Employ (70.5), Hyland (53.5)','Liferay') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (886, 'Ye Tung Ku','Syllable-Analyst (80), Skysafe-ABM Campaign MRC (350), Syllable-Analyst (0), Jaggaer-Analyst (50), Skysafe-ABM Campaign MRC (500)','Ergotron (2), Jaggaer (25)','Syllable') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (886, 'Ye Tung Ku','Syllable-Analyst (80), Skysafe-ABM Campaign MRC (350), Syllable-Analyst (0), Jaggaer-Analyst (50), Skysafe-ABM Campaign MRC (500)','Ergotron (2), Jaggaer (25)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (886, 'Ye Tung Ku','Syllable-Analyst (80), Skysafe-ABM Campaign MRC (350), Syllable-Analyst (0), Jaggaer-Analyst (50), Skysafe-ABM Campaign MRC (500)','Ergotron (2), Jaggaer (25)','Syllable') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (886, 'Ye Tung Ku','Syllable-Analyst (80), Skysafe-ABM Campaign MRC (350), Syllable-Analyst (0), Jaggaer-Analyst (50), Skysafe-ABM Campaign MRC (500)','Ergotron (2), Jaggaer (25)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (884, 'Li San Chuah','Abbyy-Campaign Creatives (80), GibraltarBA-Web Support Team (320), InStepHealth-Designer (40), Abbyy-Campaign Creatives (80), "GibraltarBA-Design Bureau (Web, UIUX) (100)", InStepHealth-Designer (40), RCG-Creative Service Bureau (200), GibraltarBA-Web Support Team (0)','Certinia (41.5), GibraltarBA (13), Infor (22), KomodoHealth (2.5)','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (884, 'Li San Chuah','Abbyy-Campaign Creatives (80), GibraltarBA-Web Support Team (320), InStepHealth-Designer (40), Abbyy-Campaign Creatives (80), "GibraltarBA-Design Bureau (Web, UIUX) (100)", InStepHealth-Designer (40), RCG-Creative Service Bureau (200), GibraltarBA-Web Support Team (0)','Certinia (41.5), GibraltarBA (13), Infor (22), KomodoHealth (2.5)','InStepHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (884, 'Li San Chuah','Abbyy-Campaign Creatives (80), GibraltarBA-Web Support Team (320), InStepHealth-Designer (40), Abbyy-Campaign Creatives (80), "GibraltarBA-Design Bureau (Web, UIUX) (100)", InStepHealth-Designer (40), RCG-Creative Service Bureau (200), GibraltarBA-Web Support Team (0)','Certinia (41.5), GibraltarBA (13), Infor (22), KomodoHealth (2.5)','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (884, 'Li San Chuah','Abbyy-Campaign Creatives (80), GibraltarBA-Web Support Team (320), InStepHealth-Designer (40), Abbyy-Campaign Creatives (80), "GibraltarBA-Design Bureau (Web, UIUX) (100)", InStepHealth-Designer (40), RCG-Creative Service Bureau (200), GibraltarBA-Web Support Team (0)','Certinia (41.5), GibraltarBA (13), Infor (22), KomodoHealth (2.5)','"GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (884, 'Li San Chuah','Abbyy-Campaign Creatives (80), GibraltarBA-Web Support Team (320), InStepHealth-Designer (40), Abbyy-Campaign Creatives (80), "GibraltarBA-Design Bureau (Web, UIUX) (100)", InStepHealth-Designer (40), RCG-Creative Service Bureau (200), GibraltarBA-Web Support Team (0)','Certinia (41.5), GibraltarBA (13), Infor (22), KomodoHealth (2.5)','UIUX) (100)"') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (884, 'Li San Chuah','Abbyy-Campaign Creatives (80), GibraltarBA-Web Support Team (320), InStepHealth-Designer (40), Abbyy-Campaign Creatives (80), "GibraltarBA-Design Bureau (Web, UIUX) (100)", InStepHealth-Designer (40), RCG-Creative Service Bureau (200), GibraltarBA-Web Support Team (0)','Certinia (41.5), GibraltarBA (13), Infor (22), KomodoHealth (2.5)','InStepHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (884, 'Li San Chuah','Abbyy-Campaign Creatives (80), GibraltarBA-Web Support Team (320), InStepHealth-Designer (40), Abbyy-Campaign Creatives (80), "GibraltarBA-Design Bureau (Web, UIUX) (100)", InStepHealth-Designer (40), RCG-Creative Service Bureau (200), GibraltarBA-Web Support Team (0)','Certinia (41.5), GibraltarBA (13), Infor (22), KomodoHealth (2.5)','RCG') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (875, 'Helicia Mathew','Cellebrite-Program Manager (Social) (160), Cellebrite-Program Manager (Social) (160)','','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (875, 'Helicia Mathew','Cellebrite-Program Manager (Social) (160), Cellebrite-Program Manager (Social) (160)','','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (871, 'Emerald Tan','eOriginal-Coordinator (480), eOriginal-Coordinator (480)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (871, 'Emerald Tan','eOriginal-Coordinator (480), eOriginal-Coordinator (480)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (872, 'Chong Ghee Lee','Syniti-Marketing Ops (80), Agiloft-Marketing Ops (Hubspot) (160), Syniti-Marketing Ops (80), DPR-Marketing Ops and Analytics (320), Agiloft-Marketing Ops (Hubspot) (80)','BRP (78.5), Docker (90.5), Syniti (2)','Agiloft') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (872, 'Chong Ghee Lee','Syniti-Marketing Ops (80), Agiloft-Marketing Ops (Hubspot) (160), Syniti-Marketing Ops (80), DPR-Marketing Ops and Analytics (320), Agiloft-Marketing Ops (Hubspot) (80)','BRP (78.5), Docker (90.5), Syniti (2)','DPR') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (872, 'Chong Ghee Lee','Syniti-Marketing Ops (80), Agiloft-Marketing Ops (Hubspot) (160), Syniti-Marketing Ops (80), DPR-Marketing Ops and Analytics (320), Agiloft-Marketing Ops (Hubspot) (80)','BRP (78.5), Docker (90.5), Syniti (2)','Agiloft') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (870, 'Samroon Michael','3X-Developer (40), AbOvo-Creative Service Bureau (265), Equiteq-Marketing Ops (55)','','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (862, 'Jason Chan','Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477)','Infor (147)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (862, 'Jason Chan','Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477)','Infor (147)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (864, 'Aqil Saiful','SandlerNetwork-Advertising (SEM) (80), Cellebrite-Advertising (6sense) (160), Cellebrite-Advertising (6sense) (160), SandlerNetwork-Advertising (SEM) (80)','3X (178)','SandlerNetwork') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (864, 'Aqil Saiful','SandlerNetwork-Advertising (SEM) (80), Cellebrite-Advertising (6sense) (160), Cellebrite-Advertising (6sense) (160), SandlerNetwork-Advertising (SEM) (80)','3X (178)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (864, 'Aqil Saiful','SandlerNetwork-Advertising (SEM) (80), Cellebrite-Advertising (6sense) (160), Cellebrite-Advertising (6sense) (160), SandlerNetwork-Advertising (SEM) (80)','3X (178)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (864, 'Aqil Saiful','SandlerNetwork-Advertising (SEM) (80), Cellebrite-Advertising (6sense) (160), Cellebrite-Advertising (6sense) (160), SandlerNetwork-Advertising (SEM) (80)','3X (178)','SandlerNetwork') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (865, 'Joash Ee','Veracode-Writer (160), Veracode-Writer (80)','Merck (1), Perforce (53.5), Plume (19.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (865, 'Joash Ee','Veracode-Writer (160), Veracode-Writer (80)','Merck (1), Perforce (53.5), Plume (19.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (856, 'Vivi Lau','Wavestone-UI/UX (80), Prospiant-UI/UX (80), Blend360-Designer (160), Blend360-Designer (160), Prospiant-UI/UX (80), Wavestone-UI/UX (80), Prospiant-UI/UX (40)','Blend360 (1.5), Exiger (7), Sandler (41.5), SandlerNetwork (10.5), TheLogicFactory (15.5)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (856, 'Vivi Lau','Wavestone-UI/UX (80), Prospiant-UI/UX (80), Blend360-Designer (160), Blend360-Designer (160), Prospiant-UI/UX (80), Wavestone-UI/UX (80), Prospiant-UI/UX (40)','Blend360 (1.5), Exiger (7), Sandler (41.5), SandlerNetwork (10.5), TheLogicFactory (15.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (856, 'Vivi Lau','Wavestone-UI/UX (80), Prospiant-UI/UX (80), Blend360-Designer (160), Blend360-Designer (160), Prospiant-UI/UX (80), Wavestone-UI/UX (80), Prospiant-UI/UX (40)','Blend360 (1.5), Exiger (7), Sandler (41.5), SandlerNetwork (10.5), TheLogicFactory (15.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (856, 'Vivi Lau','Wavestone-UI/UX (80), Prospiant-UI/UX (80), Blend360-Designer (160), Blend360-Designer (160), Prospiant-UI/UX (80), Wavestone-UI/UX (80), Prospiant-UI/UX (40)','Blend360 (1.5), Exiger (7), Sandler (41.5), SandlerNetwork (10.5), TheLogicFactory (15.5)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (856, 'Vivi Lau','Wavestone-UI/UX (80), Prospiant-UI/UX (80), Blend360-Designer (160), Blend360-Designer (160), Prospiant-UI/UX (80), Wavestone-UI/UX (80), Prospiant-UI/UX (40)','Blend360 (1.5), Exiger (7), Sandler (41.5), SandlerNetwork (10.5), TheLogicFactory (15.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (855, 'Harshini Surendran','Corcentric-Advertising (240), Corcentric-Advertising (240), Corcentric-Advertising (160)','CloudBees (66), eOriginal (68)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (855, 'Harshini Surendran','Corcentric-Advertising (240), Corcentric-Advertising (240), Corcentric-Advertising (160)','CloudBees (66), eOriginal (68)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (855, 'Harshini Surendran','Corcentric-Advertising (240), Corcentric-Advertising (240), Corcentric-Advertising (160)','CloudBees (66), eOriginal (68)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (854, 'Aaron Ho','ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), AbOvo-Program Manager (53)','6sense (152)','ConnectWise') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (854, 'Aaron Ho','ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), AbOvo-Program Manager (53)','6sense (152)','Drift') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (854, 'Aaron Ho','ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), AbOvo-Program Manager (53)','6sense (152)','ConnectWise') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (854, 'Aaron Ho','ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), AbOvo-Program Manager (53)','6sense (152)','Drift') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (854, 'Aaron Ho','ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), ConnectWise-Campaign Operations (160), Drift-Ad Hoc Support (40), AbOvo-Program Manager (53)','6sense (152)','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (847, 'Shyafika Suhaimi','Televerde-Writer (160), Televerde-Writer (160)','Sedna (105)','Televerde') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (847, 'Shyafika Suhaimi','Televerde-Writer (160), Televerde-Writer (160)','Sedna (105)','Televerde') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (851, 'Arif Ismaizam','SAP-Writer (Studio) (960), SAP-Writer (Studio) (1280)','UserTesting (118)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (851, 'Arif Ismaizam','SAP-Writer (Studio) (960), SAP-Writer (Studio) (1280)','UserTesting (118)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (843, 'Samuel Phua','Enverus-Governance (80), Enverus-Governance (80), GibraltarBA-Governance (80), Jellyvision-Governance (80)','JellyVision (45), Seismic (62)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (843, 'Samuel Phua','Enverus-Governance (80), Enverus-Governance (80), GibraltarBA-Governance (80), Jellyvision-Governance (80)','JellyVision (45), Seismic (62)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (843, 'Samuel Phua','Enverus-Governance (80), Enverus-Governance (80), GibraltarBA-Governance (80), Jellyvision-Governance (80)','JellyVision (45), Seismic (62)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (843, 'Samuel Phua','Enverus-Governance (80), Enverus-Governance (80), GibraltarBA-Governance (80), Jellyvision-Governance (80)','JellyVision (45), Seismic (62)','Jellyvision') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (837, 'Leon Tan','LogicSource-Advertising (160), Blend360-Advertising (80), Blend360-Advertising (80), LogicSource-Advertising (160), LogicSource-Advertising (80)','Blend360 (1), Certinia (60), Syniti (13.5)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (837, 'Leon Tan','LogicSource-Advertising (160), Blend360-Advertising (80), Blend360-Advertising (80), LogicSource-Advertising (160), LogicSource-Advertising (80)','Blend360 (1), Certinia (60), Syniti (13.5)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (837, 'Leon Tan','LogicSource-Advertising (160), Blend360-Advertising (80), Blend360-Advertising (80), LogicSource-Advertising (160), LogicSource-Advertising (80)','Blend360 (1), Certinia (60), Syniti (13.5)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (838, 'Kevin Hosea','DuckCreek-Advertising (80), DuckCreek-Advertising (80), Hyland-Revenue Advertising (1160)','Abbyy (21), Hyland (54)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (838, 'Kevin Hosea','DuckCreek-Advertising (80), DuckCreek-Advertising (80), Hyland-Revenue Advertising (1160)','Abbyy (21), Hyland (54)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (831, 'Sabrina Lim','Northwind-Designer (40), Infor-DC - Designer (1760), Infor-DC - Designer (1760), Northwind-Designer (80)','Infor (84.5)','Northwind') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (831, 'Sabrina Lim','Northwind-Designer (40), Infor-DC - Designer (1760), Infor-DC - Designer (1760), Northwind-Designer (80)','Infor (84.5)','Northwind') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (826, 'Joy Ang','iSpot-Writer (80), iSpot-Writer (80)','Infor (1.5), QualiTest (65), SAP (45)','iSpot') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (826, 'Joy Ang','iSpot-Writer (80), iSpot-Writer (80)','Infor (1.5), QualiTest (65), SAP (45)','iSpot') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (825, 'Izza Khaleeda','Momentus-Writer (80), Momentus-Writer (0)','Infor (103.5)','Momentus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (825, 'Izza Khaleeda','Momentus-Writer (80), Momentus-Writer (0)','Infor (103.5)','Momentus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (824, 'Chloe Yeoh','Exiger-Creative Services (120), Terrasmart-Writer (160), Exiger-Creative Services (120), Terrasmart-Writer (160)','Certinia (83.5), Terrasmart (2)','Exiger') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (824, 'Chloe Yeoh','Exiger-Creative Services (120), Terrasmart-Writer (160), Exiger-Creative Services (120), Terrasmart-Writer (160)','Certinia (83.5), Terrasmart (2)','Exiger') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (814, 'Jilian Liew','EverDriven-Governance (53), Ricoh-Governance (Creative Director) (80), EverDriven-Governance (53), Ricoh-Governance (133)','Ricoh (91.5), RicohNa (11.5)','EverDriven') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (814, 'Jilian Liew','EverDriven-Governance (53), Ricoh-Governance (Creative Director) (80), EverDriven-Governance (53), Ricoh-Governance (133)','Ricoh (91.5), RicohNa (11.5)','EverDriven') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (815, 'Christine Wong','PlexTrac-Designer (80), Novata-Creative Services (100), Novata-Creative Services (100), FARO-GDC - UI/UX (80)','BRP (3), FARO (66), IQBackOffice (26.5)','PlexTrac') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (815, 'Christine Wong','PlexTrac-Designer (80), Novata-Creative Services (100), Novata-Creative Services (100), FARO-GDC - UI/UX (80)','BRP (3), FARO (66), IQBackOffice (26.5)','Novata') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (815, 'Christine Wong','PlexTrac-Designer (80), Novata-Creative Services (100), Novata-Creative Services (100), FARO-GDC - UI/UX (80)','BRP (3), FARO (66), IQBackOffice (26.5)','Novata') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (812, 'Jee Yee Tan','TheLogicFactory-Writer (80), Blend360-Writer (160), SmartCommunications-Writer (72), Blend360-Writer (160), TheLogicFactory-Creative Service Bureau (80), SmartCommunications-Writer (100), EDB-Writer (90)','AllStar (26), Cohesity (0.5), RedCanary (3)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (812, 'Jee Yee Tan','TheLogicFactory-Writer (80), Blend360-Writer (160), SmartCommunications-Writer (72), Blend360-Writer (160), TheLogicFactory-Creative Service Bureau (80), SmartCommunications-Writer (100), EDB-Writer (90)','AllStar (26), Cohesity (0.5), RedCanary (3)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (812, 'Jee Yee Tan','TheLogicFactory-Writer (80), Blend360-Writer (160), SmartCommunications-Writer (72), Blend360-Writer (160), TheLogicFactory-Creative Service Bureau (80), SmartCommunications-Writer (100), EDB-Writer (90)','AllStar (26), Cohesity (0.5), RedCanary (3)','SmartCommunications') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (812, 'Jee Yee Tan','TheLogicFactory-Writer (80), Blend360-Writer (160), SmartCommunications-Writer (72), Blend360-Writer (160), TheLogicFactory-Creative Service Bureau (80), SmartCommunications-Writer (100), EDB-Writer (90)','AllStar (26), Cohesity (0.5), RedCanary (3)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (812, 'Jee Yee Tan','TheLogicFactory-Writer (80), Blend360-Writer (160), SmartCommunications-Writer (72), Blend360-Writer (160), TheLogicFactory-Creative Service Bureau (80), SmartCommunications-Writer (100), EDB-Writer (90)','AllStar (26), Cohesity (0.5), RedCanary (3)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (812, 'Jee Yee Tan','TheLogicFactory-Writer (80), Blend360-Writer (160), SmartCommunications-Writer (72), Blend360-Writer (160), TheLogicFactory-Creative Service Bureau (80), SmartCommunications-Writer (100), EDB-Writer (90)','AllStar (26), Cohesity (0.5), RedCanary (3)','SmartCommunications') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (812, 'Jee Yee Tan','TheLogicFactory-Writer (80), Blend360-Writer (160), SmartCommunications-Writer (72), Blend360-Writer (160), TheLogicFactory-Creative Service Bureau (80), SmartCommunications-Writer (100), EDB-Writer (90)','AllStar (26), Cohesity (0.5), RedCanary (3)','EDB') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (811, 'Sharyl Priyanka','FARO-Holobuilder - Writer (240), FARO-Holobuilder - Writer (240)','BlueMantis (40), EverDriven (25)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (811, 'Sharyl Priyanka','FARO-Holobuilder - Writer (240), FARO-Holobuilder - Writer (240)','BlueMantis (40), EverDriven (25)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (808, 'Shamini Sivaram','Prospiant-Advertising (160), Prospiant-Advertising (160), Syniti-Digital Advertising (160)','iSpot (15), Syniti (8.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (808, 'Shamini Sivaram','Prospiant-Advertising (160), Prospiant-Advertising (160), Syniti-Digital Advertising (160)','iSpot (15), Syniti (8.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (807, 'Maneesh Muppuri','FARO-GDM - Sitecore Developer (80), WoltersKluwer-Developer (Sitecore) (80), FARO-GDM - Sitecore Developer (120), WoltersKluwer-Sitecore Developer (80)','FARO (96)','WoltersKluwer') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (807, 'Maneesh Muppuri','FARO-GDM - Sitecore Developer (80), WoltersKluwer-Developer (Sitecore) (80), FARO-GDM - Sitecore Developer (120), WoltersKluwer-Sitecore Developer (80)','FARO (96)','WoltersKluwer') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (797, 'Yi Feng Tek','Veracode-Analyst (160), Thunder-Analyst (80), Thunder-Analyst (80), Veracode-Analyst (160)','Docker (63), Terrasmart (2.5), Vizient (72.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (797, 'Yi Feng Tek','Veracode-Analyst (160), Thunder-Analyst (80), Thunder-Analyst (80), Veracode-Analyst (160)','Docker (63), Terrasmart (2.5), Vizient (72.5)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (797, 'Yi Feng Tek','Veracode-Analyst (160), Thunder-Analyst (80), Thunder-Analyst (80), Veracode-Analyst (160)','Docker (63), Terrasmart (2.5), Vizient (72.5)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (797, 'Yi Feng Tek','Veracode-Analyst (160), Thunder-Analyst (80), Thunder-Analyst (80), Veracode-Analyst (160)','Docker (63), Terrasmart (2.5), Vizient (72.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (793, 'Leon Pak','Momentus-Advertising (Social) (80), BRP-Advertising (6sense) (80), Momentus-Advertising (Social) (0), BRP-Advertising (6sense) (80)','BRP (61), FARO (66)','Momentus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (793, 'Leon Pak','Momentus-Advertising (Social) (80), BRP-Advertising (6sense) (80), Momentus-Advertising (Social) (0), BRP-Advertising (6sense) (80)','BRP (61), FARO (66)','Momentus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (788, 'Hanif Shaarani','Cellebrite-Governance (80), Cellebrite-Governance (80)','Certinia (18.5), ConnectWise (7)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (788, 'Hanif Shaarani','Cellebrite-Governance (80), Cellebrite-Governance (80)','Certinia (18.5), ConnectWise (7)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (789, 'Kent Tan','eOriginal-SEO (53), Corcentric-SEO (80), Corcentric-SEO (80), eOriginal-SEO (53), TheLogicFactory-SEO (80)','3E (39), AveryDennison (10), Certinia (8), Lumivero (4)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (789, 'Kent Tan','eOriginal-SEO (53), Corcentric-SEO (80), Corcentric-SEO (80), eOriginal-SEO (53), TheLogicFactory-SEO (80)','3E (39), AveryDennison (10), Certinia (8), Lumivero (4)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (789, 'Kent Tan','eOriginal-SEO (53), Corcentric-SEO (80), Corcentric-SEO (80), eOriginal-SEO (53), TheLogicFactory-SEO (80)','3E (39), AveryDennison (10), Certinia (8), Lumivero (4)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (789, 'Kent Tan','eOriginal-SEO (53), Corcentric-SEO (80), Corcentric-SEO (80), eOriginal-SEO (53), TheLogicFactory-SEO (80)','3E (39), AveryDennison (10), Certinia (8), Lumivero (4)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (789, 'Kent Tan','eOriginal-SEO (53), Corcentric-SEO (80), Corcentric-SEO (80), eOriginal-SEO (53), TheLogicFactory-SEO (80)','3E (39), AveryDennison (10), Certinia (8), Lumivero (4)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (792, 'Lakshmi Mohana','SAP-Writer (Studio) (960), SAP-Writer (Studio) (1280)','Blend360 (15.5), Exiger (11.5), Jaggaer (23.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (792, 'Lakshmi Mohana','SAP-Writer (Studio) (960), SAP-Writer (Studio) (1280)','Blend360 (15.5), Exiger (11.5), Jaggaer (23.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (783, 'Kevin Tan','Veracode-Governance (80), Veracode-Governance (80), Symplr-Governance (80)','BaxterPlanning (42), Docker (4), GibraltarMAPS (3.5), RackspaceSM (14)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (783, 'Kevin Tan','Veracode-Governance (80), Veracode-Governance (80), Symplr-Governance (80)','BaxterPlanning (42), Docker (4), GibraltarMAPS (3.5), RackspaceSM (14)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (783, 'Kevin Tan','Veracode-Governance (80), Veracode-Governance (80), Symplr-Governance (80)','BaxterPlanning (42), Docker (4), GibraltarMAPS (3.5), RackspaceSM (14)','Symplr') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (786, 'Emily Lee','Dizzion-Creative Services (100), Tecsys-UI/UX (Support) (80), Dizzion-Creative Services (100), Hyland-Revenue Advertising (1160), Tecsys-UI/UX (Support) (80)','Docker (33.5), Hyland (78)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (786, 'Emily Lee','Dizzion-Creative Services (100), Tecsys-UI/UX (Support) (80), Dizzion-Creative Services (100), Hyland-Revenue Advertising (1160), Tecsys-UI/UX (Support) (80)','Docker (33.5), Hyland (78)','Tecsys') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (786, 'Emily Lee','Dizzion-Creative Services (100), Tecsys-UI/UX (Support) (80), Dizzion-Creative Services (100), Hyland-Revenue Advertising (1160), Tecsys-UI/UX (Support) (80)','Docker (33.5), Hyland (78)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (786, 'Emily Lee','Dizzion-Creative Services (100), Tecsys-UI/UX (Support) (80), Dizzion-Creative Services (100), Hyland-Revenue Advertising (1160), Tecsys-UI/UX (Support) (80)','Docker (33.5), Hyland (78)','Tecsys') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (781, 'Yun Seng Chin','eOriginal-Marketing Ops (320), Corcentric-Email Marketing (160), Corcentric-Email Marketing (160), eOriginal-Marketing Ops (320)','Certinia (155), IronMountain (8.5), RicohNAOps (37.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (781, 'Yun Seng Chin','eOriginal-Marketing Ops (320), Corcentric-Email Marketing (160), Corcentric-Email Marketing (160), eOriginal-Marketing Ops (320)','Certinia (155), IronMountain (8.5), RicohNAOps (37.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (781, 'Yun Seng Chin','eOriginal-Marketing Ops (320), Corcentric-Email Marketing (160), Corcentric-Email Marketing (160), eOriginal-Marketing Ops (320)','Certinia (155), IronMountain (8.5), RicohNAOps (37.5)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (781, 'Yun Seng Chin','eOriginal-Marketing Ops (320), Corcentric-Email Marketing (160), Corcentric-Email Marketing (160), eOriginal-Marketing Ops (320)','Certinia (155), IronMountain (8.5), RicohNAOps (37.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (775, 'Syahrizal Hallil','Blend360-Video Editor (80), InStepHealth-Designer (40), Blend360-Video Editor (80), InStepHealth-Designer (40), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (144.5)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (775, 'Syahrizal Hallil','Blend360-Video Editor (80), InStepHealth-Designer (40), Blend360-Video Editor (80), InStepHealth-Designer (40), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (144.5)','InStepHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (775, 'Syahrizal Hallil','Blend360-Video Editor (80), InStepHealth-Designer (40), Blend360-Video Editor (80), InStepHealth-Designer (40), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (144.5)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (775, 'Syahrizal Hallil','Blend360-Video Editor (80), InStepHealth-Designer (40), Blend360-Video Editor (80), InStepHealth-Designer (40), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (144.5)','InStepHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (780, 'Izmie Taib','DELMIA-Video Editor (160), DELMIA-Video Editor (160)','Blend360 (21.5), ConnectWise (110.5)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (780, 'Izmie Taib','DELMIA-Video Editor (160), DELMIA-Video Editor (160)','Blend360 (21.5), ConnectWise (110.5)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (774, 'Keshav Indran','Cellebrite-Program Manager (320), Cellebrite-Program Manager (320)','Avetta (131)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (774, 'Keshav Indran','Cellebrite-Program Manager (320), Cellebrite-Program Manager (320)','Avetta (131)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (771, 'Lulu Kwa','Algo-Designer (80), Cellebrite-UI/UX (80), Cellebrite-UI/UX (160), Algo-Designer (80)','Ergotron (1), EverDriven (27), IronMountain (46.5), Jaggaer (8.5), ProcessUnity (2), QuakerHoughton (24)','Algo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (771, 'Lulu Kwa','Algo-Designer (80), Cellebrite-UI/UX (80), Cellebrite-UI/UX (160), Algo-Designer (80)','Ergotron (1), EverDriven (27), IronMountain (46.5), Jaggaer (8.5), ProcessUnity (2), QuakerHoughton (24)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (771, 'Lulu Kwa','Algo-Designer (80), Cellebrite-UI/UX (80), Cellebrite-UI/UX (160), Algo-Designer (80)','Ergotron (1), EverDriven (27), IronMountain (46.5), Jaggaer (8.5), ProcessUnity (2), QuakerHoughton (24)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (771, 'Lulu Kwa','Algo-Designer (80), Cellebrite-UI/UX (80), Cellebrite-UI/UX (160), Algo-Designer (80)','Ergotron (1), EverDriven (27), IronMountain (46.5), Jaggaer (8.5), ProcessUnity (2), QuakerHoughton (24)','Algo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (759, 'Max Lew','Vertex-Marketing Ops (6sense) (80), PlexTrac-Marketing Ops (80), Vertex-Marketing Ops (6sense) (80), Cellebrite-Marketing Operations Manager (0), Cellebrite-Marketing Operations Manager - Monday.com (160)','Acquia (14), Certinia (5), ZeroFox (32)','Vertex') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (759, 'Max Lew','Vertex-Marketing Ops (6sense) (80), PlexTrac-Marketing Ops (80), Vertex-Marketing Ops (6sense) (80), Cellebrite-Marketing Operations Manager (0), Cellebrite-Marketing Operations Manager - Monday.com (160)','Acquia (14), Certinia (5), ZeroFox (32)','PlexTrac') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (759, 'Max Lew','Vertex-Marketing Ops (6sense) (80), PlexTrac-Marketing Ops (80), Vertex-Marketing Ops (6sense) (80), Cellebrite-Marketing Operations Manager (0), Cellebrite-Marketing Operations Manager - Monday.com (160)','Acquia (14), Certinia (5), ZeroFox (32)','Vertex') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (759, 'Max Lew','Vertex-Marketing Ops (6sense) (80), PlexTrac-Marketing Ops (80), Vertex-Marketing Ops (6sense) (80), Cellebrite-Marketing Operations Manager (0), Cellebrite-Marketing Operations Manager - Monday.com (160)','Acquia (14), Certinia (5), ZeroFox (32)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (759, 'Max Lew','Vertex-Marketing Ops (6sense) (80), PlexTrac-Marketing Ops (80), Vertex-Marketing Ops (6sense) (80), Cellebrite-Marketing Operations Manager (0), Cellebrite-Marketing Operations Manager - Monday.com (160)','Acquia (14), Certinia (5), ZeroFox (32)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (760, 'Ken Kwong','WoltersKluwer-Designer (640), Infor-DC - Designer (1760), Infor-DC - Designer (1760), WoltersKluwer-Designer (640)','Onec1 (84), WKBG (79.5), WoltersKluwer (1.5), Yubico (1)','Infor') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (760, 'Ken Kwong','WoltersKluwer-Designer (640), Infor-DC - Designer (1760), Infor-DC - Designer (1760), WoltersKluwer-Designer (640)','Onec1 (84), WKBG (79.5), WoltersKluwer (1.5), Yubico (1)','Infor') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (773, 'Saif Imran','FARO-GDC - Marketing Ops - Martech (160), Veracode-Email Marketing (240), FARO-GDC - Marketing Ops - Martech (160), Veracode-Email Marketing (240), Emburse-Marketing Ops (340)','Emburse (58), FARO (20)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (773, 'Saif Imran','FARO-GDC - Marketing Ops - Martech (160), Veracode-Email Marketing (240), FARO-GDC - Marketing Ops - Martech (160), Veracode-Email Marketing (240), Emburse-Marketing Ops (340)','Emburse (58), FARO (20)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (766, 'Khaleda Kamal','ConnectWise-Ops (CMS) (80), DPR-Marketing Ops and Analytics (320), ConnectWise-Ops (CMS) (80)','3E (26.5), ConnectWise (72.5)','DPR') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (758, 'Nicki Sim','DuckCreek-Writer (80), Pareto-Writer (160), DuckCreek-Writer (80), Pareto-Writer (160)','Ninjio (51.5), Suvoda (45)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (758, 'Nicki Sim','DuckCreek-Writer (80), Pareto-Writer (160), DuckCreek-Writer (80), Pareto-Writer (160)','Ninjio (51.5), Suvoda (45)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (758, 'Nicki Sim','DuckCreek-Writer (80), Pareto-Writer (160), DuckCreek-Writer (80), Pareto-Writer (160)','Ninjio (51.5), Suvoda (45)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (758, 'Nicki Sim','DuckCreek-Writer (80), Pareto-Writer (160), DuckCreek-Writer (80), Pareto-Writer (160)','Ninjio (51.5), Suvoda (45)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Ricoh') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Ricoh') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Jaggaer') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (754, 'Pei Fen Beh','Influitive-Creative Services (65), Ricoh-UI/UX (120), Fastmarkets-Creative Services (160), Skysafe-ABM Campaign MRC (350), Fastmarkets-Creative Services (160), Influitive-Creative Services (65), Ricoh-UI/UX (120), Jaggaer-Creative Service Bureau (204), AbOvo-Creative Service Bureau (265), Skysafe-ABM Campaign MRC (500), Qlik-Design Service Bureau (200), Ricoh-UI/UX (80)','Qlik (4.5), Recognize (3)','Ricoh') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (745, 'Farhan Azman','SAP-Event Coordinator (320), Exiger-Coordinator (40), SAP-Event Coordinator (480), Exiger-Coordinator (40), SAP-Event Coordinator (400)','7Rivers (21), Exiger (20.5), Phoenix (20), QuakerHoughton (22.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (745, 'Farhan Azman','SAP-Event Coordinator (320), Exiger-Coordinator (40), SAP-Event Coordinator (480), Exiger-Coordinator (40), SAP-Event Coordinator (400)','7Rivers (21), Exiger (20.5), Phoenix (20), QuakerHoughton (22.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (745, 'Farhan Azman','SAP-Event Coordinator (320), Exiger-Coordinator (40), SAP-Event Coordinator (480), Exiger-Coordinator (40), SAP-Event Coordinator (400)','7Rivers (21), Exiger (20.5), Phoenix (20), QuakerHoughton (22.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (741, 'Raja Zakiyy','FounderShield-Designer (80), BRP-Designer (110), EMS-Designer (80), Phoenix-Designer (53), BRP-Designer (110), EMS-Designer (80), FounderShield-Designer (80), Phoenix-Designer (53)','BRP (82), EMS (19.5), GnaPartners (3.5), Tangoe (38.5)','FounderShield') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (741, 'Raja Zakiyy','FounderShield-Designer (80), BRP-Designer (110), EMS-Designer (80), Phoenix-Designer (53), BRP-Designer (110), EMS-Designer (80), FounderShield-Designer (80), Phoenix-Designer (53)','BRP (82), EMS (19.5), GnaPartners (3.5), Tangoe (38.5)','Phoenix') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (741, 'Raja Zakiyy','FounderShield-Designer (80), BRP-Designer (110), EMS-Designer (80), Phoenix-Designer (53), BRP-Designer (110), EMS-Designer (80), FounderShield-Designer (80), Phoenix-Designer (53)','BRP (82), EMS (19.5), GnaPartners (3.5), Tangoe (38.5)','FounderShield') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (741, 'Raja Zakiyy','FounderShield-Designer (80), BRP-Designer (110), EMS-Designer (80), Phoenix-Designer (53), BRP-Designer (110), EMS-Designer (80), FounderShield-Designer (80), Phoenix-Designer (53)','BRP (82), EMS (19.5), GnaPartners (3.5), Tangoe (38.5)','Phoenix') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (742, 'Fei Yuen Ching','GibraltarMAPS-Designer (100), GibraltarMAPS-Designer (120), Brennan-Video Editor (35), Prospiant-Video Editor (40)','Ergotron (84), GibraltarBA (2.5), GibraltarMAPS (18)','Brennan') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (742, 'Fei Yuen Ching','GibraltarMAPS-Designer (100), GibraltarMAPS-Designer (120), Brennan-Video Editor (35), Prospiant-Video Editor (40)','Ergotron (84), GibraltarBA (2.5), GibraltarMAPS (18)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (732, 'Chan Yee Mak','Sandler-Designer (80), Equiteq-Designer (160), Equiteq-Designer (160), Sandler-Designer (80)','Equiteq (11), EROAD (78.5), Vizient (39)','Sandler') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (732, 'Chan Yee Mak','Sandler-Designer (80), Equiteq-Designer (160), Equiteq-Designer (160), Sandler-Designer (80)','Equiteq (11), EROAD (78.5), Vizient (39)','Sandler') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','FounderShield') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','FounderShield') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (723, 'Lynn Foo','FounderShield-Writer (80), GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), FounderShield-Writer (80), GibraltarMAPS-Web Support Team (240), GoTo-Creative Service Desk (1760), GoTo-Writer (480), GibraltarBA-Web Support Team (0)','RackspacePrivate (9), Tispayments (72)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (710, 'Nicole Chang','Fastmarkets-Governance (53), Fastmarkets-Governance (53), Jaggaer-Program Manager (53)','Emburse (50.5), Jaggaer (45.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (710, 'Nicole Chang','Fastmarkets-Governance (53), Fastmarkets-Governance (53), Jaggaer-Program Manager (53)','Emburse (50.5), Jaggaer (45.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (737, 'Hasyir Hashim','GibraltarBA-Analyst (53), GibraltarBA-Analyst (160)','Abbyy (8.5), Docker (43.5), GoTo (40)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (737, 'Hasyir Hashim','GibraltarBA-Analyst (53), GibraltarBA-Analyst (160)','Abbyy (8.5), Docker (43.5), GoTo (40)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (724, 'Emmanuel Chin','FARO-Holobuilder - Writer (240), FARO-Holobuilder - Writer (240), EDB-Writer (90)','FARO (61.5), Hp (24)','EDB') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (734, 'Isabella Lee','PlexTrac-Writer (Content Atomization) (80), Dizzion-Writer (80), Dizzion-Writer (80)','Infor (104)','PlexTrac') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (734, 'Isabella Lee','PlexTrac-Writer (Content Atomization) (80), Dizzion-Writer (80), Dizzion-Writer (80)','Infor (104)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (734, 'Isabella Lee','PlexTrac-Writer (Content Atomization) (80), Dizzion-Writer (80), Dizzion-Writer (80)','Infor (104)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (730, 'Nadhirah Nadzari','ToolsGroup-Ops/Campaign/Gov MRC (125), ToolsGroup-Ops/Campaign/Gov MRC (125), FARO-GDM - Advertising (240), Prospiant-Advertising (80)','FARO (64)','ToolsGroup') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (730, 'Nadhirah Nadzari','ToolsGroup-Ops/Campaign/Gov MRC (125), ToolsGroup-Ops/Campaign/Gov MRC (125), FARO-GDM - Advertising (240), Prospiant-Advertising (80)','FARO (64)','ToolsGroup') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (730, 'Nadhirah Nadzari','ToolsGroup-Ops/Campaign/Gov MRC (125), ToolsGroup-Ops/Campaign/Gov MRC (125), FARO-GDM - Advertising (240), Prospiant-Advertising (80)','FARO (64)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (728, 'Adrian Chan','eOriginal-Email Marketing (320), VertexCM-Email Marketing (160), eOriginal-Email Marketing (320)','eOriginal (34), UserTesting (6.5)','VertexCM') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (729, 'Faiz Baharudin','Enverus-Analyst (213), SAP-Event Analyst (80), Skysafe-ABM Campaign MRC (350), Enverus-Analyst (213), SAP-Event Analyst (240), Skysafe-ABM Campaign MRC (500)','EROAD (113.5)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (729, 'Faiz Baharudin','Enverus-Analyst (213), SAP-Event Analyst (80), Skysafe-ABM Campaign MRC (350), Enverus-Analyst (213), SAP-Event Analyst (240), Skysafe-ABM Campaign MRC (500)','EROAD (113.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (729, 'Faiz Baharudin','Enverus-Analyst (213), SAP-Event Analyst (80), Skysafe-ABM Campaign MRC (350), Enverus-Analyst (213), SAP-Event Analyst (240), Skysafe-ABM Campaign MRC (500)','EROAD (113.5)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (729, 'Faiz Baharudin','Enverus-Analyst (213), SAP-Event Analyst (80), Skysafe-ABM Campaign MRC (350), Enverus-Analyst (213), SAP-Event Analyst (240), Skysafe-ABM Campaign MRC (500)','EROAD (113.5)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (729, 'Faiz Baharudin','Enverus-Analyst (213), SAP-Event Analyst (80), Skysafe-ABM Campaign MRC (350), Enverus-Analyst (213), SAP-Event Analyst (240), Skysafe-ABM Campaign MRC (500)','EROAD (113.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (729, 'Faiz Baharudin','Enverus-Analyst (213), SAP-Event Analyst (80), Skysafe-ABM Campaign MRC (350), Enverus-Analyst (213), SAP-Event Analyst (240), Skysafe-ABM Campaign MRC (500)','EROAD (113.5)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (735, 'Li-Wei Poon','DELMIA-Writer (200), DELMIA-Writer (200)','IQBackOffice (43.5), MadCap (89)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (735, 'Li-Wei Poon','DELMIA-Writer (200), DELMIA-Writer (200)','IQBackOffice (43.5), MadCap (89)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (736, 'Joshua Teo','Wavestone-Writer (160), Wavestone-Writer (160), Recognize-MRC (188), Equiteq-Creative Support (50), EDB-Writer (90)','Avetta (132), Recognize (15)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (736, 'Joshua Teo','Wavestone-Writer (160), Wavestone-Writer (160), Recognize-MRC (188), Equiteq-Creative Support (50), EDB-Writer (90)','Avetta (132), Recognize (15)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (736, 'Joshua Teo','Wavestone-Writer (160), Wavestone-Writer (160), Recognize-MRC (188), Equiteq-Creative Support (50), EDB-Writer (90)','Avetta (132), Recognize (15)','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (736, 'Joshua Teo','Wavestone-Writer (160), Wavestone-Writer (160), Recognize-MRC (188), Equiteq-Creative Support (50), EDB-Writer (90)','Avetta (132), Recognize (15)','EDB') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (716, 'Raynugadewi Subramaniam','Fastmarkets-Advertising (240), Prospiant-Advertising (160), Fastmarkets-Advertising (240), Prospiant-Advertising (160)','KyruusHealth (80.5), Perforce (90.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (716, 'Raynugadewi Subramaniam','Fastmarkets-Advertising (240), Prospiant-Advertising (160), Fastmarkets-Advertising (240), Prospiant-Advertising (160)','KyruusHealth (80.5), Perforce (90.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (716, 'Raynugadewi Subramaniam','Fastmarkets-Advertising (240), Prospiant-Advertising (160), Fastmarkets-Advertising (240), Prospiant-Advertising (160)','KyruusHealth (80.5), Perforce (90.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (716, 'Raynugadewi Subramaniam','Fastmarkets-Advertising (240), Prospiant-Advertising (160), Fastmarkets-Advertising (240), Prospiant-Advertising (160)','KyruusHealth (80.5), Perforce (90.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (713, 'Amir Kok','Blend360-Marketing Ops (160), Syllable-Marketing Ops (80), Blend360-Marketing Ops (160), Syllable-Marketing Ops (0), Devo-Marketing Ops (80)','','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (713, 'Amir Kok','Blend360-Marketing Ops (160), Syllable-Marketing Ops (80), Blend360-Marketing Ops (160), Syllable-Marketing Ops (0), Devo-Marketing Ops (80)','','Syllable') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (713, 'Amir Kok','Blend360-Marketing Ops (160), Syllable-Marketing Ops (80), Blend360-Marketing Ops (160), Syllable-Marketing Ops (0), Devo-Marketing Ops (80)','','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (713, 'Amir Kok','Blend360-Marketing Ops (160), Syllable-Marketing Ops (80), Blend360-Marketing Ops (160), Syllable-Marketing Ops (0), Devo-Marketing Ops (80)','','Syllable') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (713, 'Amir Kok','Blend360-Marketing Ops (160), Syllable-Marketing Ops (80), Blend360-Marketing Ops (160), Syllable-Marketing Ops (0), Devo-Marketing Ops (80)','','Devo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (717, 'Ady Faizal','FARO-GCO – Marketing Ops – Translation (80), Prospiant-Marketing Ops (80), FARO-GCO – Marketing Ops – Translation (80), Prospiant-Marketing Ops (80), Prospiant-Marketing Ops (32)','Employbridge (64), FARO (59.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (717, 'Ady Faizal','FARO-GCO – Marketing Ops – Translation (80), Prospiant-Marketing Ops (80), FARO-GCO – Marketing Ops – Translation (80), Prospiant-Marketing Ops (80), Prospiant-Marketing Ops (32)','Employbridge (64), FARO (59.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (717, 'Ady Faizal','FARO-GCO – Marketing Ops – Translation (80), Prospiant-Marketing Ops (80), FARO-GCO – Marketing Ops – Translation (80), Prospiant-Marketing Ops (80), Prospiant-Marketing Ops (32)','Employbridge (64), FARO (59.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (706, 'Boon Ching Gan','Dizzion-Creative Services (100), SAP-Core Events Project (1120), Dizzion-Creative Services (100), Hyland-Digital Engagement (1800), GoTo-Creative Service Desk (1760), Agiloft-Design (Short Term) (160), GoTo-Graphic Designer (480)','Blend360 (8), DAS42 (2), GoTo (143), Televerde (2)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (706, 'Boon Ching Gan','Dizzion-Creative Services (100), SAP-Core Events Project (1120), Dizzion-Creative Services (100), Hyland-Digital Engagement (1800), GoTo-Creative Service Desk (1760), Agiloft-Design (Short Term) (160), GoTo-Graphic Designer (480)','Blend360 (8), DAS42 (2), GoTo (143), Televerde (2)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (706, 'Boon Ching Gan','Dizzion-Creative Services (100), SAP-Core Events Project (1120), Dizzion-Creative Services (100), Hyland-Digital Engagement (1800), GoTo-Creative Service Desk (1760), Agiloft-Design (Short Term) (160), GoTo-Graphic Designer (480)','Blend360 (8), DAS42 (2), GoTo (143), Televerde (2)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (706, 'Boon Ching Gan','Dizzion-Creative Services (100), SAP-Core Events Project (1120), Dizzion-Creative Services (100), Hyland-Digital Engagement (1800), GoTo-Creative Service Desk (1760), Agiloft-Design (Short Term) (160), GoTo-Graphic Designer (480)','Blend360 (8), DAS42 (2), GoTo (143), Televerde (2)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (706, 'Boon Ching Gan','Dizzion-Creative Services (100), SAP-Core Events Project (1120), Dizzion-Creative Services (100), Hyland-Digital Engagement (1800), GoTo-Creative Service Desk (1760), Agiloft-Design (Short Term) (160), GoTo-Graphic Designer (480)','Blend360 (8), DAS42 (2), GoTo (143), Televerde (2)','Agiloft') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (707, 'Joann Tan','Ricoh-UI/UX (120), Exiger-Creative Services (120), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), Exiger-Creative Services (120), Ricoh-UI/UX (120), BestPass-MRC (375), 3X-UI/UX (80), Ricoh-UI/UX (80), Emburse-Creative Services (400)','3X (138.5), Ricoh (0.5), Syniti (4)','Exiger') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (707, 'Joann Tan','Ricoh-UI/UX (120), Exiger-Creative Services (120), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), Exiger-Creative Services (120), Ricoh-UI/UX (120), BestPass-MRC (375), 3X-UI/UX (80), Ricoh-UI/UX (80), Emburse-Creative Services (400)','3X (138.5), Ricoh (0.5), Syniti (4)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (707, 'Joann Tan','Ricoh-UI/UX (120), Exiger-Creative Services (120), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), Exiger-Creative Services (120), Ricoh-UI/UX (120), BestPass-MRC (375), 3X-UI/UX (80), Ricoh-UI/UX (80), Emburse-Creative Services (400)','3X (138.5), Ricoh (0.5), Syniti (4)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (707, 'Joann Tan','Ricoh-UI/UX (120), Exiger-Creative Services (120), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), Exiger-Creative Services (120), Ricoh-UI/UX (120), BestPass-MRC (375), 3X-UI/UX (80), Ricoh-UI/UX (80), Emburse-Creative Services (400)','3X (138.5), Ricoh (0.5), Syniti (4)','Exiger') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (707, 'Joann Tan','Ricoh-UI/UX (120), Exiger-Creative Services (120), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), Exiger-Creative Services (120), Ricoh-UI/UX (120), BestPass-MRC (375), 3X-UI/UX (80), Ricoh-UI/UX (80), Emburse-Creative Services (400)','3X (138.5), Ricoh (0.5), Syniti (4)','BestPass') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (707, 'Joann Tan','Ricoh-UI/UX (120), Exiger-Creative Services (120), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), Exiger-Creative Services (120), Ricoh-UI/UX (120), BestPass-MRC (375), 3X-UI/UX (80), Ricoh-UI/UX (80), Emburse-Creative Services (400)','3X (138.5), Ricoh (0.5), Syniti (4)','Emburse') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (701, 'May Yin Chong','','Perforce (2), PrescientEdge (1.5), Syniti (68.5), Televerde (3.5)','') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (705, 'Nadia Karim','WoltersKluwer-Designer (640), WKBrandComms-Ad Hoc Support (40), WKBrandComms-Ad Hoc Support (40), WoltersKluwer-Designer (640), Jaggaer-Creative Service Bureau (204)','Vaco (138), WoltersKluwer (30)','WKBrandComms') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (705, 'Nadia Karim','WoltersKluwer-Designer (640), WKBrandComms-Ad Hoc Support (40), WKBrandComms-Ad Hoc Support (40), WoltersKluwer-Designer (640), Jaggaer-Creative Service Bureau (204)','Vaco (138), WoltersKluwer (30)','WKBrandComms') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (705, 'Nadia Karim','WoltersKluwer-Designer (640), WKBrandComms-Ad Hoc Support (40), WKBrandComms-Ad Hoc Support (40), WoltersKluwer-Designer (640), Jaggaer-Creative Service Bureau (204)','Vaco (138), WoltersKluwer (30)','Jaggaer') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (696, 'Khairullah Zulkafli','Pareto-Designer (160), SAP-Designer (Studio) (80), Thunder-Creative Service Bureau (100), SAP-Core Events Project (1120), Pareto-Designer (160), SAP-Designer (Studio) (800), Thunder-Creative Service Bureau (100)','MetLife (9.5), SAP (108.5)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (696, 'Khairullah Zulkafli','Pareto-Designer (160), SAP-Designer (Studio) (80), Thunder-Creative Service Bureau (100), SAP-Core Events Project (1120), Pareto-Designer (160), SAP-Designer (Studio) (800), Thunder-Creative Service Bureau (100)','MetLife (9.5), SAP (108.5)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (696, 'Khairullah Zulkafli','Pareto-Designer (160), SAP-Designer (Studio) (80), Thunder-Creative Service Bureau (100), SAP-Core Events Project (1120), Pareto-Designer (160), SAP-Designer (Studio) (800), Thunder-Creative Service Bureau (100)','MetLife (9.5), SAP (108.5)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (696, 'Khairullah Zulkafli','Pareto-Designer (160), SAP-Designer (Studio) (80), Thunder-Creative Service Bureau (100), SAP-Core Events Project (1120), Pareto-Designer (160), SAP-Designer (Studio) (800), Thunder-Creative Service Bureau (100)','MetLife (9.5), SAP (108.5)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (689, 'Faris Kamal','VertexCM-Marketing Ops (160), Employbridge-Marketing Ops (80), Employbridge-Marketing Operations Manager (80)','','VertexCM') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (689, 'Faris Kamal','VertexCM-Marketing Ops (160), Employbridge-Marketing Ops (80), Employbridge-Marketing Operations Manager (80)','','Employbridge') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (689, 'Faris Kamal','VertexCM-Marketing Ops (160), Employbridge-Marketing Ops (80), Employbridge-Marketing Operations Manager (80)','','Employbridge') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (698, 'Asyraf Husswan','eOriginal-Senior Analyst (160), eOriginal-Analyst (160), eOriginal-Analyst (160), eOriginal-Senior Analyst (160)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (698, 'Asyraf Husswan','eOriginal-Senior Analyst (160), eOriginal-Analyst (160), eOriginal-Analyst (160), eOriginal-Senior Analyst (160)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (698, 'Asyraf Husswan','eOriginal-Senior Analyst (160), eOriginal-Analyst (160), eOriginal-Analyst (160), eOriginal-Senior Analyst (160)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (698, 'Asyraf Husswan','eOriginal-Senior Analyst (160), eOriginal-Analyst (160), eOriginal-Analyst (160), eOriginal-Senior Analyst (160)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (687, 'Wen Nee Wong','TDS-Coordinator (40), 6sense-Coordinator (320), 3X-Coordinator (160), 3X-Coordinator (160), 6sense-Coordinator (320), TDS-Coordinator (2)','3X (179)','TDS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (687, 'Wen Nee Wong','TDS-Coordinator (40), 6sense-Coordinator (320), 3X-Coordinator (160), 3X-Coordinator (160), 6sense-Coordinator (320), TDS-Coordinator (2)','3X (179)','6sense') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (687, 'Wen Nee Wong','TDS-Coordinator (40), 6sense-Coordinator (320), 3X-Coordinator (160), 3X-Coordinator (160), 6sense-Coordinator (320), TDS-Coordinator (2)','3X (179)','6sense') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (687, 'Wen Nee Wong','TDS-Coordinator (40), 6sense-Coordinator (320), 3X-Coordinator (160), 3X-Coordinator (160), 6sense-Coordinator (320), TDS-Coordinator (2)','3X (179)','TDS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (697, 'Aziz Wahid','FARO-Holobuilder -Advertising (160), Pareto-Analyst (80), FARO-Holobuilder -Advertising (160), Pareto-Analyst (80)','GlobalAtlantic (115)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (697, 'Aziz Wahid','FARO-Holobuilder -Advertising (160), Pareto-Analyst (80), FARO-Holobuilder -Advertising (160), Pareto-Analyst (80)','GlobalAtlantic (115)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (697, 'Aziz Wahid','FARO-Holobuilder -Advertising (160), Pareto-Analyst (80), FARO-Holobuilder -Advertising (160), Pareto-Analyst (80)','GlobalAtlantic (115)','FARO') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (697, 'Aziz Wahid','FARO-Holobuilder -Advertising (160), Pareto-Analyst (80), FARO-Holobuilder -Advertising (160), Pareto-Analyst (80)','GlobalAtlantic (115)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (704, 'Alexandra Chew','RetailStat-Designer (80), RetailStat-Designer (0)','Exiger (23), Impact (0.5), Merck (30)','RetailStat') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (704, 'Alexandra Chew','RetailStat-Designer (80), RetailStat-Designer (0)','Exiger (23), Impact (0.5), Merck (30)','RetailStat') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (702, 'Neeraj Biaspal','GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), GibraltarMAPS-Web Support Team (240), GibraltarBA-Web Support Team (0)','','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (702, 'Neeraj Biaspal','GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), GibraltarMAPS-Web Support Team (240), GibraltarBA-Web Support Team (0)','','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (702, 'Neeraj Biaspal','GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), GibraltarMAPS-Web Support Team (240), GibraltarBA-Web Support Team (0)','','GibraltarMAPS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (702, 'Neeraj Biaspal','GibraltarBA-Web Support Team (320), GibraltarMAPS-Web Support Team (240), GibraltarMAPS-Web Support Team (240), GibraltarBA-Web Support Team (0)','','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (688, 'Kamariah Saiful','Pareto-Email Marketing (160), EPAM-Email Marketing (80), EPAM-Email Marketing (80), Pareto-Email Marketing (160)','3E (34.5), Docker (81.5), EPAM (41)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (688, 'Kamariah Saiful','Pareto-Email Marketing (160), EPAM-Email Marketing (80), EPAM-Email Marketing (80), Pareto-Email Marketing (160)','3E (34.5), Docker (81.5), EPAM (41)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (693, 'Preston Chua','DELMIA-Writer (200), DELMIA-Writer (200)','Agiloft (50.5), FARO (46)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (693, 'Preston Chua','DELMIA-Writer (200), DELMIA-Writer (200)','Agiloft (50.5), FARO (46)','DELMIA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (683, 'Jonathan Wong','FARO-Holobuilder - Developer (53), Veracode-Developer (80), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), FARO-Holobuilder - Developer (53), Veracode-Developer (80)','BaxterPlanning (31), FARO (86), Liongard (23)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (683, 'Jonathan Wong','FARO-Holobuilder - Developer (53), Veracode-Developer (80), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), FARO-Holobuilder - Developer (53), Veracode-Developer (80)','BaxterPlanning (31), FARO (86), Liongard (23)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (683, 'Jonathan Wong','FARO-Holobuilder - Developer (53), Veracode-Developer (80), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), FARO-Holobuilder - Developer (53), Veracode-Developer (80)','BaxterPlanning (31), FARO (86), Liongard (23)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (683, 'Jonathan Wong','FARO-Holobuilder - Developer (53), Veracode-Developer (80), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), FARO-Holobuilder - Developer (53), Veracode-Developer (80)','BaxterPlanning (31), FARO (86), Liongard (23)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (684, 'Agnes Low','Vertex-UI/UX (40), BRP-UI/UX (70), NoRedInk-Creative Services (60), BRP-UI/UX (70), NoRedInk-Creative Services (60), GoTo-Creative Service Desk (1760), GoTo-UI/UX Designer (320)','GoTo (176.5)','Vertex') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (684, 'Agnes Low','Vertex-UI/UX (40), BRP-UI/UX (70), NoRedInk-Creative Services (60), BRP-UI/UX (70), NoRedInk-Creative Services (60), GoTo-Creative Service Desk (1760), GoTo-UI/UX Designer (320)','GoTo (176.5)','BRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (684, 'Agnes Low','Vertex-UI/UX (40), BRP-UI/UX (70), NoRedInk-Creative Services (60), BRP-UI/UX (70), NoRedInk-Creative Services (60), GoTo-Creative Service Desk (1760), GoTo-UI/UX Designer (320)','GoTo (176.5)','NoRedInk') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (684, 'Agnes Low','Vertex-UI/UX (40), BRP-UI/UX (70), NoRedInk-Creative Services (60), BRP-UI/UX (70), NoRedInk-Creative Services (60), GoTo-Creative Service Desk (1760), GoTo-UI/UX Designer (320)','GoTo (176.5)','BRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (684, 'Agnes Low','Vertex-UI/UX (40), BRP-UI/UX (70), NoRedInk-Creative Services (60), BRP-UI/UX (70), NoRedInk-Creative Services (60), GoTo-Creative Service Desk (1760), GoTo-UI/UX Designer (320)','GoTo (176.5)','NoRedInk') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (673, 'Siew Ying Lieu','FARO-Holobuilder -Advertising (160), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), FARO-Holobuilder -Advertising (160), Jellyvision-Advertising (160)','FARO (136), IronMountain (1)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (673, 'Siew Ying Lieu','FARO-Holobuilder -Advertising (160), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), FARO-Holobuilder -Advertising (160), Jellyvision-Advertising (160)','FARO (136), IronMountain (1)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (673, 'Siew Ying Lieu','FARO-Holobuilder -Advertising (160), Cellebrite-OFA - Phase 2 (477), Cellebrite-OFA - Phase 2 (477), FARO-Holobuilder -Advertising (160), Jellyvision-Advertising (160)','FARO (136), IronMountain (1)','Jellyvision') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (670, 'Jesslyn Chai','3X-Writer (160), 3X-Writer (320), Hyland-Writer (SEO) (160)','Equiteq (24), UserTesting (95)','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (670, 'Jesslyn Chai','3X-Writer (160), 3X-Writer (320), Hyland-Writer (SEO) (160)','Equiteq (24), UserTesting (95)','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (670, 'Jesslyn Chai','3X-Writer (160), 3X-Writer (320), Hyland-Writer (SEO) (160)','Equiteq (24), UserTesting (95)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (669, 'Sonia Angel','ConnectWise-Designer (240), SmartCommunications-Designer (CSB) (60), ConnectWise-Designer (160)','Canon (54.5), ConnectWise (30.5), Planful (1.5)','SmartCommunications') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (668, 'Danial Asnawi','Tecsys-Advertising (160), Tecsys-Advertising (160), GoTo-Digital Activation Service Desk (1200), GoTo-Digital Advertising (640)','GoTo (155)','Tecsys') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (668, 'Danial Asnawi','Tecsys-Advertising (160), Tecsys-Advertising (160), GoTo-Digital Activation Service Desk (1200), GoTo-Digital Advertising (640)','GoTo (155)','Tecsys') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (666, 'Kosheila Sundram','Momentus-Analyst (80), Corcentric-Analyst (160), Corcentric-Analyst (160), Momentus-Analyst (0), Symplr-Analyst (80)','Anteriad (85), Certinia (0.5), Devo (1), Perforce (64.5), Symplr (6)','Momentus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (666, 'Kosheila Sundram','Momentus-Analyst (80), Corcentric-Analyst (160), Corcentric-Analyst (160), Momentus-Analyst (0), Symplr-Analyst (80)','Anteriad (85), Certinia (0.5), Devo (1), Perforce (64.5), Symplr (6)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (666, 'Kosheila Sundram','Momentus-Analyst (80), Corcentric-Analyst (160), Corcentric-Analyst (160), Momentus-Analyst (0), Symplr-Analyst (80)','Anteriad (85), Certinia (0.5), Devo (1), Perforce (64.5), Symplr (6)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (666, 'Kosheila Sundram','Momentus-Analyst (80), Corcentric-Analyst (160), Corcentric-Analyst (160), Momentus-Analyst (0), Symplr-Analyst (80)','Anteriad (85), Certinia (0.5), Devo (1), Perforce (64.5), Symplr (6)','Momentus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (654, 'Marya Malik','Wavestone-Analyst (40), TheLogicFactory-Analyst (80), Abbyy-Analyst (53), Abbyy-Analyst (53), TheLogicFactory-Analyst (40), Wavestone-Analyst (40), Terrasmart-Analyst (80)','Exiger (1), FARO (71.5)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (654, 'Marya Malik','Wavestone-Analyst (40), TheLogicFactory-Analyst (80), Abbyy-Analyst (53), Abbyy-Analyst (53), TheLogicFactory-Analyst (40), Wavestone-Analyst (40), Terrasmart-Analyst (80)','Exiger (1), FARO (71.5)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (654, 'Marya Malik','Wavestone-Analyst (40), TheLogicFactory-Analyst (80), Abbyy-Analyst (53), Abbyy-Analyst (53), TheLogicFactory-Analyst (40), Wavestone-Analyst (40), Terrasmart-Analyst (80)','Exiger (1), FARO (71.5)','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (654, 'Marya Malik','Wavestone-Analyst (40), TheLogicFactory-Analyst (80), Abbyy-Analyst (53), Abbyy-Analyst (53), TheLogicFactory-Analyst (40), Wavestone-Analyst (40), Terrasmart-Analyst (80)','Exiger (1), FARO (71.5)','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (654, 'Marya Malik','Wavestone-Analyst (40), TheLogicFactory-Analyst (80), Abbyy-Analyst (53), Abbyy-Analyst (53), TheLogicFactory-Analyst (40), Wavestone-Analyst (40), Terrasmart-Analyst (80)','Exiger (1), FARO (71.5)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (654, 'Marya Malik','Wavestone-Analyst (40), TheLogicFactory-Analyst (80), Abbyy-Analyst (53), Abbyy-Analyst (53), TheLogicFactory-Analyst (40), Wavestone-Analyst (40), Terrasmart-Analyst (80)','Exiger (1), FARO (71.5)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (654, 'Marya Malik','Wavestone-Analyst (40), TheLogicFactory-Analyst (80), Abbyy-Analyst (53), Abbyy-Analyst (53), TheLogicFactory-Analyst (40), Wavestone-Analyst (40), Terrasmart-Analyst (80)','Exiger (1), FARO (71.5)','Terrasmart') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (660, 'Syarizan Aziz','RetailStat-Marketing Ops (80), GibraltarBA-Web Support Team (320), KomodoHealth-Marketing Support MRC (500), Hyland-Marketing Ops (Workfront) (160), RetailStat-Marketing Ops (0), KomodoHealth-MRC (500), GibraltarBA-Web Support Team (0)','Hyland (69), MetLife (69), Recognize (15)','RetailStat') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (660, 'Syarizan Aziz','RetailStat-Marketing Ops (80), GibraltarBA-Web Support Team (320), KomodoHealth-Marketing Support MRC (500), Hyland-Marketing Ops (Workfront) (160), RetailStat-Marketing Ops (0), KomodoHealth-MRC (500), GibraltarBA-Web Support Team (0)','Hyland (69), MetLife (69), Recognize (15)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (660, 'Syarizan Aziz','RetailStat-Marketing Ops (80), GibraltarBA-Web Support Team (320), KomodoHealth-Marketing Support MRC (500), Hyland-Marketing Ops (Workfront) (160), RetailStat-Marketing Ops (0), KomodoHealth-MRC (500), GibraltarBA-Web Support Team (0)','Hyland (69), MetLife (69), Recognize (15)','KomodoHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (660, 'Syarizan Aziz','RetailStat-Marketing Ops (80), GibraltarBA-Web Support Team (320), KomodoHealth-Marketing Support MRC (500), Hyland-Marketing Ops (Workfront) (160), RetailStat-Marketing Ops (0), KomodoHealth-MRC (500), GibraltarBA-Web Support Team (0)','Hyland (69), MetLife (69), Recognize (15)','RetailStat') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (660, 'Syarizan Aziz','RetailStat-Marketing Ops (80), GibraltarBA-Web Support Team (320), KomodoHealth-Marketing Support MRC (500), Hyland-Marketing Ops (Workfront) (160), RetailStat-Marketing Ops (0), KomodoHealth-MRC (500), GibraltarBA-Web Support Team (0)','Hyland (69), MetLife (69), Recognize (15)','KomodoHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (660, 'Syarizan Aziz','RetailStat-Marketing Ops (80), GibraltarBA-Web Support Team (320), KomodoHealth-Marketing Support MRC (500), Hyland-Marketing Ops (Workfront) (160), RetailStat-Marketing Ops (0), KomodoHealth-MRC (500), GibraltarBA-Web Support Team (0)','Hyland (69), MetLife (69), Recognize (15)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (650, 'Peter Chan','BRP-Video Editor (80), BRP-Video Editor (80), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (112), Syniti (1.5)','BRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (650, 'Peter Chan','BRP-Video Editor (80), BRP-Video Editor (80), GoTo-Creative Service Desk (1760), GoTo-Video Editor (480)','GoTo (112), Syniti (1.5)','BRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (665, 'Zhee Yao Fok','Blend360-Analyst (80), Quantum-Analyst (53), Blend360-Analyst (80)','Blend360 (17), Devo (56), IQBackOffice (8), KyruusHealth (28.5)','Quantum') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (659, 'Jason Chin','Symplr-Email Marketing (160), FounderShield-Email Marketing (80), GibraltarBA-Web Support Team (320), FounderShield-Email Marketing (80), Symplr-Email Marketing (80), GibraltarBA-Web Support Team (0), AveryDennison-Marketing Ops (30)','AveryDennison (4), FounderShield (0.5), Hyland (54.5), Lytho (0.5), Seismic (51.5), Symplr (16.5)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (659, 'Jason Chin','Symplr-Email Marketing (160), FounderShield-Email Marketing (80), GibraltarBA-Web Support Team (320), FounderShield-Email Marketing (80), Symplr-Email Marketing (80), GibraltarBA-Web Support Team (0), AveryDennison-Marketing Ops (30)','AveryDennison (4), FounderShield (0.5), Hyland (54.5), Lytho (0.5), Seismic (51.5), Symplr (16.5)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (658, 'Ryan Liew','3X-Analyst (80), 3X-Analyst (320), Hyland-Analyst (Database) (160)','3X (106)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (664, 'Rachel Lim','Thunder-Creative Service Bureau (100), LogicGate-UI/UX (40), Plume-UI/UX (20), DuckCreek-Designer (160), LogicGate-UI/UX (40), Plume-UI/UX (20), Thunder-Creative Service Bureau (100)','AllStar (2), Anaplan (1.5), Avetta (4.5), BaxterPlanning (1), DAS42 (0.5), LogicGate (3), LogicSource (0.5), Novata (0.5), Recognize (4), StarLims (2), UserTesting (8), Welocalize (3)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (664, 'Rachel Lim','Thunder-Creative Service Bureau (100), LogicGate-UI/UX (40), Plume-UI/UX (20), DuckCreek-Designer (160), LogicGate-UI/UX (40), Plume-UI/UX (20), Thunder-Creative Service Bureau (100)','AllStar (2), Anaplan (1.5), Avetta (4.5), BaxterPlanning (1), DAS42 (0.5), LogicGate (3), LogicSource (0.5), Novata (0.5), Recognize (4), StarLims (2), UserTesting (8), Welocalize (3)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (664, 'Rachel Lim','Thunder-Creative Service Bureau (100), LogicGate-UI/UX (40), Plume-UI/UX (20), DuckCreek-Designer (160), LogicGate-UI/UX (40), Plume-UI/UX (20), Thunder-Creative Service Bureau (100)','AllStar (2), Anaplan (1.5), Avetta (4.5), BaxterPlanning (1), DAS42 (0.5), LogicGate (3), LogicSource (0.5), Novata (0.5), Recognize (4), StarLims (2), UserTesting (8), Welocalize (3)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (664, 'Rachel Lim','Thunder-Creative Service Bureau (100), LogicGate-UI/UX (40), Plume-UI/UX (20), DuckCreek-Designer (160), LogicGate-UI/UX (40), Plume-UI/UX (20), Thunder-Creative Service Bureau (100)','AllStar (2), Anaplan (1.5), Avetta (4.5), BaxterPlanning (1), DAS42 (0.5), LogicGate (3), LogicSource (0.5), Novata (0.5), Recognize (4), StarLims (2), UserTesting (8), Welocalize (3)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (664, 'Rachel Lim','Thunder-Creative Service Bureau (100), LogicGate-UI/UX (40), Plume-UI/UX (20), DuckCreek-Designer (160), LogicGate-UI/UX (40), Plume-UI/UX (20), Thunder-Creative Service Bureau (100)','AllStar (2), Anaplan (1.5), Avetta (4.5), BaxterPlanning (1), DAS42 (0.5), LogicGate (3), LogicSource (0.5), Novata (0.5), Recognize (4), StarLims (2), UserTesting (8), Welocalize (3)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (661, 'Shah Aiman','Abbyy-Email Marketing (80), Plume-Email Marketing (120), Abbyy-Email Marketing (80), Plume-Email Marketing (120)','Abbyy (3), GoTo (15.5), Ninjio (17)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (661, 'Shah Aiman','Abbyy-Email Marketing (80), Plume-Email Marketing (120), Abbyy-Email Marketing (80), Plume-Email Marketing (120)','Abbyy (3), GoTo (15.5), Ninjio (17)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (642, 'Syuhada Zulkipli','iSpot-Analyst (320), Brightcove-ABM (EMEA & APAC) (80), Brightcove-ABM (EMEA & APAC) (0), iSpot-Analyst (320)','Devo (21), GnAPartners (4), iSpot (66), MadCap (21.5)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (642, 'Syuhada Zulkipli','iSpot-Analyst (320), Brightcove-ABM (EMEA & APAC) (80), Brightcove-ABM (EMEA & APAC) (0), iSpot-Analyst (320)','Devo (21), GnAPartners (4), iSpot (66), MadCap (21.5)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (641, 'Diyana Halim','Veracode-Email Marketing (240), SBI-Marketing Ops (80), SBI-Marketing Ops (80), Veracode-Email Marketing (240), GoTo-Marketing Operations Managed Services (1520), GoTo-Email Marketing (320)','GoTo (104.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (641, 'Diyana Halim','Veracode-Email Marketing (240), SBI-Marketing Ops (80), SBI-Marketing Ops (80), Veracode-Email Marketing (240), GoTo-Marketing Operations Managed Services (1520), GoTo-Email Marketing (320)','GoTo (104.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (641, 'Diyana Halim','Veracode-Email Marketing (240), SBI-Marketing Ops (80), SBI-Marketing Ops (80), Veracode-Email Marketing (240), GoTo-Marketing Operations Managed Services (1520), GoTo-Email Marketing (320)','GoTo (104.5)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (641, 'Diyana Halim','Veracode-Email Marketing (240), SBI-Marketing Ops (80), SBI-Marketing Ops (80), Veracode-Email Marketing (240), GoTo-Marketing Operations Managed Services (1520), GoTo-Email Marketing (320)','GoTo (104.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (636, 'Wei Sheng Lum','DuckCreek-Designer (160), Infor-DC - Designer (1760), Infor-DC - Designer (1760), DuckCreek-Creative Services (40)','Infor (138), Northwind (4)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (636, 'Wei Sheng Lum','DuckCreek-Designer (160), Infor-DC - Designer (1760), Infor-DC - Designer (1760), DuckCreek-Creative Services (40)','Infor (138), Northwind (4)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (616, 'Hazlan Zakaria','Aidoc-Marketing Support MRC (150), Aidoc-Marketing Support MRC (150), Hyland-Revenue Advertising (1160)','Hyland (78)','Aidoc') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (616, 'Hazlan Zakaria','Aidoc-Marketing Support MRC (150), Aidoc-Marketing Support MRC (150), Hyland-Revenue Advertising (1160)','Hyland (78)','Aidoc') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (626, 'Pei Wen Siew','Tecsys-UI/UX (Support) (80), Agiloft-Designer (160), Agiloft-Designer (160), Tecsys-UI/UX (Support) (80)','Agiloft (9.5), Docker (136.5)','Tecsys') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (626, 'Pei Wen Siew','Tecsys-UI/UX (Support) (80), Agiloft-Designer (160), Agiloft-Designer (160), Tecsys-UI/UX (Support) (80)','Agiloft (9.5), Docker (136.5)','Tecsys') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (622, 'Affiq Halim','Veracode-Video Editor (160), 3X-Video Editor (80), Veracode-Video Editor (160)','Canon (9), Liongard (2)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (622, 'Affiq Halim','Veracode-Video Editor (160), 3X-Video Editor (80), Veracode-Video Editor (160)','Canon (9), Liongard (2)','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (622, 'Affiq Halim','Veracode-Video Editor (160), 3X-Video Editor (80), Veracode-Video Editor (160)','Canon (9), Liongard (2)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (627, 'Joevee Yeo','Pareto-Video Editor (80), WoltersKluwer-Video Editor (160), Pareto-Video Editor (80), WoltersKluwer-Video Editor (160)','LogicGate (12.5), WKHLRP (5.5), WoltersKluwer (138)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (627, 'Joevee Yeo','Pareto-Video Editor (80), WoltersKluwer-Video Editor (160), Pareto-Video Editor (80), WoltersKluwer-Video Editor (160)','LogicGate (12.5), WKHLRP (5.5), WoltersKluwer (138)','Pareto') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (610, 'Hazim Razali','Veracode-Email Marketing (240), Blend360-Marketing Ops (160), Blend360-Marketing Ops (160), Veracode-Email Marketing (240)','Emburse (60), MetLife (67)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (610, 'Hazim Razali','Veracode-Email Marketing (240), Blend360-Marketing Ops (160), Blend360-Marketing Ops (160), Veracode-Email Marketing (240)','Emburse (60), MetLife (67)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (610, 'Hazim Razali','Veracode-Email Marketing (240), Blend360-Marketing Ops (160), Blend360-Marketing Ops (160), Veracode-Email Marketing (240)','Emburse (60), MetLife (67)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (610, 'Hazim Razali','Veracode-Email Marketing (240), Blend360-Marketing Ops (160), Blend360-Marketing Ops (160), Veracode-Email Marketing (240)','Emburse (60), MetLife (67)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (612, 'Clement Chng','Veracode-UI/UX (160), Veracode-UI/UX (160), Emburse-Creative Services (400)','BRP (45), Emburse (20), EROAD (43.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (612, 'Clement Chng','Veracode-UI/UX (160), Veracode-UI/UX (160), Emburse-Creative Services (400)','BRP (45), Emburse (20), EROAD (43.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (592, 'Sakti Rames','ToolsGroup-Advertising (80), ToolsGroup-Ops/Campaign/Gov MRC (125), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Digital Advertising (160)','Emburse (18.5), Syniti (14)','ToolsGroup') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (592, 'Sakti Rames','ToolsGroup-Advertising (80), ToolsGroup-Ops/Campaign/Gov MRC (125), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Digital Advertising (160)','Emburse (18.5), Syniti (14)','ToolsGroup') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (592, 'Sakti Rames','ToolsGroup-Advertising (80), ToolsGroup-Ops/Campaign/Gov MRC (125), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Digital Advertising (160)','Emburse (18.5), Syniti (14)','ToolsGroup') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (598, 'Simren Kaur','VertexCM-Writer (160), Syniti-Writer (80), Syniti-Writer (80)','BlueMantis (56.5), DirectTravel (23.5), Ergotron (25)','VertexCM') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (598, 'Simren Kaur','VertexCM-Writer (160), Syniti-Writer (80), Syniti-Writer (80)','BlueMantis (56.5), DirectTravel (23.5), Ergotron (25)','Syniti') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (598, 'Simren Kaur','VertexCM-Writer (160), Syniti-Writer (80), Syniti-Writer (80)','BlueMantis (56.5), DirectTravel (23.5), Ergotron (25)','Syniti') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (590, 'Afiq Othman','SAP-Core Events Project (1120), Hyland-Digital Engagement (1800), AbOvo-Creative Service Bureau (265)','Ergotron (102)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (590, 'Afiq Othman','SAP-Core Events Project (1120), Hyland-Digital Engagement (1800), AbOvo-Creative Service Bureau (265)','Ergotron (102)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (590, 'Afiq Othman','SAP-Core Events Project (1120), Hyland-Digital Engagement (1800), AbOvo-Creative Service Bureau (265)','Ergotron (102)','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (597, 'Lik Kang Chin','Enverus-Analyst (213), Sandler-Analyst (80), Enverus-Analyst (213), Sandler-Analyst (80), Carenet-Analyst (80)','Sandler (39.5)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (597, 'Lik Kang Chin','Enverus-Analyst (213), Sandler-Analyst (80), Enverus-Analyst (213), Sandler-Analyst (80), Carenet-Analyst (80)','Sandler (39.5)','Enverus') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (597, 'Lik Kang Chin','Enverus-Analyst (213), Sandler-Analyst (80), Enverus-Analyst (213), Sandler-Analyst (80), Carenet-Analyst (80)','Sandler (39.5)','Carenet') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (596, 'Hazirah Harith','Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Skysafe-ABM Campaign MRC (350), Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Devo-Email Marketing (160), Skysafe-ABM Campaign MRC (500)','MetLife (114.5)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (596, 'Hazirah Harith','Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Skysafe-ABM Campaign MRC (350), Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Devo-Email Marketing (160), Skysafe-ABM Campaign MRC (500)','MetLife (114.5)','SimpleTire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (596, 'Hazirah Harith','Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Skysafe-ABM Campaign MRC (350), Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Devo-Email Marketing (160), Skysafe-ABM Campaign MRC (500)','MetLife (114.5)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (596, 'Hazirah Harith','Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Skysafe-ABM Campaign MRC (350), Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Devo-Email Marketing (160), Skysafe-ABM Campaign MRC (500)','MetLife (114.5)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (596, 'Hazirah Harith','Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Skysafe-ABM Campaign MRC (350), Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Devo-Email Marketing (160), Skysafe-ABM Campaign MRC (500)','MetLife (114.5)','SimpleTire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (596, 'Hazirah Harith','Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Skysafe-ABM Campaign MRC (350), Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Devo-Email Marketing (160), Skysafe-ABM Campaign MRC (500)','MetLife (114.5)','Devo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (596, 'Hazirah Harith','Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Skysafe-ABM Campaign MRC (350), Influitive-Email Marketing/Ops/ Data (125), SimpleTire-Email & Ops MRC (125), Devo-Email Marketing (160), Skysafe-ABM Campaign MRC (500)','MetLife (114.5)','Skysafe') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (586, 'Jasherr Ravindran','iSpot-Analyst (320), iSpot-Analyst (320), GoTo-Marketing Operations Managed Services (1520), GoTo-Analyst (800)','Cengage (142.5)','iSpot') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (586, 'Jasherr Ravindran','iSpot-Analyst (320), iSpot-Analyst (320), GoTo-Marketing Operations Managed Services (1520), GoTo-Analyst (800)','Cengage (142.5)','iSpot') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (586, 'Jasherr Ravindran','iSpot-Analyst (320), iSpot-Analyst (320), GoTo-Marketing Operations Managed Services (1520), GoTo-Analyst (800)','Cengage (142.5)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (586, 'Jasherr Ravindran','iSpot-Analyst (320), iSpot-Analyst (320), GoTo-Marketing Operations Managed Services (1520), GoTo-Analyst (800)','Cengage (142.5)','GoTo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (587, 'Colin Lim','eOriginal-Coordinator (480), eOriginal-Coordinator (480)','Devo (38.5), Tispayments (12.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (587, 'Colin Lim','eOriginal-Coordinator (480), eOriginal-Coordinator (480)','Devo (38.5), Tispayments (12.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (569, 'Aliff Haikal','Veracode-Marketing Ops (160), Plume-Marketing Ops (80), Plume-Marketing Ops (80), GoTo-Marketing Operations Managed Services (1520), GoTo-Email Marketing (320)','GoTo (40)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (569, 'Aliff Haikal','Veracode-Marketing Ops (160), Plume-Marketing Ops (80), Plume-Marketing Ops (80), GoTo-Marketing Operations Managed Services (1520), GoTo-Email Marketing (320)','GoTo (40)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (569, 'Aliff Haikal','Veracode-Marketing Ops (160), Plume-Marketing Ops (80), Plume-Marketing Ops (80), GoTo-Marketing Operations Managed Services (1520), GoTo-Email Marketing (320)','GoTo (40)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (564, 'Eugenie Tan','EverDriven-Writer (80), SAP-Writer (Studio) (960), EverDriven-Writer (80), SAP-Writer (Studio) (1280)','Emburse (117), MadCap (3)','EverDriven') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (564, 'Eugenie Tan','EverDriven-Writer (80), SAP-Writer (Studio) (960), EverDriven-Writer (80), SAP-Writer (Studio) (1280)','Emburse (117), MadCap (3)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (564, 'Eugenie Tan','EverDriven-Writer (80), SAP-Writer (Studio) (960), EverDriven-Writer (80), SAP-Writer (Studio) (1280)','Emburse (117), MadCap (3)','EverDriven') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (564, 'Eugenie Tan','EverDriven-Writer (80), SAP-Writer (Studio) (960), EverDriven-Writer (80), SAP-Writer (Studio) (1280)','Emburse (117), MadCap (3)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (556, 'Nashruddin Yusoff','DuckCreek-Analyst (80), Novata-Analyst (53), DuckCreek-Analyst (80), Novata-Analyst (53), AveryDennison-Analyst (40)','GoTo (102)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (556, 'Nashruddin Yusoff','DuckCreek-Analyst (80), Novata-Analyst (53), DuckCreek-Analyst (80), Novata-Analyst (53), AveryDennison-Analyst (40)','GoTo (102)','Novata') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (556, 'Nashruddin Yusoff','DuckCreek-Analyst (80), Novata-Analyst (53), DuckCreek-Analyst (80), Novata-Analyst (53), AveryDennison-Analyst (40)','GoTo (102)','DuckCreek') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (556, 'Nashruddin Yusoff','DuckCreek-Analyst (80), Novata-Analyst (53), DuckCreek-Analyst (80), Novata-Analyst (53), AveryDennison-Analyst (40)','GoTo (102)','Novata') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (556, 'Nashruddin Yusoff','DuckCreek-Analyst (80), Novata-Analyst (53), DuckCreek-Analyst (80), Novata-Analyst (53), AveryDennison-Analyst (40)','GoTo (102)','AveryDennison') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (561, 'Anusha Abishegam','Influitive-Creative Services (65), KomodoHealth-Marketing Support MRC (500), Influitive-Creative Services (65), KomodoHealth-MRC (500)','KomodoHealth (10.5), KyruusHealth (31), Tangoe (37)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (561, 'Anusha Abishegam','Influitive-Creative Services (65), KomodoHealth-Marketing Support MRC (500), Influitive-Creative Services (65), KomodoHealth-MRC (500)','KomodoHealth (10.5), KyruusHealth (31), Tangoe (37)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (553, 'Syafiq Ahmad','Brightcove-Analyst (80), SandlerNetwork-Analyst (80), Brightcove-Analyst (0), SandlerNetwork-Analyst (80), Liferay-MRC (425)','Sandler (3), SandlerNetwork (42.5), UserTesting (56.5)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (553, 'Syafiq Ahmad','Brightcove-Analyst (80), SandlerNetwork-Analyst (80), Brightcove-Analyst (0), SandlerNetwork-Analyst (80), Liferay-MRC (425)','Sandler (3), SandlerNetwork (42.5), UserTesting (56.5)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (553, 'Syafiq Ahmad','Brightcove-Analyst (80), SandlerNetwork-Analyst (80), Brightcove-Analyst (0), SandlerNetwork-Analyst (80), Liferay-MRC (425)','Sandler (3), SandlerNetwork (42.5), UserTesting (56.5)','Liferay') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (552, 'Asraf Zain','Ricoh-Video Editor (80), SandlerNetwork-Creative Services (225), Ricoh-Video Editor (80), SandlerNetwork-Creative Services (225), AbOvo-Creative Service Bureau (265), Ricoh-Video Editor (160)','Orion (5.5), Ricoh (41), Sandler (11.5)','SandlerNetwork') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (552, 'Asraf Zain','Ricoh-Video Editor (80), SandlerNetwork-Creative Services (225), Ricoh-Video Editor (80), SandlerNetwork-Creative Services (225), AbOvo-Creative Service Bureau (265), Ricoh-Video Editor (160)','Orion (5.5), Ricoh (41), Sandler (11.5)','SandlerNetwork') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (552, 'Asraf Zain','Ricoh-Video Editor (80), SandlerNetwork-Creative Services (225), Ricoh-Video Editor (80), SandlerNetwork-Creative Services (225), AbOvo-Creative Service Bureau (265), Ricoh-Video Editor (160)','Orion (5.5), Ricoh (41), Sandler (11.5)','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (547, 'Nabilah Sharil','3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250)','BRP (88)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (547, 'Nabilah Sharil','3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250)','BRP (88)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (534, 'Jayne Ong','Brightcove-Advertising (320), Brightcove-Advertising (400)','Rackspace (117)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (534, 'Jayne Ong','Brightcove-Advertising (320), Brightcove-Advertising (400)','Rackspace (117)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (526, 'Benson Kong','eOriginal-Designer (480), SAP-Core Events Project (1120), eOriginal-Designer (480), Hyland-Case Study Production (60)','Carenet (3), Hyland (9), MadCap (45.5), Onec1 (80.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (526, 'Benson Kong','eOriginal-Designer (480), SAP-Core Events Project (1120), eOriginal-Designer (480), Hyland-Case Study Production (60)','Carenet (3), Hyland (9), MadCap (45.5), Onec1 (80.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (526, 'Benson Kong','eOriginal-Designer (480), SAP-Core Events Project (1120), eOriginal-Designer (480), Hyland-Case Study Production (60)','Carenet (3), Hyland (9), MadCap (45.5), Onec1 (80.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (520, 'Julian Kee','Cellebrite-Analyst (240), Cellebrite-Analyst (240)','','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (520, 'Julian Kee','Cellebrite-Analyst (240), Cellebrite-Analyst (240)','','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (543, 'Amirah Azlan','Blend360-Designer (160), InStepHealth-Designer (40), SAP-Core Events Project (1120), Blend360-Designer (160), InStepHealth-Designer (40)','3X (67.5), Anaplan (74)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (543, 'Amirah Azlan','Blend360-Designer (160), InStepHealth-Designer (40), SAP-Core Events Project (1120), Blend360-Designer (160), InStepHealth-Designer (40)','3X (67.5), Anaplan (74)','InStepHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (543, 'Amirah Azlan','Blend360-Designer (160), InStepHealth-Designer (40), SAP-Core Events Project (1120), Blend360-Designer (160), InStepHealth-Designer (40)','3X (67.5), Anaplan (74)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (543, 'Amirah Azlan','Blend360-Designer (160), InStepHealth-Designer (40), SAP-Core Events Project (1120), Blend360-Designer (160), InStepHealth-Designer (40)','3X (67.5), Anaplan (74)','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (543, 'Amirah Azlan','Blend360-Designer (160), InStepHealth-Designer (40), SAP-Core Events Project (1120), Blend360-Designer (160), InStepHealth-Designer (40)','3X (67.5), Anaplan (74)','InStepHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (533, 'Syakirah Azmi','SBI-Email Marketing (80), EMS-Email Marketing (80), EMS-Email Marketing (80), SBI-Email Marketing (80)','','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (533, 'Syakirah Azmi','SBI-Email Marketing (80), EMS-Email Marketing (80), EMS-Email Marketing (80), SBI-Email Marketing (80)','','EMS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (533, 'Syakirah Azmi','SBI-Email Marketing (80), EMS-Email Marketing (80), EMS-Email Marketing (80), SBI-Email Marketing (80)','','EMS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (533, 'Syakirah Azmi','SBI-Email Marketing (80), EMS-Email Marketing (80), EMS-Email Marketing (80), SBI-Email Marketing (80)','','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (540, 'Wanie Yazid','EPAM-Analyst (240), EPAM-Analyst (240), Equiteq-Analyst (20)','Certinia (122), EPAM (1)','Equiteq') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (542, 'KC Ng','Sandler-Governance (80), Sandler-Governance (80), Liferay-MRC (425)','GoTo (125)','Sandler') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (542, 'KC Ng','Sandler-Governance (80), Sandler-Governance (80), Liferay-MRC (425)','GoTo (125)','Sandler') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (542, 'KC Ng','Sandler-Governance (80), Sandler-Governance (80), Liferay-MRC (425)','GoTo (125)','Liferay') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (522, 'Ven Xhin Pang','LogicSource-Writer (320), Jaggaer-Creative Service Bureau (204), LogicSource-Writer (160)','3X (151), LogicSource (0.5)','Jaggaer') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (541, 'Farah Natasya','iSpot-Advertising (80), eOriginal-Advertising (160), eOriginal-Advertising (160), iSpot-Advertising (80)','MultiPlan (20), Perforce (0.5), Syniti (27.5), UserTesting (38.5)','iSpot') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (541, 'Farah Natasya','iSpot-Advertising (80), eOriginal-Advertising (160), eOriginal-Advertising (160), iSpot-Advertising (80)','MultiPlan (20), Perforce (0.5), Syniti (27.5), UserTesting (38.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (541, 'Farah Natasya','iSpot-Advertising (80), eOriginal-Advertising (160), eOriginal-Advertising (160), iSpot-Advertising (80)','MultiPlan (20), Perforce (0.5), Syniti (27.5), UserTesting (38.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (541, 'Farah Natasya','iSpot-Advertising (80), eOriginal-Advertising (160), eOriginal-Advertising (160), iSpot-Advertising (80)','MultiPlan (20), Perforce (0.5), Syniti (27.5), UserTesting (38.5)','iSpot') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (529, 'Christine Loy','Symplr-Marketing Ops (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Symplr-Marketing Ops (80)','Growtomation (14), Lumivero (34.5), Tispayments (14.5), Welocalize (6.5)','Symplr') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (529, 'Christine Loy','Symplr-Marketing Ops (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Symplr-Marketing Ops (80)','Growtomation (14), Lumivero (34.5), Tispayments (14.5), Welocalize (6.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (529, 'Christine Loy','Symplr-Marketing Ops (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Symplr-Marketing Ops (80)','Growtomation (14), Lumivero (34.5), Tispayments (14.5), Welocalize (6.5)','3E') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (529, 'Christine Loy','Symplr-Marketing Ops (80), 3E-Marketing Support MRC (250), 3E-Marketing Support MRC (250), Symplr-Marketing Ops (80)','Growtomation (14), Lumivero (34.5), Tispayments (14.5), Welocalize (6.5)','Symplr') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (519, 'Mandy Loh','Cellebrite-Writer (Direct Response) (160), Cellebrite-Writer (Direct Response) (160)','3X (116)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (519, 'Mandy Loh','Cellebrite-Writer (Direct Response) (160), Cellebrite-Writer (Direct Response) (160)','3X (116)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (516, 'Faten Hassan','EPAM-Marketing Ops (320), EPAM-Marketing Ops (320), Prospiant-Email Marketing (80)','EPAM (60.5), ULSolutions (51)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (517, 'Faiz Rosli','Wavestone-Developer (40), Terrasmart-Developer (53), Terrasmart-Design Services Bureau (130), Terrasmart-Design Services Bureau (200), Wavestone-Developer (40), AbOvo-Creative Service Bureau (265)','Abbyy (6), Planful (18.5), PrescientEdge (8), ProcessUnity (33.5), Terrasmart (39.5)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (517, 'Faiz Rosli','Wavestone-Developer (40), Terrasmart-Developer (53), Terrasmart-Design Services Bureau (130), Terrasmart-Design Services Bureau (200), Wavestone-Developer (40), AbOvo-Creative Service Bureau (265)','Abbyy (6), Planful (18.5), PrescientEdge (8), ProcessUnity (33.5), Terrasmart (39.5)','Wavestone') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (517, 'Faiz Rosli','Wavestone-Developer (40), Terrasmart-Developer (53), Terrasmart-Design Services Bureau (130), Terrasmart-Design Services Bureau (200), Wavestone-Developer (40), AbOvo-Creative Service Bureau (265)','Abbyy (6), Planful (18.5), PrescientEdge (8), ProcessUnity (33.5), Terrasmart (39.5)','AbOvo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (506, 'Alex Liew','Cellebrite-Program Manager (320), Cellebrite-Program Manager (320)','AveryDennison (49), DirectTravel (31), StarLims (4.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (506, 'Alex Liew','Cellebrite-Program Manager (320), Cellebrite-Program Manager (320)','AveryDennison (49), DirectTravel (31), StarLims (4.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (503, 'Awang Shafiq','Sandler-Designer (80), SandlerNetwork-Creative Services (225), Sandler-Designer (80), SandlerNetwork-Creative Services (225), 3X-UI/UX (80)','Sandler (31.5), SandlerNetwork (11.5)','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (502, 'Jack Ng','FARO-GDC - Analyst (160), Thunder-ABM (53), FARO-GDC - Analyst (160), Thunder-ABM (53)','FARO (32.5), Seismic (29)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (502, 'Jack Ng','FARO-GDC - Analyst (160), Thunder-ABM (53), FARO-GDC - Analyst (160), Thunder-ABM (53)','FARO (32.5), Seismic (29)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (501, 'Cabreney Johnny','Plume-Marketing Ops (80), Assent-Marketing Ops (Drift) (160), Assent-Marketing Ops (Drift) (160), Plume-Marketing Ops (80)','AllStar (4.5), Avetta (22.5), BlueMantis (69), Fourth (1.5), Lumivero (3.5), MadCap (9)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (501, 'Cabreney Johnny','Plume-Marketing Ops (80), Assent-Marketing Ops (Drift) (160), Assent-Marketing Ops (Drift) (160), Plume-Marketing Ops (80)','AllStar (4.5), Avetta (22.5), BlueMantis (69), Fourth (1.5), Lumivero (3.5), MadCap (9)','Assent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (501, 'Cabreney Johnny','Plume-Marketing Ops (80), Assent-Marketing Ops (Drift) (160), Assent-Marketing Ops (Drift) (160), Plume-Marketing Ops (80)','AllStar (4.5), Avetta (22.5), BlueMantis (69), Fourth (1.5), Lumivero (3.5), MadCap (9)','Assent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (501, 'Cabreney Johnny','Plume-Marketing Ops (80), Assent-Marketing Ops (Drift) (160), Assent-Marketing Ops (Drift) (160), Plume-Marketing Ops (80)','AllStar (4.5), Avetta (22.5), BlueMantis (69), Fourth (1.5), Lumivero (3.5), MadCap (9)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (490, 'Rozlan Rahman','eOriginal-Designer (480), SandlerNetwork-Creative Services (225), eOriginal-Designer (480), SandlerNetwork-Creative Services (225), Symplr-Creative Service Bureau (200)','Avetta (82), RedCanary (1.5), Sandler (5), SandlerNetwork (12.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (490, 'Rozlan Rahman','eOriginal-Designer (480), SandlerNetwork-Creative Services (225), eOriginal-Designer (480), SandlerNetwork-Creative Services (225), Symplr-Creative Service Bureau (200)','Avetta (82), RedCanary (1.5), Sandler (5), SandlerNetwork (12.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (490, 'Rozlan Rahman','eOriginal-Designer (480), SandlerNetwork-Creative Services (225), eOriginal-Designer (480), SandlerNetwork-Creative Services (225), Symplr-Creative Service Bureau (200)','Avetta (82), RedCanary (1.5), Sandler (5), SandlerNetwork (12.5)','Symplr') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (486, 'Kirthana Sivaparanjothi','Cellebrite-Email Marketing (320), GibraltarBA-Email Marketing (160), Cellebrite-Email Marketing Manager (480)','Cohesity (1), EcoVadis (4.5), Growtomation (4), Seismic (141.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (486, 'Kirthana Sivaparanjothi','Cellebrite-Email Marketing (320), GibraltarBA-Email Marketing (160), Cellebrite-Email Marketing Manager (480)','Cohesity (1), EcoVadis (4.5), Growtomation (4), Seismic (141.5)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (486, 'Kirthana Sivaparanjothi','Cellebrite-Email Marketing (320), GibraltarBA-Email Marketing (160), Cellebrite-Email Marketing Manager (480)','Cohesity (1), EcoVadis (4.5), Growtomation (4), Seismic (141.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (480, 'Yue En Lau','LogicSource-Analyst (160), Hyland-Hive9 Support (160), LogicSource-Analyst (160)','','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (480, 'Yue En Lau','LogicSource-Analyst (160), Hyland-Hive9 Support (160), LogicSource-Analyst (160)','','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (480, 'Yue En Lau','LogicSource-Analyst (160), Hyland-Hive9 Support (160), LogicSource-Analyst (160)','','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (482, 'Amirul Hazriq','Fastmarkets-Analyst (80), Fastmarkets-Analyst (80)','EMS (7), FARO (51.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (482, 'Amirul Hazriq','Fastmarkets-Analyst (80), Fastmarkets-Analyst (80)','EMS (7), FARO (51.5)','Fastmarkets') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (483, 'Aliya Suhaimi','iSpot-Designer (80), Abbyy-Campaign Creatives (80), KomodoHealth-Marketing Support MRC (500), Abbyy-Campaign Creatives (80), iSpot-Designer (80), KomodoHealth-MRC (500), Brennan-Designer (35)','Ciklum (4.5), iSpot (6), Plume (67), QuakerHoughton (0.5)','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (483, 'Aliya Suhaimi','iSpot-Designer (80), Abbyy-Campaign Creatives (80), KomodoHealth-Marketing Support MRC (500), Abbyy-Campaign Creatives (80), iSpot-Designer (80), KomodoHealth-MRC (500), Brennan-Designer (35)','Ciklum (4.5), iSpot (6), Plume (67), QuakerHoughton (0.5)','KomodoHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (483, 'Aliya Suhaimi','iSpot-Designer (80), Abbyy-Campaign Creatives (80), KomodoHealth-Marketing Support MRC (500), Abbyy-Campaign Creatives (80), iSpot-Designer (80), KomodoHealth-MRC (500), Brennan-Designer (35)','Ciklum (4.5), iSpot (6), Plume (67), QuakerHoughton (0.5)','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (483, 'Aliya Suhaimi','iSpot-Designer (80), Abbyy-Campaign Creatives (80), KomodoHealth-Marketing Support MRC (500), Abbyy-Campaign Creatives (80), iSpot-Designer (80), KomodoHealth-MRC (500), Brennan-Designer (35)','Ciklum (4.5), iSpot (6), Plume (67), QuakerHoughton (0.5)','KomodoHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (483, 'Aliya Suhaimi','iSpot-Designer (80), Abbyy-Campaign Creatives (80), KomodoHealth-Marketing Support MRC (500), Abbyy-Campaign Creatives (80), iSpot-Designer (80), KomodoHealth-MRC (500), Brennan-Designer (35)','Ciklum (4.5), iSpot (6), Plume (67), QuakerHoughton (0.5)','Brennan') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (484, 'Amirul Hafidz','PCS-Writer (80), ConnectWise-Writer (Partner Marketing) (80), PCS-Writer (80)','EROAD (159), PCS (1)','ConnectWise') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (481, 'Armand Mukhlis','LogicSource-Email Marketing (160), Hyland-DPS (Ops) (1040), LogicSource-Email Marketing (160)','Certinia (81.5), Growtomation (21), Hyland (18.5)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (481, 'Armand Mukhlis','LogicSource-Email Marketing (160), Hyland-DPS (Ops) (1040), LogicSource-Email Marketing (160)','Certinia (81.5), Growtomation (21), Hyland (18.5)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (475, 'Faeez Ismail','Prospiant-Video Editor (53), GibraltarBA-Video Editor (160), Prospiant-Video Editor (53)','Infor (178.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (475, 'Faeez Ismail','Prospiant-Video Editor (53), GibraltarBA-Video Editor (160), Prospiant-Video Editor (53)','Infor (178.5)','GibraltarBA') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (475, 'Faeez Ismail','Prospiant-Video Editor (53), GibraltarBA-Video Editor (160), Prospiant-Video Editor (53)','Infor (178.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (472, 'Hui Wei Choy','LogicGate-Designer (110), SAP-Core Events Project (1120), Hyland-Digital Engagement (1800), LogicGate-Designer (110)','Hyland (138)','LogicGate') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (472, 'Hui Wei Choy','LogicGate-Designer (110), SAP-Core Events Project (1120), Hyland-Digital Engagement (1800), LogicGate-Designer (110)','Hyland (138)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (472, 'Hui Wei Choy','LogicGate-Designer (110), SAP-Core Events Project (1120), Hyland-Digital Engagement (1800), LogicGate-Designer (110)','Hyland (138)','LogicGate') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (459, 'Yi Wen Ho','PCS-Designer (60), Syniti-Creative Services (100), Veracode-Designer (160), PCS-Designer (60), Syniti-Creative Services (0), Veracode-Designer (160), Syniti-Design Services Bureau (100), AveryDennison-Designer (50)','AveryDennison (1), JellyVision (1), PCS (1.5), Rackspace (7), RackspaceSM (5)','Syniti') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (459, 'Yi Wen Ho','PCS-Designer (60), Syniti-Creative Services (100), Veracode-Designer (160), PCS-Designer (60), Syniti-Creative Services (0), Veracode-Designer (160), Syniti-Design Services Bureau (100), AveryDennison-Designer (50)','AveryDennison (1), JellyVision (1), PCS (1.5), Rackspace (7), RackspaceSM (5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (459, 'Yi Wen Ho','PCS-Designer (60), Syniti-Creative Services (100), Veracode-Designer (160), PCS-Designer (60), Syniti-Creative Services (0), Veracode-Designer (160), Syniti-Design Services Bureau (100), AveryDennison-Designer (50)','AveryDennison (1), JellyVision (1), PCS (1.5), Rackspace (7), RackspaceSM (5)','Syniti') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (459, 'Yi Wen Ho','PCS-Designer (60), Syniti-Creative Services (100), Veracode-Designer (160), PCS-Designer (60), Syniti-Creative Services (0), Veracode-Designer (160), Syniti-Design Services Bureau (100), AveryDennison-Designer (50)','AveryDennison (1), JellyVision (1), PCS (1.5), Rackspace (7), RackspaceSM (5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (459, 'Yi Wen Ho','PCS-Designer (60), Syniti-Creative Services (100), Veracode-Designer (160), PCS-Designer (60), Syniti-Creative Services (0), Veracode-Designer (160), Syniti-Design Services Bureau (100), AveryDennison-Designer (50)','AveryDennison (1), JellyVision (1), PCS (1.5), Rackspace (7), RackspaceSM (5)','Syniti') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (455, 'Taufiq Mairan','ULSolutions-Marketing Ops (160), ULSolutions-Marketing Ops (320)','Hyland (12), UserTesting (103.5), Vizient (7)','ULSolutions') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (455, 'Taufiq Mairan','ULSolutions-Marketing Ops (160), ULSolutions-Marketing Ops (320)','Hyland (12), UserTesting (103.5), Vizient (7)','ULSolutions') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (457, 'Shamala Gunasilian','EverDriven-Marketing Ops (80), Diligent-Marketing Ops - Drift (80), Drift-Ad Hoc Support (40), Drift-Ad Hoc Support (40), EverDriven-Marketing Ops (80), BRP-Marketing Ops (80)','EMS (20), Ethyca (15.5), ProcessUnity (58)','EverDriven') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (457, 'Shamala Gunasilian','EverDriven-Marketing Ops (80), Diligent-Marketing Ops - Drift (80), Drift-Ad Hoc Support (40), Drift-Ad Hoc Support (40), EverDriven-Marketing Ops (80), BRP-Marketing Ops (80)','EMS (20), Ethyca (15.5), ProcessUnity (58)','Diligent') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (457, 'Shamala Gunasilian','EverDriven-Marketing Ops (80), Diligent-Marketing Ops - Drift (80), Drift-Ad Hoc Support (40), Drift-Ad Hoc Support (40), EverDriven-Marketing Ops (80), BRP-Marketing Ops (80)','EMS (20), Ethyca (15.5), ProcessUnity (58)','Drift') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (457, 'Shamala Gunasilian','EverDriven-Marketing Ops (80), Diligent-Marketing Ops - Drift (80), Drift-Ad Hoc Support (40), Drift-Ad Hoc Support (40), EverDriven-Marketing Ops (80), BRP-Marketing Ops (80)','EMS (20), Ethyca (15.5), ProcessUnity (58)','Drift') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (457, 'Shamala Gunasilian','EverDriven-Marketing Ops (80), Diligent-Marketing Ops - Drift (80), Drift-Ad Hoc Support (40), Drift-Ad Hoc Support (40), EverDriven-Marketing Ops (80), BRP-Marketing Ops (80)','EMS (20), Ethyca (15.5), ProcessUnity (58)','EverDriven') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (457, 'Shamala Gunasilian','EverDriven-Marketing Ops (80), Diligent-Marketing Ops - Drift (80), Drift-Ad Hoc Support (40), Drift-Ad Hoc Support (40), EverDriven-Marketing Ops (80), BRP-Marketing Ops (80)','EMS (20), Ethyca (15.5), ProcessUnity (58)','BRP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (452, 'Amzar Yusuf','Brightcove-Marketing Ops (80), Sandler-Marketing Ops (80), Brightcove-Marketing Ops (0), Sandler-Marketing Ops (80)','Sandler (82.5), SandlerNetwork (3)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (452, 'Amzar Yusuf','Brightcove-Marketing Ops (80), Sandler-Marketing Ops (80), Brightcove-Marketing Ops (0), Sandler-Marketing Ops (80)','Sandler (82.5), SandlerNetwork (3)','Brightcove') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (450, 'Sofea Hazmin','SparkHire-Analyst (80), Televerde-Analyst (80), Televerde-Analyst (80)','','SparkHire') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (450, 'Sofea Hazmin','SparkHire-Analyst (80), Televerde-Analyst (80), Televerde-Analyst (80)','','Televerde') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (450, 'Sofea Hazmin','SparkHire-Analyst (80), Televerde-Analyst (80), Televerde-Analyst (80)','','Televerde') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','COREHigherEd') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','COREHigherEd') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','Dizzion') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (446, 'Amir Mansor','Veracode-Designer (160), COREHigherEd-Designer (80), Dizzion-Creative Services (100), SAP-Core Events Project (1120), COREHigherEd-Designer (80), Dizzion-Creative Services (100), Veracode-Designer (160), GoTo-Creative Service Desk (1760), GoTo-Graphic Designer (480), BestPass-Designer (160)','GoTo (144.5)','BestPass') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (437, 'Pugalzhetha Elangovan','Vertex-Marketing Ops (SalesLoft) (80), LogicSource-Marketing Ops (160), LogicSource-Marketing Ops (160), Vertex-Marketing Ops (SalesLoft) (80), LogicSource-Marketing Ops (80)','Ergotron (0.5), Vertex (43.5), VertexCM (11)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (437, 'Pugalzhetha Elangovan','Vertex-Marketing Ops (SalesLoft) (80), LogicSource-Marketing Ops (160), LogicSource-Marketing Ops (160), Vertex-Marketing Ops (SalesLoft) (80), LogicSource-Marketing Ops (80)','Ergotron (0.5), Vertex (43.5), VertexCM (11)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (437, 'Pugalzhetha Elangovan','Vertex-Marketing Ops (SalesLoft) (80), LogicSource-Marketing Ops (160), LogicSource-Marketing Ops (160), Vertex-Marketing Ops (SalesLoft) (80), LogicSource-Marketing Ops (80)','Ergotron (0.5), Vertex (43.5), VertexCM (11)','LogicSource') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (444, 'Joon Sern Gan','Sandler-Web Optimization Ops (80), KomodoHealth-Marketing Support MRC (500), Sandler-Web Optimization Ops (80), KomodoHealth-MRC (500), Qlik-Marketing Ops (240), Sandler-Web Optimization Ops (0)','FARO (10), Qlik (17)','Sandler') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (444, 'Joon Sern Gan','Sandler-Web Optimization Ops (80), KomodoHealth-Marketing Support MRC (500), Sandler-Web Optimization Ops (80), KomodoHealth-MRC (500), Qlik-Marketing Ops (240), Sandler-Web Optimization Ops (0)','FARO (10), Qlik (17)','KomodoHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (444, 'Joon Sern Gan','Sandler-Web Optimization Ops (80), KomodoHealth-Marketing Support MRC (500), Sandler-Web Optimization Ops (80), KomodoHealth-MRC (500), Qlik-Marketing Ops (240), Sandler-Web Optimization Ops (0)','FARO (10), Qlik (17)','Sandler') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (444, 'Joon Sern Gan','Sandler-Web Optimization Ops (80), KomodoHealth-Marketing Support MRC (500), Sandler-Web Optimization Ops (80), KomodoHealth-MRC (500), Qlik-Marketing Ops (240), Sandler-Web Optimization Ops (0)','FARO (10), Qlik (17)','KomodoHealth') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (444, 'Joon Sern Gan','Sandler-Web Optimization Ops (80), KomodoHealth-Marketing Support MRC (500), Sandler-Web Optimization Ops (80), KomodoHealth-MRC (500), Qlik-Marketing Ops (240), Sandler-Web Optimization Ops (0)','FARO (10), Qlik (17)','Sandler') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (434, 'Chien Law','TheLogicFactory-Advertising (80), Hyland-Advertising (ABM) (400), TheLogicFactory-Advertising (120)','Sandler (117), SandlerNetwork (23)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (434, 'Chien Law','TheLogicFactory-Advertising (80), Hyland-Advertising (ABM) (400), TheLogicFactory-Advertising (120)','Sandler (117), SandlerNetwork (23)','Hyland') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (434, 'Chien Law','TheLogicFactory-Advertising (80), Hyland-Advertising (ABM) (400), TheLogicFactory-Advertising (120)','Sandler (117), SandlerNetwork (23)','TheLogicFactory') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (435, 'Janice Ng','LogicSource-Email Marketing (160), Thunder-Email Marketing (80), LogicSource-Email Marketing (160), Thunder-Email Marketing (80)','eOriginal (46.5), LogicSource (58)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (435, 'Janice Ng','LogicSource-Email Marketing (160), Thunder-Email Marketing (80), LogicSource-Email Marketing (160), Thunder-Email Marketing (80)','eOriginal (46.5), LogicSource (58)','Thunder') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (428, 'Etrin Ameera','EPAM-Analyst (240), EPAM-Analyst (240)','IronMountain (1), LogicSource (97)','EPAM') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (428, 'Etrin Ameera','EPAM-Analyst (240), EPAM-Analyst (240)','IronMountain (1), LogicSource (97)','EPAM') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (422, 'Adibah Mahmood','SAP-Email (Studio) (640), eOriginal-Email Marketing (320), eOriginal-Email Marketing (320), SAP-Email (Studio) (560), Jaggaer-Email Marketing (50)','PCS (103), SAP (60.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (422, 'Adibah Mahmood','SAP-Email (Studio) (640), eOriginal-Email Marketing (320), eOriginal-Email Marketing (320), SAP-Email (Studio) (560), Jaggaer-Email Marketing (50)','PCS (103), SAP (60.5)','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (422, 'Adibah Mahmood','SAP-Email (Studio) (640), eOriginal-Email Marketing (320), eOriginal-Email Marketing (320), SAP-Email (Studio) (560), Jaggaer-Email Marketing (50)','PCS (103), SAP (60.5)','Jaggaer') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (420, 'Ryano Chu','Plume-Developer (40), Cellebrite-Developer (80), Cellebrite-Developer (160), Plume-Developer (40), 3X-Developer (80)','KomodoHealth (91.5), StarLims (22.5)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (420, 'Ryano Chu','Plume-Developer (40), Cellebrite-Developer (80), Cellebrite-Developer (160), Plume-Developer (40), 3X-Developer (80)','KomodoHealth (91.5), StarLims (22.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (420, 'Ryano Chu','Plume-Developer (40), Cellebrite-Developer (80), Cellebrite-Developer (160), Plume-Developer (40), 3X-Developer (80)','KomodoHealth (91.5), StarLims (22.5)','Cellebrite') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (420, 'Ryano Chu','Plume-Developer (40), Cellebrite-Developer (80), Cellebrite-Developer (160), Plume-Developer (40), 3X-Developer (80)','KomodoHealth (91.5), StarLims (22.5)','Plume') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (420, 'Ryano Chu','Plume-Developer (40), Cellebrite-Developer (80), Cellebrite-Developer (160), Plume-Developer (40), 3X-Developer (80)','KomodoHealth (91.5), StarLims (22.5)','3X') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (418, 'Vivian Lim','Corcentric-Governance (80), Corcentric-Governance (80)','Devo (60.5), SmartCommNAM (5), Vizient (64)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (418, 'Vivian Lim','Corcentric-Governance (80), Corcentric-Governance (80)','Devo (60.5), SmartCommNAM (5), Vizient (64)','Corcentric') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (412, 'HK Lee','Prospiant-Developer (40), Prospiant-Developer (80), Prospiant-Developer (60)','3E (58.5), QuakerHoughton (25.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (412, 'HK Lee','Prospiant-Developer (40), Prospiant-Developer (80), Prospiant-Developer (60)','3E (58.5), QuakerHoughton (25.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (412, 'HK Lee','Prospiant-Developer (40), Prospiant-Developer (80), Prospiant-Developer (60)','3E (58.5), QuakerHoughton (25.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (408, 'Ayub Rafar','BRP-Governance (80), BRP-Governance (80), Devo-Governance (80)','BRP (37), IronMountain (39)','Devo') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','ToolsGroup') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','Syniti') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','eOriginal') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','Syniti') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','ToolsGroup') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','DPR') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (407, 'Izzaty Azman','eOriginal-Marketing Ops (320), ToolsGroup-Ops/Campaign/Gov MRC (125), Syniti-Marketing Ops (80), eOriginal-Marketing Ops (320), Syniti-Marketing Ops (80), ToolsGroup-Ops/Campaign/Gov MRC (125), DPR-Marketing Ops and Analytics (320), BestPass-MRC (375)','','BestPass') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (402, 'Ivan Ong','Suvoda-ABM (160), Influitive-ABM (80), Influitive-ABM (80), Suvoda-ABM (160), Liferay-MRC (425)','Equiteq (16), GnAPartners (3), ProcessUnity (36.5), WKHLRP (74)','Suvoda') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (402, 'Ivan Ong','Suvoda-ABM (160), Influitive-ABM (80), Influitive-ABM (80), Suvoda-ABM (160), Liferay-MRC (425)','Equiteq (16), GnAPartners (3), ProcessUnity (36.5), WKHLRP (74)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (402, 'Ivan Ong','Suvoda-ABM (160), Influitive-ABM (80), Influitive-ABM (80), Suvoda-ABM (160), Liferay-MRC (425)','Equiteq (16), GnAPartners (3), ProcessUnity (36.5), WKHLRP (74)','Influitive') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (402, 'Ivan Ong','Suvoda-ABM (160), Influitive-ABM (80), Influitive-ABM (80), Suvoda-ABM (160), Liferay-MRC (425)','Equiteq (16), GnAPartners (3), ProcessUnity (36.5), WKHLRP (74)','Suvoda') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (402, 'Ivan Ong','Suvoda-ABM (160), Influitive-ABM (80), Influitive-ABM (80), Suvoda-ABM (160), Liferay-MRC (425)','Equiteq (16), GnAPartners (3), ProcessUnity (36.5), WKHLRP (74)','Liferay') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (406, 'Pravina Pragasam','SAP-Event Coordinator (320), SAP-Event Coordinator (480), SAP-Event Coordinator (400)','Carenet (18.5), Merck (6.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (406, 'Pravina Pragasam','SAP-Event Coordinator (320), SAP-Event Coordinator (480), SAP-Event Coordinator (400)','Carenet (18.5), Merck (6.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (406, 'Pravina Pragasam','SAP-Event Coordinator (320), SAP-Event Coordinator (480), SAP-Event Coordinator (400)','Carenet (18.5), Merck (6.5)','SAP') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (396, 'Kenneth Chaw','Prospiant-Writer (80), 3X-Writer (160), 3X-Writer (320)','3X (1), Emburse (61), Hyland (54.5)','Prospiant') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (394, 'Natasha Ameer','Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160), Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160)','3X (7.5), Ricoh (56), RicohGC (8), RicohNa (2)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (394, 'Natasha Ameer','Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160), Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160)','3X (7.5), Ricoh (56), RicohGC (8), RicohNa (2)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (394, 'Natasha Ameer','Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160), Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160)','3X (7.5), Ricoh (56), RicohGC (8), RicohNa (2)','SBI') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (394, 'Natasha Ameer','Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160), Ricoh-Designer (160), SBI-Designer (80), Veracode-Designer (160)','3X (7.5), Ricoh (56), RicohGC (8), RicohNa (2)','Veracode') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (391, 'Jia Jing Lee','EverDriven-Designer (160), EverDriven-Designer (80), AWS-Creative Services (80), TDS-Design Service Bureau (120), EverDriven-Designer (160), TDS-Design Service Bureau (158), RCG-Creative Service Bureau (200)','EverDriven (7), Infor (130.5)','AWS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (391, 'Jia Jing Lee','EverDriven-Designer (160), EverDriven-Designer (80), AWS-Creative Services (80), TDS-Design Service Bureau (120), EverDriven-Designer (160), TDS-Design Service Bureau (158), RCG-Creative Service Bureau (200)','EverDriven (7), Infor (130.5)','TDS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (391, 'Jia Jing Lee','EverDriven-Designer (160), EverDriven-Designer (80), AWS-Creative Services (80), TDS-Design Service Bureau (120), EverDriven-Designer (160), TDS-Design Service Bureau (158), RCG-Creative Service Bureau (200)','EverDriven (7), Infor (130.5)','TDS') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (391, 'Jia Jing Lee','EverDriven-Designer (160), EverDriven-Designer (80), AWS-Creative Services (80), TDS-Design Service Bureau (120), EverDriven-Designer (160), TDS-Design Service Bureau (158), RCG-Creative Service Bureau (200)','EverDriven (7), Infor (130.5)','RCG') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (752, 'Jo Ee Hoo','Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (20), Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (1)','','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (752, 'Jo Ee Hoo','Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (20), Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (1)','','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (752, 'Jo Ee Hoo','Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (20), Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (1)','','LogicGate') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (752, 'Jo Ee Hoo','Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (20), Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (1)','','Abbyy') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (752, 'Jo Ee Hoo','Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (20), Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (1)','','Blend360') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))
INSERT INTO placement_check (_userID, _name, _placement, _actual,_missing) VALUES (752, 'Jo Ee Hoo','Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (20), Abbyy-Governance (53), Blend360-Governance (80), LogicGate-Governance (1)','','LogicGate') ON DUPLICATE KEY UPDATE _missing = CONCAT(_missing,',',VALUES(_missing))