sync ads impression

mail@pastecode.io avatar
unknown
pgsql
21 days ago
514 B
5
Indexable
Never
update ads_impressions
set logs = logs || ' '|| (select ads_id from advertises where advertises.id = ads_impressions.advertise_id) || ' '|| (select name from advertises where advertises.id = ads_impressions.advertise_id)
where ads_impressions.advertise_id != 0;

update ads_impressions
set logs = logs || ' '|| (select id_listing from projects where projects.id = ads_impressions.project_id) || ' '|| (select name from projects where projects.id = ads_impressions.project_id)
where ads_impressions.project_id != 0;
Leave a Comment