POTENŢIAL ŞTIINŢIFIC UMAN
user warning: Error writing file '/home/databases/tmp/MY7KMmqF' (Errcode: 28)
query: SELECT eu.uid AS euid,
eu.birth_date, eu.first_name, eu.last_name, eu.father_name,
et.tid,
et.defending_date,
et.maintain_date,
et.equivalence_date,
ewts.start_title,
ewts.end_title
FROM expert_users eu
LEFT JOIN drupal_users_roles dur ON eu.uid = dur.uid
LEFT JOIN expert_data_work edw ON eu.uid = edw.uid
LEFT JOIN expert_name_institutie_serviciu edwi ON edwi.institutie_id = edw.name_inst
LEFT JOIN expert_training et ON eu.uid = et.euid
LEFT JOIN expert_workers_training_studies ewts ON ewts.sid = et.sid
WHERE dur.rid = '14' AND eu.citizenship_id = 1
AND eu.dead_date='0000-00-00'
GROUP BY
eu.uid
ORDER BY first_name ASC,
last_name ASC, father_name ASC, 2 DESC in /home/www3/idsi/expert/includes/database.mysql.inc on line 175.