SLOVENIA, Unione Europea
Kolodvorska cesta 9, 5213 Kanal
tel: +386 (0)5 3302600
fax: +386 (0)5 3302620
e-mail:

SERBIA
Save Kovačevića bb, 22320 Inđija
tel: +381 (0)22 510 969
fax: +381 (0)22 510 971
e-mail:

SELECT u.id as id, u.surname as surname, u.name as name, u.email as email, u.tel as tel, u.tel2 as tel2, u.fax as fax, up.name as prefix, ue.name as education, upos.name as workPosition FROM users u LEFT JOIN users_NamePrefixData up on u.users_NamePrefix_id = up.users_NamePrefix_id and up.global_languages_code = 'ita' LEFT JOIN users_educationData ue on u.users_education_id = ue.users_education_id and ue.global_languages_code = 'ita' LEFT JOIN users_workPositionData upos on u.users_workPosition_id = upos.users_workPosition_id and upos.global_languages_code = 'ita' WHERE u.country = 'srp' AND u.active = 'Y' AND u.contact = 'Y'