SHARE
TWEET

Untitled

a guest Jun 18th, 2019 68 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT personnel.Region_1 as 'personnel.Region_1',personnel.LimosaIdValidityDate as 'personnel.LimosaIdValidityDate',personnel.Employer as 'personnel.Employer',personnel.LIMOSAID as 'personnel.LIMOSAID', personnel.INSS as 'personnel.INSS' , personnel.TeamResponsible as 'personnel.TeamResponsible',personnel.IsActive as 'personnel.IsActive',personnel.Color as 'personnel.Color',personnel.IconId as 'personnel.IconId',personnel.Mobile as 'personnel.Mobile',personnel.Email as 'personnel.Email',personnel.uaid as 'personnel.uaid',personnel.PersonnelId as 'personnel.PersonnelId',personnel.LastName as 'personnel.LastName',personnel.FirstName as 'personnel.FirstName',personnel.FunctionId as 'personnel.FunctionId',personnel.BadgeNumber as 'personnel.BadgeNumber',personnel.AddressLon as 'personnel.AddressLon',personnel.AddressLat as 'personnel.AddressLat',personnel.AddressNum as 'personnel.AddressNum', personnel.TeamResponsible as 'personnel.TeamResponsible',personnel.FamilyId as 'personnel.FamilyId',personnel.Language as 'personnel.Language',personnel.UserNumber as 'personnel.UserNumber',personnel.TimeTrackingSource as 'personnel.TimeTrackingSource',personnel.str01 as 'personnel.str01',personnel.str02 as 'personnel.str02',personnel.str03 as 'personnel.str03',personnel.str04 as 'personnel.str04',personnel.str05 as 'personnel.str05',personnel.str06 as 'personnel.str06',personnel.str07 as 'personnel.str07',personnel.str08 as 'personnel.str08',personnel.str09 as 'personnel.str09',personnel.str10 as 'personnel.str10',personnel.str11 as 'personnel.str11',personnel.str12 as 'personnel.str12',personnel.str13 as 'personnel.str13',personnel.str14 as 'personnel.str14',personnel.str15 as 'personnel.str15',personnel.str16 as 'personnel.str16',personnel.str17 as 'personnel.str17',personnel.str18 as 'personnel.str18',personnel.str19 as 'personnel.str19',personnel.str20 as 'personnel.str20',personnel.AddressStreet as 'personnel.AddressStreet',personnel.AddressZip as 'personnel.AddressZip',personnel.AddressCity as 'personnel.AddressCity',personnel.IsActive as 'personnel.IsActive',personnel.AddressCountry as 'personnel.AddressCountry',personnel.Wage_Cat as 'personnel.Wage_Cat',personnel.CalendarId as 'personnel.CalendarId',personnel.JobDescription as 'personnel.JobDescription',personnel.AddressLocality as 'personnel.AddressLocality', personnel.Employer as 'personnel.Employer', personnel.Commentaire as 'personnel.Commentaire', personnel.Stopped_Working as 'personnel.Stopped_Working', personnel.Started_Working as 'personnel.Started_Working', personnel.ShopId as 'personnel.ShopId', personnel.FunctionId as 'personnel.FunctionId', personnel.TeamRef as 'personnel.TeamRef', personnel.ContractualDailyWorkHour as 'personnel.ContractualDailyWorkHour', personnel.OverTimeHours as 'personnel.OverTimeHours', personnel.Cree_Le as 'personnel.Cree_Le', personnel.Contract_Number as 'Contract_Number' , personnel.serverrecordstatus as 'personnel.serverrecordstatus', signature.PictureId as SignatureId,photo.pictureId as PhotoId,mtgroupuser.Id_group as 'mtgroupuser.Id_group',mtgroups.Name as 'mtgroup.Name',hll.hlabel as NomCat, mtsed.SedId,mtsed.UserId,mtsed.FamilyId,mtsed.DeviceId,mtsed.Name,mtsed.TypeId,mtsed.Active,mtsed.CreationDate, vehicle.VehicleId,vehicle.ExtId,vehicle.ShortDesc,vehicle.DeviceId,vehicle.PlateNumber
  2. FROM personnel
  3. LEFT JOIN mtsed ON  personnel.uaid=mtsed.UserId AND mtsed.ServerRecordStatus!=3 AND mtsed.Active=1
  4. LEFT JOIN vehicle ON vehicle.DefaultDriver = personnel.uaid AND vehicle.ServerRecordStatus!=3
  5. LEFT JOIN pictures signature ON signature.referenceId = personnel.uaid AND signature.ServerRecordStatus!=3 AND signature.ReferenceTableId=38  
  6. LEFT JOIN pictures photo ON photo.referenceId = personnel.uaid AND photo.ServerRecordStatus!=3 AND photo.ReferenceTableId=31  
  7. LEFT JOIN hierarchylabel hl ON personnel.Wage_Cat = hl.LabelId AND hl.serverrecordstatus != 3 AND hl.LabelContext = 'PERSONNEL' AND hl.LabelGroup = 'Wage_Cat'
  8. LEFT JOIN hierarchylabellocalization hll ON hll.LabelId = hl.LabelId AND hll.LabelLanguage = 'EN'
  9. LEFT JOIN mtgroupuser ON mtgroupuser.uaid = personnel.uaid AND mtgroupuser.ServerRecordStatus !=3
  10. LEFT JOIN mtgroups ON mtgroups.Id_group = mtgroupuser.Id_group AND mtgroups.ServerRecordStatus !=3
  11. WHERE personnel.uaid!=0 AND personnel.uaid = 444799591  AND personnel.ServerRecordStatus!=3 AND personnel.AccountId = 406;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top