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