OrthoSm;)e Dental Clinic

select top #total_rows# i.*, a.tx_info_1 nm_brand, a2.tx_info_1 nm_condition, a3.tx_info_1 nm_transmission, a4.tx_info_1 nm_category, a5.tx_info_1 nm_fuel, u.nm_file from inventory i left join global..article a on i.id_make = a.id_article left join global..article a2 on i.id_condition = a2.id_article left join global..article a3 on i.id_transmission = a3.id_article left join global..article a4 on i.id_category = a4.id_article left join global..article a5 on i.id_fuel = a5.id_article LEFT JOIN ( SELECT nm_folder, nm_file, ROW_NUMBER() OVER ( PARTITION BY nm_folder ORDER BY id_index_pic DESC, id_upload ) as rn FROM global..upload WHERE id_app = 52 AND tx_path_folder = 'D:\inetpub\wwwroot\S\speedo\inventory\upload' ) u ON CONVERT(VARCHAR, i.id_inventory) = u.nm_folder AND u.rn = 1 where 1=1