sync ads impression
unknown
pgsql
a year ago
514 B
7
Indexable
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;
Editor is loading...
Leave a Comment