We have revised the SWIRE Photometric Redshift Catalogue to take account of new optical photometry in several of the SWIRE areas, and incorporating 2MASS and UKIDSS near infrared data. Aperture matching is an important issue for combining near infrared and optical data, and we have explored a number of methods of doing this. The increased number of photometric bands available for the redshift solution results in improvements both in the rms error and, especially, in the outlier rate. We have also found that incorporating the dust torus emission into the QSO templates improves the performance for QSO redshift estimation. Our revised redshift catalogue contains over 1 million extragalactic objects, of which 26288 are QSOs.