Posted By

davidbdehaan on 05/11/13


Tagged


Versions (?)

author_id update


 / Published in: MySQL
 

update qry

  1. UPDATE
  2. exp_channel_titles t,
  3. exp_channel_data d,
  4. exp_playa_relationships p,
  5. exp_channel_titles devt,
  6. exp_channel_data devd
  7. SET
  8. t.author_id = devd.field_id_100
  9. WHERE
  10. t.entry_id = d.entry_id
  11. AND t.entry_id = p.parent_entry_id
  12. AND p.parent_field_id = 62
  13. AND p.child_entry_id = devt.entry_id
  14. AND devt.entry_id = devd.entry_id
  15. AND t.channel_id = 2
  16. AND devd.field_id_100 != '';

Report this snippet  

You need to login to post a comment.