Active Projects not displayed

This is caused by an incorrect SQL statement which does not work if no company has been created yet:

SELECT DISTINCT i.*, p.* from project p, company c, item i 
WHERE p.status <= 3 
AND p.status >= 1 
AND p.state = 1 
AND i.id = p.id 
AND (p.company = c.id OR p.company = 0) 
ORDER BY prio, name

I am not firm enough in SQL to see, why this query only works, if there is at least one row in the company table.

Burger? Binder? Any idea?

Please check:

SELECT DISTINCT i.*, p.* from streber.item i, streber.project p left join streber.company c on p.company = c.id
WHERE p.status <= 3
AND p.status >= 1
AND p.state = 1
AND i.id = p.id
ORDER BY prio, name;

It seems to work excellently. Maybe I should invest some time in figuring out the difference ;-)

Is not done in v0.079