CREATE or REPLACE FUNCTION pleaselogin(varchar,varchar,integer) RETURNS integer AS
'select contact.id
   from contact left join contact_department on  contact.id = contact_department.contact
                left join department on contact_department.department = department.id
                left join phoneline on (phoneline.contact = contact.id
                                     or (phoneline.function = ''contact'' and phoneline.lookupid = contact.id))
  where contact.login || contact.pin = $1 || $2 and contact.status = ''active''
    and department.company = $3 and phoneline.contact IS NOT NULL limit 1;
' LANGUAGE SQL;

