sync ads impression
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