SELECT id FROM table WHERE fecha_fabricacion BETWEEN "2019-01-15" AND "2019-02-10" and fecha_recojo BETWEEN "2019-01-15" AND "2019-02-10";