SELECT pfh.hotel_id AS hobjekt,
p.preisliste_id AS preisliste,
p.title AS title,
pf.pdf_id AS pdf_id
FROM preisliste p
LEFT JOIN preisliste_pdf pf ON p.preisliste_id = pf.preisliste_id
LEFT JOIN preisliste_pdf_hotel pfh ON pfh.pdf_id = pf.pdf_id
WHERE pfh.hotel_id IN(1002) AND
DATEDIFF(pf.time_from, now()) <= 0 AND
DATEDIFF(pf.time_to,now()) >= 0