Why sphinx doe not return attributes name?

Vote count:

0

I use two indexes for search in Sphinx:

#users
source users : lsParentSource
{

    sql_query_range   = SELECT MIN(idDetailToUsers), MAX(idDetailToUsers) FROM detailtousers
    sql_query         = SELECT idDetailToUsers as id, 1000 as type, UsersTypeAccount, idDetailToUsers, SpecializationName, DetailToUsersName, DetailToUsersPhoto, city, country FROM detailtousers join users ON users.idUsers = detailtousers.idDetailToUsers left join usersspecialization ON usersspecialization.UsersSpecializationIdUser = detailtousers.idDetailToUsers left join specializationtousers ON specializationtousers.idSpecialization = usersspecialization.UsersSpecializationIdSpecialization WHERE idDetailToUsers >= $start AND idDetailToUsers <= $end GROUP BY idDetailToUsers

    sql_attr_uint     = type
    sql_attr_uint     = idDetailToUsers
    sql_attr_uint     = UsersTypeAccount
    sql_field_string  = SpecializationName
    sql_field_string  = DetailToUsersName
    sql_field_string  = DetailToUsersPhoto
    sql_attr_uint     = city
    sql_attr_uint     = country

    sql_query_info    = SELECT idDetailToUsers, DetailToUsersName, UsersTypeAccount, SpecializationName, DetailToUsersPhoto, city, country \
                        FROM detailtousers WHERE idDetailToUsers = $id
    sql_ranged_throttle = 0
}


#medical
source medical : lsParentSource
{

    sql_query_range   = SELECT MIN(idMedicalFacilities), MAX(idMedicalFacilities) FROM medicalfacilities
    sql_query         = SELECT idMedicalFacilities as id, 2000 as type, idMedicalFacilities, MedicalFacilitiesName, MedicalFacilitiesPhoto, city, country FROM medicalfacilities WHERE idMedicalFacilities >= $start AND idMedicalFacilities <= $end

    sql_attr_uint     = type
    sql_attr_uint     = MedicalFacilitiesIdUser
    sql_attr_uint     = idMedicalFacilities
    sql_field_string  = MedicalFacilitiesName
    sql_field_string  = MedicalFacilitiesPhoto
    sql_attr_uint     = city
    sql_attr_uint     = country

    sql_query_info    = SELECT MedicalFacilitiesIdUser, MedicalFacilitiesName, MedicalFacilitiesPhoto FROM medicalfacilities WHERE idMedicalFacilities = $id
    sql_ranged_throttle = 0
}

If use an index users only it returns me all attributes specified in select query. But if use a two indexes the sphinx does not return attributes. What is reason?

asked 29 secs ago

FranceDePerost

1

Why sphinx doe not return attributes name?