SELECT stella2_concentral_cons.name, guests, ort, UNIX_TIMESTAMP(con_from) AS von, UNIX_TIMESTAMP(con_till) AS bis FROM stella2_concentral_cons INNER JOIN stella2_concentral_items ON (stella2_concentral_cons.id = stella2_concentral_items.conID) WHERE stella2_concentral_cons.id='' AND (stella2_concentral_items.date <= NOW() OR stella2_concentral_items.date IS NULL) GROUP BY stella2_concentral_cons.id