author_id update


/ Published in: MySQL
Save to your folder(s)

update qry


Copy this code and paste it in your HTML
  1. exp_channel_titles t,
  2. exp_channel_data d,
  3. exp_playa_relationships p,
  4. exp_channel_titles devt,
  5. exp_channel_data devd
  6. t.author_id = devd.field_id_100
  7. t.entry_id = d.entry_id
  8. AND t.entry_id = p.parent_entry_id
  9. AND p.parent_field_id = 62
  10. AND p.child_entry_id = devt.entry_id
  11. AND devt.entry_id = devd.entry_id
  12. AND t.channel_id = 2
  13. AND devd.field_id_100 != '';

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.