xxxxxxxxxx
SELECT o.handle_id
FROM dbo.dsobject_table o
INNER JOIN dbo.link_table l
ON o.handle_id = l.destination_id
INNER JOIN dbo.class_def_table c
ON c.class_id = o.handle_class
WHERE originalname NOT IN ( 'Collection', 'BulletinBoard', 'Weblog', 'Wiki',
'Calendar', 'Workspace' )
AND handle_class != 3
AND object_isdeleted = 0
AND l.source_id = 740001
AND CONVERT(DATETIME, object_create_date, 102) BETWEEN
CONVERT(DATETIME, '01-Oct-23', 102) AND
CONVERT(DATETIME, '02-Oct-23', 102)