xdenser

select * from table t
where 
not
(
{$fromDate} between t.date1 and t.date2
or
{$toDate} between t.date1 and t.date2
)
</sql>

select c.name, 
         (select count(*)  
          from products p
          where p.id_company = c.id
          and to_days(now()) - to_days(p.data) <= 10) as cnt
from company c