select z_pk, datetime(ZBATCHBREWDATE, 'unixepoch', '+31 years') as BREW_DATE,  zbatchname, ZBATCHTYPE, ZBATCHSIZE, 
ZBATCHBOILSIZE, ZBATCHBOILTIME, ZBATCHACTABV, ZBATCHACTOG, ZBATCHACTFG, ZBATCHEFFICIENCY, ZBATCHCOLOR, 
ZBATCHRATING, ZBATCHNOTES from ZBATCHES order by z_pk

select ZEQPROFILENAME as Name , ZEQBOILOFFAMOUNT as BoilOffAmount, ZEQGRAINABSORPTION as GrainAborption, ZEQGRAINTEMP as GrainTemp, ZEQKETTLELOSS as KettleLoss, ZEQMASHTUNTEMPLOSS as MashTunTempLoss, ZEQMASHTUNVOLUMELOSS as MashTunVolumeLoss, ZEQWORTSHRINKAGE as WorkShrinkage from ZEQPROFILES