gistfile1.sql

SELECT 
  sp.user_id 
FROM shop_pagers sp 
WHERE sp.user_id NOT IN (
  SELECT 
    owner_id 
  FROM tickets 
  WHERE ticket_status NOT IN (3,4,7)
) 
AND sp.shop_id = 1;

SELECT 
  sp.user_id 
FROM shop_pagers sp 
LEFT JOIN tickets t ON t.owner_id = sp.user_id AND t.ticket_status NOT IN (3,4,7)
WHERE t.id IS NULL
AND sp.shop_id = 1;