SELECT 'http://www.telemoustique.be/imgres/q80/w50/h50/'+ object_img as image_url , * FROM vw_tm_agenda_new_mini vw_tm_mini INNER JOIN (SELECT object_id, ROW_NUMBER() OVER (Order BY object_date asc) AS RowNumber FROM vw_tm_agenda_new_mini WHERE object_date >= left(dbo.convertToStrDate(getdate()),8) ) T ON T.object_id = vw_tm_mini.object_id AND T.RowNumber BETWEEN (0+1) AND (0 +10) ORDER BY T.RowNumber asc