Dear OMP users,
I’m trying to get a list of external reviewer with their interests using a SQL query.
I know that the database structure is very close to OJS, so I tried this one found in a OJS Forum thread, but I have zero result. I’ve tried to change us.user_group_id=33 to other value but no results. No error but zero result from the query.
Someone have any idea about the correct way to get a list of reviewer with their interest?
Thank you
(SELECT ‘Username’,‘Email’,‘Interest’)
UNION
(SELECT t2.username, t2.email, t2.interes FROM
(SELECT us2.username, us2.email , t.setting_value as interes FROM
(SELECT us.* FROM (SELECT u.*, uug.user_group_id
FROM users as u INNER JOIN user_user_groups as uug ON u.user_id = uug.user_id) us WHERE
us.user_group_id=33) us2 INNER JOIN (SELECT uc.user_id, cv.setting_value FROM
user_interests uc INNER JOIN controlled_vocab_entry_settings cv ON uc.controlled_vocab_entry_id = cv.controlled_vocab_entry_id) t ON
us2.user_id = t.user_id) t2
INTO OUTFILE ‘reviewers_interests.csv’
FIELDS ENCLOSED BY ‘"’ TERMINATED BY ‘;’ ESCAPED BY ‘"’
LINES TERMINATED BY ‘\r\n’);