LEFT JOIN profile_job AS pj ON (pj.pid = pa.pid
AND pj.id = IF(pa.type = 'job', pa.id, NULL))
LEFT JOIN profile_job_enum AS pje ON (pj.jobid = pje.id)
- WHERE pa.pid IN {?} AND FIND_IN_SET('ax_mail', pa.flags)", $pids);
+ WHERE pa.pid IN {?} AND FIND_IN_SET('dn_best_mail', pa.flags)", $pids);
foreach ($res->fetchAllRow() as $item) {
list($axid, $promo, $title, $lastname, $firstname, $company, $full_address, $zipcode, $email, $delivery_issue) = array_map('utf8_decode', $item);
$lines = self::split_address($full_address);