"SELECT g.g_account_name, a.id
FROM gapps_nicknames AS g
LEFT JOIN aliases AS a ON (a.alias = g.g_account_name AND a.type = 'a_vie')
"SELECT g.g_account_name, a.id
FROM gapps_nicknames AS g
LEFT JOIN aliases AS a ON (a.alias = g.g_account_name AND a.type = 'a_vie')