ON user.item_id = room.creator_id WHERE room.type = "grouproom" AND room.deletion_date IS NULL '; $indexer->add(CS_GROUPROOM_TYPE, $query); //////////////////////////// ////// Annotations ///////// //////////////////////////// $query = ' SELECT annotations.item_id AS item_id, annotations.linked_item_id AS index_id, NULL AS version_id, annotations.modification_date, CONCAT(annotations.title, " ", annotations.description, " ", user.firstname, " ", user.lastname) AS search_data FROM annotations LEFT JOIN user ON user.item_id = annotations.creator_id WHERE annotations.deletion_date IS NULL '; $indexer->add(CS_ANNOTATION_TYPE, $query); $indexer->generateIndex();