Created by
Marco Zanetti
| SELECT r.id, r.target_id, t.name, r.province, r.employmentkind, r.leadsource
FROM `rules` as r inner join `accounts_targets` as t on (r.target_id = t.id)
WHERE r.employmentkind = 'Dipendente pubblico' AND r.leadsource = 'CALLNO' AND t.id NOT IN (16,39)
order by t.name, r.province, r.employmentkind
|
| SELECT r.id, r.target_id, t.name, r.province, r.employmentkind, r.leadsource
FROM `rules` as r inner join `accounts_targets` as t on (r.target_id = t.id)
WHERE r.employmentkind = 'Dipendente pubblico' AND r.leadsource = 'CALLNO2' AND t.id NOT IN (16,39)
order by t.name, r.province, r.employmentkind
|
| update `rules`
set leadsource = 'CALL'
WHERE `id` in (SELECT r.id FROM `rules` as r inner join `accounts_targets` as t on (r.target_id = t.id) WHERE r.employmentkind = 'Dipendente pubblico' AND r.leadsource = 'CALLNO' AND t.id NOT IN (16,39))
and target_id <>32
|