public final function loadPublications() { $this->publications = array(); $q = $this->db->buildQuery("SELECT publication_id, p.connection_id, p.external_id, c.service FROM publications p LEFT join connections c ON c.external_id=p.connection_id WHERE p.object_id=%d", $this->objectId); $rs = $this->db->query($q); while ($o = $this->db->fetchObject($rs)) { $publication = new Publication(); $publication->setFromObject($o); $this->publications[$o->publication_id] = $publication; } }