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(1922) AND
DATEDIFF(pf.time_from, now()) <= 0 AND
DATEDIFF(pf.time_to,now()) >= 0SELECT 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(1920) AND
DATEDIFF(pf.time_from, now()) <= 0 AND
DATEDIFF(pf.time_to,now()) >= 0SELECT 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(1919) AND
DATEDIFF(pf.time_from, now()) <= 0 AND
DATEDIFF(pf.time_to,now()) >= 0SELECT 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(1921) AND
DATEDIFF(pf.time_from, now()) <= 0 AND
DATEDIFF(pf.time_to,now()) >= 0
Simply provide your number as well as the desired time within our services times. We will endeavour to call you back at this time. Of course this service is free of charge!