Advertisement
Guest User

Untitled

a guest
Jun 20th, 2018
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. SELECT
  2. ost_form_entry_values.value as ost_form_entry_values__value
  3. FROM
  4. ost_ticket AS t
  5. LEFT JOIN ost_form_entry
  6. ON t.ticket_id = ost_form_entry.object_id
  7. LEFT JOIN ost_form_entry_values
  8. ON ost_form_entry_values.entry_id = ost_form_entry.id
  9. WHERE ost_form_entry_values.field_id = 20
  10. ORDER BY
  11. t.created DESC
  12. LIMIT 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement