wistia and simplybook links for staff

select id,name,wistia_id, book_call_url from staff where active=1 and publish=1;

alter table staff add column wistia_id text default null;
alter table staff add column book_call_url text default null;

-- example
update staff set wistia_id = 'gt0dmdff1b', book_call_url = 'https://anywhereinc.simplybook.me/v2/#book/location/3/service/1/provider/5/' where id =19; --	Erick Pinell

update staff set wistia_id = '', book_call_url = '' where id = 96; --	Daniel Gonzales
update staff set wistia_id = '', book_call_url = '' where id =133; -- Jason Vargas
update staff set wistia_id = '', book_call_url = '' where id =121; --	Gisella Vildoso Hidalgo
update staff set wistia_id = '', book_call_url = '' where id =20; --	Katia Quiros
update staff set wistia_id = '', book_call_url = '' where id =41; --	Harold Montero
update staff set wistia_id = '', book_call_url = '' where id =97; --	Mariandree Saravia
update staff set wistia_id = '', book_call_url = '' where id = 128;	-- Lizza Corrales
update staff set wistia_id = '', book_call_url = '' where id = 72	; -- Bitty Ramirez Portilla
update staff set wistia_id = '', book_call_url = '' where id = 39	; --Gaudy Marin Hernandez
update staff set wistia_id = '', book_call_url = '' where id = 61	; --Tracy Rodriguez
update staff set wistia_id = '', book_call_url = '' where id = 16	; --Royner Lopez
update staff set wistia_id = '', book_call_url = '' where id = 79	; --Leonardo Navarro Castro
update staff set wistia_id = '', book_call_url = '' where id = 95	; --Sisy Gomez
update staff set wistia_id = '', book_call_url = '' where id = 32	; --Alfonso Fernandez
update staff set wistia_id = '', book_call_url = '' where id = 69	; --Henry Aguilar
update staff set wistia_id = '', book_call_url = '' where id = 35	; --Lester Ruiz
update staff set wistia_id = '', book_call_url = '' where id = 94	; --Jose Parrondo
update staff set wistia_id = '', book_call_url = '' where id = 136	; --Alexandra Cartolin
update staff set wistia_id = '', book_call_url = '' where id = 77	; --Jose Miguel Fernandez
update staff set wistia_id = '', book_call_url = '' where id = 120	; --Sylvia Perez
update staff set wistia_id = '', book_call_url = '' where id = 91	; --Claudia Fernandez
update staff set wistia_id = '', book_call_url = '' where id = 132	; --Sofia Ortiz
update staff set wistia_id = '', book_call_url = '' where id = 1	; --Pablo Brenes
update staff set wistia_id = '', book_call_url = '' where id = 15	; --Abby Bello
update staff set wistia_id = '', book_call_url = '' where id = 76	; --Joel Coillo Orcoapaza
update staff set wistia_id = '', book_call_url = '' where id = 57	; --Angelica Regalado
update staff set wistia_id = '', book_call_url = '' where id = 73	; --Franklin Juarez
update staff set wistia_id = '', book_call_url = '' where id = 63	; --Jessica Carvajal
update staff set wistia_id = '', book_call_url = '' where id = 47	; --Ileana Mena Mora
update staff set wistia_id = '', book_call_url = '' where id = 123	; --Peter Hernandez
update staff set wistia_id = '', book_call_url = '' where id = 5	; --Gema Cantillano
update staff set wistia_id = '', book_call_url = '' where id = 112	; --Sara Nizama
update staff set wistia_id = '', book_call_url = '' where id = 134	; --Milagros Mamani
update staff set wistia_id = '', book_call_url = '' where id = 53	; --Jessica Garro
update staff set wistia_id = '', book_call_url = '' where id = 68	; --Cesar Nizama
update staff set wistia_id = '', book_call_url = '' where id = 11	; --Daniella
update staff set wistia_id = '', book_call_url = '' where id = 117	; --Claudia Samayoa
update staff set wistia_id = '', book_call_url = '' where id = 75	; --Percy Coll Santillan
update staff set wistia_id = '', book_call_url = '' where id = 80	; --Roy Soto Cruz
update staff set wistia_id = '', book_call_url = '' where id = 40	; --Yahaira Quesada
update staff set wistia_id = '', book_call_url = '' where id = 71	; --Andrea Luna Fernandez
update staff set wistia_id = '', book_call_url = '' where id = 42	; --Sirleny Zuniga