Without actual sample data, this is a little difficult, my answer is guess work.

My guess, however, is that you're starting in the wrong place. I assuming that your table, FCTtable, doesn't have a value for ID-1411 at 01:00:00. As that's your base table, it doesn't matter what (left) joins you're doing, you're never going to return a result (well unless you use a FULL OUTER JOIN, but I don't think that's your intention/solution here).

Edit: Also, the SQL you have provided won't run, the entire thing is encapsulated in quotations. You have a CAST without an AS, and you also reference a table 'i', but there is no table, or alias 'i'. I was attempting to give you a solution, however, I don't want to second guess so please at least fix your SQL first.