condition('ji.plugin', 'locale') ->condition('ji.state', TMGMT_JOB_ITEM_STATE_ACCEPTED); $query->innerJoin('tmgmt_job', 'j', 'j.tjid = ji.tjid'); $query->addField('ji', 'item_id', 'lid'); $query->addField('j', 'target_language', 'language'); foreach ($query->execute() as $row) { db_update('locales_target') ->condition('lid', $row->lid) ->condition('language', $row->language) ->fields(array('l10n_status' => L10N_UPDATE_STRING_CUSTOM)) ->execute(); } } }