SELECT WID, 
JobSheetNo, 
AID, 
AccRef, 
Customer, 
Department, 
Address1, 
Address2, 
Town, 
County, 
PostCode, 
Telephone, 
JobDate, 
AppointmentDate, 
CompletionDate, 
TechID, 
StartTime, 
FinishTime, 
BreakdownService, 
CertIssued, 
Finished, 
PassFail, 
FinishCount, 
PassCount, 
JobCount, 
CancelCount, 
CallbackRequired, 
CustomerPrintName, 
EngineerPrintName, 
InvoiceNo, 
BedTypes, 
BathHoistType, 
BathLifterType, 
MiscellaneousTypes, 
WheelHoistTypes, 
MattressTypes, 
CeilingTrackTypes, 
MobileHoistTypes, 
BathLifterTypes, 
InflatableBathLiftTypes, 
BedRailTypes, 
MattressServiceTypes, 
RiseChairTypes, 
ElectricLifterTypes, 
InflatableLifterTypes, 
NonPoweredStandTypes, 
PoweredStandTypes, 
SlingTypes, 
CeilingTrackInstallTypes, 
JobType1, 
JobType2, 
JobType3, 
JobType4, 
JobType5, 
JobType6, 
JobType7, 
JobType8, 
JobType9, 
JobType10, 
JobType11, 
JobType12, 
JobType13, 
JobType14, 
JobType15, 
JobType16, 
JobType17, 
JobType18, 
JobType19, 
JobType20, 
JobType21, 
JobType22, 
JobType23, 
JobType24, 
JobType25, 
JobType26, 
JobType27, 
Notes, 
JobType28, 
JobType29, 
JobType30, 
JobType31, 
JobType32, 
JobType33, 
JobType34, 
JobType35, 
JobType36, 
JobType37, 
JobType38, 
JobType39, 
JobType40, 
RepairedCount, 
PartsCount, 
OfficeComplete, 
servicewid
 FROM workbooks
 WHERE WID=:WID