fix ads id log

 avatar
user_4900472
pgsql
a month ago
429 B
2
Indexable
Never
UPDATE advertises
SET logs = advertises.name || ' ' || advertises.province || ' ' || advertises.subdistrict || ' ' || advertises.regency || ' ' || (select pic_name from agents where id = advertises.agent_id) || ' ' || advertises.ads_id || ' ' || (select office_agents.name from office_agents where office_agents.id = advertises.office_id) || ' '|| advertises.desc || ' '|| advertises.price
where advertises.ads_id = '6954331850';
Leave a Comment