SELECT p.ProductCode AS 'Unique Retailer SKU' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-2.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-3.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-4.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-5.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-6.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-7.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-8.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-9.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-10.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-11.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-12.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-13.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-14.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-15.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-16.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-17.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-18.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-19.jpg' AS 'Image URL' , 'Config_FullStoreURLConfig_ProductPhotosFolder/' + p.ProductCode + '-20.jpg' AS 'Image URL' FROM Products p INNER JOIN Products_Descriptions pd ON p.ProductID = pd.ProductID INNER JOIN Products_Extended pe ON pd.ProductID = pe.ProductID ORDER BY p.ProductCode