SELECT 
  u.id AS parent_id,
  u.firstname AS parent_firstname,
  u.lastname AS parent_lastname,
  u.phone AS parent_phone,
  u.status AS relationship_status,
  u.created_at AS student_signup_unix,
  up.country AS parent_country
FROM user u
LEFT JOIN user_profile up ON u.id = up.user_id
WHERE 
     u.type = 'parent'
  AND u.created_at BETWEEN 1748818800 AND 1750460400
    AND (
    (
      NOT (
        u.phone LIKE '234%' OR 
        u.phone LIKE '080%' OR 
        u.phone LIKE '081%' OR 
        u.phone LIKE '070%' OR 
        u.phone LIKE '090%' OR 
        u.phone LIKE '091%'
      )
    )
    AND (
      LOWER(up.country) NOT IN ('nigeria') OR up.country IS NULL
    )
  );