credentials sent. I have most of it fixed now. I am still working on one last issue in the query, I am trying to add an additional WHERE not equal to statement to additionally filter my results.
I've tried adding
and (((ief_rsticketspro_tickets.status_id)<>="3"))
after
SELECT ief_rsticketspro_custom_fields_values.value, ief_rsticketspro_ticket_messages.Date , ief_rsticketspro_tickets.code, ief_rsticketspro_ticket_messages.message, CONCAT('
pond.turtlesoutheast.com/index.php/current-tickets/view-ticket/' ,ief_rsticketspro_tickets.id ,'-equipment-down' , '</a>') AS weblink FROM ief_rsticketspro_custom_fields_values INNER JOIN (ief_rsticketspro_ticket_messages INNER JOIN ief_rsticketspro_tickets ON ief_rsticketspro_ticket_messages.ticket_id = ief_rsticketspro_tickets.id) ON ief_rsticketspro_custom_fields_values.ticket_id = ief_rsticketspro_tickets.id WHERE (((ief_rsticketspro_custom_fields_values.custom_field_id)=1))
But this results in an error.
