-- Add Mayo GAA to Michael's personal intel
-- Critical for connecting with Irish people!

UPDATE lead_intel
SET
  hobbies = ARRAY['Following F1', 'Watching football', 'Watching NRL', 'Grew up working in family pub', 'GAA - Mayo supporter'],
  interests = ARRAY['Liverpool FC supporter', 'South Sydney Rabbitohs fan', 'F1 Racing - Max Verstappen', 'Construction industry', 'Irish heritage', 'Mayo GAA'],
  conversation_starters = ARRAY[
    'Ask about Mayo GAA - the heartbreak and the hope! Every Irish person has an opinion',
    'Ask about Liverpool''s season - he''s a big Reds supporter',
    'Mention the F1 - Max Verstappen is his driver',
    'Ask how the Rabbitohs are going this NRL season',
    'Growing up in a pub on Achill Island - great stories there',
    'Construction chat - Formcork Steelfixin and concrete work'
  ],
  personal_news = jsonb_set(
    personal_news,
    '{gaa_team}',
    '"Mayo"'
  )
WHERE lead_id IN (
  SELECT id FROM leads
  WHERE (first_name ILIKE '%michael%' AND last_name ILIKE '%loughlin%')
     OR (first_name ILIKE '%michael%' AND last_name ILIKE '%rocco%')
);
