SELECT DATE_ONLINE,DATE_TO_ENABLE ,mdoc_id,SUBTITLE,SUMMARY,TITLE,DATE_ONLINE,TIME_ONLINE,KEYWORD_A,content_table.PICT.P_SIZE,content_table.PICT.P_CREDIT,content_table.PICT.P_TITLE,content_table.PICT.P_PATH FROM content_table,content_table.PICT WHERE STATUS_PUB = 'on' AND DOC_TYPE = 'content' AND DATE_ONLINE <= 'checkdate' AND DATE_TO_ENABLE <= 'checkdatetime' AND DATE_OFFLINE > 'checkdate' AND MENU = 'Agrarverlag' AND ID_KEY = 2583 AND RANK = 1 AND mdoc_id NOT IN ('') AND content_table.PICT.mdv_index = 0 ORDER BY DATE_ONLINE DESC,DATE_TO_ENABLE DESC LIMIT 100