Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- ost_form_entry_values.value as ost_form_entry_values__value
- FROM
- ost_ticket AS t
- LEFT JOIN ost_form_entry
- ON t.ticket_id = ost_form_entry.object_id
- LEFT JOIN ost_form_entry_values
- ON ost_form_entry_values.entry_id = ost_form_entry.id
- WHERE ost_form_entry_values.field_id = 20
- ORDER BY
- t.created DESC
- LIMIT 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement